Convert each of the following conceptual schemas into a relational schema. Be su

Question

Convert each of the following conceptual schemas into a relational schema. Be sure to list all the tables and attributes, and clearly specify primary keys and foreign key references. All answers must be typed.

Note: Use proper notation when listing tables in your relational schema. For example:

Instructor (InstructorID, Lname, Fname, Office)

Course (CourseID, Title, Credits, InstructorID)

InstructorID is a foreign key references Instructor.InstructorID

You could also use dash underline to represent a foreign key if the foreign key has the same name as the primary key it references to.

Explanation / Answer

As per Given in problem statement:

EMPLOYEE(EID (primary key), Name, Address, BirthDate)

EMPLOYEE is having four keys among EID is primary key.

PROJECT(PROJECT_ID (primary key), PName, StartDate)

PROJECT is having 3 keys among PROJECT_ID is primary key

Defining a relation between EMPLOYEE and PROJECT :

Assigned_to(Billing_Date,EID(foreign key w.r.s EMPLOYEE), PROJECT_ID(foreign key w.r.s PROJECT))

Employee is having self reference It means Employee manages him self

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

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