Management and information system help

Pts Possible

Pts Earned

File submitted correctly to Blackboard (not via email)

2

Filename has correct format (example: TroboyKimLBR.accdb)

2

Added required data:

1. Self as a shareholder

2. Self as a shareholder with shares in at least two aircraft

2

At least six tables with appropriate names (i.e., shareholder, aircraft, ownership list, ownership detail, pilot list, mechanic list)

6

Appropriate and sufficient fields in each table. Entity properties appropriately set for each field (data type, 'required', etc.)

6

Appropriate primary keys identified for each entity ('PK' set in Design View, 3 pts) and foreign keys for related tables (3 pts, Database Tools, Relationship Tab)

6

Appropriate Relationships set (four relationships, mandatory/optional, cardinality, Enforce Referential integrity enforced, Cascade update related fields, Cascade update related Records)

8

Data correctly transformed from other files

3

Data entry forms for each table

3

At least two queries

6

At least two reports

6

Extra credit (two additional tables or additional reports, 2-3 bonus points)

Total

50