Section 6 Section 6
(Answer all questions in this section)
(Answer all questions in this section)
1.
1.What is the rule of Second Normal Form?What is the rule of Second Normal Form? Mark forMark for
Review
Review
(1) oints
(1) oints
No non!"#$ attri%utes can %e de&endent on an' &art of the "#$
No non!"#$ attri%utes can %e de&endent on an' &art of the "#$
Some non!"#$ attri%utes can %e de&endent on the entire "#$
Some non!"#$ attri%utes can %e de&endent on the entire "#$
All non!"#$ attri%utes must %e de&endent u&on the entire "#$ ()
All non!"#$ attri%utes must %e de&endent u&on the entire "#$ ()
None of the a%ove
None of the a%ove
*orrect
*orrect
2.
2.+,amine the followin- entit' and decide how to make it conform to the rule+,amine the followin- entit' and decide how to make it conform to the rule of .nd Normal Form/ of .nd Normal Form/ +N0#0/ R+*+#0 +N0#0/ R+*+#0 A00R#2"0+S/ A00R#2"0+S/ 3*"S04M+R #$ 3*"S04M+R #$ 3S04R+ #$ 3S04R+ #$ S04R+ 54*A0#4N S04R+ 54*A0#4N $A0+ $A0+ Mark for Mark for Review Review (1) oints (1) oints
Move the attri%ute S04R+ 54*A0#4N to a new entit'6 S04R+6 with a "#$
Move the attri%ute S04R+ 54*A0#4N to a new entit'6 S04R+6 with a "#$
of S04R+ #$6 and create a relationshi& to the ori-inal entit' ()
of S04R+ #$6 and create a relationshi& to the ori-inal entit' ()
$elete the attri%ute S04R+ #$
$elete the attri%ute S04R+ #$
Move the attri%ute S04R+ 54*A0#4N to a new entit'6 S04R+6 with a "#$
Move the attri%ute S04R+ 54*A0#4N to a new entit'6 S04R+6 with a "#$
of S04R+ 54*A0#4N6 and create a relationshi& to the ori-inal entit'
of S04R+ 54*A0#4N6 and create a relationshi& to the ori-inal entit'
$o nothin-6 it is alread' in .nd Normal Form
$o nothin-6 it is alread' in .nd Normal Form
*orrect
*orrect
3.
3. 0 0o resolve a .o resolve a .nd Normnd Normal Foral Form violation6 wm violation6 we/e/ Mark forMark for
Review
Review
(1) oints
(1) oints
Move the attri%ute that violates .nd Normal Form to a new entit' with a
Move the attri%ute that violates .nd Normal Form to a new entit' with a
relationshi& to the ori-inal entit' ()
relationshi& to the ori-inal entit' ()
$elete the attri%ute that was causin- the violation
$elete the attri%ute that was causin- the violation
$o nothin-6 an entit' does not need to %e in .nd Normal Form
$o nothin-6 an entit' does not need to %e in .nd Normal Form
Move the attri%ute that violates .nd Normal Form to a new +R$
Move the attri%ute that violates .nd Normal Form to a new +R$
*orrect
4.When an' attri%ute in an entit' is de&endent on an' other non!"#$ attri%ute
in that entit'6 this is known as/ Mark for
Review (1) oints Non!de&endenc' $e&endenc' 0ransitive de&endenc' () Functional de&endenc' *orrect
5.+,amine the followin- +ntit' and decide which rule of Normal Form is %ein-violated/ +N0#0/ *5#+N0 A00R#2"0+S/ 3 *5#+N0 #$ F#RS0 NAM+ 5AS0 NAM+ 4R$+R #$ S0R++0 7# *4$+ Mark for Review (1) oints 1st Normal Form () .nd Normal Form 8rd Normal Form
None of the a%ove6 the entit' is full' normalised #ncorrect Refer to Section 9 5esson :
Section 6
(Answer all questions in this section)
6. +,amine the followin- +ntit' and decide which rule of Normal Form is %ein-violated/ +N0#0/ *5#+N0 A00R#2"0+S/ 3 *5#+N0 #$ F#RS0 NAM+ 5AS0 NAM+ S0R++0 *#0 7# *4$+ Mark for Review (1) oints 1st Normal Form .nd Normal Form
8rd Normal Form
None of the a%ove6 the entit' is full' normalised ()
*orrect
7. +,amine the followin- +ntit' and decide which sets of attri%utes %reak the 8rd Normal Form rule/
+N0#0/ 0RA#N A00R#2"0+S/ 0RA#N #$ MA;+ $R#<+R #$ $R#<+R NAM+ $A0+ 4F MAN"FA*0"R+ Mark for Review (1) oints 0RA#N #$6 MA;+ $R#<+R #$6 $R#<+R NAM+ () MA;+6 $A0+ 4F MAN"FA*0"R+
None of the a%ove6 the entit' is alread' in 8rd Normal Form
*orrect
8. When data is stored in more than one &lace in a data%ase6 the data%ase
violates the rules of =========== Mark for
Review (1) oints $ecenc' Normali>ation () Normalc' Re&lication *orrect
9. When all attri%utes are sin-le!valued6 the data%ase model is said to
conform to/ Mark for
Review (1) oints 1st Normal Form () .nd Normal Form 8rd Normal Form :th Normal Form
*orrect
10.An entit' can have re&eated values and still %e in 1st Normal Form 0rue or
False? Mark for
Review (1) oints 0rue False () *orrect Section 6
(Answer all questions in this section)
11. 0o convert an entit' with a multi valued attri%ute to 1st Normal Form6 we create an additional entit' and relate it to the ori-inal entit' with a 1/1 relationshi& 0rue or False?
Mark for Review (1) oints 0rue
False ()
#ncorrect Refer to Section 9 5esson .
12.A unique identier can onl' %e made u& of one attri%ute 0rue or False? Mark for
Review (1) oints 0rue
False ()
*orrect
13.Where an entit' has more than one attri%ute suita%le to %e the rimar' "#$6
these are known as ============= "#$s Mark for
Review (1) oints Sim&le *andidate () Secondar' *om&osite
*orrect
14.#f an entit' has no attri%ute suita%le to %e a rimar' "#$6 we can create an
articial one 0rue or False? Mark for
Review (1) oints 0rue ()
False
*orrect
15.An entit' could have more than one attri%ute that would %e a suita%le
rimar' "#$ 0rue or False? Mark for
Review (1) oints 0rue () False *orrect Section 7
(Answer all questions in this section)
16.Arcs model an +,clusive 4R constraint 0rue or False? Mark for
Review (1) oints 0rue ()
False
*orrect
17.An arc can often %e modeled as Su&ert'&e and Su%t'&es 0rue or False? Mark for
Review (1) oints 0rue ()
False
18.Which of the followin- would %est %e re&resented %' an arc? Mark for
Review (1) oints S0"$+N0 (senior6 male)
S0"$+N0 (@rade A student6 Avera-e Student) S0"$+N0 (-raduatin-6 female)
S0"$+N0 ( "niversit'6 0echnical *olle-e) ()
#ncorrect Refer to Section 5esson 1
19.Arcs are used to visuall' re&resent ========= %etween two or more
relationshi&s in an +R$ Mark for
Review (1) oints #nheritance Sameness +,clusivit' () $iBerences *orrect
20.A Cierarchical relationshi& is a series of relationshi&s that reDect entities
or-ani>ed into successive levels 0rue or False? Mark for
Review (1) oints 0rue () False *orrect Section 7
(Answer all questions in this section)
21.A Recursive Relationshi& is re&resented on an +R$ %' aEan/ Mark for
Review (1) oints $o-s 0ail
Sin-le 0oe *rows Foot
i-s +ar ()
*orrect
22.2usiness or-ani>ational charts are often modeled as a Cierarchical
relationshi& 0rue or False? Mark for
Review (1) oints 0rue ()
False
*orrect
23.A recursive relationshi& must %e Mandator' at %oth ends 0rue or False? Mark for
Review (1) oints 0rue
False ()
*orrect
24.A sin-le relationshi& can %e %oth Recursive and Cierarchical at the same
time 0rue or False? Mark for
Review (1) oints 0rue False () *orrect Section 8
(Answer all questions in this section)
25.Cistorical data should alwa's %e ke&t 0rue or False? Mark for
Review (1) oints 0rue
*orrect Section 8
(Answer all questions in this section)
26.When modelin- historical data the unique identier is alwa's made u& of a
%arred relationshi& from the ori-inal two entities 0rue or False? Mark for Review (1) oints 0rue
False ()
#ncorrect Refer to Section G 5esson 1
27.Modelin- historical data is o&tional 0rue or False? Mark for
Review (1) oints 0rue ()
False
*orrect
28.Which of the followin- would %e a lo-ical constraint when modelin- time for
a *it' entit'? Mark for
Review (1) oints *ites ma' chan-e their names andEor countr' association if the %orders
of a countr' chan-e ()
$ail' traHc &atterns must %e monitored to determine how man' law enforcement oHcers are needed
eo&le are %orn in the cit' and &eo&le die in the cit'
#f 'ou are doin- a s'stem for an' French *it'6 'ou would need securit' clearance
*orrect
29.What is the function of lo--in- or Iournalin- in conce&tual data models? Mark for
Review (1) oints Re&resents entities as time in the data model
@ives a timestam& to all entities
Allows 'ou to track the histor' of attri%ute values6 relationshi&s6 andEor entire entities ()
*reates a ,ed time for all events in a data model
*orrect
30.Wh' would 'ou want to model a time com&onent when desi-nin- a s'stem
that lets &eo&le %u' %ars of -old? Mark for
Review (1) oints 0he &rice of -old Ductuates and6 to determine the current &rice6 'ou
need to know the time of &urchase ()
0he @overnment of 'our countr' mi-ht want to %e notied of this transaction
ou would not want to model thisJ it is not im&ortant
Sales &eo&le must determine where the -old is comin- from
*orrect Section 8
(Answer all questions in this section)
31.No formal rules e,ist for drawin- +R$s 0he most im&ortant thin- is to make sure that all entities6 attri%utes6 and relationshi&s are documented on the dia-ram6 and the dia-ram is clear and reada%le 0rue or False?
Mark for Review (1) oints 0rue () False *orrect
32. ou must make sure all entities of a &ro&osed s'stem can t onto one dia-ram #t is not allowed to %reak u& a data model into more than one dia-ram 0rue or False?
Mark for Review (1) oints 0rue False () *orrect Section 9
(Answer all questions in this section)
33.An KArc #m&lementationK can %e done Iust like an' other Relationshi& ! 'ou
Review (1) oints 0rue
False ()
#ncorrect Refer to Section L 5esson :
34.When translatin- an arc relationshi& to a &h'sical desi-n6 'ou must turn the arc relationshi&s into forei-n ke's What additional ste& must 'ou take with the created forei-n ke's to ensure the e,clusivit' &rinci&le of arc
relationshi&s? (Assume that 'ou are im&lementin- an +,clusive $esi-n) (*hoose 0wo)
Mark for Review (1) oints (*hoose all correct answers)
Make all relationshi&s mandator' Make all relationshi&s o&tional ()
*reate an additional check constraint to verif' that one forei-n ke' is &o&ulated and the others are not ()
All the a%ove
*orrect
35. 0he e,&lanation %elow is an e,am&le of which constraint t'&e?
A &rimar' ke' must %e unique6 and no &art of the &rimar' ke' can %e null Mark for Review (1) oints Referential inte-rit' "ser!dened inte-rit' *olumn inte-rit' +ntit' inte-rit' () *orrect Section 9
(Answer all questions in this section)
36.#dentif' all of the incorrect statements that com&lete this sentence/ A
&rimar' ke' is(*hoose three) Mark for
Review (1) oints (*hoose all correct answers)
4nl' one column that must %e null ()
4ne or more columns in a ta%le that uniquel' identies each row in that ta%le
A set of columns in one ta%le that uniquel' identies each row in another ta%le ()
*orrect
37. 0he e,&lanation %elow is an e,am&le of which constraint t'&e?
0he value in the de&t=no column of the +M54++S ta%le must match a value in the de&t=no column in the $+AR0M+N0S ta%le
Mark for Review (1) oints Referential inte-rit' () +ntit' inte-rit' *olumn inte-rit' "ser!dened inte-rit' *orrect
38. 0he e,&lanation %elow is an e,am&le of which constraint t'&e?
#f the value in the %alance column of the A**4"N0S ta%le is %elow 16 we must send a letter to the account owner which will require e,tra
&ro-rammin- to enforce Mark for Review (1) oints *olumn inte-rit' +ntit' inte-rit' "ser!dened inte-rit' () Referential inte-rit' *orrect
39.Forei-n ke's cannot %e null when Mark for
Review (1) oints #t refers to another ta%le
#t contains three or more columns #t is &art of a &rimar' ke' () #t refers to the same ta%le
#ncorrect Refer to Section L 5esson 1
Review (1) oints 0rue () False *orrect Section 9
(Answer all questions in this section)
41. 0he h'sical model is created %' transformin- which of the
followin-models? Mark for
Review (1) oints 0a%le h'sical *once&tual () *onstraint *orrect
42.#n a &h'sical data model6 a relationshi& is re&resented as a/ Mark for
Review (1) oints "nique #dentier *olumn Forei-n ;e' () rimar' ;e' *orrect
43.#n an 4racle data%ase6 wh' would 1=0A25+ not work as a ta%le name? Mark for
Review (1) oints 0A25+ is a reserved word
4%Iect names must not start with a num%er 0he' must %e-in with a letter ()
0he data%ase does not understand all ca&ital letters
*orrect
44.4ne!to!4ne relationshi&s are transformed into Forei-n ;e's in the ta%les
created at either end of that relationshi& 0rue or False? Mark for Review (1) oints 0rue
False ()
#ncorrect Refer to Section L 5esson 8
45. 0he 4racle $ata%ase can im&lement a man' to man' relationshi& ou
sim&l' create two forei-n ke's %etween the two ta%les 0rue or False? Mark for Review (1) oints 0rue False () *orrect ection 9
(Answer all questions in this section)
46. 0o resolve a man' to man' relationshi& in a &h'sical model 'ou create a(n)
===================? Mark for
Review (1) oints 0wo ta%les with Forei-n ke' constraints %etween them
#ntersection entit' #ntersection ta%le () "nique ke' constraints
*orrect
47.A %arrred Relationshi& will result in a Forei-n ;e' column that also is &art
of/ Mark for
Review (1) oints 0he *olumn Name
0he rimar' ;e' () 0he 0a%le Name
0he *heck *onstraint
#ncorrect Refer to Section L 5esson 8
48.4ne!to!Man' 4&tional to Mandator' %ecomes a =============== on the
Master ta%le Mark for
Review (1) oints 4&tional Forei-n ;e' ()
"nique ;e' rimar' ;e'
Mandator' Forei-n ;e'
#ncorrect Refer to Section L 5esson 8
Section 10
(Answer all questions in this section)
49.S'stems are alwa's Iust rolled out as soon as the &ro-rammin- &hase is nished No further work is required once the develo&ment is nished 0rue or False? Mark for Review (1) oints 0rue False () *orrect
50. 0he data model can %e used to Mark for
Review (1) oints *ommunicate and conrm
$escri%e and s&ecif' Anal'>e and rene All of the A%ove ()
