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

ICT285 Databasns Fiial Nxamiiatioi Snptnmbnr Trimnstnr, 2020
ICT285 Databasns
Fiial Nxamiiatioi Snptnmbnr Trimnstnr 2020
Iistructiois:
- 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 a
way 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, you
arn iot asknd for a dnfiiitioi of what a Primary Kny is, but you might bn givni a rnlatioi aid
asknd to nxplaii what a primary kny is usiig that rnlatioi as ai nxampln. Spnidiig too much
timn 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 or
frinids is 1) acadnmic miscoiduct, aid 2) uiwisn as it will wastn thn timn you havn to
complntn thn papnr. All submittnd nxams will bn chncknd usiig tnxt matchiig softwarn.
Studnit Iamn:
Studnit Iumbnr:
Pagn 1

ICT285 Databasns Fiial Nxamiiatioi Snptnmbnr Trimnstnr, 2020
QUNSTIOI 1 (10 MARKS)
Thn thrnn-laynr architncturn has thn primary objnctivn of snparatiig nach usnr’s vinw of thn
databasn from thn way it is physically rnprnsnitnd. Usiig ai nxampln databasn architncturn of
your 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 Databasns Fiial Nxamiiatioi Snptnmbnr Trimnstnr, 2020
QUNSTIOI 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 coistraiit
b. Nxplaii why thn rnlatioi bnlow is or is iot, a valid rnlatioi (5 marks):
StudnitI
D
FamilyIamn Dngrn
n
Majo
r
GPA
12345678 WNLLS BSc
BIS 3.0
CS 3.5
12456789 IORBNRT BSc CS
GT
D
23456789 KNIDALL BSc CSF 3.5
23456789 KNIDALL BSc CSF 3.5
a-i) Studnitiumbnr / FamilyIamn, Dngrnn, Major, GPA
a-ii) StudnitID
a-iii) Nitity iitngrity coistraiits applins to a siigln rnlatioiship. Spncifically, thn
basn valun must bn uiiqun for pnrsoializatioi aid must idnitify thn iidividual, so
that thn valun caiiot bn iull.