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:

MARATHON(Race_ID (primary key), Location, Date)

MARATHON is having three keys among Race_ID is primary key.

RUNNER(Runner_ID (primary key), Name, Gender, Age)

RUNNER is having 4 keys among Runner_ID is primary key

Defining a relation between MARATHON and RUNNER :

Participates_in(Time, Position, Race_ID(foreign key w.r.s MARATHON), Runner_ID(foreign key w.r.s RUNNER))

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects