+1-415-670-9189
info@expertsmind.com
Entity-relationship diagram
Course:- Database Management System
Reference No.:- EM13419




Assignment Help
Assignment Help >> Database Management System

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts. The relationships between the entities and the attributes for the entities will be described. This database will provide the foundation for the follow-on project. The subsequent paragraphs provide the background and summary of the business requirements.

You are a database consultant with Ace Software, Inc. and have been assigned to prepare a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database.

1. Evaluate and list your entities. Then explain fully the relationships between entities via pairs of sentences that shows the two components of the total relationship in both directions between the entities. Relationships may be unary, binary, or ternary with respect to entities. You could not have any many-to-many relationships.

2. Begin the database logical design by identifying the entities, relationships between entities, and entities' attributes. Use the same entity/relationship diagram (ERD) notation as used in class for entities, attributes, and relationships. Sketch your ERD by hand or a drawing program (e.g., Visio, PPT, SQL Modeler ...) on one single 8-1/2" x 11" page (8-1/2" x 14" maximum), labeled "Mom and Pop Johnson Video Store Database E/R Diagram." Your ERD could not have any many-to-many relationships between entities.

3. Complete the logical database design and start the physical database design by preparing metadata documentation) that describes the table(s) created from each entity and thecolumn(s) created from each attribute in the ERD. Attributes could be self-describing. Particular attention will be given to the proper specification of all primary key (via "PK") and foreign key (via "FK") columns in the table layouts. These could match your ERD exactly. Begin these descriptions on a page labeled "Proposed Database Tables and Columns based on E/R Diagram." All tables must be 3rd Normal Form. Shows any and all assumptions that were made.




Put your comment
 
Minimize


Ask Question & Get Answers from Experts
Browse some more (Database Management System) Materials
Create a graph or chart that compares the data in a meaningful way, i.e. compare regions by month, compare products by month, etc. Create a spreadsheet formatted to present y
You need to develop new user named ASSOCDBA1 and new ROLE named JRDBA1 which can be used for assistant DBA. You wish the new role to contain DBA role that the SYSTEM user ha
What is the difference between a database and a table? What two conditions must be met before an entity can be classified as a weak entity? Give an example of a weak entity.
You have probably seen that already when you tried to create an E-R diagram. Visio uses notation and graphical shapes that are not the same as those in your text. If you look
Visit the W3C Web site and look at the information under Mission (http://www.w3.org/Consortium/mission). Discuss why you think the W3C is important in the world of databases
1. Use Microsoft Visio (or open source equivalent) in which you: a. Modify the database diagram from Lab 1 with the entities and attributes that the scenario identified (i
Create a tree that models the following scenario. A player decides to play a maximum of 4 times, betting on red each time. The player will quit after losing twice. In the tr
Describe the purpose of the database. Based on your research and / or common knowledge of a college and the information tracked by a college, describe the entities of the dat