Case Study Case

Step

Task

Points

1a

Primary key identified for each entity (four tables): patients, doctors, procedures and appointments  

5

1b

Attributes identified for each entity (four tables): patients, doctors, procedures and appointments  

5

2

Data Types

2a

Identified data types  

5

3

Relationships

3a

Identify one-to-many relationships  

5

3b

Identify many-to-many relationships  

5

4

Foreign Keys

4a

Add foreign keys to tables as needed  

10

5

ER Diagrams

5a

Create an ER diagram using Visio  

15

Total

50

Step

Task

Points

6

Create and Populate the Database

6a

Create the tables and relationships in Access

15

6b

Integrate the data from the spreadsheets

20

6c

Create query 1 - Create an Action query 1 - Action queries can delete records, update data, append data from one or more tables to another table, and make a new table. See your professor

10

6d

Create query 2. - Multiple criterion query

10

6e

Create query 3. - Crosstab query

10

7

Written report

7a

Discuss database benefits when businesses use queries, forms, and reports

10

7b

Discuss at least two security concerns should be discussed with a proposed solution to mitigate the security issues

10

7c

Edit, spellcheck, and list references

5

Total

90