k7tXnfWm

11. 	Examine the following Entity and decide which rule of Normal Form is being violated:
2
3ENTITY: CLIENT
4ATTRIBUTES:
5    # CLIENT ID
6    FIRST NAME
7    LAST NAME
8    STREET
9    CITY
10    ZIP CODE
11	Mark for Review 
12(1) Points
13					
14			
15	1st Normal Form.
16	
17			
18	2nd Normal Form.
19	
20			
21	3rd Normal Form.
22	
23			
24	None of the above, the entity is fully normalised. (*)
25	
26					
27				
28[Correct] 		Correct
29	
30					
31		2. 	Examine the following Entity and decide which rule of Normal Form is being violated:
32
33ENTITY: CLIENT ORDER
34ATTRIBUTES:
35    # CLIENT ID
36    # ORDER ID
37    FIRST NAME
38    LAST NAME
39    ORDER DATE
40    CITY
41    ZIP CODE
42	Mark for Review 
43(1) Points
44					
45			
46	1st Normal Form.
47	
48			
49	2nd Normal Form. (*)
50	
51			
52	3rd Normal Form.
53	
54			
55	None of the above, the entity is fully normalised.
56	
57					
58				
59[Correct] 		Correct
60	
61					
62		3. 	A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity. 	Mark for Review 
63(1) Points
64					
65			
66	True (*)
67	
68			
69	False
70	
71					
72				
73[Correct] 		Correct
74	
75					
76		4. 	Examine the following Entity and decide which sets of attributes break the 3rd Normal Form rule:
77
78ENTITY: TRAIN
79ATTRIBUTES:
80    TRAIN ID
81    MAKE
82    DRIVER ID
83    DRIVER NAME
84    DATE OF MANUFACTURE
85	Mark for Review 
86(1) Points
87					
88			
89	TRAIN ID, MAKE
90	
91			
92	DRIVER ID, DRIVER NAME (*)
93	
94			
95	MAKE, DATE OF MANUFACTURE
96	
97			
98	None of the above, the entity is already in 3rd Normal Form.
99	
100					
101				
102[Correct] 		Correct
103	
104					
105		5. 	Any Non-UID attribute must be dependent upon the entire UID. True or False? 	Mark for Review 
106(1) Points
107					
108			
109	True (*)
110	
111			
112	False
113	
114					
115				
116[Correct] 		Correct 
1171. 	Examine the following Entity and decide which rule of Normal Form is being violated:
118
119ENTITY: CLIENT
120ATTRIBUTES:
121    # CLIENT ID
122    FIRST NAME
123    LAST NAME
124    STREET
125    CITY
126    ZIP CODE
127	Mark for Review 
128(1) Points
129					
130			
131	1st Normal Form.
132	
133			
134	2nd Normal Form.
135	
136			
137	3rd Normal Form.
138	
139			
140	None of the above, the entity is fully normalised. (*)
141	
142					
143				
144[Correct] 		Correct
145	
146					
147		2. 	Examine the following Entity and decide which rule of Normal Form is being violated:
148
149ENTITY: CLIENT ORDER
150ATTRIBUTES:
151    # CLIENT ID
152    # ORDER ID
153    FIRST NAME
154    LAST NAME
155    ORDER DATE
156    CITY
157    ZIP CODE
158	Mark for Review 
159(1) Points
160					
161			
162	1st Normal Form.
163	
164			
165	2nd Normal Form. (*)
166	
167			
168	3rd Normal Form.
169	
170			
171	None of the above, the entity is fully normalised.
172	
173					
174				
175[Correct] 		Correct
176	
177					
178		3. 	A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity. 	Mark for Review 
179(1) Points
180					
181			
182	True (*)
183	
184			
185	False
186	
187					
188				
189[Correct] 		Correct
190	
191					
192		4. 	Examine the following Entity and decide which sets of attributes break the 3rd Normal Form rule:
193
194ENTITY: TRAIN
195ATTRIBUTES:
196    TRAIN ID
197    MAKE
198    DRIVER ID
199    DRIVER NAME
200    DATE OF MANUFACTURE
201	Mark for Review 
202(1) Points
203					
204			
205	TRAIN ID, MAKE
206	
207			
208	DRIVER ID, DRIVER NAME (*)
209	
210			
211	MAKE, DATE OF MANUFACTURE
212	
213			
214	None of the above, the entity is already in 3rd Normal Form.
215	
216					
217				
218[Correct] 		Correct
219	
220					
221		5. 	Any Non-UID attribute must be dependent upon the entire UID. True or False? 	Mark for Review 
222(1) Points
223					
224			
225	True (*)
226	
227			
228	False
229	
230					
231				
232[Correct] 		Correct 
2331. 	Examine the following Entity and decide which rule of Normal Form is being violated:
234
235ENTITY: CLIENT
236ATTRIBUTES:
237    # CLIENT ID
238    FIRST NAME
239    LAST NAME
240    STREET
241    CITY
242    ZIP CODE
243	Mark for Review 
244(1) Points
245					
246			
247	1st Normal Form.
248	
249			
250	2nd Normal Form.
251	
252			
253	3rd Normal Form.
254	
255			
256	None of the above, the entity is fully normalised. (*)
257	
258					
259				
260[Correct] 		Correct
261	
262					
263		2. 	Examine the following Entity and decide which rule of Normal Form is being violated:
264
265ENTITY: CLIENT ORDER
266ATTRIBUTES:
267    # CLIENT ID
268    # ORDER ID
269    FIRST NAME
270    LAST NAME
271    ORDER DATE
272    CITY
273    ZIP CODE
274	Mark for Review 
275(1) Points
276					
277			
278	1st Normal Form.
279	
280			
281	2nd Normal Form. (*)
282	
283			
284	3rd Normal Form.
285	
286			
287	None of the above, the entity is fully normalised.
288	
289					
290				
291[Correct] 		Correct
292	
293					
294		3. 	A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity. 	Mark for Review 
295(1) Points
296					
297			
298	True (*)
299	
300			
301	False
302	
303					
304				
305[Correct] 		Correct
306	
307					
308		4. 	Examine the following Entity and decide which sets of attributes break the 3rd Normal Form rule:
309
310ENTITY: TRAIN
311ATTRIBUTES:
312    TRAIN ID
313    MAKE
314    DRIVER ID
315    DRIVER NAME
316    DATE OF MANUFACTURE
317	Mark for Review 
318(1) Points
319					
320			
321	TRAIN ID, MAKE
322	
323			
324	DRIVER ID, DRIVER NAME (*)
325	
326			
327	MAKE, DATE OF MANUFACTURE
328	
329			
330	None of the above, the entity is already in 3rd Normal Form.
331	
332					
333				
334[Correct] 		Correct
335	
336					
337		5. 	Any Non-UID attribute must be dependent upon the entire UID. True or False? 	Mark for Review 
338(1) Points
339					
340			
341	True (*)
342	
343			
344	False
345	
346					
347				
348[Correct] 		Correct 
3491. 	Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two) 	Mark for Review 
350(1) Points
351					
352			(Choose all correct answers) 	
353					
354			
355	Social Security Number (*)
356	
357			
358	Address
359	
360			
361	Last Name
362	
363			
364	Employee ID (*)
365	
366					
367				
368[Correct] 		Correct
369	
370					
371		2. 	An entity could have more than one attribute that would be a suitable Primary UID. True or False? 	Mark for Review 
372(1) Points
373					
374			
375	True (*)
376	
377			
378	False
379	
380					
381				
382[Correct] 		Correct
383	
384					
385		3. 	If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False? 	Mark for Review 
386(1) Points
387					
388			
389	True (*)
390	
391			
392	False
393	
394					
395				
396[Correct] 		Correct
397	
398					
399		4. 	The candidate UID that is chosen to identify an entity is called the Primary UID; other candidate UIDs are called Secondary UIDs. 	Mark for Review 
400(1) Points
401					
402			
403	Yes, this is the way UID's are named. (*)
404	
405			
406	No, it is not possible to have more than one UID for an Entity.
407	
408			
409	No, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc.
410	
411			
412	No, each Entity can only have one UID, the secondary one.
413	
414					
415				
416[Correct] 		Correct
417	
418					
419		5. 	Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:
420
421ENTITY: RECEIPT
422ATTRIBUTES:
423   #CUSTOMER ID
424   #STORE ID
425   STORE LOCATION
426   DATE
427	Mark for Review 
428(1) Points
429					
430			
431	Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity. (*)
432	
433			
434	Do nothing, it is already in 2nd Normal Form.
435	
436			
437	Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.
438	
439			
440	Delete the attribute STORE ID
441	
442					
443				
444[Incorrect] 		Incorrect. Refer to Section 6 Lesson 3. 
4456. 	When is an entity in 2nd Normal Form? 	Mark for Review 
446(1) Points
447					
448			
449	When all non-UID attributes are dependent upon the entire UID. (*)
450	
451			
452	When attributes with repeating or multi-values are present.
453	
454			
455	When no attritibutes are mutually independent and all are fully dependent on the primary key.
456	
457			
458	None of the Above.
459	
460					
461				
462[Incorrect] 		Incorrect. Refer to Section 6 Lesson 3.
463	
464					
465		7. 	To resolve a 2nd Normal Form violation, we: 	Mark for Review 
466(1) Points
467					
468			
469	Move the attribute that violates 2nd Normal Form to a new ERD.
470	
471			
472	Move the attribute that violates 2nd Normal Form to a new entity with a relationship to the original entity. (*)
473	
474			
475	Do nothing, an entity does not need to be in 2nd Normal Form.
476	
477			
478	Delete the attribute that was causing the violation.
479	
480					
481				
482[Incorrect] 		Incorrect. Refer to Section 6 Lesson 3.
483	
484					
485		8. 	When data is stored in more than one place in a database, the database violates the rules of ___________. 	Mark for Review 
486(1) Points
487					
488			
489	Normalcy
490	
491			
492	Normalization (*)
493	
494			
495	Decency
496	
497			
498	Replication
499	
500					
501				
502[Incorrect] 		Incorrect. Refer to Section 6 Lesson 2.
503	
504					
505		9. 	If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we: 	Mark for Review 
506(1) Points
507					
508			
509	Make the attribute optional
510	
511			
512	Create an additional entity and relate it to the original entity with a 1:M relationship. (*)
513	
514			
515	Create an additional entity and relate it to the original entity with a M:M relationship.
516	
517			
518	Do nothing, an entity does not have to be in 1st Normal Form
519	
520					
521				
522[Correct] 		Correct
523	
524					
525		10. 	An entity can have repeated values and still be in 1st Normal Form. True or False? 	Mark for Review 
526(1) Points
527					
528			
529	True
530	
531			
532	False (*)
533	
534					
535				
536[Incorrect] 		Incorrect. Refer to Section 6 Lesson 2. 
53711. 	Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False? 	Mark for Review 
538(1) Points
539					
540			
541	True (*)
542	
543			
544	False
545	
546					
547				
548[Correct] 		Correct
549	
550					
551		12. 	As a database designer, you do not need to worry about where in the datamodel you store a particular attribute; as long as you get it onto the ERD, your job is done. True or False? 	Mark for Review 
552(1) Points
553				
554			
555	True
556	
557			
558	False (*)
559	
560					
561				
562[Incorrect] 		Incorrect. Refer to Section 6 Lesson 4.
563	
564					
565		13. 	Examine the following Entity and decide which sets of attributes break the 3rd Normal Form rule:
566
567ENTITY: TRAIN
568ATTRIBUTES:
569    TRAIN ID
570    MAKE
571    DRIVER ID
572    DRIVER NAME
573    DATE OF MANUFACTURE
574	Mark for Review 
575(1) Points
576					
577			
578	TRAIN ID, MAKE
579	
580			
581	DRIVER ID, DRIVER NAME (*)
582	
583			
584	MAKE, DATE OF MANUFACTURE
585	
586			
587	None of the above, the entity is already in 3rd Normal Form.
588	
589					
590				
591[Incorrect] 		Incorrect. Refer to Section 6 Lesson 4.
592	
593					
594		14. 	When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as: 	Mark for Review 
595(1) Points
596					
597			
598	Functional dependency
599	
600			
601	Non-dependency
602	
603			
604	Transitive dependency (*)
605	
606			
607	Dependency
608	
609					
610				
611[Incorrect] 		Incorrect. Refer to Section 6 Lesson 4.
612	
613					
614		15. 	Examine the following Entity and decide which rule of Normal Form is being violated:
615
616ENTITY: CLIENT
617ATTRIBUTES:
618    # CLIENT ID
619    FIRST NAME
620    LAST NAME
621    STREET
622    CITY
623    ZIP CODE
624	Mark for Review 
625(1) Points
626					
627			
628	1st Normal Form.
629	
630			
631	2nd Normal Form.
632	
633			
634	3rd Normal Form.
635	
636			
637	None of the above, the entity is fully normalised. (*)
638	
639					
640				
641[Incorrect] 		Incorrect. Refer to Section 6 Lesson 4.
6421. 	The candidate UID that is chosen to identify an entity is called the Primary UID; other candidate UIDs are called Secondary UIDs. 	Mark for Review 
643(1) Points
644					
645			
646	Yes, this is the way UID's are named. (*)
647	
648			
649	No, each Entity can only have one UID, the secondary one.
650	
651			
652	No, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc.
653	
654			
655	No, it is not possible to have more than one UID for an Entity.
656	
657					
658				
659[Correct] 		Correct
660	
661					
662		2. 	People are not born with 'numbers', but a lot of systems assign student numbers, customer IDs, etc. ï¾ These are known as a/an ______________ UID. 	Mark for Review 
663(1) Points
664					
665			
666	Unrealistic
667	
668			
669	Identification
670	
671			
672	Structured
673	
674			
675	Artificial (*)
676	
677					
678				
679[Correct] 		Correct
680	
681					
682		3. 	An entity can only have one Primary UID. True or False? 	Mark for Review 
683(1) Points
684					
685			
686	True (*)
687	
688			
689	False
690	
691					
692				
693[Incorrect] 		Incorrect. Refer to Section 6 Lesson 1.
694	
695					
696		4. 	If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False? 	Mark for Review 
697(1) Points
698					
699			
700	True (*)
701	
702			
703	False
704	
705					
706				
707[Correct] 		Correct
708	
709					
710		5. 	To resolve a 2nd Normal Form violation, we: 	Mark for Review 
711(1) Points
712					
713			
714	Delete the attribute that was causing the violation.
715	
716			
717	Move the attribute that violates 2nd Normal Form to a new entity with a relationship to the original entity. (*)
718	
719			
720	Do nothing, an entity does not need to be in 2nd Normal Form.
721	
722			
723	Move the attribute that violates 2nd Normal Form to a new ERD.
724	
725					
726				
727[Correct] 		Correct
728	
729				6. 	Any Non-UID attribute must be dependent upon the entire UID. True or False? 	Mark for Review 
730(1) Points
731					
732			
733	True (*)
734	
735			
736	False
737	
738					
739				
740[Correct] 		Correct
741	
742					
743		7. 	What is the rule of Second Normal Form? 	Mark for Review 
744(1) Points
745					
746			
747	No non-UID attributes can be dependent on any part of the UID.
748	
749			
750	Some non-UID attributes can be dependent on the entire UID.
751	
752			
753	All non-UID attributes must be dependent upon the entire UID. (*)
754	
755			
756	None of the above
757	
758					
759				
760[Incorrect] 		Incorrect. Refer to Section 6 Lesson 3.
761	
762					
763		8. 	Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False? 	Mark for Review 
764(1) Points
765					
766			
767	True (*)
768	
769			
770	False
771	
772					
773				
774[Correct] 		Correct
775	
776					
777		9. 	An entity ORDER has the attributes Order ID, Order Date, Product id, Customer ID. This entity is in 1st Normal Form. True or False? 	Mark for Review 
778(1) Points
779					
780			
781	True
782	
783			
784	False (*)
785	
786					
787				
788[Correct] 		Correct
789	
790					
791		10. 	When data is only stored in one place in a database, the database conforms to the rules of ___________. 	Mark for Review 
792(1) Points
793					
794			
795	Normalization (*)
796	
797			
798	Multiplication
799	
800			
801	Normality
802	
803			
804	Reduction
805	
806					
807				
808[Incorrect] 		Incorrect. Refer to Section 6 Lesson 2. 
80911. 	To convert an entity with a multi valued attribute to 1st Normal Form, we create an additional entity and relate it to the original entity with a 1:1 relationship. True or False? 	Mark for Review 
810(1) Points
811					
812			
813	True
814	
815			
816	False (*)
817	
818					
819				
820[Incorrect] 		Incorrect. Refer to Section 6 Lesson 2.
821	
822					
823		12. 	Examine the following Entity and decide which rule of Normal Form is being violated:
824
825ENTITY: CLIENT
826ATTRIBUTES:
827    # CLIENT ID
828    FIRST NAME
829    LAST NAME
830    STREET
831    CITY
832    ZIP CODE
833	Mark for Review 
834(1) Points
835					
836			
837	1st Normal Form.
838	
839			
840	2nd Normal Form.
841	
842			
843	3rd Normal Form.
844	
845			
846	None of the above, the entity is fully normalised. (*)
847	
848					
849				
850[Incorrect] 		Incorrect. Refer to Section 6 Lesson 4.
851	
852					
853		13. 	Examine the following Entity and decide which rule of Normal Form is being violated:
854
855ENTITY: CLIENT ORDER
856ATTRIBUTES:
857    # CLIENT ID
858    # ORDER ID
859    FIRST NAME
860    LAST NAME
861    ORDER DATE
862    CITY
863    ZIP CODE
864	Mark for Review 
865(1) Points
866					
867			
868	1st Normal Form.
869	
870			
871	2nd Normal Form. (*)
872	
873			
874	3rd Normal Form.
875	
876			
877	None of the above, the entity is fully normalised.
878	
879					
880				
881[Correct] 		Correct
882	
883					
884		14. 	A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity. 	Mark for Review 
885(1) Points
886					
887			
888	True (*)
889	
890			
891	False
892	
893					
894				
895[Correct] 		Correct
896	
897					
898		15. 	When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as: 	Mark for Review 
899(1) Points
900					
901			
902	Transitive dependency (*)
903	
904			
905	Non-dependency
906	
907			
908	Functional dependency
909	
910			
911	Dependency
912	
913					
914				
915[Correct] 		Correct
916	
917				7. 	There is no limit to how many columns can make up an entity's UID. True or False? 	Mark for Review 
918(1) Points
919					
920			
921	True (*)
922	
923			
924	False
925	
926					
927				
928[Correct] 		Correct
929	
930					
931		8. 	A unique identifier can only be made up of one attribute. True or False? 	Mark for Review 
932(1) Points
933					
934			
935	True
936	
937			
938	False (*)
939	
940					
941				
942[Incorrect] 		Incorrect. Refer to Section 6 Lesson 1.
943	
944					
945		9. 	The Rule of 3rd Normal Form states that No Non-UID attribute can be dependent on another non-UID attribute. True or False? 	Mark for Review 
946(1) Points
947					
948			
949	True (*)
950	
951			
952	False
953	
954					
955				
956[Correct] 		Correct
957	10. 	Examine the following Entity and decide which rule of Normal Form is being violated:
958
959ENTITY: CLIENT
960ATTRIBUTES:
961    # CLIENT ID
962    FIRST NAME
963    LAST NAME
964    ORDER ID
965    STREET
966    ZIP CODE
967	Mark for Review 
968(1) Points
969					
970			
971	1st Normal Form. (*)
972	
973			
974	2nd Normal Form.
975	
976			
977	3rd Normal Form.
978	
979			
980	None of the above, the entity is fully normalised.
981	
982				1. 	Examine the following Entity and decide which rule of Normal Form is being violated:
983
984ENTITY: CLIENT
985ATTRIBUTES:
986    # CLIENT ID
987    FIRST NAME
988    LAST NAME
989    STREET
990    CITY
991    ZIP CODE
992	Mark for Review 
993(1) Points
994					
995			
996	1st Normal Form.
997	
998			
999	2nd Normal Form.
1000	
1001			
1002	3rd Normal Form.
1003	
1004			
1005	None of the above, the entity is fully normalised. (*)
1006	
1007					
1008				
1009[Incorrect] 		Incorrect. Refer to Section 6 Lesson 4.
1010	
1011					
1012		12. 	When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as: 	Mark for Review 
1013(1) Points
1014					
1015			
1016	Functional dependency
1017	
1018			
1019	Non-dependency
1020	
1021			
1022	Transitive dependency (*)
1023	
1024			
1025	Dependency
1026	
1027					
1028				
1029[Correct] 		Correct
1030	
1031					
1032		13. 	To resolve a 2nd Normal Form violation, we: 	Mark for Review 
1033(1) Points
1034					
1035			
1036	Do nothing, an entity does not need to be in 2nd Normal Form.
1037	
1038			
1039	Move the attribute that violates 2nd Normal Form to a new ERD.
1040	
1041			
1042	Move the attribute that violates 2nd Normal Form to a new entity with a relationship to the original entity. (*)
1043	
1044			
1045	Delete the attribute that was causing the violation.
1046	
1047					
1048				
1049[Correct] 		Correct
1050	
1051					
1052		14. 	When is an entity in 2nd Normal Form? 	Mark for Review 
1053(1) Points
1054					
1055			
1056	When all non-UID attributes are dependent upon the entire UID. (*)
1057	
1058			
1059	When attributes with repeating or multi-values are present.
1060	
1061			
1062	When no attritibutes are mutually independent and all are fully dependent on the primary key.
1063	
1064			
1065	None of the Above.
1066	
1067					
1068				
1069[Correct] 		Correct
1070	
1071					
1072		15. 	Examine the following entity and decide which attribute breaks the 2nd Normal Form rule:
1073
1074ENTITY: CLASS
1075ATTRIBUTES:
1076   #CLASS ID
1077   #TEACHER ID
1078   SUBJECT
1079   TEACHER NAME
1080	Mark for Review 
1081(1) Points
1082					
1083			
1084	CLASS ID
1085	
1086			
1087	TEACHER NAME (*)
1088	
1089			
1090	TEACHER ID
1091	
1092			
1093	SUBJECT
1094	
1095					
1096				
1097[Incorrect] 		Incorrect. Refer to Section 6 Lesson 3.
1098
1099
1100Section 7 Quiz
1101	(Answer all questions in this section)
1102					
1103		1. 	Every business has restrictions on which attribute values and which relationships are allowed. These are known as:	 Mark for Review 
1104(1) Points
1105					
1106			
1107	Entities.
1108
1109			
1110	Constraints. (*)
1111
1112			
1113	Relationships
1114
1115			
1116	Attributes
1117
1118					
1119				
1120Correct		Correct
1121
1122					
1123		2. 	A relationship between an entity and itself is called a/an:	 Mark for Review 
1124(1) Points
1125					
1126			
1127	STUDENT (senior, male)
1128
1129			
1130	STUDENT ( University, Technical College) (*)
1131
1132			
1133	STUDENT (Grade A student, Average Student)
1134
1135			
1136	STUDENT (graduating, female)
1137
1138					
1139				
1140Correct		Correct
1141
1142					
1143		3. 	Which of the following can be added to a relationship?	 Mark for Review 
1144(1) Points
1145					
1146			
1147	An optional attribute can be created
1148
1149			
1150	A composite attribute
1151
1152			
1153	An attribute
1154
1155			
1156	An arc can be assigned (*)
1157
1158					
1159				
1160Correct		Correct
1161
1162					
1163		4. 	Which of the following would best be represented by an arc?	 Mark for Review 
1164(1) Points
1165					
1166			
1167	STUDENT (Grade A student, Average Student)
1168
1169			
1170	TEACHER (Female, Bob)
1171
1172			
1173	PARENT (Girl, Bob)
1174
1175			
1176	DELIVERY ADDRESS (Home, Office) (*)
1177
1178					
1179				
1180Correct		Correct
1181
1182					
1183		5. 	To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.	 Mark for Review 
1184(1) Points
1185					
1186			
1187	Relationship
1188
1189			
1190	Arc (*)
1191
1192			
1193	UID
1194
1195			
1196	Attribute
1197
1198					
1199				
1200Correct		Correct
1201
1202					
1203Page 1 of 3	Next	Summary
1204 
1205Section 7 Quiz
1206	(Answer all questions in this section)
1207					
1208		6. 	Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False?	 Mark for Review 
1209(1) Points
1210					
1211			
1212	True
1213
1214			
1215	False (*)
1216
1217					
1218				
1219Correct		Correct
1220
1221					
1222		7. 	An arc can often be modeled as Supertype and Subtypes. True or False?	 Mark for Review 
1223(1) Points
1224					
1225			
1226	True (*)
1227
1228			
1229	False
1230
1231					
1232				
1233Correct		Correct
1234
1235					
1236		8. 	Arcs are used to visually represent _________ between two or more relationships in an ERD.	 Mark for Review 
1237(1) Points
1238					
1239			
1240	Sameness
1241
1242			
1243	Differences
1244
1245			
1246	Exclusivity (*)
1247
1248			
1249	Inheritance
1250
1251					
1252				
1253Incorrect		Incorrect. Refer to Section 7 Lesson 1.
1254
1255					
1256		9. 	A recursive relationship must be Mandatory at both ends. True or False?	 Mark for Review 
1257(1) Points
1258					
1259			
1260	True
1261
1262			
1263	False (*)
1264
1265					
1266				
1267Correct		Correct
1268
1269					
1270		10. 	A single relationship can be both Recursive and Hierarchical at the same time. True or False?	 Mark for Review 
1271(1) Points
1272					
1273			
1274	True
1275
1276			
1277	False (*)
1278
1279					
1280				
1281Incorrect		Incorrect. Refer to Section 7 Lesson 2.
1282
1283					
1284Previous	Page 2 of 3	Next	Summary
1285 
1286	Section 7 Quiz
1287	(Answer all questions in this section)
1288					
1289		11. 	Business organizational charts are often modeled as a Hierarchical relationship. True or False?	 Mark for Review 
1290(1) Points
1291					
1292			
1293	True (*)
1294
1295			
1296	False
1297
1298					
1299				
1300Correct		Correct
1301
1302					
1303		12. 	A Recursive Relationship is represented on an ERD by a/an:	 Mark for Review 
1304(1) Points
1305					
1306			
1307	Crow's Foot
1308
1309			
1310	Pig's Ear (*)
1311
1312			
1313	Single Toe
1314
1315			
1316	Dog's Tail
1317
1318					
1319				
1320Correct		Correct
1321
1322					
1323		13. 	A relationship between an entity and itself is called a/an:	 Mark for Review 
1324(1) Points
1325					
1326			
1327	General Relationship
1328
1329			
1330	Heirarchical Relationship
1331
1332			
1333	Recursive Relationship (*)
1334
1335			
1336	Invalid Relationship
1337
1338					
1339				
1340Correct		Correct
1341
1342					
1343		14. 	Cascading UIDs are a feature often found in what type of Relationship?	 Mark for Review 
1344(1) Points
1345					
1346			
1347	General Relationship
1348
1349			
1350	Invalid Relationship
1351
1352			
1353	Heirarchical Relationship (*)
1354
1355			
1356	Recursive Relationship
1357
1358					
1359				
1360Incorrect		Incorrect. Refer to Section 7 Lesson 2.
1361
1362					
1363		15. 	A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False?	 Mark for Review 
1364(1) Points
1365					
1366			
1367	True (*)
1368
1369			
1370	False
1371
1372					
1373				
1374Correct		Correct
1375
1376					
1377Previous	Page 3 of 3	Summary
1378 
13791. 	Which of the following would best be represented by an arc? 	Mark for Review 
1380(1) Points
1381					
1382			
1383	STUDENT (Grade A student, Average Student)
1384	
1385			
1386	DELIVERY ADDRESS (Home, Office) (*)
1387	
1388			
1389	PARENT (Girl, Bob)
1390	
1391			
1392	TEACHER (Female, Bob)
1393	
1394					
1395				
1396[Correct] 		Correct
1397	
1398					
1399		2. 	Arcs model an Exclusive OR constraint. True or False? 	Mark for Review 
1400(1) Points
1401					
1402			
1403	True (*)
1404	
1405			
1406	False
1407	
1408					
1409				
1410[Correct] 		Correct
1411	
1412					
1413		3. 	Arcs are used to visually represent _________ between two or more relationships in an ERD. 	Mark for Review 
1414(1) Points
1415					
1416			
1417	Differences
1418	
1419			
1420	Inheritance
1421	
1422			
1423	Exclusivity (*)
1424	
1425			
1426	Sameness
1427	
1428					
1429				
1430[Correct] 		Correct
1431	
1432					
1433		4. 	All relationships participating in an arc must be mandatory. True or False? 	Mark for Review 
1434(1) Points
1435					
1436			
1437	True
1438	
1439			
1440	False (*)
1441	
1442					
1443				
1444[Incorrect] 		Incorrect. Refer to Section 7 Lesson 1.
1445	
1446					
1447		5. 	Every business has restrictions on which attribute values and which relationships are allowed. These are known as: 	Mark for Review 
1448(1) Points
1449					
1450			
1451	Entities.
1452	
1453			
1454	Constraints. (*)
1455	
1456			
1457	Relationships
1458	
1459			
1460	Attributes
1461	
1462					
1463				
1464[Incorrect] 		Incorrect. Refer to Section 7 Lesson 1. 
1465 			
1466		6. 	Which of the following would best be represented by an arc? 	Mark for Review 
1467(1) Points
1468					
1469			
1470	STUDENT ( University, Technical College) (*)
1471	
1472			
1473	STUDENT (senior, male)
1474	
1475			
1476	STUDENT (Grade A student, Average Student)
1477	
1478			
1479	STUDENT (graduating, female)
1480	
1481					
1482				
1483[Correct] 		Correct
1484	
1485					
1486		7. 	Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False? 	Mark for Review 
1487(1) Points
1488					
1489			
1490	True
1491	
1492			
1493	False (*)
1494	
1495					
1496				
1497[Correct] 		Correct
1498	
1499					
1500		8. 	An arc can often be modeled as Supertype and Subtypes. True or False? 	Mark for Review 
1501(1) Points
1502					
1503			
1504	True (*)
1505	
1506			
1507	False
1508	
1509					
1510				
1511[Incorrect] 		Incorrect. Refer to Section 7 Lesson 1.
1512	
1513					
1514		9. 	A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False? 	Mark for Review 
1515(1) Points
1516					
1517			
1518	True (*)
1519	
1520			
1521	False
1522	
1523					
1524				
1525[Correct] 		Correct
1526	
1527					
1528		10. 	Cascading UIDs are a feature often found in what type of Relationship? 	Mark for Review 
1529(1) Points
1530					
1531			
1532	Recursive Relationship
1533	
1534			
1535	General Relationship
1536	
1537			
1538	Heirarchical Relationship (*)
1539	
1540			
1541	Invalid Relationship
1542	
1543					
1544				
1545[Correct] 		Correct 
154611. 	A recursive relationship must be Mandatory at both ends. True or False? 	Mark for Review 
1547(1) Points
1548					
1549			
1550	True
1551	
1552			
1553	False (*)
1554	
1555					
1556				
1557[Correct] 		Correct
1558	
1559					
1560		12. 	A Recursive Relationship is represented on an ERD by a/an: 	Mark for Review 
1561(1) Points
1562					
1563			
1564	Crow's Foot
1565	
1566			
1567	Single Toe
1568	
1569			
1570	Pig's Ear (*)
1571	
1572			
1573	Dog's Tail
1574	
1575					
1576				
1577[Correct] 		Correct
1578	
1579					
1580		13. 	Business organizational charts are often modeled as a Hierarchical relationship. True or False? 	Mark for Review 
1581(1) Points
1582					
1583			
1584	True (*)
1585	
1586			
1587	False
1588	
1589					
1590				
1591[Correct] 		Correct
1592	
1593					
1594		14. 	A relationship between an entity and itself is called a/an: 	Mark for Review 
1595(1) Points
1596					
1597			
1598	Recursive Relationship (*)
1599	
1600			
1601	General Relationship
1602	
1603			
1604	Invalid Relationship
1605	
1606			
1607	Heirarchical Relationship
1608	
1609					
1610				
1611[Correct] 		Correct
1612	
1613					
1614		15. 	A single relationship can be both Recursive and Hierarchical at the same time. True or False? 	Mark for Review 
1615(1) Points
1616					
1617			
1618	True
1619	
1620			
1621	False (*)
1622	
1623					
1624				
1625[Correct] 		Correct
1626	
16271.  A single relationship can be both Recursive and Hierarchical at the same time. True or False? Mark for Review
1628(1) Points
1629     
1630   
1631 True
1632
1633   
1634 False (*)
1635
1636     
1637    
1638Correct  Correct
1639
1640     
1641  2.  A Recursive Relationship is represented on an ERD by a/an: Mark for Review
1642(1) Points
1643     
1644   
1645 Single Toe
1646
1647   
1648 Dog's Tail
1649
1650   
1651 Crow's Foot
1652
1653   
1654 Pig's Ear (*)
1655
1656     
1657    
1658Incorrect  Incorrect. Refer to Section 7 Lesson 2.
1659
1660     
1661  3.  A relationship between an entity and itself is called a/an: Mark for Review
1662(1) Points
1663     
1664   
1665 Invalid Relationship
1666
1667   
1668 Heirarchical Relationship
1669
1670   
1671 Recursive Relationship (*)
1672
1673   
1674 General Relationship
1675
1676     
1677    
1678Incorrect  Incorrect. Refer to Section 7 Lesson 2.
1679
1680     
1681  4.  Business organizational charts are often modeled as a Hierarchical relationship. True or False? Mark for Review
1682(1) Points
1683     
1684   
1685 True (*)
1686
1687   
1688 False
1689
1690     
1691    
1692Correct  Correct
1693
1694     
1695  5.  A recursive relationship must be Mandatory at both ends. True or False? Mark for Review
1696(1) Points
1697     
1698   
1699 True
1700
1701   
1702 False (*)
1703
1704     
1705    
1706Correct  Correct
1707
1708     
1709Page 1 of 3 Next Summary
1710
1711
1712Test: Section 7 Quiz
1713Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
1714
1715 Section 7 Quiz
1716 (Answer all questions in this section)
1717     
1718  6.  Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
1719(1) Points
1720     
1721   
1722 Recursive Relationship
1723
1724   
1725 Invalid Relationship
1726
1727   
1728 Heirarchical Relationship (*)
1729
1730   
1731 General Relationship
1732
1733     
1734    
1735Incorrect  Incorrect. Refer to Section 7 Lesson 2.
1736
1737     
1738  7.  A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False? Mark for Review
1739(1) Points
1740     
1741   
1742 True (*)
1743
1744   
1745 False
1746
1747     
1748    
1749Correct  Correct
1750
1751     
1752  8.  All relationships participating in an arc must be mandatory. True or False? Mark for Review
1753(1) Points
1754     
1755   
1756 True
1757
1758   
1759 False (*)
1760
1761     
1762    
1763Incorrect  Incorrect. Refer to Section 7 Lesson 1.
1764
1765     
1766  9.  Which of the following can be added to a relationship? Mark for Review
1767(1) Points
1768     
1769   
1770 An arc can be assigned (*)
1771
1772   
1773 An optional attribute can be created
1774
1775   
1776 An attribute
1777
1778   
1779 A composite attribute
1780
1781     
1782    
1783Incorrect  Incorrect. Refer to Section 7 Lesson 1.
1784
1785     
1786  10.  To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________. Mark for Review
1787(1) Points
1788     
1789   
1790 Arc (*)
1791
1792   
1793 Relationship
1794
1795   
1796 Attribute
1797
1798   
1799 UID
1800
1801     
1802    
1803Correct  Correct
1804
1805     
1806Previous Page 2 of 3 Next Summary
1807
1808
1809Test: Section 7 Quiz
1810Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
1811
1812 Section 7 Quiz
1813 (Answer all questions in this section)
1814     
1815  11.  Which of the following would best be represented by an arc? Mark for Review
1816(1) Points
1817     
1818   
1819 STUDENT (Grade A student, Average Student)
1820
1821   
1822 STUDENT ( University, Technical College) (*)
1823
1824   
1825 STUDENT (graduating, female)
1826
1827   
1828 STUDENT (senior, male)
1829
1830     
1831    
1832Correct  Correct
1833
1834     
1835  12.  An arc can often be modeled as Supertype and Subtypes. True or False? Mark for Review
1836(1) Points
1837     
1838   
1839 True (*)
1840
1841   
1842 False
1843
1844     
1845    
1846Correct  Correct
1847
1848     
1849  13.  Which of the following would best be represented by an arc? Mark for Review
1850(1) Points
1851     
1852   
1853 PARENT (Girl, Bob)
1854
1855   
1856 DELIVERY ADDRESS (Home, Office) (*)
1857
1858   
1859 TEACHER (Female, Bob)
1860
1861   
1862 STUDENT (Grade A student, Average Student)
1863
1864     
1865    
1866Incorrect  Incorrect. Refer to Section 7 Lesson 1.
1867
1868     
1869  14.  Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False? Mark for Review
1870(1) Points
1871     
1872   
1873 True
1874
1875   
1876 False (*)
1877
1878     
1879    
1880Correct  Correct
1881
1882     
1883  15.  Arcs are used to visually represent _________ between two or more relationships in an ERD. Mark for Review
1884(1) Points
1885     
1886   
1887 Inheritance
1888
1889   
1890 Exclusivity (*)
1891
1892   
1893 Sameness
1894
1895   
1896 Differences
1897
1898     
1899    
1900Incorrect  Incorrect. Refer to Section 7 Lesson 1.
1901
1902     
1903Previous Page 3 of 3 Summary
1904
1905
1906Test: Section 7 Quiz
1907Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
1908
1909 Section 7 Quiz
1910 (Answer all questions in this section)
1911     
1912  1.  An arc can often be modeled as Supertype and Subtypes. True or False? Mark for Review
1913(1) Points
1914     
1915   
1916 True (*)
1917
1918   
1919 False
1920
1921     
1922    
1923Correct  Correct
1924
1925     
1926  2.  Which of the following would best be represented by an arc? Mark for Review
1927(1) Points
1928     
1929   
1930 STUDENT (graduating, female)
1931
1932   
1933 STUDENT (senior, male)
1934
1935   
1936 STUDENT (Grade A student, Average Student)
1937
1938   
1939 STUDENT ( University, Technical College) (*)
1940
1941     
1942    
1943Correct  Correct
1944
1945     
1946  3.  To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________. Mark for Review
1947(1) Points
1948     
1949   
1950 Attribute
1951
1952   
1953 Arc (*)
1954
1955   
1956 UID
1957
1958   
1959 Relationship
1960
1961     
1962    
1963Correct  Correct
1964
1965     
1966  4.  Which of the following would best be represented by an arc? Mark for Review
1967(1) Points
1968     
1969   
1970 STUDENT (Grade A student, Average Student)
1971
1972   
1973 TEACHER (Female, Bob)
1974
1975   
1976 DELIVERY ADDRESS (Home, Office) (*)
1977
1978   
1979 PARENT (Girl, Bob)
1980
1981     
1982    
1983Correct  Correct
1984
1985     
1986  5.  Arcs are used to visually represent _________ between two or more relationships in an ERD. Mark for Review
1987(1) Points
1988     
1989   
1990 Sameness
1991
1992   
1993 Inheritance
1994
1995   
1996 Differences
1997
1998   
1999 Exclusivity (*)
2000
2001     
2002    
2003Correct  Correct
2004
2005     
2006Page 1 of 3 Next Summary
2007
2008
2009Test: Section 7 Quiz
2010Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
2011
2012 Section 7 Quiz
2013 (Answer all questions in this section)
2014     
2015  6.  Arcs model an Exclusive OR constraint. True or False? Mark for Review
2016(1) Points
2017     
2018   
2019 True (*)
2020
2021   
2022 False
2023
2024     
2025    
2026Correct  Correct
2027
2028     
2029  7.  Which of the following can be added to a relationship? Mark for Review
2030(1) Points
2031     
2032   
2033 An arc can be assigned (*)
2034
2035   
2036 An attribute
2037
2038   
2039 An optional attribute can be created
2040
2041   
2042 A composite attribute
2043
2044     
2045    
2046Correct  Correct
2047
2048     
2049  8.  Every business has restrictions on which attribute values and which relationships are allowed. These are known as: Mark for Review
2050(1) Points
2051     
2052   
2053 Entities.
2054
2055   
2056 Attributes
2057
2058   
2059 Relationships
2060
2061   
2062 Constraints. (*)
2063
2064     
2065    
2066Incorrect  Incorrect. Refer to Section 7 Lesson 1.
2067
2068     
2069  9.  A recursive relationship must be Mandatory at both ends. True or False? Mark for Review
2070(1) Points
2071     
2072   
2073 True
2074
2075   
2076 False (*)
2077
2078     
2079    
2080Correct  Correct
2081
2082     
2083  10.  A Recursive Relationship is represented on an ERD by a/an: Mark for Review
2084(1) Points
2085     
2086   
2087 Pig's Ear (*)
2088
2089   
2090 Single Toe
2091
2092   
2093 Crow's Foot
2094
2095   
2096 Dog's Tail
2097
2098     
2099    
2100Correct  Correct
2101
2102     
2103Previous Page 2 of 3 Next Summary
2104
2105
2106Test: Section 7 Quiz
2107Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
2108
2109 Section 7 Quiz
2110 (Answer all questions in this section)
2111     
2112  11.  A single relationship can be both Recursive and Hierarchical at the same time. True or False? Mark for Review
2113(1) Points
2114     
2115   
2116 True
2117
2118   
2119 False (*)
2120
2121     
2122    
2123Correct  Correct
2124
2125     
2126  12.  Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
2127(1) Points
2128     
2129   
2130 General Relationship
2131
2132   
2133 Heirarchical Relationship (*)
2134
2135   
2136 Invalid Relationship
2137
2138   
2139 Recursive Relationship
2140
2141     
2142    
2143Correct  Correct
2144
2145     
2146  13.  A relationship between an entity and itself is called a/an: Mark for Review
2147(1) Points
2148     
2149   
2150 Recursive Relationship (*)
2151
2152   
2153 Invalid Relationship
2154
2155   
2156 Heirarchical Relationship
2157
2158   
2159 General Relationship
2160
2161     
2162    
2163Correct  Correct
2164
2165     
2166  14.  A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False? Mark for Review
2167(1) Points
2168     
2169   
2170 True (*)
2171
2172   
2173 False
2174
2175     
2176    
2177Correct  Correct
2178
2179     
2180  15.  Business organizational charts are often modeled as a Hierarchical relationship. True or False? Mark for Review
2181(1) Points
2182     
2183   
2184 True (*)
2185
2186   
2187 False
2188
2189     
2190    
2191Correct  Correct
2192
2193Section 8 Quiz
2194	(Answer all questions in this section)
2195					
2196		1. 	Modeling historical data can produce a unique identifier that includes a date. True or False?	 Mark for Review 
2197(1) Points
2198					
2199			
2200	True (*)
2201
2202			
2203	False
2204
2205					
2206				
2207Incorrect		Incorrect. Refer to Section 8 Lesson 1.
2208
2209					
2210		2. 	When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False?	 Mark for Review 
2211(1) Points
2212					
2213			
2214	True
2215
2216			
2217	False (*)
2218
2219					
2220				
2221Incorrect		Incorrect. Refer to Section 8 Lesson 1.
2222
2223					
2224		3. 	Which of the following scenarios should be modeled so that historical data is kept? (Choose two)	 Mark for Review 
2225(1) Points
2226					
2227			(Choose all correct answers)	
2228					
2229			
2230	LIBRARY and BOOK (*)
2231
2232			
2233	STUDENT and GRADE (*)
2234
2235			
2236	STUDENT and AGE
2237
2238			
2239	LIBRARY and NUMBER OF BOOKS
2240
2241					
2242				
2243Incorrect		Incorrect. Refer to Section 8 Lesson 1.
2244
2245					
2246		4. 	In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?	 Mark for Review 
2247(1) Points
2248					
2249			
2250	True
2251
2252			
2253	False (*)
2254
2255					
2256				
2257Incorrect		Incorrect. Refer to Section 8 Lesson 4.
2258
2259					
2260		5. 	Formal rules exist for drawing ERD's. You must always follow them, even if it results in an ERD that is difficult to read. True or False?	 Mark for Review 
2261(1) Points
2262					
2263			
2264	True
2265
2266			
2267	False (*)
2268
2269					
2270				
2271Correct		Correct
2272
2273					
2274Page 1 of 3	Next	Summary
2275 
2276Section 8 Quiz
2277	(Answer all questions in this section)
2278					
2279		6. 	Which of the following statements are true to enhance the readability of ERDs? (Choose Two)	 Mark for Review 
2280(1) Points
2281					
2282			(Choose all correct answers)	
2283					
2284			
2285	Relationship lines should not cross. (*)
2286
2287			
2288	Crossing relationship lines help the readability of the diagram.
2289
2290			
2291	It does not matter which way the crows feet (many ends of a relationship) point.
2292
2293			
2294	Crows feet (the many-ends of relationships) should consistently point the same direction where possible, either South & East or North & West (*)
2295
2296					
2297				
2298Incorrect		Incorrect. Refer to Section 8 Lesson 4.
2299
2300					
2301		7. 	You must make sure all entities of a proposed system can fit onto one diagram. It is not allowed to break up a data model into more than one diagram. True or False?	 Mark for Review 
2302(1) Points
2303					
2304			
2305	True
2306
2307			
2308	False (*)
2309
2310					
2311				
2312Correct		Correct
2313
2314					
2315		8. 	All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False?	 Mark for Review 
2316(1) Points
2317					
2318			
2319	True
2320
2321			
2322	False (*)
2323
2324					
2325				
2326Correct		Correct
2327
2328					
2329		9. 	When a relationship may or may not be transferable, depending on time, this is know as a/an:	 Mark for Review 
2330(1) Points
2331					
2332			
2333	Non-transferable Relationship.
2334
2335			
2336	Conditional Non-transferable Relationship. (*)
2337
2338			
2339	Arc.
2340
2341			
2342	Transferable Relationship
2343
2344					
2345				
2346Correct		Correct
2347
2348					
2349		10. 	Modeling historical data is optional. True or False?	 Mark for Review 
2350(1) Points
2351					
2352			
2353	True (*)
2354
2355			
2356	False
2357
2358					
2359				
2360Correct		Correct
2361
2362					
2363Previous	Page 2 of 3	Next	Summary
2364 
2365Section 8 Quiz
2366	(Answer all questions in this section)
2367					
2368		11. 	Which of the following would be a logical constraint when modeling time for a country entity?	 Mark for Review 
2369(1) Points
2370					
2371			
2372	People have births and deaths in their countries that must be tracked by the system.
2373
2374			
2375	Countries may change their names and/or borders over a period of time. (*)
2376
2377			
2378	Daily traffic patterns must be monitored to determine which countries are overcrowded.
2379
2380			
2381	If you are doing a system for France or Germany, you would need security clearance.
2382
2383					
2384				
2385Correct		Correct
2386
2387					
2388		12. 	Which of the following would be a logical constraint when modeling time for a City entity?	 Mark for Review 
2389(1) Points
2390					
2391			
2392	If you are doing a system for any French City, you would need security clearance.
2393
2394			
2395	People are born in the city and people die in the city.
2396
2397			
2398	Cites may change their names and/or country association if the borders of a country change. (*)
2399
2400			
2401	Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.
2402
2403					
2404				
2405Incorrect		Incorrect. Refer to Section 8 Lesson 2.
2406
2407					
2408		13. 	What is the function of logging or journaling in conceptual data models?	 Mark for Review 
2409(1) Points
2410					
2411			
2412	Allows you to track the history of attribute values, relationships, and/or entire entities (*)
2413
2414			
2415	Creates a fixed time for all events in a data model.
2416
2417			
2418	Gives a timestamp to all entities.
2419
2420			
2421	Represents entities as time in the data model.
2422
2423					
2424				
2425Incorrect		Incorrect. Refer to Section 8 Lesson 3.
2426
2427					
2428		14. 	When a system requires that old values for attributes are kept on record, this is know as Journaling or Logging. True or False?	 Mark for Review 
2429(1) Points
2430					
2431			
2432	True (*)
2433
2434			
2435	False
2436
2437					
2438				
2439Incorrect		Incorrect. Refer to Section 8 Lesson 3.
2440
2441					
2442		15. 	All systems must include functionality to provide logging or journaling in conceptual data models. True or False?	 Mark for Review 
2443(1) Points
2444					
2445			
2446	True
2447
2448			
2449	False (*)
2450
2451					
2452				
2453Incorrect		Incorrect. Refer to Section 8 Lesson 3.
2454
2455					
2456Previous	Page 3 of 3	Summary
2457 Section 8 Quiz
2458	(Answer all questions in this section)
2459					
2460		1. 	Which of the following would be a logical constraint when modeling time for a City entity?	 Mark for Review 
2461(1) Points
2462					
2463			
2464	If you are doing a system for any French City, you would need security clearance.
2465
2466			
2467	Cites may change their names and/or country association if the borders of a country change. (*)
2468
2469			
2470	People are born in the city and people die in the city.
2471
2472			
2473	Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.
2474
2475					
2476				
2477Correct		Correct
2478
2479					
2480		2. 	How do you know when to use the different types of time in your design?	 Mark for Review 
2481(1) Points
2482					
2483			
2484	The rules are fixed and should be followed.
2485
2486			
2487	It depends on the functional needs of the system . (*)
2488
2489			
2490	You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
2491
2492			
2493	Always model time; you can take it out later if it is not needed.
2494
2495					
2496				
2497Incorrect		Incorrect. Refer to Section 8 Lesson 2.
2498
2499					
2500		3. 	There are no circumstances where you would create a DAY entity. True or False?	 Mark for Review 
2501(1) Points
2502					
2503			
2504	True
2505
2506			
2507	False (*)
2508
2509					
2510				
2511Incorrect		Incorrect. Refer to Section 8 Lesson 2.
2512
2513					
2514		4. 	Conditional non-transferability refers to a relationship that may or may not be transferable, depending on time. True or False?	 Mark for Review 
2515(1) Points
2516					
2517			
2518	True (*)
2519
2520			
2521	False
2522
2523					
2524				
2525Correct		Correct
2526
2527					
2528		5. 	When a relationship may or may not be transferable, depending on time, this is know as a/an:	 Mark for Review 
2529(1) Points
2530					
2531			
2532	Arc.
2533
2534			
2535	Non-transferable Relationship.
2536
2537			
2538	Conditional Non-transferable Relationship. (*)
2539
2540			
2541	Transferable Relationship
2542
2543					
2544				
2545Incorrect		Incorrect. Refer to Section 8 Lesson 2.
2546
2547					
2548Page 1 of 3	Next	Summary
2549 
2550
2551	Section 8 Quiz
2552	(Answer all questions in this section)
2553					
2554		6. 	Which of the following scenarios should be modeled so that historical data is kept? (Choose two)	 Mark for Review 
2555(1) Points
2556					
2557			(Choose all correct answers)	
2558					
2559			
2560	LIBRARY and NUMBER OF BOOKS
2561
2562			
2563	STUDENT and GRADE (*)
2564
2565			
2566	LIBRARY and BOOK (*)
2567
2568			
2569	STUDENT and AGE
2570
2571					
2572				
2573Correct		Correct
2574
2575					
2576		7. 	When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False?	 Mark for Review 
2577(1) Points
2578					
2579			
2580	True
2581
2582			
2583	False (*)
2584
2585					
2586				
2587Correct		Correct
2588
2589					
2590		8. 	Historical data must never be kept. True or False?	 Mark for Review 
2591(1) Points
2592					
2593			
2594	True
2595
2596			
2597	False (*)
2598
2599					
2600				
2601Incorrect		Incorrect. Refer to Section 8 Lesson 1.
2602
2603					
2604		9. 	You are doing a data model for a computer sales company where the price fluctuates on a regular basis. If you want to allow the company to modify the price and keep track of the changes, what is the best way to model this?	 Mark for Review 
2605(1) Points
2606					
2607			
2608	A. Create a product entity and a related price entity with start and end dates, and then let the users enter the new price whenever required.
2609
2610			
2611	B. Create a new item and a new price every day.
2612
2613			
2614	C. Use a price entity with a start and end date
2615
2616			
2617	D. Allow them to delete the item and enter a new one.
2618
2619			
2620	E. Both A and C (*)
2621
2622					
2623				
2624Correct		Correct
2625
2626					
2627		10. 	You are doing a data model for a computer sales company where the price of postage depends upon the day of the week that goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this?	 Mark for Review 
2628(1) Points
2629					
2630			
2631	Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.
2632
2633			
2634	Email current prices to all employees whenever a price changes.
2635
2636			
2637	Allow them to enter whatever delivery charge they want.
2638
2639			
2640	Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*)
2641
2642					
2643				
2644Incorrect		Incorrect. Refer to Section 8 Lesson 3.
2645
2646					
2647Previous	Page 2 of 3	Next	Summary
2648 
2649Section 8 Quiz
2650	(Answer all questions in this section)
2651					
2652		11. 	What is the function of logging or journaling in conceptual data models?	 Mark for Review 
2653(1) Points
2654					
2655			
2656	Allows you to track the history of attribute values, relationships, and/or entire entities (*)
2657
2658			
2659	Represents entities as time in the data model.
2660
2661			
2662	Gives a timestamp to all entities.
2663
2664			
2665	Creates a fixed time for all events in a data model.
2666
2667					
2668				
2669Correct		Correct
2670
2671					
2672		12. 	No formal rules exist for drawing ERD's. The most important thing is to make sure that all entities, attributes, and relationships are documented on the diagram, and the diagram is clear and readable. True or False?	 Mark for Review 
2673(1) Points
2674					
2675			
2676	True (*)
2677
2678			
2679	False
2680
2681					
2682				
2683Correct		Correct
2684
2685					
2686		13. 	Formal rules exist for drawing ERD's. You must always follow them, even if it results in an ERD that is difficult to read. True or False?	 Mark for Review 
2687(1) Points
2688					
2689			
2690	True
2691
2692			
2693	False (*)
2694
2695					
2696				
2697Incorrect		Incorrect. Refer to Section 8 Lesson 4.
2698
2699					
2700		14. 	Which of the following statements are true for ERD's to enhance their readability. (Choose Two)	 Mark for Review 
2701(1) Points
2702					
2703			(Choose all correct answers)	
2704					
2705			
2706	It is OK to break down a large ERD into subsets of the overall picture. By doing so, you end up with more than one ERD that, taken together, documents the entire system. (*)
2707
2708			
2709	The crows feet (many ends) can point whichever way is the easiest to draw.
2710
2711			
2712	You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram.
2713
2714			
2715	Avoid crossing one relationship line with another. (*)
2716
2717					
2718				
2719Incorrect		Incorrect. Refer to Section 8 Lesson 4.
2720
2721					
2722		15. 	In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?	 Mark for Review 
2723(1) Points
2724					
2725			
2726	True
2727
2728			
2729	False (*)
2730
2731					
2732				
2733Incorrect		Incorrect. Refer to Section 8 Lesson 4.
2734
2735					
2736Previous	Page 3 of 3	Summary
2737 
2738Section 9 Quiz
2739	(Answer all questions in this section)
2740					
2741		1. 	Column integrity refers to	 Mark for Review 
2742(1) Points
2743					
2744			
2745	Columns always containing positive numbers
2746
2747			
2748	Columns always containing values consistent with the defined data format (*)
2749
2750			
2751	Columns always containing text data less than 255 characters
2752
2753			
2754	Columns always having values
2755
2756					
2757				
2758Correct		Correct
2759
2760					
2761		2. 	Foreign keys must be null. True or False?	 Mark for Review 
2762(1) Points
2763					
2764			
2765	True
2766
2767			
2768	False (*)
2769
2770					
2771				
2772Incorrect		Incorrect. Refer to Section 9 Lesson 1.
2773
2774					
2775		3. 	A foreign key always refers to a primary key in the same table. True or False?	 Mark for Review 
2776(1) Points
2777					
2778			
2779	True
2780
2781			
2782	False (*)
2783
2784					
2785				
2786Incorrect		Incorrect. Refer to Section 9 Lesson 1.
2787
2788					
2789		4. 	The explanation below is an example of which constraint type? 
2790If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce.	 Mark for Review 
2791(1) Points
2792					
2793			
2794	User-defined integrity (*)
2795
2796			
2797	Column integrity
2798
2799			
2800	Referential integrity
2801
2802			
2803	Entity integrity
2804
2805					
2806				
2807Incorrect		Incorrect. Refer to Section 9 Lesson 1.
2808
2809					
2810		5. 	When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two)	 Mark for Review 
2811(1) Points
2812					
2813			(Choose all correct answers)	
2814					
2815			
2816	Make all relationships mandatory
2817
2818			
2819	Make all relationships optional (*)
2820
2821			
2822	Create an additional check constraint to verify that one foreign key is populated and the others are not (*)
2823
2824			
2825	All the above
2826
2827					
2828				
2829Incorrect		Incorrect. Refer to Section 9 Lesson 4.
2830
2831					
2832Page 1 of 3	Next	Summary
2833 
2834Section 9 Quiz
2835	(Answer all questions in this section)
2836					
2837		6. 	Which of the following is a valid reason for considering a Subtype Implementation?	 Mark for Review 
2838(1) Points
2839					
2840			
2841	Most of the relationships are at the supertype level.
2842
2843			
2844	Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
2845
2846			
2847	The resulting table will reside in a single database and be used by just ONE user.
2848
2849			
2850	The common access paths for the supertypes are different.
2851
2852					
2853				
2854Incorrect		Incorrect. Refer to Section 9 Lesson 4.
2855
2856					
2857		7. 	When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False?	 Mark for Review 
2858(1) Points
2859					
2860			
2861	True
2862
2863			
2864	False (*)
2865
2866					
2867				
2868Incorrect		Incorrect. Refer to Section 9 Lesson 4.
2869
2870					
2871		8. 	One-to-Many Optional to Mandatory becomes a _______________ on the Master table.	 Mark for Review 
2872(1) Points
2873					
2874			
2875	Primary Key
2876
2877			
2878	Unique Key
2879
2880			
2881	Mandatory Foreign Key
2882
2883			
2884	Optional Foreign Key (*)
2885
2886					
2887				
2888Incorrect		Incorrect. Refer to Section 9 Lesson 3.
2889
2890					
2891		9. 	To resolve a many to many relationship in a physical model you create a(n) ___________________?	 Mark for Review 
2892(1) Points
2893					
2894			
2895	Intersection entity
2896
2897			
2898	Unique key constraints
2899
2900			
2901	Intersection table (*)
2902
2903			
2904	Two tables with Foreign key constraints between them
2905
2906					
2907				
2908Correct		Correct
2909
2910					
2911		10. 	When an Arc is transformed to the physical model every relationship in the Arc becomes a mandatory Foreign Key. True or False?	 Mark for Review 
2912(1) Points
2913					
2914			
2915	True
2916
2917			
2918	False (*)
2919
2920					
2921				
2922Incorrect		Incorrect. Refer to Section 9 Lesson 3.
2923
2924					
2925Previous	Page 2 of 3	Next	Summary
2926 
2927
2928	Section 9 Quiz
2929	(Answer all questions in this section)
2930					
2931		11. 	In a physical model, many to many relationships are resolved via a structure called a(n): ________________	 Mark for Review 
2932(1) Points
2933					
2934			
2935	Intersection Entity
2936
2937			
2938	Intersection Table (*)
2939
2940			
2941	Subtype
2942
2943			
2944	Supertype
2945
2946					
2947				
2948Incorrect		Incorrect. Refer to Section 9 Lesson 3.
2949
2950					
2951		12. 	In an Oracle database, why would 1_TABLE not work as a table name?	 Mark for Review 
2952(1) Points
2953					
2954			
2955	The database does not understand all capital letters.
2956
2957			
2958	There is no problem here. You can create a table called 1_TABLE.
2959
2960			
2961	Object names must not start with a number. They must begin with a letter. (*)
2962
2963			
2964	TABLE is a reserved word.
2965
2966					
2967				
2968Incorrect		Incorrect. Refer to Section 9 Lesson 2.
2969
2970					
2971		13. 	In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?	 Mark for Review 
2972(1) Points
2973					
2974			
2975	JOBS is a reserved word
2976
2977			
2978	The database does not understand all capital letters
2979
2980			
2981	You cannot have spaces between words in a table name (*)
2982
2983			
2984	EMPLOYEE is a reserved word
2985
2986					
2987				
2988Correct		Correct
2989
2990					
2991		14. 	In a physical data model, an entity becomes a _____________.	 Mark for Review 
2992(1) Points
2993					
2994			
2995	Attribute
2996
2997			
2998	Table (*)
2999
3000			
3001	Column
3002
3003			
3004	Constraint
3005
3006					
3007				
3008Incorrect		Incorrect. Refer to Section 9 Lesson 2.
3009
3010					
3011		15. 	Why would this table name NOT work in an Oracle database? this_year_end+next_year	 Mark for Review 
3012(1) Points
3013					
3014			
3015	Table names must begin with an alphabetic character.
3016
3017			
3018	It is too long.
3019
3020			
3021	The Plus sign + is not allowed in object names. (*)
3022
3023			
3024	None of the above.
3025
3026					
3027				
3028Incorrect		Incorrect. Refer to Section 9 Lesson 2.
3029
3030					
3031Previous	Page 3 of 3	Summary
3032 
3033
3034
3035	Section 9 Quiz
3036	(Answer all questions in this section)
3037					
3038		1. 	When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two)	 Mark for Review 
3039(1) Points
3040					
3041			(Choose all correct answers)	
3042					
3043			
3044	Make all relationships mandatory
3045
3046			
3047	Make all relationships optional (*)
3048
3049			
3050	Create an additional check constraint to verify that one foreign key is populated and the others are not (*)
3051
3052			
3053	All the above
3054
3055					
3056				
3057Correct		Correct
3058
3059					
3060		2. 	The "Arc Implementation" is a synonym for what type of implementation?	 Mark for Review 
3061(1) Points
3062					
3063			
3064	Subtype Implementation
3065
3066			
3067	Cascade Implementation
3068
3069			
3070	Supertype and Subtype Implementation (*)
3071
3072			
3073	Supertype Implementation
3074
3075					
3076				
3077Correct		Correct
3078
3079					
3080		3. 	An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False?	 Mark for Review 
3081(1) Points
3082					
3083			
3084	True
3085
3086			
3087	False (*)
3088
3089					
3090				
3091Correct		Correct
3092
3093					
3094		4. 	To resolve a many to many relationship in a physical model you create a(n) ___________________?	 Mark for Review 
3095(1) Points
3096					
3097			
3098	Intersection entity
3099
3100			
3101	Two tables with Foreign key constraints between them
3102
3103			
3104	Unique key constraints
3105
3106			
3107	Intersection table (*)
3108
3109					
3110				
3111Correct		Correct
3112
3113					
3114		5. 	Two entities A and B have an optional (A) to Mandatory (B) One-to-One relationship. When they are transformed, the Foreign Key(s) is placed on:	 Mark for Review 
3115(1) Points
3116					
3117			
3118	The table B (*)
3119
3120			
3121	Nowhere, One-to-One relationships are not transformed.
3122
3123			
3124	The table A
3125
3126			
3127	Both tables A and B get a new column and a Foreign Key.
3128
3129					
3130				
3131Correct		Correct
3132
3133					
3134Page 1 of 3	Next	Summary
3135 
3136	Section 9 Quiz
3137	(Answer all questions in this section)
3138					
3139		6. 	One-to-Many Optional to Mandatory becomes a _______________ on the Master table.	 Mark for Review 
3140(1) Points
3141					
3142			
3143	Unique Key
3144
3145			
3146	Mandatory Foreign Key
3147
3148			
3149	Optional Foreign Key (*)
3150
3151			
3152	Primary Key
3153
3154					
3155				
3156Correct		Correct
3157
3158					
3159		7. 	Why would this table name NOT work in an Oracle database? this_year_end+next_year	 Mark for Review 
3160(1) Points
3161					
3162			
3163	True
3164
3165			
3166	False (*)
3167
3168					
3169				
3170Correct		Correct
3171
3172					
3173		8. 	The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?	 Mark for Review 
3174(1) Points
3175					
3176			
3177	True (*)
3178
3179			
3180	False
3181
3182					
3183				
3184Correct		Correct
3185
3186					
3187		9. 	Why would this table name NOT work in an Oracle database? this_year_end+next_year	 Mark for Review 
3188(1) Points
3189					
3190			
3191	Table names must begin with an alphabetic character.
3192
3193			
3194	It is too long.
3195
3196			
3197	The Plus sign + is not allowed in object names. (*)
3198
3199			
3200	None of the above.
3201
3202					
3203				
3204Correct		Correct
3205
3206					
3207		10. 	Attributes become columns in a database table. True or False?	 Mark for Review 
3208(1) Points
3209					
3210			
3211	True (*)
3212
3213			
3214	False
3215
3216					
3217				
3218Correct		Correct
3219
3220					
3221Previous	Page 2 of 3	Next	Summary
3222 
3223	Section 9 Quiz
3224	(Answer all questions in this section)
3225					
3226		6. 	One-to-Many Optional to Mandatory becomes a _______________ on the Master table.	 Mark for Review 
3227(1) Points
3228					
3229			
3230	Unique Key
3231
3232			
3233	Mandatory Foreign Key
3234
3235			
3236	Optional Foreign Key (*)
3237
3238			
3239	Primary Key
3240
3241					
3242				
3243Correct		Correct
3244
3245					
3246		7. 	Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?	 Mark for Review 
3247(1) Points
3248					
3249			
3250	True
3251
3252			
3253	False (*)
3254
3255					
3256				
3257Correct		Correct
3258
3259					
3260		8. 	The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?	 Mark for Review 
3261(1) Points
3262					
3263			
3264	True (*)
3265
3266			
3267	False
3268
3269					
3270				
3271Correct		Correct
3272
3273					
3274		9. 	Why would this table name NOT work in an Oracle database? this_year_end+next_year	 Mark for Review 
3275(1) Points
3276					
3277			
3278	Table names must begin with an alphabetic character.
3279
3280			
3281	It is too long.
3282
3283			
3284	The Plus sign + is not allowed in object names. (*)
3285
3286			
3287	None of the above.
3288
3289					
3290				
3291Correct		Correct
3292
3293					
3294		10. 	Attributes become columns in a database table. True or False?	 Mark for Review 
3295(1) Points
3296					
3297			
3298	True (*)
3299
3300			
3301	False
3302
3303					
3304				
3305Correct		Correct
3306
3307					
3308Previous	Page 2 of 3	Next	Summary
3309 
3310	Section 9 Quiz
3311	(Answer all questions in this section)
3312					
3313		6. 	One-to-Many Optional to Mandatory becomes a _______________ on the Master table.	 Mark for Review 
3314(1) Points
3315					
3316			
3317	Unique Key
3318
3319			
3320	Mandatory Foreign Key
3321
3322			
3323	Optional Foreign Key (*)
3324
3325			
3326	Primary Key
3327
3328					
3329				
3330Correct		Correct
3331
3332					
3333		7. 	Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?	 Mark for Review 
3334(1) Points
3335					
3336			
3337	True
3338
3339			
3340	False (*)
3341
3342					
3343				
3344Correct		Correct
3345
3346					
3347		8. 	The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?	 Mark for Review 
3348(1) Points
3349					
3350			
3351	True (*)
3352
3353			
3354	False
3355
3356					
3357				
3358Correct		Correct
3359
3360					
3361		9. 	Why would this table name NOT work in an Oracle database? this_year_end+next_year	 Mark for Review 
3362(1) Points
3363					
3364			
3365	Table names must begin with an alphabetic character.
3366
3367			
3368	It is too long.
3369
3370			
3371	The Plus sign + is not allowed in object names. (*)
3372
3373			
3374	None of the above.
3375
3376					
3377				
3378Correct		Correct
3379
3380					
3381		10. 	Attributes become columns in a database table. True or False?	 Mark for Review 
3382(1) Points
3383					
3384			
3385	True (*)
3386
3387			
3388	False
3389
3390					
3391				
3392Correct		Correct
3393
3394					
3395Previous	Page 2 of 3	Next	Summary
3396 
3397	Section 9 Quiz
3398	(Answer all questions in this section)
3399					
3400		6. 	One-to-Many Optional to Mandatory becomes a _______________ on the Master table.	 Mark for Review 
3401(1) Points
3402					
3403			
3404	Unique Key
3405
3406			
3407	Mandatory Foreign Key
3408
3409			
3410	Optional Foreign Key (*)
3411
3412			
3413	Primary Key
3414
3415					
3416				
3417Correct		Correct
3418
3419					
3420		7. 	Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?	 Mark for Review 
3421(1) Points
3422					
3423			
3424	True
3425
3426			
3427	False (*)
3428
3429					
3430				
3431Correct		Correct
3432
3433					
3434		8. 	The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?	 Mark for Review 
3435(1) Points
3436					
3437			
3438	True (*)
3439
3440			
3441	False
3442
3443					
3444				
3445Correct		Correct
3446
3447					
3448		9. 	Why would this table name NOT work in an Oracle database? this_year_end+next_year	 Mark for Review 
3449(1) Points
3450					
3451			
3452	Table names must begin with an alphabetic character.
3453
3454			
3455	It is too long.
3456
3457			
3458	The Plus sign + is not allowed in object names. (*)
3459
3460			
3461	None of the above.
3462
3463					
3464				
3465Correct		Correct
3466
3467					
3468		10. 	Attributes become columns in a database table. True or False?	 Mark for Review 
3469(1) Points
3470					
3471			
3472	True (*)
3473
3474			
3475	False
3476
3477					
3478				
3479Correct		Correct
3480
3481					
3482Previous	Page 2 of 3	Next	Summary
3483 
3484
3485Test: Section 9 Quiz
3486Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
3487
3488	Section 9 Quiz
3489	(Answer all questions in this section)
3490					
3491		11. 	In an Oracle database, why would 1_TABLE not work as a table name?	 Mark for Review 
3492(1) Points
3493					
3494			
3495	Object names must not start with a number. They must begin with a letter. (*)
3496
3497			
3498	TABLE is a reserved word.
3499
3500			
3501	There is no problem here. You can create a table called 1_TABLE.
3502
3503			
3504	The database does not understand all capital letters.
3505
3506					
3507				
3508Correct		Correct
3509
3510					
3511		12. 	A table must have a primary key. True or False?	 Mark for Review 
3512(1) Points
3513					
3514			
3515	True
3516
3517			
3518	False (*)
3519
3520					
3521				
3522Incorrect		Incorrect. Refer to Section 9 Lesson 1.
3523
3524					
3525		13. 	A foreign key cannot refer to a primary key in the same table. True or False?	 Mark for Review 
3526(1) Points
3527					
3528			
3529	True
3530
3531			
3532	False (*)
3533
3534					
3535				
3536Correct		Correct
3537
3538					
3539		14. 	The explanation below is an example of which constraint type? 
3540The value in the dept_no column of the EMPLOYEES table must match a value in the dept_no column in the DEPARTMENTS table.	 Mark for Review 
3541(1) Points
3542					
3543			
3544	Referential integrity (*)
3545
3546			
3547	Column integrity
3548
3549			
3550	User-defined integrity
3551
3552			
3553	Entity integrity
3554
3555					
3556				
3557Incorrect		Incorrect. Refer to Section 9 Lesson 1.
3558
3559					
3560		15. 	Column integrity refers to	 Mark for Review 
3561(1) Points
3562					
3563			
3564	Columns always containing text data less than 255 characters
3565
3566			
3567	Columns always containing values consistent with the defined data format (*)
3568
3569			
3570	Columns always containing positive numbers
3571
3572			
3573	Columns always having values
3574
3575					
3576				
3577Correct		Correct
35781. 	All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False? 	Mark for Review 
3579(1) Points
3580					
3581			
3582	True
3583	
3584			
3585	False (*)
3586	
3587					
3588				
3589[Correct] 		Correct
3590	
3591					
3592		2. 	When you add the concept of time to your data model, your model becomes more complex. True or False? 	Mark for Review 
3593(1) Points
3594					
3595			
3596	True (*)
3597	
3598			
3599	False
3600	
3601					
3602				
3603[Correct] 		Correct
3604	
3605					
3606		3. 	When a relationship may or may not be transferable, depending on time, this is know as a/an: 	Mark for Review 
3607(1) Points
3608					
3609			
3610	Non-transferable Relationship.
3611	
3612			
3613	Conditional Non-transferable Relationship. (*)
3614	
3615			
3616	Arc.
3617	
3618			
3619	Transferable Relationship
3620	
3621					
3622				
3623[Correct] 		Correct
3624	
3625					
3626		4. 	There are no circumstances where you would create a DAY entity. True or False? 	Mark for Review 
3627(1) Points
3628					
3629			
3630	True
3631	
3632			
3633	False (*)
3634	
3635					
3636				
3637[Correct] 		Correct
3638	
3639					
3640		5. 	Conditional non-transferability refers to a relationship that may or may not be transferable, depending on time. True or False? 	Mark for Review 
3641(1) Points
3642					
3643			
3644	True (*)
3645	
3646			
3647	False
3648	
3649					
3650				
3651[Correct] 		Correct 
36526. 	When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False? 	Mark for Review 
3653(1) Points
3654					
3655			
3656	True
3657	
3658			
3659	False (*)
3660	
3661					
3662				
3663[Correct] 		Correct
3664	
3665					
3666		7. 	Modeling historical data can produce a unique identifier that includes a date. True or False? 	Mark for Review 
3667(1) Points
3668					
3669			
3670	True (*)
3671	
3672			
3673	False
3674	
3675					
3676				
3677[Correct] 		Correct
3678	
3679					
3680		8. 	Which of the following scenarios should be modeled so that historical data is kept? (Choose two) 	Mark for Review 
3681(1) Points
3682					
3683			(Choose all correct answers) 	
3684					
3685			
3686	TEACHER and AGE
3687	
3688			
3689	CUSTOMER and PAYMENTS (*)
3690	
3691			
3692	BABY and AGE
3693	
3694			
3695	CUSTOMER and ORDERS (*)
3696	
3697					
3698				
3699[Correct] 		Correct
3700	
3701					
3702		9. 	Which of the following statements are true for ERD's to enhance their readability. (Choose Two) 	Mark for Review 
3703(1) Points
3704					
3705			(Choose all correct answers) 	
3706					
3707			
3708	The crows feet (many ends) can point whichever way is the easiest to draw.
3709	
3710			
3711	It is OK to break down a large ERD into subsets of the overall picture. By doing so, you end up with more than one ERD that, taken together, documents the entire system. (*)
3712	
3713			
3714	Avoid crossing one relationship line with another. (*)
3715	
3716			
3717	You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram.
3718	
3719					
3720				
3721[Incorrect] 		Incorrect. Refer to Section 8 Lesson 4.
3722	
3723					
3724		10. 	In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False? 	Mark for Review 
3725(1) Points
3726					
3727			
3728	True (*)
3729	
3730			
3731	False
3732	
3733					
3734				
3735[Correct] 		Correct 
37366. 	When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False? 	Mark for Review 
3737(1) Points
3738					
3739			
3740	True
3741	
3742			
3743	False (*)
3744	
3745					
3746				
3747[Correct] 		Correct
3748	
3749					
3750		7. 	Modeling historical data can produce a unique identifier that includes a date. True or False? 	Mark for Review 
3751(1) Points
3752					
3753			
3754	True (*)
3755	
3756			
3757	False
3758	
3759					
3760				
3761[Correct] 		Correct
3762	
3763					
3764		8. 	Which of the following scenarios should be modeled so that historical data is kept? (Choose two) 	Mark for Review 
3765(1) Points
3766					
3767			(Choose all correct answers) 	
3768					
3769			
3770	TEACHER and AGE
3771	
3772			
3773	CUSTOMER and PAYMENTS (*)
3774	
3775			
3776	BABY and AGE
3777	
3778			
3779	CUSTOMER and ORDERS (*)
3780	
3781					
3782				
3783[Correct] 		Correct
3784	
3785					
3786		9. 	Which of the following statements are true for ERD's to enhance their readability. (Choose Two) 	Mark for Review 
3787(1) Points
3788					
3789			(Choose all correct answers) 	
3790					
3791			
3792	The crows feet (many ends) can point whichever way is the easiest to draw.
3793	
3794			
3795	It is OK to break down a large ERD into subsets of the overall picture. By doing so, you end up with more than one ERD that, taken together, documents the entire system. (*)
3796	
3797			
3798	Avoid crossing one relationship line with another. (*)
3799	
3800			
3801	You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram.
3802	
3803					
3804				
3805[Incorrect] 		Incorrect. Refer to Section 8 Lesson 4.
3806	
3807					
3808		10. 	In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False? 	Mark for Review 
3809(1) Points
3810					
3811			
3812	True (*)
3813	
3814			
3815	False
3816	
3817					
3818				
3819[Correct] 		Correct 
3820  1.  In a payroll system, it is desirable to have an entity called DAY with a holiday attribute when you want to track special holiday dates. True or False? Mark for Review
3821(1) Points
3822     
3823   
3824 True (*)
3825
3826   
3827 False
3828
3829     
3830    
3831Correct  Correct
3832
3833     
3834  2.  If you have an entity that a DATE attribute, and other attributes that track characteristics of the date, you should create a DAY entity. True or False? Mark for Review
3835(1) Points
3836     
3837   
3838 True (*)
3839
3840   
3841 False
3842
3843     
3844    
3845Correct  Correct
3846
3847     
3848  3.  Modeling historical data is optional. True or False? Mark for Review
3849(1) Points
3850     
3851   
3852 True (*)
3853
3854   
3855 False
3856
3857     
3858    
3859Incorrect  Incorrect. Refer to Section 8 Lesson 2.
3860
3861     
3862  4.  All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False? Mark for Review
3863(1) Points
3864     
3865   
3866 True
3867
3868   
3869 False (*)
3870
3871     
3872    
3873Incorrect  Incorrect. Refer to Section 8 Lesson 2.
3874
3875     
3876  5.  How do you know when to use the different types of time in your design? Mark for Review
3877(1) Points
3878     
3879   
3880 It depends on the functional needs of the system . (*)
3881
3882   
3883 Always model time; you can take it out later if it is not needed.
3884
3885   
3886 You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
3887
3888   
3889 The rules are fixed and should be followed.
3890
3891     
3892    
3893Correct  Correct
3894
3895     
3896Page 1 of 3 Next Summary
3897
3898
3899Test: Section 8 Quiz
3900Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
3901
3902 Section 8 Quiz
3903 (Answer all questions in this section)
3904     
3905  6.  Formal rules exist for drawing ERD's. You must always follow them, even if it results in an ERD that is difficult to read. True or False? Mark for Review
3906(1) Points
3907     
3908   
3909 True
3910
3911   
3912 False (*)
3913
3914     
3915    
3916Incorrect  Incorrect. Refer to Section 8 Lesson 4.
3917
3918     
3919  7.  In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False? Mark for Review
3920(1) Points
3921     
3922   
3923 True (*)
3924
3925   
3926 False
3927
3928     
3929    
3930Correct  Correct
3931
3932     
3933  8.  In an ERD, High Volume Entities usually have very few relationships to other entities. True or False? Mark for Review
3934(1) Points
3935     
3936   
3937 True
3938
3939   
3940 False (*)
3941
3942     
3943    
3944Incorrect  Incorrect. Refer to Section 8 Lesson 4.
3945
3946     
3947  9.  You must make sure all entities of a proposed system can fit onto one diagram. It is not allowed to break up a data model into more than one diagram. True or False? Mark for Review
3948(1) Points
3949     
3950   
3951 True
3952
3953   
3954 False (*)
3955
3956     
3957    
3958Incorrect  Incorrect. Refer to Section 8 Lesson 4.
3959
3960     
3961  10.  Which of the following scenarios should be modeled so that historical data is kept? (Choose two) Mark for Review
3962(1) Points
3963     
3964   (Choose all correct answers) 
3965     
3966   
3967 TEACHER and AGE
3968
3969   
3970 CUSTOMER and ORDERS (*)
3971
3972   
3973 CUSTOMER and PAYMENTS (*)
3974
3975   
3976 BABY and AGE
3977
3978     
3979    
3980Incorrect  Incorrect. Refer to Section 8 Lesson 1.
3981
3982     
3983Previous Page 2 of 3 Next Summary
3984
3985
3986Test: Section 8 Quiz
3987Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
3988
3989 Section 8 Quiz
3990 (Answer all questions in this section)
3991     
3992  11.  When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False? Mark for Review
3993(1) Points
3994     
3995   
3996 True
3997
3998   
3999 False (*)
4000
4001     
4002    
4003Incorrect  Incorrect. Refer to Section 8 Lesson 1.
4004
4005     
4006  12.  Historical data must never be kept. True or False? Mark for Review
4007(1) Points
4008     
4009   
4010 True
4011
4012   
4013 False (*)
4014
4015     
4016    
4017Incorrect  Incorrect. Refer to Section 8 Lesson 1.
4018
4019     
4020  13.  You are doing a data model for a computer sales company where the price of postage depends upon the day of the week that goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this? Mark for Review
4021(1) Points
4022     
4023   
4024 Email current prices to all employees whenever a price changes.
4025
4026   
4027 Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*)
4028
4029   
4030 Allow them to enter whatever delivery charge they want.
4031
4032   
4033 Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.
4034
4035     
4036    
4037Incorrect  Incorrect. Refer to Section 8 Lesson 3.
4038
4039     
4040  14.  What is the function of logging or journaling in conceptual data models? Mark for Review
4041(1) Points
4042     
4043   
4044 Creates a fixed time for all events in a data model.
4045
4046   
4047 Gives a timestamp to all entities.
4048
4049   
4050 Allows you to track the history of attribute values, relationships, and/or entire entities (*)
4051
4052   
4053 Represents entities as time in the data model.
4054
4055     
4056    
4057Incorrect  Incorrect. Refer to Section 8 Lesson 3.
4058
4059     
4060  15.  When a system requires that old values for attributes are kept on record, this is know as Journaling or Logging. True or False? Mark for Review
4061(1) Points
4062     
4063   
4064 True (*)
4065
4066   
4067 False
4068
4069     
4070    
4071Correct  Correct
4072
4073     
4074Previous Page 3 of 3 Summary
4075
4076
4077Test: Section 8 Quiz
4078Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4079
4080 Section 8 Quiz
4081 (Answer all questions in this section)
4082     
4083  1.  What is the function of logging or journaling in conceptual data models? Mark for Review
4084(1) Points
4085     
4086   
4087 Gives a timestamp to all entities.
4088
4089   
4090 Creates a fixed time for all events in a data model.
4091
4092   
4093 Represents entities as time in the data model.
4094
4095   
4096 Allows you to track the history of attribute values, relationships, and/or entire entities (*)
4097
4098     
4099    
4100Correct  Correct
4101
4102     
4103  2.  Which of the following is a logical constraint that could result from considering how time impacts an example of data storage? Mark for Review
4104(1) Points
4105     
4106   
4107 An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)
4108
4109   
4110 EMPLOYEE periods can overlap causing the database to crash.
4111
4112   
4113 End Date must be before the Start Date.
4114
4115   
4116 Dates must be stored with Time.
4117
4118     
4119    
4120Correct  Correct
4121
4122     
4123  3.  When a system requires that old values for attributes are kept on record, this is know as Journaling or Logging. True or False? Mark for Review
4124(1) Points
4125     
4126   
4127 True (*)
4128
4129   
4130 False
4131
4132     
4133    
4134Correct  Correct
4135
4136     
4137  4.  When a relationship may or may not be transferable, depending on time, this is know as a/an: Mark for Review
4138(1) Points
4139     
4140   
4141 Arc.
4142
4143   
4144 Transferable Relationship
4145
4146   
4147 Conditional Non-transferable Relationship. (*)
4148
4149   
4150 Non-transferable Relationship.
4151
4152     
4153    
4154Incorrect  Incorrect. Refer to Section 8 Lesson 2.
4155
4156     
4157  5.  How do you know when to use the different types of time in your design? Mark for Review
4158(1) Points
4159     
4160   
4161 Always model time; you can take it out later if it is not needed.
4162
4163   
4164 It depends on the functional needs of the system . (*)
4165
4166   
4167 You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
4168
4169   
4170 The rules are fixed and should be followed.
4171
4172     
4173    
4174Correct  Correct
4175
4176     
4177Page 1 of 3 Next Summary
4178
4179
4180Test: Section 8 Quiz
4181Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4182
4183 Section 8 Quiz
4184 (Answer all questions in this section)
4185     
4186  6.  Conditional non-transferability refers to a relationship that may or may not be transferable, depending on time. True or False? Mark for Review
4187(1) Points
4188     
4189   
4190 True (*)
4191
4192   
4193 False
4194
4195     
4196    
4197Correct  Correct
4198
4199     
4200  7.  In a payroll system, it is desirable to have an entity called DAY with a holiday attribute when you want to track special holiday dates. True or False? Mark for Review
4201(1) Points
4202     
4203   
4204 True (*)
4205
4206   
4207 False
4208
4209     
4210    
4211Correct  Correct
4212
4213     
4214  8.  Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review
4215(1) Points
4216     
4217   
4218 Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.
4219
4220   
4221 If you are doing a system for any French City, you would need security clearance.
4222
4223   
4224 Cites may change their names and/or country association if the borders of a country change. (*)
4225
4226   
4227 People are born in the city and people die in the city.
4228
4229     
4230    
4231Correct  Correct
4232
4233     
4234  9.  You must make sure all entities of a proposed system can fit onto one diagram. It is not allowed to break up a data model into more than one diagram. True or False? Mark for Review
4235(1) Points
4236     
4237   
4238 True
4239
4240   
4241 False (*)
4242
4243     
4244    
4245Correct  Correct
4246
4247     
4248  10.  There is no point in trying to group your entities together on your diagram according to volume, and making a diagram look nice is a waste of time. True or False? Mark for Review
4249(1) Points
4250     
4251   
4252 True
4253
4254   
4255 False (*)
4256
4257     
4258    
4259Incorrect  Incorrect. Refer to Section 8 Lesson 4.
4260
4261     
4262Previous Page 2 of 3 Next Summary
4263
4264
4265Test: Section 8 Quiz
4266Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4267
4268 Section 8 Quiz
4269 (Answer all questions in this section)
4270     
4271  11.  In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False? Mark for Review
4272(1) Points
4273     
4274   
4275 True (*)
4276
4277   
4278 False
4279
4280     
4281    
4282Correct  Correct
4283
4284     
4285  12.  Which of the following statements are true to enhance the readability of ERDs? (Choose Two) Mark for Review
4286(1) Points
4287     
4288   (Choose all correct answers) 
4289     
4290   
4291 Relationship lines should not cross. (*)
4292
4293   
4294 Crossing relationship lines help the readability of the diagram.
4295
4296   
4297 It does not matter which way the crows feet (many ends of a relationship) point.
4298
4299   
4300 Crows feet (the many-ends of relationships) should consistently point the same direction where possible, either South & East or North & West (*)
4301
4302     
4303    
4304Incorrect  Incorrect. Refer to Section 8 Lesson 4.
4305
4306     
4307  13.  Historical data must never be kept. True or False? Mark for Review
4308(1) Points
4309     
4310   
4311 True
4312
4313   
4314 False (*)
4315
4316     
4317    
4318Correct  Correct
4319
4320     
4321  14.  When modeling historical data the unique identifier is always made up of a barred relationship from the original two entities. True or False? Mark for Review
4322(1) Points
4323     
4324   
4325 True
4326
4327   
4328 False (*)
4329
4330     
4331    
4332Correct  Correct
4333
4334     
4335  15.  Which of the following scenarios should be modeled so that historical data is kept? (Choose two) Mark for Review
4336(1) Points
4337     
4338   (Choose all correct answers) 
4339     
4340   
4341 TEACHER and AGE
4342
4343   
4344 BABY and AGE
4345
4346   
4347 CUSTOMER and PAYMENTS (*)
4348
4349   
4350 CUSTOMER and ORDERS (*)
4351
4352     
4353    
4354Correct  Correct
4355
4356     
4357Previous Page 3 of 3 Summary
4358
4359
4360Test: Section 8 Quiz
4361Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4362
4363 Section 8 Quiz
4364 (Answer all questions in this section)
4365     
4366  1.  Modeling historical data can produce a unique identifier that includes a date. True or False? Mark for Review
4367(1) Points
4368     
4369   
4370 True (*)
4371
4372   
4373 False
4374
4375     
4376    
4377Correct  Correct
4378
4379     
4380  2.  Which of the following scenarios should be modeled so that historical data is kept? (Choose two) Mark for Review
4381(1) Points
4382     
4383   (Choose all correct answers) 
4384     
4385   
4386 LIBRARY and BOOK (*)
4387
4388   
4389 LIBRARY and NUMBER OF BOOKS
4390
4391   
4392 STUDENT and AGE
4393
4394   
4395 STUDENT and GRADE (*)
4396
4397     
4398    
4399Incorrect  Incorrect. Refer to Section 8 Lesson 1.
4400
4401     
4402  3.  Historical data must never be kept. True or False? Mark for Review
4403(1) Points
4404     
4405   
4406 True
4407
4408   
4409 False (*)
4410
4411     
4412    
4413Correct  Correct
4414
4415     
4416  4.  Which of the following statements are true to enhance the readability of ERDs? (Choose Two) Mark for Review
4417(1) Points
4418     
4419   (Choose all correct answers) 
4420     
4421   
4422 Crows feet (the many-ends of relationships) should consistently point the same direction where possible, either South & East or North & West (*)
4423
4424   
4425 Crossing relationship lines help the readability of the diagram.
4426
4427   
4428 It does not matter which way the crows feet (many ends of a relationship) point.
4429
4430   
4431 Relationship lines should not cross. (*)
4432
4433     
4434    
4435Correct  Correct
4436
4437     
4438  5.  In an ERD, High Volume Entities usually have very few relationships to other entities. True or False? Mark for Review
4439(1) Points
4440     
4441   
4442 True
4443
4444   
4445 False (*)
4446
4447     
4448    
4449Correct  Correct
4450
4451     
4452Page 1 of 3 Next Summary
4453
4454
4455Test: Section 8 Quiz
4456Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4457
4458 Section 8 Quiz
4459 (Answer all questions in this section)
4460     
4461  6.  In an ERD, it is a good idea to group your entities according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False? Mark for Review
4462(1) Points
4463     
4464   
4465 True (*)
4466
4467   
4468 False
4469
4470     
4471    
4472Correct  Correct
4473
4474     
4475  7.  No formal rules exist for drawing ERD's. The most important thing is to make sure that all entities, attributes, and relationships are documented on the diagram, and the diagram is clear and readable. True or False? Mark for Review
4476(1) Points
4477     
4478   
4479 True (*)
4480
4481   
4482 False
4483
4484     
4485    
4486Correct  Correct
4487
4488     
4489  8.  When a system requires that old values for attributes are kept on record, this is know as Journaling or Logging. True or False? Mark for Review
4490(1) Points
4491     
4492   
4493 True (*)
4494
4495   
4496 False
4497
4498     
4499    
4500Correct  Correct
4501
4502     
4503  9.  Why would you want to model a time component when designing a system that lets people buy bars of gold? Mark for Review
4504(1) Points
4505     
4506   
4507 Sales people must determine where the gold is coming from.
4508
4509   
4510 You would not want to model this; it is not important.
4511
4512   
4513 The price of gold fluctuates and, to determine the current price, you need to know the time of purchase. (*)
4514
4515   
4516 The Government of your country might want to be notified of this transaction.
4517
4518     
4519    
4520Incorrect  Incorrect. Refer to Section 8 Lesson 3.
4521
4522     
4523  10.  What is the function of logging or journaling in conceptual data models? Mark for Review
4524(1) Points
4525     
4526   
4527 Creates a fixed time for all events in a data model.
4528
4529   
4530 Allows you to track the history of attribute values, relationships, and/or entire entities (*)
4531
4532   
4533 Gives a timestamp to all entities.
4534
4535   
4536 Represents entities as time in the data model.
4537
4538     
4539    
4540Correct  Correct
4541
4542     
4543Previous Page 2 of 3 Next Summary
4544
4545
4546Test: Section 8 Quiz
4547Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4548
4549 Section 8 Quiz
4550 (Answer all questions in this section)
4551     
4552  11.  All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False? Mark for Review
4553(1) Points
4554     
4555   
4556 True
4557
4558   
4559 False (*)
4560
4561     
4562    
4563Correct  Correct
4564
4565     
4566  12.  When you add the concept of time to your data model, your model becomes more complex. True or False? Mark for Review
4567(1) Points
4568     
4569   
4570 True (*)
4571
4572   
4573 False
4574
4575     
4576    
4577Correct  Correct
4578
4579     
4580  13.  How do you know when to use the different types of time in your design? Mark for Review
4581(1) Points
4582     
4583   
4584 The rules are fixed and should be followed.
4585
4586   
4587 It depends on the functional needs of the system . (*)
4588
4589   
4590 You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
4591
4592   
4593 Always model time; you can take it out later if it is not needed.
4594
4595     
4596    
4597Correct  Correct
4598
4599     
4600  14.  Which of the following would be a logical constraint when modeling time for a country entity? Mark for Review
4601(1) Points
4602     
4603   
4604 People have births and deaths in their countries that must be tracked by the system.
4605
4606   
4607 Daily traffic patterns must be monitored to determine which countries are overcrowded.
4608
4609   
4610 If you are doing a system for France or Germany, you would need security clearance.
4611
4612   
4613 Countries may change their names and/or borders over a period of time. (*)
4614
4615     
4616    
4617Correct  Correct
4618
4619     
4620  15.  When a relationship may or may not be transferable, depending on time, this is know as a/an: Mark for Review
4621(1) Points
4622     
4623   
4624 Conditional Non-transferable Relationship. (*)
4625
4626   
4627 Arc.
4628
4629   
4630 Transferable Relationship
4631
4632   
4633 Non-transferable Relationship.
4634
4635     
4636    
4637Correct  Correct
4638
4639Section 9 Quiz
4640 (Answer all questions in this section)
4641     
4642  1.  The explanation below is an example of which constraint type?
4643A column must contain only values consistent with the defined data format of the column Mark for Review
4644(1) Points
4645     
4646   
4647 Entity integrity
4648
4649   
4650 Column integrity (*)
4651
4652   
4653 Referential integrity
4654
4655   
4656 User-defined integrity
4657
4658     
4659    
4660Correct  Correct
4661
4662     
4663  2.  Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three) Mark for Review
4664(1) Points
4665     
4666   (Choose all correct answers) 
4667     
4668   
4669 One or more columns in a table that uniquely identifies each row in that table.
4670
4671   
4672 Only one column that must be null. (*)
4673
4674   
4675 A single column that uniquely identifies each column in a table. (*)
4676
4677   
4678 A set of columns in one table that uniquely identifies each row in another table. (*)
4679
4680     
4681    
4682Incorrect  Incorrect. Refer to Section 9 Lesson 1.
4683
4684     
4685  3.  A table does not have to have a primary key. True or False? Mark for Review
4686(1) Points
4687     
4688   
4689 True (*)
4690
4691   
4692 False
4693
4694     
4695    
4696Correct  Correct
4697
4698     
4699  4.  A foreign key always refers to a primary key in the same table. True or False? Mark for Review
4700(1) Points
4701     
4702   
4703 True
4704
4705   
4706 False (*)
4707
4708     
4709    
4710Correct  Correct
4711
4712     
4713  5.  When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two) Mark for Review
4714(1) Points
4715     
4716   (Choose all correct answers) 
4717     
4718   
4719 Make all relationships mandatory
4720
4721   
4722 Make all relationships optional (*)
4723
4724   
4725 Create an additional check constraint to verify that one foreign key is populated and the others are not (*)
4726
4727   
4728 All the above
4729
4730     
4731    
4732Correct  Correct
4733
4734     
4735Page 1 of 3 Next Summary
4736
4737
4738Test: Section 9 Quiz
4739Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4740
4741 Section 9 Quiz
4742 (Answer all questions in this section)
4743     
4744  6.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False? Mark for Review
4745(1) Points
4746     
4747   
4748 True (*)
4749
4750   
4751 False
4752
4753     
4754    
4755Correct  Correct
4756
4757     
4758  7.  An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False? Mark for Review
4759(1) Points
4760     
4761   
4762 True
4763
4764   
4765 False (*)
4766
4767     
4768    
4769Incorrect  Incorrect. Refer to Section 9 Lesson 4.
4770
4771     
4772  8.  In a physical model, many to many relationships are resolved via a structure called a(n): ________________ Mark for Review
4773(1) Points
4774     
4775   
4776 Intersection Table
4777
4778   
4779 Subtype
4780
4781   
4782 Intersection Entity (*)
4783
4784   
4785 Supertype
4786
4787     
4788    
4789Incorrect  Incorrect. Refer to Section 9 Lesson 3.
4790
4791     
4792  9.  One-to-Many Optional to Mandatory becomes a _______________ on the Master table. Mark for Review
4793(1) Points
4794     
4795   
4796 Unique Key
4797
4798   
4799 Optional Foreign Key (*)
4800
4801   
4802 Mandatory Foreign Key
4803
4804   
4805 Primary Key
4806
4807     
4808    
4809Incorrect  Incorrect. Refer to Section 9 Lesson 3.
4810
4811     
4812  10.  It is possible to implement non-transferability via a simple Foreign Key Relationship. True or False? Mark for Review
4813(1) Points
4814     
4815   
4816 True
4817
4818   
4819 False (*)
4820
4821     
4822    
4823Incorrect  Incorrect. Refer to Section 9 Lesson 3.
4824
4825     
4826Previous Page 2 of 3 Next Summary
4827
4828
4829Test: Section 9 Quiz
4830Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4831
4832 Section 9 Quiz
4833 (Answer all questions in this section)
4834     
4835  11.  An Arc is transformed to the physical model by adding a foeign Key for every relationship in the Arc. True or False? Mark for Review
4836(1) Points
4837     
4838   
4839 True (*)
4840
4841   
4842 False
4843
4844     
4845    
4846Correct  Correct
4847
4848     
4849  12.  The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review
4850(1) Points
4851     
4852   
4853 True (*)
4854
4855   
4856 False
4857
4858     
4859    
4860Correct  Correct
4861
4862     
4863  13.  The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ : Mark for Review
4864(1) Points
4865     
4866   
4867 Columns
4868
4869   
4870 Tables (*)
4871
4872   
4873 Unique Keys
4874
4875   
4876 Foreign Keys
4877
4878     
4879    
4880Incorrect  Incorrect. Refer to Section 9 Lesson 2.
4881
4882     
4883  14.  In a physical data model, an attribute becomes a _____________. Mark for Review
4884(1) Points
4885     
4886   
4887 Foreign Key
4888
4889   
4890 Constraint
4891
4892   
4893 Column (*)
4894
4895   
4896 Table
4897
4898     
4899    
4900Incorrect  Incorrect. Refer to Section 9 Lesson 2.
4901
4902     
4903  15.  In a physical data model, a relationship is represented as a: Mark for Review
4904(1) Points
4905     
4906   
4907 Column
4908
4909   
4910 Foreign Key (*)
4911
4912   
4913 Unique Identifier
4914
4915   
4916 Primary Key
4917
4918     
4919    
4920Incorrect  Incorrect. Refer to Section 9 Lesson 2.
4921
4922     
4923Previous Page 3 of 3 Summary
4924
4925
4926Test: Section 9 Quiz
4927Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4928
4929 Section 9 Quiz
4930 (Answer all questions in this section)
4931     
4932  1.  A table does not have to have a primary key. True or False? Mark for Review
4933(1) Points
4934     
4935   
4936 True (*)
4937
4938   
4939 False
4940
4941     
4942    
4943Correct  Correct
4944
4945     
4946  2.  Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three) Mark for Review
4947(1) Points
4948     
4949   (Choose all correct answers) 
4950     
4951   
4952 A set of columns that uniquely identifies each row in a table (*)
4953
4954   
4955 A single column that uniquely identifies each row in a table (*)
4956
4957   
4958 A set of columns and keys in a single table that uniquely identifies each row in a single table (*)
4959
4960   
4961 Only one column that cannot be null
4962
4963     
4964    
4965Correct  Correct
4966
4967     
4968  3.  The explanation below is an example of which constraint type?
4969If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce. Mark for Review
4970(1) Points
4971     
4972   
4973 User-defined integrity (*)
4974
4975   
4976 Entity integrity
4977
4978   
4979 Referential integrity
4980
4981   
4982 Column integrity
4983
4984     
4985    
4986Incorrect  Incorrect. Refer to Section 9 Lesson 1.
4987
4988     
4989  4.  The explanation below is an example of which constraint type?
4990A column must contain only values consistent with the defined data format of the column Mark for Review
4991(1) Points
4992     
4993   
4994 Entity integrity
4995
4996   
4997 Column integrity (*)
4998
4999   
5000 Referential integrity
5001
5002   
5003 User-defined integrity
5004
5005     
5006    
5007Correct  Correct
5008
5009     
5010  5.  One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False? Mark for Review
5011(1) Points
5012     
5013   
5014 True
5015
5016   
5017 False (*)
5018
5019     
5020    
5021Correct  Correct
5022
5023     
5024Page 1 of 3 Next Summary
5025
5026
5027Test: Section 9 Quiz
5028Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5029
5030 Section 9 Quiz
5031 (Answer all questions in this section)
5032     
5033  6.  To resolve a many to many relationship in a physical model you create a(n) ___________________? Mark for Review
5034(1) Points
5035     
5036   
5037 Two tables with Foreign key constraints between them
5038
5039   
5040 Unique key constraints
5041
5042   
5043 Intersection entity
5044
5045   
5046 Intersection table (*)
5047
5048     
5049    
5050Incorrect  Incorrect. Refer to Section 9 Lesson 3.
5051
5052     
5053  7.  It is possible to implement non-transferability via a simple Foreign Key Relationship. True or False? Mark for Review
5054(1) Points
5055     
5056   
5057 True
5058
5059   
5060 False (*)
5061
5062     
5063    
5064Correct  Correct
5065
5066     
5067  8.  The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False? Mark for Review
5068(1) Points
5069     
5070   
5071 True
5072
5073   
5074 False (*)
5075
5076     
5077    
5078Incorrect  Incorrect. Refer to Section 9 Lesson 3.
5079
5080     
5081  9.  Why would this table name NOT work in an Oracle database? this_year_end+next_year Mark for Review
5082(1) Points
5083     
5084   
5085 Table names must begin with an alphabetic character.
5086
5087   
5088 It is too long.
5089
5090   
5091 The Plus sign + is not allowed in object names. (*)
5092
5093   
5094 None of the above.
5095
5096     
5097    
5098Incorrect  Incorrect. Refer to Section 9 Lesson 2.
5099
5100     
5101  10.  In a physical data model, a relationship is represented as a combination of: (Choose Two) Mark for Review
5102(1) Points
5103     
5104   (Choose all correct answers) 
5105     
5106   
5107 Column
5108
5109   
5110 Check Constraint or Unique Key
5111
5112   
5113 Primary Key or Unique Key (*)
5114
5115   
5116 Foreign Key (*)
5117
5118     
5119    
5120Incorrect  Incorrect. Refer to Section 9 Lesson 2.
5121
5122     
5123Previous Page 2 of 3 Next Summary
5124
5125
5126Test: Section 9 Quiz
5127Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5128
5129 Section 9 Quiz
5130 (Answer all questions in this section)
5131     
5132  11.  The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review
5133(1) Points
5134     
5135   
5136 True (*)
5137
5138   
5139 False
5140
5141     
5142    
5143Correct  Correct
5144
5145     
5146  12.  In a physical data model, an attribute becomes a _____________. Mark for Review
5147(1) Points
5148     
5149   
5150 Constraint
5151
5152   
5153 Table
5154
5155   
5156 Column (*)
5157
5158   
5159 Foreign Key
5160
5161     
5162    
5163Correct  Correct
5164
5165     
5166  13.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False? Mark for Review
5167(1) Points
5168     
5169   
5170 True
5171
5172   
5173 False (*)
5174
5175     
5176    
5177Incorrect  Incorrect. Refer to Section 9 Lesson 4.
5178
5179     
5180  14.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False? Mark for Review
5181(1) Points
5182     
5183   
5184 True (*)
5185
5186   
5187 False
5188
5189     
5190    
5191Correct  Correct
5192
5193     
5194  15.  Which of the following is a valid reason for considering a Subtype Implementation? Mark for Review
5195(1) Points
5196     
5197   
5198 Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
5199
5200   
5201 The resulting table will reside in a single database and be used by just ONE user.
5202
5203   
5204 The common access paths for the supertypes are different.
5205
5206   
5207 Most of the relationships are at the supertype level.
5208
5209     
5210    
5211Incorrect  Incorrect. Refer to Section 9 Lesson 4.
5212
5213     
5214Previous Page 3 of 3 Summary
5215
5216
5217Test: Section 9 Quiz
5218Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5219
5220 Section 9 Quiz
5221 (Answer all questions in this section)
5222     
5223  1.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False? Mark for Review
5224(1) Points
5225     
5226   
5227 True
5228
5229   
5230 False (*)
5231
5232     
5233    
5234Correct  Correct
5235
5236     
5237  2.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False? Mark for Review
5238(1) Points
5239     
5240   
5241 True (*)
5242
5243   
5244 False
5245
5246     
5247    
5248Correct  Correct
5249
5250     
5251  3.  An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False? Mark for Review
5252(1) Points
5253     
5254   
5255 True
5256
5257   
5258 False (*)
5259
5260     
5261    
5262Correct  Correct
5263
5264     
5265  4.  An Arc is transformed to the physical model by adding a foeign Key for every relationship in the Arc. True or False? Mark for Review
5266(1) Points
5267     
5268   
5269 True (*)
5270
5271   
5272 False
5273
5274     
5275    
5276Correct  Correct
5277
5278     
5279  5.  Relationships on an ERD can only be transformed into UIDs in the physical model? True or False? Mark for Review
5280(1) Points
5281     
5282   
5283 True
5284
5285   
5286 False (*)
5287
5288     
5289    
5290Incorrect  Incorrect. Refer to Section 9 Lesson 3.
5291
5292     
5293Page 1 of 3 Next Summary
5294
5295
5296Test: Section 9 Quiz
5297Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5298
5299 Section 9 Quiz
5300 (Answer all questions in this section)
5301     
5302  6.  One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False? Mark for Review
5303(1) Points
5304     
5305   
5306 True
5307
5308   
5309 False (*)
5310
5311     
5312    
5313Correct  Correct
5314
5315     
5316  7.  A barrred Relationship will result in a Foreign Key column that also is part of: Mark for Review
5317(1) Points
5318     
5319   
5320 The Primary Key (*)
5321
5322   
5323 The Check Constraint
5324
5325   
5326 The Column Name
5327
5328   
5329 The Table Name
5330
5331     
5332    
5333Correct  Correct
5334
5335     
5336  8.  The explanation below is an example of which constraint type?
5337If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce. Mark for Review
5338(1) Points
5339     
5340   
5341 Referential integrity
5342
5343   
5344 User-defined integrity (*)
5345
5346   
5347 Entity integrity
5348
5349   
5350 Column integrity
5351
5352     
5353    
5354Correct  Correct
5355
5356     
5357  9.  The explanation below is an example of which constraint type?
5358A column must contain only values consistent with the defined data format of the column Mark for Review
5359(1) Points
5360     
5361   
5362 Entity integrity
5363
5364   
5365 Referential integrity
5366
5367   
5368 User-defined integrity
5369
5370   
5371 Column integrity (*)
5372
5373     
5374    
5375Correct  Correct
5376
5377     
5378  10.  The explanation below is an example of which constraint type?
5379A primary key must be unique, and no part of the primary key can be null. Mark for Review
5380(1) Points
5381     
5382   
5383 Entity integrity (*)
5384
5385   
5386 Column integrity
5387
5388   
5389 User-defined integrity
5390
5391   
5392 Referential integrity
5393
5394     
5395    
5396Incorrect  Incorrect. Refer to Section 9 Lesson 1.
5397
5398     
5399Previous Page 2 of 3 Next Summary
5400
5401
5402Test: Section 9 Quiz
5403Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5404
5405 Section 9 Quiz
5406 (Answer all questions in this section)
5407     
5408  11.  A foreign key always refers to a primary key in the same table. True or False? Mark for Review
5409(1) Points
5410     
5411   
5412 True
5413
5414   
5415 False (*)
5416
5417     
5418    
5419Correct  Correct
5420
5421     
5422  12.  The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review
5423(1) Points
5424     
5425   
5426 True (*)
5427
5428   
5429 False
5430
5431     
5432    
5433Correct  Correct
5434
5435     
5436  13.  In a physical data model, a relationship is represented as a combination of: (Choose Two) Mark for Review
5437(1) Points
5438     
5439   (Choose all correct answers) 
5440     
5441   
5442 Check Constraint or Unique Key
5443
5444   
5445 Foreign Key (*)
5446
5447   
5448 Column
5449
5450   
5451 Primary Key or Unique Key (*)
5452
5453     
5454    
5455Correct  Correct
5456
5457     
5458  14.  In a physical data model, an attribute becomes a _____________. Mark for Review
5459(1) Points
5460     
5461   
5462 Foreign Key
5463
5464   
5465 Constraint
5466
5467   
5468 Table
5469
5470   
5471 Column (*)
5472
5473     
5474    
5475Correct  Correct
5476
5477     
5478  15.  In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review
5479(1) Points
5480     
5481   
5482 There is no problem here. You can create a table called 1_TABLE.
5483
5484   
5485 TABLE is a reserved word.
5486
5487   
5488 The database does not understand all capital letters.
5489
5490   
5491 Object names must not start with a number. They must begin with a letter. (*)
5492
5493     
5494    
5495Incorrect  Incorrect. Refer to Section 9 Lesson 2.
5496
5497     
5498Previous Page 3 of 3 Summary
5499
5500
5501Test: Section 9 Quiz
5502Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5503
5504 Section 9 Quiz
5505 (Answer all questions in this section)
5506     
5507  1.  The explanation below is an example of which constraint type?
5508The value in the dept_no column of the EMPLOYEES table must match a value in the dept_no column in the DEPARTMENTS table. Mark for Review
5509(1) Points
5510     
5511   
5512 Column integrity
5513
5514   
5515 User-defined integrity
5516
5517   
5518 Referential integrity (*)
5519
5520   
5521 Entity integrity
5522
5523     
5524    
5525Incorrect  Incorrect. Refer to Section 9 Lesson 1.
5526
5527     
5528  2.  The explanation below is an example of which constraint type?
5529If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce. Mark for Review
5530(1) Points
5531     
5532   
5533 User-defined integrity (*)
5534
5535   
5536 Referential integrity
5537
5538   
5539 Column integrity
5540
5541   
5542 Entity integrity
5543
5544     
5545    
5546Correct  Correct
5547
5548     
5549  3.  Foreign keys must be null. True or False? Mark for Review
5550(1) Points
5551     
5552   
5553 True
5554
5555   
5556 False (*)
5557
5558     
5559    
5560Incorrect  Incorrect. Refer to Section 9 Lesson 1.
5561
5562     
5563  4.  Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three) Mark for Review
5564(1) Points
5565     
5566   (Choose all correct answers) 
5567     
5568   
5569 A set of columns and keys in a single table that uniquely identifies each row in a single table (*)
5570
5571   
5572 Only one column that cannot be null
5573
5574   
5575 A single column that uniquely identifies each row in a table (*)
5576
5577   
5578 A set of columns that uniquely identifies each row in a table (*)
5579
5580     
5581    
5582Correct  Correct
5583
5584     
5585  5.  One-to-Many Optional to Mandatory becomes a _______________ on the Master table. Mark for Review
5586(1) Points
5587     
5588   
5589 Primary Key
5590
5591   
5592 Optional Foreign Key (*)
5593
5594   
5595 Mandatory Foreign Key
5596
5597   
5598 Unique Key
5599
5600     
5601    
5602Correct  Correct
5603
5604     
5605Page 1 of 3 Next Summary
5606
5607
5608Test: Section 9 Quiz
5609Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5610
5611 Section 9 Quiz
5612 (Answer all questions in this section)
5613     
5614  6.  A barrred Relationship will result in a Foreign Key column that also is part of: Mark for Review
5615(1) Points
5616     
5617   
5618 The Column Name
5619
5620   
5621 The Table Name
5622
5623   
5624 The Primary Key (*)
5625
5626   
5627 The Check Constraint
5628
5629     
5630    
5631Correct  Correct
5632
5633     
5634  7.  Two entities A and B have an optional (A) to Mandatory (B) One-to-One relationship. When they are transformed, the Foreign Key(s) is placed on: Mark for Review
5635(1) Points
5636     
5637   
5638 The table B (*)
5639
5640   
5641 Both tables A and B get a new column and a Foreign Key.
5642
5643   
5644 Nowhere, One-to-One relationships are not transformed.
5645
5646   
5647 The table A
5648
5649     
5650    
5651Incorrect  Incorrect. Refer to Section 9 Lesson 3.
5652
5653     
5654  8.  To resolve a many to many relationship in a physical model you create a(n) ___________________? Mark for Review
5655(1) Points
5656     
5657   
5658 Intersection table (*)
5659
5660   
5661 Unique key constraints
5662
5663   
5664 Two tables with Foreign key constraints between them
5665
5666   
5667 Intersection entity
5668
5669     
5670    
5671Correct  Correct
5672
5673     
5674  9.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become mandatory. True or False? Mark for Review
5675(1) Points
5676     
5677   
5678 True
5679
5680   
5681 False (*)
5682
5683     
5684    
5685Correct  Correct
5686
5687     
5688  10.  The "Arc Implementation" is a synonym for what type of implementation? Mark for Review
5689(1) Points
5690     
5691   
5692 Subtype Implementation
5693
5694   
5695 Supertype and Subtype Implementation (*)
5696
5697   
5698 Supertype Implementation
5699
5700   
5701 Cascade Implementation
5702
5703     
5704    
5705Incorrect  Incorrect. Refer to Section 9 Lesson 4.
5706
5707     
5708Previous Page 2 of 3 Next Summary
5709
5710
5711Test: Section 9 Quiz
5712Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5713
5714 Section 9 Quiz
5715 (Answer all questions in this section)
5716     
5717  11.  An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False? Mark for Review
5718(1) Points
5719     
5720   
5721 True
5722
5723   
5724 False (*)
5725
5726     
5727    
5728Correct  Correct
5729
5730     
5731  12.  In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review
5732(1) Points
5733     
5734   
5735 TABLE is a reserved word.
5736
5737   
5738 There is no problem here. You can create a table called 1_TABLE.
5739
5740   
5741 Object names must not start with a number. They must begin with a letter. (*)
5742
5743   
5744 The database does not understand all capital letters.
5745
5746     
5747    
5748Correct  Correct
5749
5750     
5751  13.  In a physical data model, a relationship is represented as a: Mark for Review
5752(1) Points
5753     
5754   
5755 Foreign Key (*)
5756
5757   
5758 Unique Identifier
5759
5760   
5761 Primary Key
5762
5763   
5764 Column
5765
5766     
5767    
5768Correct  Correct
5769
5770     
5771  14.  In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'? Mark for Review
5772(1) Points
5773     
5774   
5775 EMPLOYEE is a reserved word
5776
5777   
5778 The database does not understand all capital letters
5779
5780   
5781 JOBS is a reserved word
5782
5783   
5784 You cannot have spaces between words in a table name (*)
5785
5786     
5787    
5788Incorrect  Incorrect. Refer to Section 9 Lesson 2.
5789
5790     
5791  15.  The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ : Mark for Review
5792(1) Points
5793     
5794   
5795 Foreign Keys
5796
5797   
5798 Tables (*)
5799
5800   
5801 Columns
5802
5803   
5804 Unique Keys
5805
5806     
5807    
5808Correct  Correct
5809
5810     
5811Previous Page 3 of 3 Summary
5812
5813
5814Test: Section 9 Quiz
5815Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5816
5817 Section 9 Quiz
5818 (Answer all questions in this section)
5819     
5820  1.  In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review
5821(1) Points
5822     
5823   
5824 TABLE is a reserved word.
5825
5826   
5827 Object names must not start with a number. They must begin with a letter. (*)
5828
5829   
5830 There is no problem here. You can create a table called 1_TABLE.
5831
5832   
5833 The database does not understand all capital letters.
5834
5835     
5836    
5837Correct  Correct
5838
5839     
5840  2.  In a physical data model, an entity becomes a _____________. Mark for Review
5841(1) Points
5842     
5843   
5844 Attribute
5845
5846   
5847 Table (*)
5848
5849   
5850 Column
5851
5852   
5853 Constraint
5854
5855     
5856    
5857Incorrect  Incorrect. Refer to Section 9 Lesson 2.
5858
5859     
5860  3.  The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review
5861(1) Points
5862     
5863   
5864 True (*)
5865
5866   
5867 False
5868
5869     
5870    
5871Correct  Correct
5872
5873     
5874  4.  In a physical data model, an attribute becomes a _____________. Mark for Review
5875(1) Points
5876     
5877   
5878 Constraint
5879
5880   
5881 Table
5882
5883   
5884 Column (*)
5885
5886   
5887 Foreign Key
5888
5889     
5890    
5891Correct  Correct
5892
5893     
5894  5.  An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False? Mark for Review
5895(1) Points
5896     
5897   
5898 True
5899
5900   
5901 False (*)
5902
5903     
5904    
5905Correct  Correct
5906
5907     
5908Page 1 of 3 Next Summary
5909
5910
5911Test: Section 9 Quiz
5912Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5913
5914 Section 9 Quiz
5915 (Answer all questions in this section)
5916     
5917  6.  When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two) Mark for Review
5918(1) Points
5919     
5920   (Choose all correct answers) 
5921     
5922   
5923 Make all relationships mandatory
5924
5925   
5926 Make all relationships optional (*)
5927
5928   
5929 Create an additional check constraint to verify that one foreign key is populated and the others are not (*)
5930
5931   
5932 All the above
5933
5934     
5935    
5936Correct  Correct
5937
5938     
5939  7.  When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False? Mark for Review
5940(1) Points
5941     
5942   
5943 True (*)
5944
5945   
5946 False
5947
5948     
5949    
5950Correct  Correct
5951
5952     
5953  8.  A barrred Relationship will result in a Foreign Key column that also is part of: Mark for Review
5954(1) Points
5955     
5956   
5957 The Primary Key (*)
5958
5959   
5960 The Check Constraint
5961
5962   
5963 The Table Name
5964
5965   
5966 The Column Name
5967
5968     
5969    
5970Correct  Correct
5971
5972     
5973  9.  The Oracle Database can implement a many to many relationship. You simply create two foreign keys between the two tables. True or False? Mark for Review
5974(1) Points
5975     
5976   
5977 True
5978
5979   
5980 False (*)
5981
5982     
5983    
5984Correct  Correct
5985
5986     
5987  10.  One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False? Mark for Review
5988(1) Points
5989     
5990   
5991 True
5992
5993   
5994 False (*)
5995
5996     
5997    
5998Correct  Correct
5999
6000     
6001Previous Page 2 of 3 Next Summary
6002
6003
6004Test: Section 9 Quiz
6005Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
6006
6007 Section 9 Quiz
6008 (Answer all questions in this section)
6009     
6010  11.  Two entities A and B have an optional (A) to Mandatory (B) One-to-One relationship. When they are transformed, the Foreign Key(s) is placed on: Mark for Review
6011(1) Points
6012     
6013   
6014 Nowhere, One-to-One relationships are not transformed.
6015
6016   
6017 The table B (*)
6018
6019   
6020 Both tables A and B get a new column and a Foreign Key.
6021
6022   
6023 The table A
6024
6025     
6026    
6027Correct  Correct
6028
6029     
6030  12.  Foreign keys cannot be null when Mark for Review
6031(1) Points
6032     
6033   
6034 It refers to the same table
6035
6036   
6037 It contains three or more columns
6038
6039   
6040 It is part of a primary key (*)
6041
6042   
6043 It refers to another table
6044
6045     
6046    
6047Correct  Correct
6048
6049     
6050  13.  The explanation below is an example of which constraint type?
6051A column must contain only values consistent with the defined data format of the column Mark for Review
6052(1) Points
6053     
6054   
6055 Column integrity (*)
6056
6057   
6058 Referential integrity
6059
6060   
6061 Entity integrity
6062
6063   
6064 User-defined integrity
6065
6066     
6067    
6068Correct  Correct
6069
6070     
6071  14.  The explanation below is an example of which constraint type?
6072A primary key must be unique, and no part of the primary key can be null. Mark for Review
6073(1) Points
6074     
6075   
6076 User-defined integrity
6077
6078   
6079 Column integrity
6080
6081   
6082 Entity integrity (*)
6083
6084   
6085 Referential integrity
6086
6087     
6088    
6089Incorrect  Incorrect. Refer to Section 9 Lesson 1.
6090
6091     
6092  15.  Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three) Mark for Review
6093(1) Points
6094     
6095   (Choose all correct answers) 
6096     
6097   
6098 Only one column that must be null. (*)
6099
6100   
6101 A set of columns in one table that uniquely identifies each row in another table. (*)
6102
6103   
6104 One or more columns in a table that uniquely identifies each row in that table.
6105
6106   
6107 A single column that uniquely identifies each column in a table. (*)
6108
6109     
6110    
6111Correct  Correct
61126. 	When an Arc is transformed to the physical model every relationship in the Arc becomes a mandatory Foreign Key. True or False? 	Mark for Review 
6113(1) Points
6114					
6115			
6116	True
6117	
6118			
6119	False (*)
6120	
6121					
6122				
6123[Incorrect] 		Incorrect. Refer to Section 9 Lesson 3.
6124	
6125				 	9. 	Column integrity refers to 	Mark for Review 
6126(1) Points
6127					
6128			
6129	Columns always having values
6130	
6131			
6132	Columns always containing values consistent with the defined data format (*)
6133	
6134			
6135	Columns always containing text data less than 255 characters
6136	
6137			
6138	Columns always containing positive numbers
6139	
6140					
6141				
6142[Correct] 		Correct 
614312. 	The Physical model is created by transforming which of the following models? 	Mark for Review 
6144(1) Points
6145					
6146			
6147	Conceptual (*)
6148	
6149			
6150	Constraint
6151	
6152			
6153	Table
6154	
6155			
6156	Physical
6157	
6158					
6159				
6160[Incorrect] 		Incorrect. Refer to Section 9 Lesson 2.
6161	
6162					
6163		13. 	Attributes become columns in a database table. True or False? 	Mark for Review 
6164(1) Points
6165					
6166			
6167	True (*)
6168	
6169			
6170	False
6171	
6172					
6173				
6174[Correct] 		Correct