Question: Part II. Relational Model [30 pts] Throughout this part, all the questions are by default based on the relation instance provided below, which stores information

 Part II. Relational Model [30 pts] Throughout this part, all thequestions are by default based on the relation instance provided below, which

Part II. Relational Model [30 pts] Throughout this part, all the questions are by default based on the relation instance provided below, which stores information of international students in a university. collegelD ENG SCI SCI MED ENG BUS departID stuNo CSE 14234 MATH 15234 PHY 13234 NEUR 14234 MECH 15234 FIN 24657 firstName Jean Mandi John Lei Ming Jean lastName country Kim KOR Smith UK Smith CAN Li CHN Li CHN Cham FRE age passportNo 26 CDE4561 22 ABC3542 24 EFG7869 23 PE56790 23 ASE1567 23 RWA1564 1. [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. 2. [5 pts] Name five different super keys for the given relation. 3. [6 pts] Name three candidate keys with two attributes in the given relation. 4. [4 pts] Consider a general dataset with the same schema as you answered in the first question (NOT the instance provided above). Choose a reasonable three-attribute primary key and briefly explain why it makes sense

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!