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.
\table[[collegelD,departID,stuNo,firstName,lastName,country,age,passportNo],[ENG,MECH,15234,Ming,Li,CHN,23,ASEQ567],[ENG,CSE,87924,Allen,Kim,KOR,26,CD44561],[SCI,MATH,15234,Mandi,Smith,UK,22,ABC3542],[MED,NEUR,14234,Lei,Li,CHN,23,PE56790],[BUS,FIN,24657,Jean,Cham,FRE,23,RWA1564],[IST,IST,15223,Raj,Paul,IND,21,VSZ4892],[SCI,PHY,13234,John,Smith,CAN,24,EFGT869]]
[5 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.
 All the questions below are by default based on the relation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!