Design a database schema for the proposal

Assignment Help Database Management System

Reference no: EM132027938

Question: Design a database schema for the proposed Database Design Proposal in Module 1. Identify and list all relevant entities and their relationships:

1) Select no less than five entities.

2) Provide a diagram.

3) Map this to a database schema.

4) Provide a data dictionary for all entity attributes.

Focus on one or two areas of your design that seemed especially difficult to develop and provide a brief assessment of the difficulty you encountered in modeling or mapping to the schema. In addition, provide the rationale for the design chosen, its limitations, and its possible extensions.

Tip: If you do not have access to ER modeling software or a diagramming tool like Visio or OmniGraffle, you can simply create diagrams in a presentation tool like PowerPoint. This is an essential skill which is used in the field.

APA format is not required, but solid academic writing is expected.

This homework uses a grading rubric. Instructors will be using the rubric to grade the assignment; therefore, students should review the rubric prior to beginning the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment.

This assignment will be utilized again in Modules 4 and 5. Prior to Module 4, review any feedback provided to you by the instructor.

Reference no: EM132027938

Questions Cloud

Identify an enterprise wireless access control solution : You work as a network administrator for a college located in your local city. Next door to the college is a new gated community.

Annual cost of living adjustment cola : Does CPI (Consumer Price Index) affects the annual cost of living adjustment COLA that is provided to the retirees?

What is the private optimum and public optimum : What is the private optimum and public optimum.

Why shadow economy a problem for the governments : Why shadow economy a problem for the governments?

Design a database schema for the proposal : Design a database schema for the proposed Database Design Proposal in Module 1. Identify and list all relevant entities and their relationships.

What happens to the price of coffee and thomas income : What happens to the price of coffee and Thomas's income. I would like to know the thinking steps in detail, best regards.

How did the american revolution impact native americans : "How did the American Revolution impact Native Americans?"

Discuss the challenges of maintaining information security : Discuss the challenges of maintaining information security at a remote recovery location. The response must be typed.

Effect of a natural disaster that hit a small country : How could you use a production possibilities frontier to show the effect of a natural disaster that hit a small country?

User Account

All Pages