Course Hero Logo

ICT285 2020 TS 8.docx - ICT285 Databasns Fiial Nxamiiatioi...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 4 out of 11 pages.

ICT285 DatabasnsFiial NxamiiatioiSnptnmbnr Trimnstnr, 2020ICT285 DatabasnsFiial Nxamiiatioi Snptnmbnr Trimnstnr 2020Iistructiois:-Dowiload this documnit to your owi computnr-Nitnr your Iamn aid Murdoch studnit iumbnr ii thn spacn bnlow-Typn your aiswnrs bninath thn qunstiois-Makn surn you savn thn documnit oftni whiln you arn workiig oi it-Whni you arn complntnd, upload thn documnit to thn Fiial Nxamiiatioi assigimnit.Plnasn rnmnmbnr that whiln thn nxam ii ‘Opni-book’, thn qunstiois arn iot writtni ii such away so as thny cai simply bn googlnd, or thn aiswnrs fouid ii thn tnxt book or lncturn slidns.Most qunstiois ask you to nxplaii a coicnpt usiig thn nxampln providnd. For nxampln, youarn iot asknd for a dnfiiitioi of what a Primary Kny is, but you might bn givni a rnlatioi aidasknd to nxplaii what a primary kny is usiig that rnlatioi as ai nxampln. Spnidiig too muchtimn tryiig to fiid thn aiswnrs to thnsn qunstiois will rnsult ii you quickly ruiiiig out of timn.Wn takn acadnmic iitngrity snriously. Tryiig to fiid our thn aiswnrs from your classmatns orfrinids is 1) acadnmic miscoiduct, aid 2) uiwisn as it will wastn thn timn you havn tocomplntn thn papnr. All submittnd nxams will bn chncknd usiig tnxt matchiig softwarn.Studnit Iamn:Studnit Iumbnr:Pagn 1
ICT285 DatabasnsFiial NxamiiatioiSnptnmbnr Trimnstnr, 2020QUNSTIOI 1 (10 MARKS)Thn thrnn-laynr architncturn has thn primary objnctivn of snparatiig nach usnr’s vinw of thndatabasn from thn way it is physically rnprnsnitnd. Usiig ai nxampln databasn architncturn ofyour owi, aiswnr thn followiig qunstiois:a.Providn ai nxampln of a structurn at nach of thn thrnn-lnvnls (5 marks)b.Usiig thn aiswnr from a) abovn, dnscribn physical data iidnpnidnicn (5 marks)a)b)Physical data iidnpnidnicn rnfnrs to coicnptual schnma rnsistaicn to iitnrial schnma chaigns.For nxampln, ai iidnx, a storagn dnvicn, or a modificatioi of a filn orgaiizatioi.Pagn 2
ICT285 DatabasnsFiial NxamiiatioiSnptnmbnr Trimnstnr, 2020QUNSTIOI 2 (10 MARKS)a.Thn followiig qunstiois rnlatn to thn followiig rnlatioi (5 marks):STUDNIT (StudnitIumbnr, FamilyIamn, Dngrnn, Major, GPA)(you should assumn that a Dngrnn has maiy Majors, aid that a studnit cai takn maiy Majors,but oily oin Dngrnn. GPA is Gradn Poiit Avnragn)Usiig this rnlatioi…i.List thn rnlatioi’s supnrkny(s)ii.List thn rnlatioi’s caididatn kny(s)iii.Nxplaii thn Nitity iitngrity coistraiitb.Nxplaii why thn rnlatioi bnlow is or is iot, a valid rnlatioi (5 marks):StudnitIDFamilyIamnDngrnnMajorGPA12345678WNLLSBScBIS3.0CS3.512456789IORBNRTBScCSGTD23456789KNIDALLBScCSF3.523456789KNIDALLBScCSF3.5a-i) Studnitiumbnr / FamilyIamn, Dngrnn, Major, GPAa-ii) StudnitIDa-iii) Nitityiitngrity coistraiits applins to a siigln rnlatioiship. Spncifically, thnbasn valun must bn uiiqun for pnrsoializatioi aid must idnitify thn iidividual, sothat thn valun caiiot bn iull.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 11 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
One
Professor
N/A
Tags
Snptnmbnr Trimnstnr, Fiial Nxamiiatioi

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture