Database diagrams

2-2 LAB ACTIVITY: DRAWING E-R DIAGRAMS

Using Microsoft Visio, create an entity-relationship (E-R) diagram for the scenario that you selected from Hands-On Database and based on the information you produced when completing the “To Do” activities from Chapter 3 (for the scenario activity in this module). 

Scenarios WiLD WooD ApArTmenTS

The Wild Wood Management team is ready to see some results. You have a meeting with them at the end of the week. It is time to analyze and organize all the information. Look back at the material from earlier chapters.

To do

1. Make a list of issues with the current system.

2. Make a list of the database requirements for each stake-

holder involved in the database.

3. Make a list of business rules.

4. List some major security rules for the database.

5. Take a look at each of the forms, and make a list of all the nouns in them. Do the same for the interview, the ques- tionnaire, and the Job Shadow Report. Then set up some preliminary entities and attributes.

6. Identify some candidate keys.

7. Documentation: Store the list of the requirements and

business rules in your database notebook.

(Conger 60)

Conger, Steve. Hands-On Database, 2nd Edition. Pearson, 20150612. VitalBook file.

The citation provided is a guideline. Please check each citation for accuracy before use.

(Conger 60)

Conger, Steve. Hands-On Database, 2nd Edition. Pearson, 20150612. VitalBook file.

The citation provided is a guideline. Please check each citation for accuracy before use.