Question: Exercise 2 . Consider the following relations: Students ( sid: string, name: string, login: string, age: integer, gpx real ) Faculty ( fid: string, fname:
Exercise Consider the following relations:
Studentssid: string, name: string, login: string,
age: integer, gpx real
Facultyfid: string, fname: string, sal: real
Coursescid: string, cname: string, credits: integer
Roomsmo: integer, address: string, capacity; integer
Enrolledsid: string, cid: string, grade: string
Teachesfid: string, cid: string
MeetsIncid: string, mo: integer, time: string
a List all the foreign key constraints among these relations.
b Give an example of a plausible constraint involving one or more of these relations that is not a primary
key or foreign key constraint.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
