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 fromHands-On Databaseand 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.