JOB PK Job_Code Job_Description Job_Chg_Hour Job_Last_Update --H- PK EMPLOYEE Emp_Num Emp_LName Emp_FName Emp_Initial Emp_HireDate Fk1 Job_Code Emp_Years ASSIGNMENT PK Assign_Num Assign_Date Fk2 Proj_Num Fk1 Emp_Num PROJECT ---?- Assign_Job Assign_Chg_Hr--H-PK Proj_Num Assign_Hours Assign_Charge TH- Proj_Name Proj_Value Proj_Balance Fk1 Emp_Num
Added by Katelyn H.
Close
Step 1
There are four entities: JOB, EMPLOYEE, ASSIGNMENT, and PROJECT, each represented as a table with attributes. Show more…
Show all steps
Your feedback will help us improve your experience
Mohan Jain and 59 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
The following figure shows an EER diagram for a restaurant, its tables, and the waiters and waiting staff managers who work at the restaurant. NOTE: In the EMPLOYEE entity, you can assume an additional attribute EmpType that serves as a subtype discriminator. Transform the EER diagram into a 3NF relation schema and show all the dependencies.
Aarya B.
Mini Final Project Part 1: Due [6/23/2020] 1. Select a topic to design. 2. Design ER Diagram. 3. Define Entity-Relationship schema. Marking Scheme: ER Diagram i. Is the ER Diagram clear? Yes No ii. Match the style from class? Yes No iii. Is the cardinality accurate? Yes No iv. Match the structure from the DDL scripts? Yes No v. Missing Relationships? Yes vi. Does the ER Diagram have Many-Many Relationships? Yes No vii. Is the diagram in the Third Normal Form? Yes No Comments: No Minimum Requirements: - 4 Entities - Minimum of 4 Attributes per Entity - Each table must include a primary key - Database must use a minimum of 3 foreign keys
Akash M.
The following tables form part of a database held in an RDBMS: Employee (empNo, fName, lName, address, DOB, sex, position, deptNo) Department (deptNo, deptName, mgrEmpNo) Project (projNo, projName, deptNo) WorksOn (empNo, projNo, dateWorked, hoursWorked) Where: - Employee table contains employee details and empNo is the key. - Department table contains department details and deptNo is the key. mgrEmpNo identifies the employee who is the manager of the department. There is only one manager for each department. - Project table contains details of the projects in each department and the key is projNo (no two departments can run the same project). - WorksOn table contains details of the hours worked by employees on each project, and empNo/projNo/dateWorked form the key.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD