Question: All the questions below are by default based on the relation instance provided below, which stores information of international students in a university. table
All the questions below are by default based on the relation instance provided below, which stores information of international students in a university.
tablecollegelDdepartID,stuNo,firstName,lastName,country,age,passportNoENGMECH,Ming,LiCHNASEQENGCSE,Allen,Kim,KOR,CDSCIMATH,Mandi,Smith,UKABCMEDNEUR,Lei,LiCHNPEBUSFIN,Jean,Cham,FRE,RWAISTIST,Raj,Paul,IND,VSZSCIPHYJohn,Smith,CAN,EFGT
pts What is the schema for this relation? Please include value domain for each attribute as well. You may choose your own relation name, and the value domain in your answer must be compatible with the instance given above. If multiple value domain is possible for an attribute, use the most strict one that fits the given database instance.
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
