User Account

All Pages

Create an entity-relationship diagram and design

Assignment Help Database Management System
Reference no: EM13346531

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.

Reference no: EM13346531

Questions Cloud

Please answer 3 questions please note the layout of your : please answer 3 questions. please note the layout of your answers should be in paragraph style.nbsp1. how do
Write a webservices application that does a simple four : write a webservices application that does a simple four function calculator. write a cgi program launched by your
International accounting standards are unusable from an : international accounting standards are unusable from an investors viewpoint and make global allocation of capital more
Write a research paper an event not bp-gulf of mexico or : write a research paper an event not bp-gulf of mexico or exxon valdez. where a company created a situation where their
Create an entity-relationship diagram and design : create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices
Campc is a 5-year old chain of 12 medium-sized supermarkets : campc is a 5-year old chain of 12 medium-sized supermarkets. the supermarkets are targeting the middle- and top-income
Examine the needs for measuring assets at fair value in the : examine the needs for measuring assets at fair value in the following accounting standards nbspias3aasb 3 business
Wind turbines are becoming more and more common as a method : wind turbines are becoming more and more common as a method of energy production wind turbines by their very nature are
1briefly trace the development and growth of amazoncom from : 1.briefly trace the development and growth of amazon.com from 1995 to the present through the application of corporate

Reviews

Write a Review

Database Management System Questions & Answers

  Interface with some other dbms

Develop a RDBMS (Relational Database Management System) in Python. The RDBMS should actually be written in Python, not just interface with some other DBMS. This system should track students: Personal Data, Schedules and Grades. The system should cont..

  Use javascript to ensure that an entry has been made

When the database is set up it should be populated with the data that you have chosen. Display this data as part of your documentation. Each table should have from 3 to 6 records initially.

  Do a requirements analysis for the case study

To apply and consolidate skills acquired in the requirement and analysis disciplines through analysis of a simple case study, and to express the results through the relevant UML diagrams. ITC203

  Design premiere products databas-shows relationship

Indicate changes you require to make to design of Premiere Products database to support following situation: There is no relationship between customers and sales reps.

  Illustrate concurrency control method by two phase locking

For each table argue whether or not interference with another transaction is possible. Illustrate concurrency control method using two phase locking.

  Difference between e-r diagram and the data dictionary

E-R diagram specializes a logical graphic model and it doesn't contain any data type or data information in a database.

  Describe the different operations of relational algebra

Describe relationships with the example. Also illustrate degree of relationship for that example. Describe the different operations of relational algebra with suitable example each.

  Find maximum salary of employees from database table

Find the maximum salary of all employees who are not managers. Give all the managers in the database a 10 percent salary raise. Give all the other employees a 5 percent salary raise.

  Develop a new information system

MGMT321 Group Project :  You were hired as an analyst to develop a new information system to automate the payroll transactions in a mid-size organization. The proposed system will contain employees’ data and interface with the organization’s General ..

  Study on managing the software enterprise

This course is for those in a management capacity, or those interested in management, involving the strategic consideration of software acquisition, development and project management.

  Create a clustered index on the groupid column

Write the CREATE INDEX statements to create a clustered index on the GroupID column and a nonclustered index on the IndividuallD column of the GroupMembership table.

  What are the main activities that the business undertakes

What are the main activities that the business undertakes and where in the business are the crucial decisions made?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd