TM-315 DATABASE SYSTEMS

Please help me to draw an ERD and the Relational Schema and please mark the Primary and Foreign Key .....

Deliverable:

Word document with grade sheet followed by Part 1 ERD and the Part 2 relational schema.

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.

PLEASE WRITE THE ERD AND RELATIONAL SCHEMA LIKE THE EXAMPLE BELOW

employee's boss DEPT EMP *deptname deptfloor empno empfname department's Lempsalary boss DEPT(deptname, deptfloor, deptphone, deptbossno) EMP(empno, empfname, empsalary, empbossno,deptname)