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.
