Transform the given diagram into a relational schema

Assignment Help Computer Engineering

Reference no: EM131886058

Assignment

Deliverable:

1. Word document with grade sheet followed by Part 1 ERD and the Part 2 relational schema. Please name this file lastnameITM315HMWK3 (fullerITM315HMWK3)

Part 1: Draw the ERD for the following situation. 8 pts

Be sure to:

• Convert all many-to-many relationships to associative entities.
• Make sure each regular entity has an appropriate identifier.
• Make sure attribute names are unique within the ERD.

Wally Los Gatos, owner of Wally's wonderful World of Wallcoverings, has hired you as a consultant to design a database management system for his chain of three stores that sell wallpaper and accessories. After an initial meeting with Wally, you have developed a list of business rules and specifications to begin the design of an E-R model.

• Customers place orders through a branch. Each customer may order from multiple branches. Each branch receives orders from many customers.

• The following information needs to be recorded each time a customer orders from a branch: Order date and Credit Authorization status.

• Wally would like to track the following about customers: Name, Address, Telephone, and Date of Birth.

• The following information about each branch needs to be recorded: Branch Number and square footage.

• Wally has many employees. He would like to track the following information about employees: Name, date of hire, title, salary, and age.

• Each employee works in one and only one branch. Each branch has multiple employees.

• Each branch is managed by an employee. Not all employees manage branches and no one manages more than one branch.

Part 2: Transform the diagram below into a relational schema that shows referential integrity constraints.

Paste your schema in your word document below the part 1 ERD.

442_Relational schema.jpg

Reference no: EM131886058

Questions Cloud

Evaluate the cultural issues that need to be addressed : Review Juanita's World Parts 1-5, which are found in the Weeks 1 and 2 lectures, and write a 5-7 page paper.

How would a vw representative respond to the arguments : Who is likely to oppose the plant, and what would be their main arguments? How would a VW representative respond to the arguments of those opposed?

Define arbitration and negotiation : How are arbitrators chosen under Saudi law? How does this compare to the method used in the United States.

Discuss why the current health care system is in turmoil : Discuss why the current health care system is in turmoil. Identify two major problems of health care and analyze the impact of each of the chosen problems.

Transform the given diagram into a relational schema : Transform the diagram below into a relational schema that shows referential integrity constraints.

What do you need to work on in your memos : Based on the comments you received, what do you need to work on in your memos? How will you make your next memo stronger than this one?

Discuss about an overview of the employee compensation : Provide an overview of the employee compensation and benefits package that you developed in the narrative portion of this assignment.

What is the court likely to rule and why : Pearl is an Internet Technology representative who is employed by Pi Computer Systems.

Compare ohio and nebraskas positions on noncompete clauses : Discuss the legal implications for employers and employees for requiring employees to sign noncompete agreements.

User Account

All Pages