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.

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.