ADVANCE DATABASE MANAGEMENT SYSTEMS

QUESTION1 a. List three characteristics of a table in the relational data model. [6marks]

b. Given the following attribute values, create a table called STUDENT and insert values into this table up to two rows.[8marks] STUNUM= Studentnumber STULNAME=Studentlastname STU_FNAME= Studentfirstname STUINIT= Studentmiddleinitial STUDOB= Studentdateofbirth STUHRS=Credithoursearned STU_CLASS= Studentclassification STU_GPA=Gradepointaverage STUTRANSFER= IsStudenttransferredfromanotherinstitution? DEPT_CODE= Departmentcode STU_PHONE=4-digitcampusphoneextension PROF_NUM= Numberoftlteprofessorwhoisthestudent'sadvisor

c. Using the attribute table values in 1.b, briefly define the following term swith one example for each term: i.Superkey ii.Candidatekey iii.Secondarykey

d. Describe entity integrity and referential integrity. [6marks] [6marks]