Question: Based on the scenario Identify the most appropriate Unique Identifier ( UID ) for COLLEGE, DEPT and STUDENT. The university is organized into colleges (
Based on the scenario Identify the most appropriate Unique Identifier UID for COLLEGE, DEPT and STUDENT.
"The university is organized into colleges COLLEGE and each college has a unique name CName a main office COffice and phone CPhone and a particular faculty member who is dean of the college. Each college administers a number of academic departments DEPT Each department has a unique name DName a unique code number DCode a main office DOffice and phone DPhone
The database will keep student data STUDENT and stores each students name SName composed of first name FName middle name MName last name LName student id Sid unique for every student address Addr phone Phone major code Major and date of birth DoB A student is assigned to one primary academic department.
CName, DName, SName
CName, DCode, Sid
CPhone, DCode, DoB
DeanName, DName, Addr
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
