1. Map ERD/EERD to a relational database indicating the relation name, primary k

Question

1. Map ERD/EERD to a relational database indicating the relation name, primary key, foreign key and related attributes for each relation. Add appropriate additional field according to the given scenario in the diagram..

Table name:

Table name:

Table name:

Table name:

Table name:

Table name:

Table name:

Table name:

4. Establish join paths for the above relational database using the referential integrity by drawing arrow lines between the above tables. Indicate all the primary keys (PK) and foreign keys (FK).

Supervise Part-time Hrs per week Works for Working on Employee Employee Name Social Security Address Employee Type Department Department Name Department Number Location Manages Managed Full-time Salary Have Controls Controlled by Belongs to Dependent Dependent Name Sex Birthday Relationship Project Project Name Project Number Project Location

Explanation / Answer

If you have any doubts, please give me comment...

Employee(EmployeeName, SocialSecurity (PK), Address, Supervisor(FK), DepartmentNumber);

Part-time(SocialSecurity(PK, FK), HrsPerWeek);

Full-time(SocialSecurity(PK, FK), Salary);

Department(DepartmentName, DepartmentNumber(PK), Location);

Dependant(SocialSecurity(PK, FK), DepartmentName(PK), Sex, Birthday, Relationship);

Project(ProjectName, ProjectNumber(PK), ProjectLocation);

Works_On(ProjectNumber(PK, FK), DepartmentNumber(PK, FK))

Note: PK(Primary key), FK(Foreign Key)

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.