Assignment: Database Diagrams
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 stakeholder 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.
Report: HANDS ON DATABASE by Steve Conger © 2010.