Assignment #3: Data Definition The ER Model shown below is based on the following business rules. A manager manages one department. Each department is managed by one manager. An employee is assigned...


Assignment #3: Data Definition<br>The ER Model shown below is based on the following business rules.<br>A manager manages one department. Each department is managed by one<br>manager.<br>An employee is assigned to one project. Each project is assigned many<br>employees.<br>Employee's salary cannot be less than 0.<br>A project's end date cannot be earlier than its start date.<br>UID (Unique identifier) uniquely identifies an instance of the entities.<br>DEPARTMENT<br>PROJECT<br>DeptNo: UID<br>ProjectNo: UID<br>StartDate<br>DName<br>EndDate<br>Location<br>Is assigned<br>managed by<br>is hired by<br>ΕMPLOYEΕ<br>EmpNo: UID<br>EmpFName<br>EmpLName<br>EmpPhone<br>Salary<br>BirthDate<br>Zipcode<br>manages<br>is supervised by<br>Supclvises<br>Requirements<br>1<br>Based on the ER Model, write SQL statements to create EMPLOYEE,<br>DEPARTMENT and PROJECT tables.<br>• First, you'll need to do the relational modeling. In other words, map the ER<br>model to the relational model (i.e., table structure with PK and FKs)<br>• For each column, use the data type and length that you think appropriate.<br>• Implement all necessary data integrity rules (e.g., entity integrity constraint,<br>key constraint, referential integrity constraint, and semantic integrity<br>constraints).<br>• If necessary, make explicit assumptions.<br>

Extracted text: Assignment #3: Data Definition The ER Model shown below is based on the following business rules. A manager manages one department. Each department is managed by one manager. An employee is assigned to one project. Each project is assigned many employees. Employee's salary cannot be less than 0. A project's end date cannot be earlier than its start date. UID (Unique identifier) uniquely identifies an instance of the entities. DEPARTMENT PROJECT DeptNo: UID ProjectNo: UID StartDate DName EndDate Location Is assigned managed by is hired by ΕMPLOYEΕ EmpNo: UID EmpFName EmpLName EmpPhone Salary BirthDate Zipcode manages is supervised by Supclvises Requirements 1 Based on the ER Model, write SQL statements to create EMPLOYEE, DEPARTMENT and PROJECT tables. • First, you'll need to do the relational modeling. In other words, map the ER model to the relational model (i.e., table structure with PK and FKs) • For each column, use the data type and length that you think appropriate. • Implement all necessary data integrity rules (e.g., entity integrity constraint, key constraint, referential integrity constraint, and semantic integrity constraints). • If necessary, make explicit assumptions.

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here