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.

Ask Question & Get Answers from Experts
Browse some more (Database Management System) Materials
In Word, identify a potential database application. It should be based on data you understand well, such as student data (refer to text), a hobby (see Lesson 8), or a set of
Draw the class diagram which covers all the situations described in the carpark system, showing inheritance, association (aggregation and composition as necessary) and multi
it is not essential to give violations which have more than one attribute on right side. Decompose the relation, as essential, into collection of relations which are in BCNF.
supplies % of votes each candidate is likely to receive, based on popularity rating. Actual number of votes received is that percentage of General votes. You should enter da
Using Microsoft Access, prepare a database and save it as Acme Inc. Prepare the following tables: Employees and Products. Field names for Employees table are first name,
Recognize level within a database system (user, programmer of application software, and designer of the DBMS software) at which each of the following concerns or activities
Examples for small n are given bellow, where a small square box represents an unsuccessful search. Prove that leaves of any binary search tree are located in the bottom two le
Write an application that creates a database named Personnel. The database should have a table named Employee, with columns for employee ID, named position, and hourly pay r
Construct a diagram using Rationale to map the arguments about a moral claim that you have identified in the article/case study and write an essay, which maps closely to the R
A university library database records information about books; for each book, it records the book isbn number (which is unique), and the book name. In addition, it records whi
Write a program to calculate the tax of an employee whose employee number is input from the keyboard. Display an appropriate error message if the data does not exist in t
Instructions: You can use any source you prefer, the text, Internet, etc. The answers should not take more than 1 - 2 paragraphs of text, please submit a word processing doc