Part v: Please follow the steps below to create: i. Create a schema for each of
ID: 671060 • Letter: P
Question
Part v: Please follow the steps below to create:
i. Create a schema for each of the Entities in the diagram. The schema will be a list (as in this example:
EMPLOYEE{SSN, LName, FName, BirthDate, EmpAddress, EmpCity, EmpState, EmpZip, JobType – FK to Job table, DeptID – FK to Department table} ) of attributes needed for the entity.
ii: Identify Primary Key of each by underlining it.
iii: Represent the relationships by "shared” attributes across Entities. Identify the Foreign keys required in each schema and what other Entities it has a relationship with. Check for cardinality when choosing FKs.
University Database CS 5332 || Data Base Theory and Design Name PERSON FACULTY CodegDeYear STUDENT Dagrees COMMITTEE Class-5 GRAD_STUDENT GRANT Agercy ELONGS TiITE SUPPORT GSTERED CHAIRS Erni MINOR > N INSTRUCTOR RESEARCHER TRANSCRIPT CURFENT SECTION TEACH atr-Curent r Year Curent Year SECTION DEPARTMENT CS DName)I DPhonel Office COLLEGE CD DC COURSEExplanation / Answer
Person( SSN,BDate, Sex, FName,Lname,City,State, Zip) Faculty(FPhone,FOffice,Rank,Salary,Department) Student(FName,LName,Class,DName is fk to Department,Section) Section(Sec#, year, Qtr, Current_section) Department(Dname,DPhone,Office,Course) Course(C#,CName,CDesc) College(CName,Dean,Coffice) Grad_student(Faculty,College,Degree,Year) Grant(Title,No,Agency,Stdate) Support(Start,Time,End)