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:

CASE(CASE# (primary key), Date_Opened, Date_Closed, Judgement)

CASE is having four keys among CASE# is primary key.

LEGAL_ENTITY(LE# (primary key), LE_Name, LE_net_address. Perons_or_org)

LEGAL_ENTITY is having 4 keys among # is primary key

Defining a relation between CASE and LEGAL_ENTITY :

Brought_Against(CASE#(foreign key w.r.s CASE),LE#(foreign key w.r.s LEGAL_ENTITY))

Defining a relation between CASE and LEGAL_ENTITY :

Brought_By(LE#(foreign key w.r.s LEGAL_ENTITY), CASE#(foreign key w.r.s CASE))

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

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