Create an entity-relationship diagram for the scenario

Assignment Help Database Management System

Reference no: EM131512838

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.

Reference no: EM131512838

Questions Cloud

Absolute advantage in trade : Provide At least two products for each country that have provided China, the US and Germany an absolute advantage in trade.

What''s economics in general : What's Economics in general? What does this definition means to you with respect to your individual life/daily events and decision making and to work?

Evaluate speeds of dsl and cable modem that you researched : Compare and evaluate the speeds of DSL and cable modem that you researched. evaluate the cost of DSL and cable modem that you researched.

Savings account at an annual interest rate : If you invest $1,000 into a savings account at an annual interest rate of 5% (APR), compounded semi-annually, how much will you have in the savings account.

Create an entity-relationship diagram for the scenario : create an entity-relationship (E-R) diagram for the scenario that you selected from Hands-On Database and based on the information you produced.

Prepare a international business report : Having now completed a major analysis of environment in which your business will operate you will need to prepare Part 2 of your International Business Report

Identify and address any other security concerns : Identify and address any other security concerns. The client realizes that her expertise is in coffee and hospitality

Comparative advantage in producing : What are some examples of goods that the United States has comparative advantage in producing?

What is the present value of the payments : The interest rate is 5% now and increases to 8% in the next year. What is the present value of the payments?

User Account

All Pages