rC42Msms

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.
1098Section 7 Quiz
1099	(Answer all questions in this section)
1100					
1101		1. 	Every business has restrictions on which attribute values and which relationships are allowed. These are known as:	 Mark for Review 
1102(1) Points
1103					
1104			
1105	Entities.
1106
1107			
1108	Constraints. (*)
1109
1110			
1111	Relationships
1112
1113			
1114	Attributes
1115
1116					
1117				
1118Correct		Correct
1119
1120					
1121		2. 	A relationship between an entity and itself is called a/an:	 Mark for Review 
1122(1) Points
1123					
1124			
1125	STUDENT (senior, male)
1126
1127			
1128	STUDENT ( University, Technical College) (*)
1129
1130			
1131	STUDENT (Grade A student, Average Student)
1132
1133			
1134	STUDENT (graduating, female)
1135
1136					
1137				
1138Correct		Correct
1139
1140					
1141		3. 	Which of the following can be added to a relationship?	 Mark for Review 
1142(1) Points
1143					
1144			
1145	An optional attribute can be created
1146
1147			
1148	A composite attribute
1149
1150			
1151	An attribute
1152
1153			
1154	An arc can be assigned (*)
1155
1156					
1157				
1158Correct		Correct
1159
1160					
1161		4. 	Which of the following would best be represented by an arc?	 Mark for Review 
1162(1) Points
1163					
1164			
1165	STUDENT (Grade A student, Average Student)
1166
1167			
1168	TEACHER (Female, Bob)
1169
1170			
1171	PARENT (Girl, Bob)
1172
1173			
1174	DELIVERY ADDRESS (Home, Office) (*)
1175
1176					
1177				
1178Correct		Correct
1179
1180					
1181		5. 	To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.	 Mark for Review 
1182(1) Points
1183					
1184			
1185	Relationship
1186
1187			
1188	Arc (*)
1189
1190			
1191	UID
1192
1193			
1194	Attribute
1195
1196					
1197				
1198Correct		Correct
1199
1200					
1201Page 1 of 3	Next	Summary
1202 
1203Section 7 Quiz
1204	(Answer all questions in this section)
1205					
1206		6. 	Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False?	 Mark for Review 
1207(1) Points
1208					
1209			
1210	True
1211
1212			
1213	False (*)
1214
1215					
1216				
1217Correct		Correct
1218
1219					
1220		7. 	An arc can often be modeled as Supertype and Subtypes. True or False?	 Mark for Review 
1221(1) Points
1222					
1223			
1224	True (*)
1225
1226			
1227	False
1228
1229					
1230				
1231Correct		Correct
1232
1233					
1234		8. 	Arcs are used to visually represent _________ between two or more relationships in an ERD.	 Mark for Review 
1235(1) Points
1236					
1237			
1238	Sameness
1239
1240			
1241	Differences
1242
1243			
1244	Exclusivity (*)
1245
1246			
1247	Inheritance
1248
1249					
1250				
1251Incorrect		Incorrect. Refer to Section 7 Lesson 1.
1252
1253					
1254		9. 	A recursive relationship must be Mandatory at both ends. True or False?	 Mark for Review 
1255(1) Points
1256					
1257			
1258	True
1259
1260			
1261	False (*)
1262
1263					
1264				
1265Correct		Correct
1266
1267					
1268		10. 	A single relationship can be both Recursive and Hierarchical at the same time. True or False?	 Mark for Review 
1269(1) Points
1270					
1271			
1272	True
1273
1274			
1275	False (*)
1276
1277					
1278				
1279Incorrect		Incorrect. Refer to Section 7 Lesson 2.
1280
1281					
1282Previous	Page 2 of 3	Next	Summary
1283 
1284	Section 7 Quiz
1285	(Answer all questions in this section)
1286					
1287		11. 	Business organizational charts are often modeled as a Hierarchical relationship. True or False?	 Mark for Review 
1288(1) Points
1289					
1290			
1291	True (*)
1292
1293			
1294	False
1295
1296					
1297				
1298Correct		Correct
1299
1300					
1301		12. 	A Recursive Relationship is represented on an ERD by a/an:	 Mark for Review 
1302(1) Points
1303					
1304			
1305	Crow's Foot
1306
1307			
1308	Pig's Ear (*)
1309
1310			
1311	Single Toe
1312
1313			
1314	Dog's Tail
1315
1316					
1317				
1318Correct		Correct
1319
1320					
1321		13. 	A relationship between an entity and itself is called a/an:	 Mark for Review 
1322(1) Points
1323					
1324			
1325	General Relationship
1326
1327			
1328	Heirarchical Relationship
1329
1330			
1331	Recursive Relationship (*)
1332
1333			
1334	Invalid Relationship
1335
1336					
1337				
1338Correct		Correct
1339
1340					
1341		14. 	Cascading UIDs are a feature often found in what type of Relationship?	 Mark for Review 
1342(1) Points
1343					
1344			
1345	General Relationship
1346
1347			
1348	Invalid Relationship
1349
1350			
1351	Heirarchical Relationship (*)
1352
1353			
1354	Recursive Relationship
1355
1356					
1357				
1358Incorrect		Incorrect. Refer to Section 7 Lesson 2.
1359
1360					
1361		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 
1362(1) Points
1363					
1364			
1365	True (*)
1366
1367			
1368	False
1369
1370					
1371				
1372Correct		Correct
1373
1374					
1375Previous	Page 3 of 3	Summary
1376 
13771. 	Which of the following would best be represented by an arc? 	Mark for Review 
1378(1) Points
1379					
1380			
1381	STUDENT (Grade A student, Average Student)
1382	
1383			
1384	DELIVERY ADDRESS (Home, Office) (*)
1385	
1386			
1387	PARENT (Girl, Bob)
1388	
1389			
1390	TEACHER (Female, Bob)
1391	
1392					
1393				
1394[Correct] 		Correct
1395	
1396					
1397		2. 	Arcs model an Exclusive OR constraint. True or False? 	Mark for Review 
1398(1) Points
1399					
1400			
1401	True (*)
1402	
1403			
1404	False
1405	
1406					
1407				
1408[Correct] 		Correct
1409	
1410					
1411		3. 	Arcs are used to visually represent _________ between two or more relationships in an ERD. 	Mark for Review 
1412(1) Points
1413					
1414			
1415	Differences
1416	
1417			
1418	Inheritance
1419	
1420			
1421	Exclusivity (*)
1422	
1423			
1424	Sameness
1425	
1426					
1427				
1428[Correct] 		Correct
1429	
1430					
1431		4. 	All relationships participating in an arc must be mandatory. True or False? 	Mark for Review 
1432(1) Points
1433					
1434			
1435	True
1436	
1437			
1438	False (*)
1439	
1440					
1441				
1442[Incorrect] 		Incorrect. Refer to Section 7 Lesson 1.
1443	
1444					
1445		5. 	Every business has restrictions on which attribute values and which relationships are allowed. These are known as: 	Mark for Review 
1446(1) Points
1447					
1448			
1449	Entities.
1450	
1451			
1452	Constraints. (*)
1453	
1454			
1455	Relationships
1456	
1457			
1458	Attributes
1459	
1460					
1461				
1462[Incorrect] 		Incorrect. Refer to Section 7 Lesson 1. 
1463 			
1464		6. 	Which of the following would best be represented by an arc? 	Mark for Review 
1465(1) Points
1466					
1467			
1468	STUDENT ( University, Technical College) (*)
1469	
1470			
1471	STUDENT (senior, male)
1472	
1473			
1474	STUDENT (Grade A student, Average Student)
1475	
1476			
1477	STUDENT (graduating, female)
1478	
1479					
1480				
1481[Correct] 		Correct
1482	
1483					
1484		7. 	Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False? 	Mark for Review 
1485(1) Points
1486					
1487			
1488	True
1489	
1490			
1491	False (*)
1492	
1493					
1494				
1495[Correct] 		Correct
1496	
1497					
1498		8. 	An arc can often be modeled as Supertype and Subtypes. True or False? 	Mark for Review 
1499(1) Points
1500					
1501			
1502	True (*)
1503	
1504			
1505	False
1506	
1507					
1508				
1509[Incorrect] 		Incorrect. Refer to Section 7 Lesson 1.
1510	
1511					
1512		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 
1513(1) Points
1514					
1515			
1516	True (*)
1517	
1518			
1519	False
1520	
1521					
1522				
1523[Correct] 		Correct
1524	
1525					
1526		10. 	Cascading UIDs are a feature often found in what type of Relationship? 	Mark for Review 
1527(1) Points
1528					
1529			
1530	Recursive Relationship
1531	
1532			
1533	General Relationship
1534	
1535			
1536	Heirarchical Relationship (*)
1537	
1538			
1539	Invalid Relationship
1540	
1541					
1542				
1543[Correct] 		Correct 
154411. 	A recursive relationship must be Mandatory at both ends. True or False? 	Mark for Review 
1545(1) Points
1546					
1547			
1548	True
1549	
1550			
1551	False (*)
1552	
1553					
1554				
1555[Correct] 		Correct
1556	
1557					
1558		12. 	A Recursive Relationship is represented on an ERD by a/an: 	Mark for Review 
1559(1) Points
1560					
1561			
1562	Crow's Foot
1563	
1564			
1565	Single Toe
1566	
1567			
1568	Pig's Ear (*)
1569	
1570			
1571	Dog's Tail
1572	
1573					
1574				
1575[Correct] 		Correct
1576	
1577					
1578		13. 	Business organizational charts are often modeled as a Hierarchical relationship. True or False? 	Mark for Review 
1579(1) Points
1580					
1581			
1582	True (*)
1583	
1584			
1585	False
1586	
1587					
1588				
1589[Correct] 		Correct
1590	
1591					
1592		14. 	A relationship between an entity and itself is called a/an: 	Mark for Review 
1593(1) Points
1594					
1595			
1596	Recursive Relationship (*)
1597	
1598			
1599	General Relationship
1600	
1601			
1602	Invalid Relationship
1603	
1604			
1605	Heirarchical Relationship
1606	
1607					
1608				
1609[Correct] 		Correct
1610	
1611					
1612		15. 	A single relationship can be both Recursive and Hierarchical at the same time. True or False? 	Mark for Review 
1613(1) Points
1614					
1615			
1616	True
1617	
1618			
1619	False (*)
1620	
1621					
1622				
1623[Correct] 		Correct
1624	
16251.  A single relationship can be both Recursive and Hierarchical at the same time. True or False? Mark for Review
1626(1) Points
1627     
1628   
1629 True
1630
1631   
1632 False (*)
1633
1634     
1635    
1636Correct  Correct
1637
1638     
1639  2.  A Recursive Relationship is represented on an ERD by a/an: Mark for Review
1640(1) Points
1641     
1642   
1643 Single Toe
1644
1645   
1646 Dog's Tail
1647
1648   
1649 Crow's Foot
1650
1651   
1652 Pig's Ear (*)
1653
1654     
1655    
1656Incorrect  Incorrect. Refer to Section 7 Lesson 2.
1657
1658     
1659  3.  A relationship between an entity and itself is called a/an: Mark for Review
1660(1) Points
1661     
1662   
1663 Invalid Relationship
1664
1665   
1666 Heirarchical Relationship
1667
1668   
1669 Recursive Relationship (*)
1670
1671   
1672 General Relationship
1673
1674     
1675    
1676Incorrect  Incorrect. Refer to Section 7 Lesson 2.
1677
1678     
1679  4.  Business organizational charts are often modeled as a Hierarchical relationship. True or False? Mark for Review
1680(1) Points
1681     
1682   
1683 True (*)
1684
1685   
1686 False
1687
1688     
1689    
1690Correct  Correct
1691
1692     
1693  5.  A recursive relationship must be Mandatory at both ends. True or False? Mark for Review
1694(1) Points
1695     
1696   
1697 True
1698
1699   
1700 False (*)
1701
1702     
1703    
1704Correct  Correct
1705
1706     
1707Page 1 of 3 Next Summary
1708
1709
1710Test: Section 7 Quiz
1711Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
1712
1713 Section 7 Quiz
1714 (Answer all questions in this section)
1715     
1716  6.  Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
1717(1) Points
1718     
1719   
1720 Recursive Relationship
1721
1722   
1723 Invalid Relationship
1724
1725   
1726 Heirarchical Relationship (*)
1727
1728   
1729 General Relationship
1730
1731     
1732    
1733Incorrect  Incorrect. Refer to Section 7 Lesson 2.
1734
1735     
1736  7.  A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False? Mark for Review
1737(1) Points
1738     
1739   
1740 True (*)
1741
1742   
1743 False
1744
1745     
1746    
1747Correct  Correct
1748
1749     
1750  8.  All relationships participating in an arc must be mandatory. True or False? Mark for Review
1751(1) Points
1752     
1753   
1754 True
1755
1756   
1757 False (*)
1758
1759     
1760    
1761Incorrect  Incorrect. Refer to Section 7 Lesson 1.
1762
1763     
1764  9.  Which of the following can be added to a relationship? Mark for Review
1765(1) Points
1766     
1767   
1768 An arc can be assigned (*)
1769
1770   
1771 An optional attribute can be created
1772
1773   
1774 An attribute
1775
1776   
1777 A composite attribute
1778
1779     
1780    
1781Incorrect  Incorrect. Refer to Section 7 Lesson 1.
1782
1783     
1784  10.  To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________. Mark for Review
1785(1) Points
1786     
1787   
1788 Arc (*)
1789
1790   
1791 Relationship
1792
1793   
1794 Attribute
1795
1796   
1797 UID
1798
1799     
1800    
1801Correct  Correct
1802
1803     
1804Previous Page 2 of 3 Next Summary
1805
1806
1807Test: Section 7 Quiz
1808Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
1809
1810 Section 7 Quiz
1811 (Answer all questions in this section)
1812     
1813  11.  Which of the following would best be represented by an arc? Mark for Review
1814(1) Points
1815     
1816   
1817 STUDENT (Grade A student, Average Student)
1818
1819   
1820 STUDENT ( University, Technical College) (*)
1821
1822   
1823 STUDENT (graduating, female)
1824
1825   
1826 STUDENT (senior, male)
1827
1828     
1829    
1830Correct  Correct
1831
1832     
1833  12.  An arc can often be modeled as Supertype and Subtypes. True or False? Mark for Review
1834(1) Points
1835     
1836   
1837 True (*)
1838
1839   
1840 False
1841
1842     
1843    
1844Correct  Correct
1845
1846     
1847  13.  Which of the following would best be represented by an arc? Mark for Review
1848(1) Points
1849     
1850   
1851 PARENT (Girl, Bob)
1852
1853   
1854 DELIVERY ADDRESS (Home, Office) (*)
1855
1856   
1857 TEACHER (Female, Bob)
1858
1859   
1860 STUDENT (Grade A student, Average Student)
1861
1862     
1863    
1864Incorrect  Incorrect. Refer to Section 7 Lesson 1.
1865
1866     
1867  14.  Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False? Mark for Review
1868(1) Points
1869     
1870   
1871 True
1872
1873   
1874 False (*)
1875
1876     
1877    
1878Correct  Correct
1879
1880     
1881  15.  Arcs are used to visually represent _________ between two or more relationships in an ERD. Mark for Review
1882(1) Points
1883     
1884   
1885 Inheritance
1886
1887   
1888 Exclusivity (*)
1889
1890   
1891 Sameness
1892
1893   
1894 Differences
1895
1896     
1897    
1898Incorrect  Incorrect. Refer to Section 7 Lesson 1.
1899
1900     
1901Previous Page 3 of 3 Summary
1902
1903
1904Test: Section 7 Quiz
1905Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
1906
1907 Section 7 Quiz
1908 (Answer all questions in this section)
1909     
1910  1.  An arc can often be modeled as Supertype and Subtypes. True or False? Mark for Review
1911(1) Points
1912     
1913   
1914 True (*)
1915
1916   
1917 False
1918
1919     
1920    
1921Correct  Correct
1922
1923     
1924  2.  Which of the following would best be represented by an arc? Mark for Review
1925(1) Points
1926     
1927   
1928 STUDENT (graduating, female)
1929
1930   
1931 STUDENT (senior, male)
1932
1933   
1934 STUDENT (Grade A student, Average Student)
1935
1936   
1937 STUDENT ( University, Technical College) (*)
1938
1939     
1940    
1941Correct  Correct
1942
1943     
1944  3.  To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________. Mark for Review
1945(1) Points
1946     
1947   
1948 Attribute
1949
1950   
1951 Arc (*)
1952
1953   
1954 UID
1955
1956   
1957 Relationship
1958
1959     
1960    
1961Correct  Correct
1962
1963     
1964  4.  Which of the following would best be represented by an arc? Mark for Review
1965(1) Points
1966     
1967   
1968 STUDENT (Grade A student, Average Student)
1969
1970   
1971 TEACHER (Female, Bob)
1972
1973   
1974 DELIVERY ADDRESS (Home, Office) (*)
1975
1976   
1977 PARENT (Girl, Bob)
1978
1979     
1980    
1981Correct  Correct
1982
1983     
1984  5.  Arcs are used to visually represent _________ between two or more relationships in an ERD. Mark for Review
1985(1) Points
1986     
1987   
1988 Sameness
1989
1990   
1991 Inheritance
1992
1993   
1994 Differences
1995
1996   
1997 Exclusivity (*)
1998
1999     
2000    
2001Correct  Correct
2002
2003     
2004Page 1 of 3 Next Summary
2005
2006
2007Test: Section 7 Quiz
2008Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
2009
2010 Section 7 Quiz
2011 (Answer all questions in this section)
2012     
2013  6.  Arcs model an Exclusive OR constraint. True or False? Mark for Review
2014(1) Points
2015     
2016   
2017 True (*)
2018
2019   
2020 False
2021
2022     
2023    
2024Correct  Correct
2025
2026     
2027  7.  Which of the following can be added to a relationship? Mark for Review
2028(1) Points
2029     
2030   
2031 An arc can be assigned (*)
2032
2033   
2034 An attribute
2035
2036   
2037 An optional attribute can be created
2038
2039   
2040 A composite attribute
2041
2042     
2043    
2044Correct  Correct
2045
2046     
2047  8.  Every business has restrictions on which attribute values and which relationships are allowed. These are known as: Mark for Review
2048(1) Points
2049     
2050   
2051 Entities.
2052
2053   
2054 Attributes
2055
2056   
2057 Relationships
2058
2059   
2060 Constraints. (*)
2061
2062     
2063    
2064Incorrect  Incorrect. Refer to Section 7 Lesson 1.
2065
2066     
2067  9.  A recursive relationship must be Mandatory at both ends. True or False? Mark for Review
2068(1) Points
2069     
2070   
2071 True
2072
2073   
2074 False (*)
2075
2076     
2077    
2078Correct  Correct
2079
2080     
2081  10.  A Recursive Relationship is represented on an ERD by a/an: Mark for Review
2082(1) Points
2083     
2084   
2085 Pig's Ear (*)
2086
2087   
2088 Single Toe
2089
2090   
2091 Crow's Foot
2092
2093   
2094 Dog's Tail
2095
2096     
2097    
2098Correct  Correct
2099
2100     
2101Previous Page 2 of 3 Next Summary
2102
2103
2104Test: Section 7 Quiz
2105Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
2106
2107 Section 7 Quiz
2108 (Answer all questions in this section)
2109     
2110  11.  A single relationship can be both Recursive and Hierarchical at the same time. True or False? Mark for Review
2111(1) Points
2112     
2113   
2114 True
2115
2116   
2117 False (*)
2118
2119     
2120    
2121Correct  Correct
2122
2123     
2124  12.  Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
2125(1) Points
2126     
2127   
2128 General Relationship
2129
2130   
2131 Heirarchical Relationship (*)
2132
2133   
2134 Invalid Relationship
2135
2136   
2137 Recursive Relationship
2138
2139     
2140    
2141Correct  Correct
2142
2143     
2144  13.  A relationship between an entity and itself is called a/an: Mark for Review
2145(1) Points
2146     
2147   
2148 Recursive Relationship (*)
2149
2150   
2151 Invalid Relationship
2152
2153   
2154 Heirarchical Relationship
2155
2156   
2157 General Relationship
2158
2159     
2160    
2161Correct  Correct
2162
2163     
2164  14.  A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False? Mark for Review
2165(1) Points
2166     
2167   
2168 True (*)
2169
2170   
2171 False
2172
2173     
2174    
2175Correct  Correct
2176
2177     
2178  15.  Business organizational charts are often modeled as a Hierarchical relationship. True or False? Mark for Review
2179(1) Points
2180     
2181   
2182 True (*)
2183
2184   
2185 False
2186
2187     
2188    
2189Correct  Correct
2190Section 8 Quiz
2191	(Answer all questions in this section)
2192					
2193		1. 	Modeling historical data can produce a unique identifier that includes a date. True or False?	 Mark for Review 
2194(1) Points
2195					
2196			
2197	True (*)
2198
2199			
2200	False
2201
2202					
2203				
2204Incorrect		Incorrect. Refer to Section 8 Lesson 1.
2205
2206					
2207		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 
2208(1) Points
2209					
2210			
2211	True
2212
2213			
2214	False (*)
2215
2216					
2217				
2218Incorrect		Incorrect. Refer to Section 8 Lesson 1.
2219
2220					
2221		3. 	Which of the following scenarios should be modeled so that historical data is kept? (Choose two)	 Mark for Review 
2222(1) Points
2223					
2224			(Choose all correct answers)	
2225					
2226			
2227	LIBRARY and BOOK (*)
2228
2229			
2230	STUDENT and GRADE (*)
2231
2232			
2233	STUDENT and AGE
2234
2235			
2236	LIBRARY and NUMBER OF BOOKS
2237
2238					
2239				
2240Incorrect		Incorrect. Refer to Section 8 Lesson 1.
2241
2242					
2243		4. 	In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?	 Mark for Review 
2244(1) Points
2245					
2246			
2247	True
2248
2249			
2250	False (*)
2251
2252					
2253				
2254Incorrect		Incorrect. Refer to Section 8 Lesson 4.
2255
2256					
2257		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 
2258(1) Points
2259					
2260			
2261	True
2262
2263			
2264	False (*)
2265
2266					
2267				
2268Correct		Correct
2269
2270					
2271Page 1 of 3	Next	Summary
2272 
2273Section 8 Quiz
2274	(Answer all questions in this section)
2275					
2276		6. 	Which of the following statements are true to enhance the readability of ERDs? (Choose Two)	 Mark for Review 
2277(1) Points
2278					
2279			(Choose all correct answers)	
2280					
2281			
2282	Relationship lines should not cross. (*)
2283
2284			
2285	Crossing relationship lines help the readability of the diagram.
2286
2287			
2288	It does not matter which way the crows feet (many ends of a relationship) point.
2289
2290			
2291	Crows feet (the many-ends of relationships) should consistently point the same direction where possible, either South & East or North & West (*)
2292
2293					
2294				
2295Incorrect		Incorrect. Refer to Section 8 Lesson 4.
2296
2297					
2298		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 
2299(1) Points
2300					
2301			
2302	True
2303
2304			
2305	False (*)
2306
2307					
2308				
2309Correct		Correct
2310
2311					
2312		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 
2313(1) Points
2314					
2315			
2316	True
2317
2318			
2319	False (*)
2320
2321					
2322				
2323Correct		Correct
2324
2325					
2326		9. 	When a relationship may or may not be transferable, depending on time, this is know as a/an:	 Mark for Review 
2327(1) Points
2328					
2329			
2330	Non-transferable Relationship.
2331
2332			
2333	Conditional Non-transferable Relationship. (*)
2334
2335			
2336	Arc.
2337
2338			
2339	Transferable Relationship
2340
2341					
2342				
2343Correct		Correct
2344
2345					
2346		10. 	Modeling historical data is optional. True or False?	 Mark for Review 
2347(1) Points
2348					
2349			
2350	True (*)
2351
2352			
2353	False
2354
2355					
2356				
2357Correct		Correct
2358
2359					
2360Previous	Page 2 of 3	Next	Summary
2361 
2362Section 8 Quiz
2363	(Answer all questions in this section)
2364					
2365		11. 	Which of the following would be a logical constraint when modeling time for a country entity?	 Mark for Review 
2366(1) Points
2367					
2368			
2369	People have births and deaths in their countries that must be tracked by the system.
2370
2371			
2372	Countries may change their names and/or borders over a period of time. (*)
2373
2374			
2375	Daily traffic patterns must be monitored to determine which countries are overcrowded.
2376
2377			
2378	If you are doing a system for France or Germany, you would need security clearance.
2379
2380					
2381				
2382Correct		Correct
2383
2384					
2385		12. 	Which of the following would be a logical constraint when modeling time for a City entity?	 Mark for Review 
2386(1) Points
2387					
2388			
2389	If you are doing a system for any French City, you would need security clearance.
2390
2391			
2392	People are born in the city and people die in the city.
2393
2394			
2395	Cites may change their names and/or country association if the borders of a country change. (*)
2396
2397			
2398	Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.
2399
2400					
2401				
2402Incorrect		Incorrect. Refer to Section 8 Lesson 2.
2403
2404					
2405		13. 	What is the function of logging or journaling in conceptual data models?	 Mark for Review 
2406(1) Points
2407					
2408			
2409	Allows you to track the history of attribute values, relationships, and/or entire entities (*)
2410
2411			
2412	Creates a fixed time for all events in a data model.
2413
2414			
2415	Gives a timestamp to all entities.
2416
2417			
2418	Represents entities as time in the data model.
2419
2420					
2421				
2422Incorrect		Incorrect. Refer to Section 8 Lesson 3.
2423
2424					
2425		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 
2426(1) Points
2427					
2428			
2429	True (*)
2430
2431			
2432	False
2433
2434					
2435				
2436Incorrect		Incorrect. Refer to Section 8 Lesson 3.
2437
2438					
2439		15. 	All systems must include functionality to provide logging or journaling in conceptual data models. True or False?	 Mark for Review 
2440(1) Points
2441					
2442			
2443	True
2444
2445			
2446	False (*)
2447
2448					
2449				
2450Incorrect		Incorrect. Refer to Section 8 Lesson 3.
2451
2452					
2453Previous	Page 3 of 3	Summary
2454 Section 8 Quiz
2455	(Answer all questions in this section)
2456					
2457		1. 	Which of the following would be a logical constraint when modeling time for a City entity?	 Mark for Review 
2458(1) Points
2459					
2460			
2461	If you are doing a system for any French City, you would need security clearance.
2462
2463			
2464	Cites may change their names and/or country association if the borders of a country change. (*)
2465
2466			
2467	People are born in the city and people die in the city.
2468
2469			
2470	Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.
2471
2472					
2473				
2474Correct		Correct
2475
2476					
2477		2. 	How do you know when to use the different types of time in your design?	 Mark for Review 
2478(1) Points
2479					
2480			
2481	The rules are fixed and should be followed.
2482
2483			
2484	It depends on the functional needs of the system . (*)
2485
2486			
2487	You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
2488
2489			
2490	Always model time; you can take it out later if it is not needed.
2491
2492					
2493				
2494Incorrect		Incorrect. Refer to Section 8 Lesson 2.
2495
2496					
2497		3. 	There are no circumstances where you would create a DAY entity. True or False?	 Mark for Review 
2498(1) Points
2499					
2500			
2501	True
2502
2503			
2504	False (*)
2505
2506					
2507				
2508Incorrect		Incorrect. Refer to Section 8 Lesson 2.
2509
2510					
2511		4. 	Conditional non-transferability refers to a relationship that may or may not be transferable, depending on time. True or False?	 Mark for Review 
2512(1) Points
2513					
2514			
2515	True (*)
2516
2517			
2518	False
2519
2520					
2521				
2522Correct		Correct
2523
2524					
2525		5. 	When a relationship may or may not be transferable, depending on time, this is know as a/an:	 Mark for Review 
2526(1) Points
2527					
2528			
2529	Arc.
2530
2531			
2532	Non-transferable Relationship.
2533
2534			
2535	Conditional Non-transferable Relationship. (*)
2536
2537			
2538	Transferable Relationship
2539
2540					
2541				
2542Incorrect		Incorrect. Refer to Section 8 Lesson 2.
2543
2544					
2545Page 1 of 3	Next	Summary
2546 
2547
2548	Section 8 Quiz
2549	(Answer all questions in this section)
2550					
2551		6. 	Which of the following scenarios should be modeled so that historical data is kept? (Choose two)	 Mark for Review 
2552(1) Points
2553					
2554			(Choose all correct answers)	
2555					
2556			
2557	LIBRARY and NUMBER OF BOOKS
2558
2559			
2560	STUDENT and GRADE (*)
2561
2562			
2563	LIBRARY and BOOK (*)
2564
2565			
2566	STUDENT and AGE
2567
2568					
2569				
2570Correct		Correct
2571
2572					
2573		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 
2574(1) Points
2575					
2576			
2577	True
2578
2579			
2580	False (*)
2581
2582					
2583				
2584Correct		Correct
2585
2586					
2587		8. 	Historical data must never be kept. True or False?	 Mark for Review 
2588(1) Points
2589					
2590			
2591	True
2592
2593			
2594	False (*)
2595
2596					
2597				
2598Incorrect		Incorrect. Refer to Section 8 Lesson 1.
2599
2600					
2601		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 
2602(1) Points
2603					
2604			
2605	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.
2606
2607			
2608	B. Create a new item and a new price every day.
2609
2610			
2611	C. Use a price entity with a start and end date
2612
2613			
2614	D. Allow them to delete the item and enter a new one.
2615
2616			
2617	E. Both A and C (*)
2618
2619					
2620				
2621Correct		Correct
2622
2623					
2624		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 
2625(1) Points
2626					
2627			
2628	Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.
2629
2630			
2631	Email current prices to all employees whenever a price changes.
2632
2633			
2634	Allow them to enter whatever delivery charge they want.
2635
2636			
2637	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. (*)
2638
2639					
2640				
2641Incorrect		Incorrect. Refer to Section 8 Lesson 3.
2642
2643					
2644Previous	Page 2 of 3	Next	Summary
2645 
2646Section 8 Quiz
2647	(Answer all questions in this section)
2648					
2649		11. 	What is the function of logging or journaling in conceptual data models?	 Mark for Review 
2650(1) Points
2651					
2652			
2653	Allows you to track the history of attribute values, relationships, and/or entire entities (*)
2654
2655			
2656	Represents entities as time in the data model.
2657
2658			
2659	Gives a timestamp to all entities.
2660
2661			
2662	Creates a fixed time for all events in a data model.
2663
2664					
2665				
2666Correct		Correct
2667
2668					
2669		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 
2670(1) Points
2671					
2672			
2673	True (*)
2674
2675			
2676	False
2677
2678					
2679				
2680Correct		Correct
2681
2682					
2683		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 
2684(1) Points
2685					
2686			
2687	True
2688
2689			
2690	False (*)
2691
2692					
2693				
2694Incorrect		Incorrect. Refer to Section 8 Lesson 4.
2695
2696					
2697		14. 	Which of the following statements are true for ERD's to enhance their readability. (Choose Two)	 Mark for Review 
2698(1) Points
2699					
2700			(Choose all correct answers)	
2701					
2702			
2703	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. (*)
2704
2705			
2706	The crows feet (many ends) can point whichever way is the easiest to draw.
2707
2708			
2709	You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram.
2710
2711			
2712	Avoid crossing one relationship line with another. (*)
2713
2714					
2715				
2716Incorrect		Incorrect. Refer to Section 8 Lesson 4.
2717
2718					
2719		15. 	In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?	 Mark for Review 
2720(1) Points
2721					
2722			
2723	True
2724
2725			
2726	False (*)
2727
2728					
2729				
2730Incorrect		Incorrect. Refer to Section 8 Lesson 4.
2731
2732					
2733Previous	Page 3 of 3	Summary
2734 
2735Section 9 Quiz
2736	(Answer all questions in this section)
2737					
2738		1. 	Column integrity refers to	 Mark for Review 
2739(1) Points
2740					
2741			
2742	Columns always containing positive numbers
2743
2744			
2745	Columns always containing values consistent with the defined data format (*)
2746
2747			
2748	Columns always containing text data less than 255 characters
2749
2750			
2751	Columns always having values
2752
2753					
2754				
2755Correct		Correct
2756
2757					
2758		2. 	Foreign keys must be null. True or False?	 Mark for Review 
2759(1) Points
2760					
2761			
2762	True
2763
2764			
2765	False (*)
2766
2767					
2768				
2769Incorrect		Incorrect. Refer to Section 9 Lesson 1.
2770
2771					
2772		3. 	A foreign key always refers to a primary key in the same table. True or False?	 Mark for Review 
2773(1) Points
2774					
2775			
2776	True
2777
2778			
2779	False (*)
2780
2781					
2782				
2783Incorrect		Incorrect. Refer to Section 9 Lesson 1.
2784
2785					
2786		4. 	The explanation below is an example of which constraint type? 
2787If 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 
2788(1) Points
2789					
2790			
2791	User-defined integrity (*)
2792
2793			
2794	Column integrity
2795
2796			
2797	Referential integrity
2798
2799			
2800	Entity integrity
2801
2802					
2803				
2804Incorrect		Incorrect. Refer to Section 9 Lesson 1.
2805
2806					
2807		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 
2808(1) Points
2809					
2810			(Choose all correct answers)	
2811					
2812			
2813	Make all relationships mandatory
2814
2815			
2816	Make all relationships optional (*)
2817
2818			
2819	Create an additional check constraint to verify that one foreign key is populated and the others are not (*)
2820
2821			
2822	All the above
2823
2824					
2825				
2826Incorrect		Incorrect. Refer to Section 9 Lesson 4.
2827
2828					
2829Page 1 of 3	Next	Summary
2830 
2831Section 9 Quiz
2832	(Answer all questions in this section)
2833					
2834		6. 	Which of the following is a valid reason for considering a Subtype Implementation?	 Mark for Review 
2835(1) Points
2836					
2837			
2838	Most of the relationships are at the supertype level.
2839
2840			
2841	Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
2842
2843			
2844	The resulting table will reside in a single database and be used by just ONE user.
2845
2846			
2847	The common access paths for the supertypes are different.
2848
2849					
2850				
2851Incorrect		Incorrect. Refer to Section 9 Lesson 4.
2852
2853					
2854		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 
2855(1) Points
2856					
2857			
2858	True
2859
2860			
2861	False (*)
2862
2863					
2864				
2865Incorrect		Incorrect. Refer to Section 9 Lesson 4.
2866
2867					
2868		8. 	One-to-Many Optional to Mandatory becomes a _______________ on the Master table.	 Mark for Review 
2869(1) Points
2870					
2871			
2872	Primary Key
2873
2874			
2875	Unique Key
2876
2877			
2878	Mandatory Foreign Key
2879
2880			
2881	Optional Foreign Key (*)
2882
2883					
2884				
2885Incorrect		Incorrect. Refer to Section 9 Lesson 3.
2886
2887					
2888		9. 	To resolve a many to many relationship in a physical model you create a(n) ___________________?	 Mark for Review 
2889(1) Points
2890					
2891			
2892	Intersection entity
2893
2894			
2895	Unique key constraints
2896
2897			
2898	Intersection table (*)
2899
2900			
2901	Two tables with Foreign key constraints between them
2902
2903					
2904				
2905Correct		Correct
2906
2907					
2908		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 
2909(1) Points
2910					
2911			
2912	True
2913
2914			
2915	False (*)
2916
2917					
2918				
2919Incorrect		Incorrect. Refer to Section 9 Lesson 3.
2920
2921					
2922Previous	Page 2 of 3	Next	Summary
2923 
2924
2925	Section 9 Quiz
2926	(Answer all questions in this section)
2927					
2928		11. 	In a physical model, many to many relationships are resolved via a structure called a(n): ________________	 Mark for Review 
2929(1) Points
2930					
2931			
2932	Intersection Entity
2933
2934			
2935	Intersection Table (*)
2936
2937			
2938	Subtype
2939
2940			
2941	Supertype
2942
2943					
2944				
2945Incorrect		Incorrect. Refer to Section 9 Lesson 3.
2946
2947					
2948		12. 	In an Oracle database, why would 1_TABLE not work as a table name?	 Mark for Review 
2949(1) Points
2950					
2951			
2952	The database does not understand all capital letters.
2953
2954			
2955	There is no problem here. You can create a table called 1_TABLE.
2956
2957			
2958	Object names must not start with a number. They must begin with a letter. (*)
2959
2960			
2961	TABLE is a reserved word.
2962
2963					
2964				
2965Incorrect		Incorrect. Refer to Section 9 Lesson 2.
2966
2967					
2968		13. 	In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?	 Mark for Review 
2969(1) Points
2970					
2971			
2972	JOBS is a reserved word
2973
2974			
2975	The database does not understand all capital letters
2976
2977			
2978	You cannot have spaces between words in a table name (*)
2979
2980			
2981	EMPLOYEE is a reserved word
2982
2983					
2984				
2985Correct		Correct
2986
2987					
2988		14. 	In a physical data model, an entity becomes a _____________.	 Mark for Review 
2989(1) Points
2990					
2991			
2992	Attribute
2993
2994			
2995	Table (*)
2996
2997			
2998	Column
2999
3000			
3001	Constraint
3002
3003					
3004				
3005Incorrect		Incorrect. Refer to Section 9 Lesson 2.
3006
3007					
3008		15. 	Why would this table name NOT work in an Oracle database? this_year_end+next_year	 Mark for Review 
3009(1) Points
3010					
3011			
3012	Table names must begin with an alphabetic character.
3013
3014			
3015	It is too long.
3016
3017			
3018	The Plus sign + is not allowed in object names. (*)
3019
3020			
3021	None of the above.
3022
3023					
3024				
3025Incorrect		Incorrect. Refer to Section 9 Lesson 2.
3026
3027					
3028Previous	Page 3 of 3	Summary
3029 
3030
3031
3032	Section 9 Quiz
3033	(Answer all questions in this section)
3034					
3035		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 
3036(1) Points
3037					
3038			(Choose all correct answers)	
3039					
3040			
3041	Make all relationships mandatory
3042
3043			
3044	Make all relationships optional (*)
3045
3046			
3047	Create an additional check constraint to verify that one foreign key is populated and the others are not (*)
3048
3049			
3050	All the above
3051
3052					
3053				
3054Correct		Correct
3055
3056					
3057		2. 	The "Arc Implementation" is a synonym for what type of implementation?	 Mark for Review 
3058(1) Points
3059					
3060			
3061	Subtype Implementation
3062
3063			
3064	Cascade Implementation
3065
3066			
3067	Supertype and Subtype Implementation (*)
3068
3069			
3070	Supertype Implementation
3071
3072					
3073				
3074Correct		Correct
3075
3076					
3077		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 
3078(1) Points
3079					
3080			
3081	True
3082
3083			
3084	False (*)
3085
3086					
3087				
3088Correct		Correct
3089
3090					
3091		4. 	To resolve a many to many relationship in a physical model you create a(n) ___________________?	 Mark for Review 
3092(1) Points
3093					
3094			
3095	Intersection entity
3096
3097			
3098	Two tables with Foreign key constraints between them
3099
3100			
3101	Unique key constraints
3102
3103			
3104	Intersection table (*)
3105
3106					
3107				
3108Correct		Correct
3109
3110					
3111		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 
3112(1) Points
3113					
3114			
3115	The table B (*)
3116
3117			
3118	Nowhere, One-to-One relationships are not transformed.
3119
3120			
3121	The table A
3122
3123			
3124	Both tables A and B get a new column and a Foreign Key.
3125
3126					
3127				
3128Correct		Correct
3129
3130					
3131Page 1 of 3	Next	Summary
3132 
3133	Section 9 Quiz
3134	(Answer all questions in this section)
3135					
3136		6. 	One-to-Many Optional to Mandatory becomes a _______________ on the Master table.	 Mark for Review 
3137(1) Points
3138					
3139			
3140	Unique Key
3141
3142			
3143	Mandatory Foreign Key
3144
3145			
3146	Optional Foreign Key (*)
3147
3148			
3149	Primary Key
3150
3151					
3152				
3153Correct		Correct
3154
3155					
3156		7. 	Why would this table name NOT work in an Oracle database? this_year_end+next_year	 Mark for Review 
3157(1) Points
3158					
3159			
3160	True
3161
3162			
3163	False (*)
3164
3165					
3166				
3167Correct		Correct
3168
3169					
3170		8. 	The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?	 Mark for Review 
3171(1) Points
3172					
3173			
3174	True (*)
3175
3176			
3177	False
3178
3179					
3180				
3181Correct		Correct
3182
3183					
3184		9. 	Why would this table name NOT work in an Oracle database? this_year_end+next_year	 Mark for Review 
3185(1) Points
3186					
3187			
3188	Table names must begin with an alphabetic character.
3189
3190			
3191	It is too long.
3192
3193			
3194	The Plus sign + is not allowed in object names. (*)
3195
3196			
3197	None of the above.
3198
3199					
3200				
3201Correct		Correct
3202
3203					
3204		10. 	Attributes become columns in a database table. True or False?	 Mark for Review 
3205(1) Points
3206					
3207			
3208	True (*)
3209
3210			
3211	False
3212
3213					
3214				
3215Correct		Correct
3216
3217					
3218Previous	Page 2 of 3	Next	Summary
3219 
3220	Section 9 Quiz
3221	(Answer all questions in this section)
3222					
3223		6. 	One-to-Many Optional to Mandatory becomes a _______________ on the Master table.	 Mark for Review 
3224(1) Points
3225					
3226			
3227	Unique Key
3228
3229			
3230	Mandatory Foreign Key
3231
3232			
3233	Optional Foreign Key (*)
3234
3235			
3236	Primary Key
3237
3238					
3239				
3240Correct		Correct
3241
3242					
3243		7. 	Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?	 Mark for Review 
3244(1) Points
3245					
3246			
3247	True
3248
3249			
3250	False (*)
3251
3252					
3253				
3254Correct		Correct
3255
3256					
3257		8. 	The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?	 Mark for Review 
3258(1) Points
3259					
3260			
3261	True (*)
3262
3263			
3264	False
3265
3266					
3267				
3268Correct		Correct
3269
3270					
3271		9. 	Why would this table name NOT work in an Oracle database? this_year_end+next_year	 Mark for Review 
3272(1) Points
3273					
3274			
3275	Table names must begin with an alphabetic character.
3276
3277			
3278	It is too long.
3279
3280			
3281	The Plus sign + is not allowed in object names. (*)
3282
3283			
3284	None of the above.
3285
3286					
3287				
3288Correct		Correct
3289
3290					
3291		10. 	Attributes become columns in a database table. True or False?	 Mark for Review 
3292(1) Points
3293					
3294			
3295	True (*)
3296
3297			
3298	False
3299
3300					
3301				
3302Correct		Correct
3303
3304					
3305Previous	Page 2 of 3	Next	Summary
3306 
3307	Section 9 Quiz
3308	(Answer all questions in this section)
3309					
3310		6. 	One-to-Many Optional to Mandatory becomes a _______________ on the Master table.	 Mark for Review 
3311(1) Points
3312					
3313			
3314	Unique Key
3315
3316			
3317	Mandatory Foreign Key
3318
3319			
3320	Optional Foreign Key (*)
3321
3322			
3323	Primary Key
3324
3325					
3326				
3327Correct		Correct
3328
3329					
3330		7. 	Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?	 Mark for Review 
3331(1) Points
3332					
3333			
3334	True
3335
3336			
3337	False (*)
3338
3339					
3340				
3341Correct		Correct
3342
3343					
3344		8. 	The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?	 Mark for Review 
3345(1) Points
3346					
3347			
3348	True (*)
3349
3350			
3351	False
3352
3353					
3354				
3355Correct		Correct
3356
3357					
3358		9. 	Why would this table name NOT work in an Oracle database? this_year_end+next_year	 Mark for Review 
3359(1) Points
3360					
3361			
3362	Table names must begin with an alphabetic character.
3363
3364			
3365	It is too long.
3366
3367			
3368	The Plus sign + is not allowed in object names. (*)
3369
3370			
3371	None of the above.
3372
3373					
3374				
3375Correct		Correct
3376
3377					
3378		10. 	Attributes become columns in a database table. True or False?	 Mark for Review 
3379(1) Points
3380					
3381			
3382	True (*)
3383
3384			
3385	False
3386
3387					
3388				
3389Correct		Correct
3390
3391					
3392Previous	Page 2 of 3	Next	Summary
3393 
3394	Section 9 Quiz
3395	(Answer all questions in this section)
3396					
3397		6. 	One-to-Many Optional to Mandatory becomes a _______________ on the Master table.	 Mark for Review 
3398(1) Points
3399					
3400			
3401	Unique Key
3402
3403			
3404	Mandatory Foreign Key
3405
3406			
3407	Optional Foreign Key (*)
3408
3409			
3410	Primary Key
3411
3412					
3413				
3414Correct		Correct
3415
3416					
3417		7. 	Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?	 Mark for Review 
3418(1) Points
3419					
3420			
3421	True
3422
3423			
3424	False (*)
3425
3426					
3427				
3428Correct		Correct
3429
3430					
3431		8. 	The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?	 Mark for Review 
3432(1) Points
3433					
3434			
3435	True (*)
3436
3437			
3438	False
3439
3440					
3441				
3442Correct		Correct
3443
3444					
3445		9. 	Why would this table name NOT work in an Oracle database? this_year_end+next_year	 Mark for Review 
3446(1) Points
3447					
3448			
3449	Table names must begin with an alphabetic character.
3450
3451			
3452	It is too long.
3453
3454			
3455	The Plus sign + is not allowed in object names. (*)
3456
3457			
3458	None of the above.
3459
3460					
3461				
3462Correct		Correct
3463
3464					
3465		10. 	Attributes become columns in a database table. True or False?	 Mark for Review 
3466(1) Points
3467					
3468			
3469	True (*)
3470
3471			
3472	False
3473
3474					
3475				
3476Correct		Correct
3477
3478					
3479Previous	Page 2 of 3	Next	Summary
3480 
3481
3482Test: Section 9 Quiz
3483Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
3484
3485	Section 9 Quiz
3486	(Answer all questions in this section)
3487					
3488		11. 	In an Oracle database, why would 1_TABLE not work as a table name?	 Mark for Review 
3489(1) Points
3490					
3491			
3492	Object names must not start with a number. They must begin with a letter. (*)
3493
3494			
3495	TABLE is a reserved word.
3496
3497			
3498	There is no problem here. You can create a table called 1_TABLE.
3499
3500			
3501	The database does not understand all capital letters.
3502
3503					
3504				
3505Correct		Correct
3506
3507					
3508		12. 	A table must have a primary key. True or False?	 Mark for Review 
3509(1) Points
3510					
3511			
3512	True
3513
3514			
3515	False (*)
3516
3517					
3518				
3519Incorrect		Incorrect. Refer to Section 9 Lesson 1.
3520
3521					
3522		13. 	A foreign key cannot refer to a primary key in the same table. True or False?	 Mark for Review 
3523(1) Points
3524					
3525			
3526	True
3527
3528			
3529	False (*)
3530
3531					
3532				
3533Correct		Correct
3534
3535					
3536		14. 	The explanation below is an example of which constraint type? 
3537The 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 
3538(1) Points
3539					
3540			
3541	Referential integrity (*)
3542
3543			
3544	Column integrity
3545
3546			
3547	User-defined integrity
3548
3549			
3550	Entity integrity
3551
3552					
3553				
3554Incorrect		Incorrect. Refer to Section 9 Lesson 1.
3555
3556					
3557		15. 	Column integrity refers to	 Mark for Review 
3558(1) Points
3559					
3560			
3561	Columns always containing text data less than 255 characters
3562
3563			
3564	Columns always containing values consistent with the defined data format (*)
3565
3566			
3567	Columns always containing positive numbers
3568
3569			
3570	Columns always having values
3571
3572					
3573				
3574Correct		Correct
35751. 	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 
3576(1) Points
3577					
3578			
3579	True
3580	
3581			
3582	False (*)
3583	
3584					
3585				
3586[Correct] 		Correct
3587	
3588					
3589		2. 	When you add the concept of time to your data model, your model becomes more complex. True or False? 	Mark for Review 
3590(1) Points
3591					
3592			
3593	True (*)
3594	
3595			
3596	False
3597	
3598					
3599				
3600[Correct] 		Correct
3601	
3602					
3603		3. 	When a relationship may or may not be transferable, depending on time, this is know as a/an: 	Mark for Review 
3604(1) Points
3605					
3606			
3607	Non-transferable Relationship.
3608	
3609			
3610	Conditional Non-transferable Relationship. (*)
3611	
3612			
3613	Arc.
3614	
3615			
3616	Transferable Relationship
3617	
3618					
3619				
3620[Correct] 		Correct
3621	
3622					
3623		4. 	There are no circumstances where you would create a DAY entity. True or False? 	Mark for Review 
3624(1) Points
3625					
3626			
3627	True
3628	
3629			
3630	False (*)
3631	
3632					
3633				
3634[Correct] 		Correct
3635	
3636					
3637		5. 	Conditional non-transferability refers to a relationship that may or may not be transferable, depending on time. True or False? 	Mark for Review 
3638(1) Points
3639					
3640			
3641	True (*)
3642	
3643			
3644	False
3645	
3646					
3647				
3648[Correct] 		Correct 
36496. 	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 
3650(1) Points
3651					
3652			
3653	True
3654	
3655			
3656	False (*)
3657	
3658					
3659				
3660[Correct] 		Correct
3661	
3662					
3663		7. 	Modeling historical data can produce a unique identifier that includes a date. True or False? 	Mark for Review 
3664(1) Points
3665					
3666			
3667	True (*)
3668	
3669			
3670	False
3671	
3672					
3673				
3674[Correct] 		Correct
3675	
3676					
3677		8. 	Which of the following scenarios should be modeled so that historical data is kept? (Choose two) 	Mark for Review 
3678(1) Points
3679					
3680			(Choose all correct answers) 	
3681					
3682			
3683	TEACHER and AGE
3684	
3685			
3686	CUSTOMER and PAYMENTS (*)
3687	
3688			
3689	BABY and AGE
3690	
3691			
3692	CUSTOMER and ORDERS (*)
3693	
3694					
3695				
3696[Correct] 		Correct
3697	
3698					
3699		9. 	Which of the following statements are true for ERD's to enhance their readability. (Choose Two) 	Mark for Review 
3700(1) Points
3701					
3702			(Choose all correct answers) 	
3703					
3704			
3705	The crows feet (many ends) can point whichever way is the easiest to draw.
3706	
3707			
3708	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. (*)
3709	
3710			
3711	Avoid crossing one relationship line with another. (*)
3712	
3713			
3714	You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram.
3715	
3716					
3717				
3718[Incorrect] 		Incorrect. Refer to Section 8 Lesson 4.
3719	
3720					
3721		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 
3722(1) Points
3723					
3724			
3725	True (*)
3726	
3727			
3728	False
3729	
3730					
3731				
3732[Correct] 		Correct 
37336. 	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 
3734(1) Points
3735					
3736			
3737	True
3738	
3739			
3740	False (*)
3741	
3742					
3743				
3744[Correct] 		Correct
3745	
3746					
3747		7. 	Modeling historical data can produce a unique identifier that includes a date. True or False? 	Mark for Review 
3748(1) Points
3749					
3750			
3751	True (*)
3752	
3753			
3754	False
3755	
3756					
3757				
3758[Correct] 		Correct
3759	
3760					
3761		8. 	Which of the following scenarios should be modeled so that historical data is kept? (Choose two) 	Mark for Review 
3762(1) Points
3763					
3764			(Choose all correct answers) 	
3765					
3766			
3767	TEACHER and AGE
3768	
3769			
3770	CUSTOMER and PAYMENTS (*)
3771	
3772			
3773	BABY and AGE
3774	
3775			
3776	CUSTOMER and ORDERS (*)
3777	
3778					
3779				
3780[Correct] 		Correct
3781	
3782					
3783		9. 	Which of the following statements are true for ERD's to enhance their readability. (Choose Two) 	Mark for Review 
3784(1) Points
3785					
3786			(Choose all correct answers) 	
3787					
3788			
3789	The crows feet (many ends) can point whichever way is the easiest to draw.
3790	
3791			
3792	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. (*)
3793	
3794			
3795	Avoid crossing one relationship line with another. (*)
3796	
3797			
3798	You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram.
3799	
3800					
3801				
3802[Incorrect] 		Incorrect. Refer to Section 8 Lesson 4.
3803	
3804					
3805		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 
3806(1) Points
3807					
3808			
3809	True (*)
3810	
3811			
3812	False
3813	
3814					
3815				
3816[Correct] 		Correct 
3817  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
3818(1) Points
3819     
3820   
3821 True (*)
3822
3823   
3824 False
3825
3826     
3827    
3828Correct  Correct
3829
3830     
3831  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
3832(1) Points
3833     
3834   
3835 True (*)
3836
3837   
3838 False
3839
3840     
3841    
3842Correct  Correct
3843
3844     
3845  3.  Modeling historical data is optional. True or False? Mark for Review
3846(1) Points
3847     
3848   
3849 True (*)
3850
3851   
3852 False
3853
3854     
3855    
3856Incorrect  Incorrect. Refer to Section 8 Lesson 2.
3857
3858     
3859  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
3860(1) Points
3861     
3862   
3863 True
3864
3865   
3866 False (*)
3867
3868     
3869    
3870Incorrect  Incorrect. Refer to Section 8 Lesson 2.
3871
3872     
3873  5.  How do you know when to use the different types of time in your design? Mark for Review
3874(1) Points
3875     
3876   
3877 It depends on the functional needs of the system . (*)
3878
3879   
3880 Always model time; you can take it out later if it is not needed.
3881
3882   
3883 You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
3884
3885   
3886 The rules are fixed and should be followed.
3887
3888     
3889    
3890Correct  Correct
3891
3892     
3893Page 1 of 3 Next Summary
3894
3895
3896Test: Section 8 Quiz
3897Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
3898
3899 Section 8 Quiz
3900 (Answer all questions in this section)
3901     
3902  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
3903(1) Points
3904     
3905   
3906 True
3907
3908   
3909 False (*)
3910
3911     
3912    
3913Incorrect  Incorrect. Refer to Section 8 Lesson 4.
3914
3915     
3916  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
3917(1) Points
3918     
3919   
3920 True (*)
3921
3922   
3923 False
3924
3925     
3926    
3927Correct  Correct
3928
3929     
3930  8.  In an ERD, High Volume Entities usually have very few relationships to other entities. True or False? Mark for Review
3931(1) Points
3932     
3933   
3934 True
3935
3936   
3937 False (*)
3938
3939     
3940    
3941Incorrect  Incorrect. Refer to Section 8 Lesson 4.
3942
3943     
3944  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
3945(1) Points
3946     
3947   
3948 True
3949
3950   
3951 False (*)
3952
3953     
3954    
3955Incorrect  Incorrect. Refer to Section 8 Lesson 4.
3956
3957     
3958  10.  Which of the following scenarios should be modeled so that historical data is kept? (Choose two) Mark for Review
3959(1) Points
3960     
3961   (Choose all correct answers) 
3962     
3963   
3964 TEACHER and AGE
3965
3966   
3967 CUSTOMER and ORDERS (*)
3968
3969   
3970 CUSTOMER and PAYMENTS (*)
3971
3972   
3973 BABY and AGE
3974
3975     
3976    
3977Incorrect  Incorrect. Refer to Section 8 Lesson 1.
3978
3979     
3980Previous Page 2 of 3 Next Summary
3981
3982
3983Test: Section 8 Quiz
3984Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
3985
3986 Section 8 Quiz
3987 (Answer all questions in this section)
3988     
3989  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
3990(1) Points
3991     
3992   
3993 True
3994
3995   
3996 False (*)
3997
3998     
3999    
4000Incorrect  Incorrect. Refer to Section 8 Lesson 1.
4001
4002     
4003  12.  Historical data must never be kept. True or False? Mark for Review
4004(1) Points
4005     
4006   
4007 True
4008
4009   
4010 False (*)
4011
4012     
4013    
4014Incorrect  Incorrect. Refer to Section 8 Lesson 1.
4015
4016     
4017  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
4018(1) Points
4019     
4020   
4021 Email current prices to all employees whenever a price changes.
4022
4023   
4024 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. (*)
4025
4026   
4027 Allow them to enter whatever delivery charge they want.
4028
4029   
4030 Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.
4031
4032     
4033    
4034Incorrect  Incorrect. Refer to Section 8 Lesson 3.
4035
4036     
4037  14.  What is the function of logging or journaling in conceptual data models? Mark for Review
4038(1) Points
4039     
4040   
4041 Creates a fixed time for all events in a data model.
4042
4043   
4044 Gives a timestamp to all entities.
4045
4046   
4047 Allows you to track the history of attribute values, relationships, and/or entire entities (*)
4048
4049   
4050 Represents entities as time in the data model.
4051
4052     
4053    
4054Incorrect  Incorrect. Refer to Section 8 Lesson 3.
4055
4056     
4057  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
4058(1) Points
4059     
4060   
4061 True (*)
4062
4063   
4064 False
4065
4066     
4067    
4068Correct  Correct
4069
4070     
4071Previous Page 3 of 3 Summary
4072
4073
4074Test: Section 8 Quiz
4075Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4076
4077 Section 8 Quiz
4078 (Answer all questions in this section)
4079     
4080  1.  What is the function of logging or journaling in conceptual data models? Mark for Review
4081(1) Points
4082     
4083   
4084 Gives a timestamp to all entities.
4085
4086   
4087 Creates a fixed time for all events in a data model.
4088
4089   
4090 Represents entities as time in the data model.
4091
4092   
4093 Allows you to track the history of attribute values, relationships, and/or entire entities (*)
4094
4095     
4096    
4097Correct  Correct
4098
4099     
4100  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
4101(1) Points
4102     
4103   
4104 An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)
4105
4106   
4107 EMPLOYEE periods can overlap causing the database to crash.
4108
4109   
4110 End Date must be before the Start Date.
4111
4112   
4113 Dates must be stored with Time.
4114
4115     
4116    
4117Correct  Correct
4118
4119     
4120  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
4121(1) Points
4122     
4123   
4124 True (*)
4125
4126   
4127 False
4128
4129     
4130    
4131Correct  Correct
4132
4133     
4134  4.  When a relationship may or may not be transferable, depending on time, this is know as a/an: Mark for Review
4135(1) Points
4136     
4137   
4138 Arc.
4139
4140   
4141 Transferable Relationship
4142
4143   
4144 Conditional Non-transferable Relationship. (*)
4145
4146   
4147 Non-transferable Relationship.
4148
4149     
4150    
4151Incorrect  Incorrect. Refer to Section 8 Lesson 2.
4152
4153     
4154  5.  How do you know when to use the different types of time in your design? Mark for Review
4155(1) Points
4156     
4157   
4158 Always model time; you can take it out later if it is not needed.
4159
4160   
4161 It depends on the functional needs of the system . (*)
4162
4163   
4164 You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
4165
4166   
4167 The rules are fixed and should be followed.
4168
4169     
4170    
4171Correct  Correct
4172
4173     
4174Page 1 of 3 Next Summary
4175
4176
4177Test: Section 8 Quiz
4178Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4179
4180 Section 8 Quiz
4181 (Answer all questions in this section)
4182     
4183  6.  Conditional non-transferability refers to a relationship that may or may not be transferable, depending on time. True or False? Mark for Review
4184(1) Points
4185     
4186   
4187 True (*)
4188
4189   
4190 False
4191
4192     
4193    
4194Correct  Correct
4195
4196     
4197  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
4198(1) Points
4199     
4200   
4201 True (*)
4202
4203   
4204 False
4205
4206     
4207    
4208Correct  Correct
4209
4210     
4211  8.  Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review
4212(1) Points
4213     
4214   
4215 Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.
4216
4217   
4218 If you are doing a system for any French City, you would need security clearance.
4219
4220   
4221 Cites may change their names and/or country association if the borders of a country change. (*)
4222
4223   
4224 People are born in the city and people die in the city.
4225
4226     
4227    
4228Correct  Correct
4229
4230     
4231  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
4232(1) Points
4233     
4234   
4235 True
4236
4237   
4238 False (*)
4239
4240     
4241    
4242Correct  Correct
4243
4244     
4245  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
4246(1) Points
4247     
4248   
4249 True
4250
4251   
4252 False (*)
4253
4254     
4255    
4256Incorrect  Incorrect. Refer to Section 8 Lesson 4.
4257
4258     
4259Previous Page 2 of 3 Next Summary
4260
4261
4262Test: Section 8 Quiz
4263Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4264
4265 Section 8 Quiz
4266 (Answer all questions in this section)
4267     
4268  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
4269(1) Points
4270     
4271   
4272 True (*)
4273
4274   
4275 False
4276
4277     
4278    
4279Correct  Correct
4280
4281     
4282  12.  Which of the following statements are true to enhance the readability of ERDs? (Choose Two) Mark for Review
4283(1) Points
4284     
4285   (Choose all correct answers) 
4286     
4287   
4288 Relationship lines should not cross. (*)
4289
4290   
4291 Crossing relationship lines help the readability of the diagram.
4292
4293   
4294 It does not matter which way the crows feet (many ends of a relationship) point.
4295
4296   
4297 Crows feet (the many-ends of relationships) should consistently point the same direction where possible, either South & East or North & West (*)
4298
4299     
4300    
4301Incorrect  Incorrect. Refer to Section 8 Lesson 4.
4302
4303     
4304  13.  Historical data must never be kept. True or False? Mark for Review
4305(1) Points
4306     
4307   
4308 True
4309
4310   
4311 False (*)
4312
4313     
4314    
4315Correct  Correct
4316
4317     
4318  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
4319(1) Points
4320     
4321   
4322 True
4323
4324   
4325 False (*)
4326
4327     
4328    
4329Correct  Correct
4330
4331     
4332  15.  Which of the following scenarios should be modeled so that historical data is kept? (Choose two) Mark for Review
4333(1) Points
4334     
4335   (Choose all correct answers) 
4336     
4337   
4338 TEACHER and AGE
4339
4340   
4341 BABY and AGE
4342
4343   
4344 CUSTOMER and PAYMENTS (*)
4345
4346   
4347 CUSTOMER and ORDERS (*)
4348
4349     
4350    
4351Correct  Correct
4352
4353     
4354Previous Page 3 of 3 Summary
4355
4356
4357Test: Section 8 Quiz
4358Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4359
4360 Section 8 Quiz
4361 (Answer all questions in this section)
4362     
4363  1.  Modeling historical data can produce a unique identifier that includes a date. True or False? Mark for Review
4364(1) Points
4365     
4366   
4367 True (*)
4368
4369   
4370 False
4371
4372     
4373    
4374Correct  Correct
4375
4376     
4377  2.  Which of the following scenarios should be modeled so that historical data is kept? (Choose two) Mark for Review
4378(1) Points
4379     
4380   (Choose all correct answers) 
4381     
4382   
4383 LIBRARY and BOOK (*)
4384
4385   
4386 LIBRARY and NUMBER OF BOOKS
4387
4388   
4389 STUDENT and AGE
4390
4391   
4392 STUDENT and GRADE (*)
4393
4394     
4395    
4396Incorrect  Incorrect. Refer to Section 8 Lesson 1.
4397
4398     
4399  3.  Historical data must never be kept. True or False? Mark for Review
4400(1) Points
4401     
4402   
4403 True
4404
4405   
4406 False (*)
4407
4408     
4409    
4410Correct  Correct
4411
4412     
4413  4.  Which of the following statements are true to enhance the readability of ERDs? (Choose Two) Mark for Review
4414(1) Points
4415     
4416   (Choose all correct answers) 
4417     
4418   
4419 Crows feet (the many-ends of relationships) should consistently point the same direction where possible, either South & East or North & West (*)
4420
4421   
4422 Crossing relationship lines help the readability of the diagram.
4423
4424   
4425 It does not matter which way the crows feet (many ends of a relationship) point.
4426
4427   
4428 Relationship lines should not cross. (*)
4429
4430     
4431    
4432Correct  Correct
4433
4434     
4435  5.  In an ERD, High Volume Entities usually have very few relationships to other entities. True or False? Mark for Review
4436(1) Points
4437     
4438   
4439 True
4440
4441   
4442 False (*)
4443
4444     
4445    
4446Correct  Correct
4447
4448     
4449Page 1 of 3 Next Summary
4450
4451
4452Test: Section 8 Quiz
4453Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4454
4455 Section 8 Quiz
4456 (Answer all questions in this section)
4457     
4458  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
4459(1) Points
4460     
4461   
4462 True (*)
4463
4464   
4465 False
4466
4467     
4468    
4469Correct  Correct
4470
4471     
4472  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
4473(1) Points
4474     
4475   
4476 True (*)
4477
4478   
4479 False
4480
4481     
4482    
4483Correct  Correct
4484
4485     
4486  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
4487(1) Points
4488     
4489   
4490 True (*)
4491
4492   
4493 False
4494
4495     
4496    
4497Correct  Correct
4498
4499     
4500  9.  Why would you want to model a time component when designing a system that lets people buy bars of gold? Mark for Review
4501(1) Points
4502     
4503   
4504 Sales people must determine where the gold is coming from.
4505
4506   
4507 You would not want to model this; it is not important.
4508
4509   
4510 The price of gold fluctuates and, to determine the current price, you need to know the time of purchase. (*)
4511
4512   
4513 The Government of your country might want to be notified of this transaction.
4514
4515     
4516    
4517Incorrect  Incorrect. Refer to Section 8 Lesson 3.
4518
4519     
4520  10.  What is the function of logging or journaling in conceptual data models? Mark for Review
4521(1) Points
4522     
4523   
4524 Creates a fixed time for all events in a data model.
4525
4526   
4527 Allows you to track the history of attribute values, relationships, and/or entire entities (*)
4528
4529   
4530 Gives a timestamp to all entities.
4531
4532   
4533 Represents entities as time in the data model.
4534
4535     
4536    
4537Correct  Correct
4538
4539     
4540Previous Page 2 of 3 Next Summary
4541
4542
4543Test: Section 8 Quiz
4544Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4545
4546 Section 8 Quiz
4547 (Answer all questions in this section)
4548     
4549  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
4550(1) Points
4551     
4552   
4553 True
4554
4555   
4556 False (*)
4557
4558     
4559    
4560Correct  Correct
4561
4562     
4563  12.  When you add the concept of time to your data model, your model becomes more complex. True or False? Mark for Review
4564(1) Points
4565     
4566   
4567 True (*)
4568
4569   
4570 False
4571
4572     
4573    
4574Correct  Correct
4575
4576     
4577  13.  How do you know when to use the different types of time in your design? Mark for Review
4578(1) Points
4579     
4580   
4581 The rules are fixed and should be followed.
4582
4583   
4584 It depends on the functional needs of the system . (*)
4585
4586   
4587 You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
4588
4589   
4590 Always model time; you can take it out later if it is not needed.
4591
4592     
4593    
4594Correct  Correct
4595
4596     
4597  14.  Which of the following would be a logical constraint when modeling time for a country entity? Mark for Review
4598(1) Points
4599     
4600   
4601 People have births and deaths in their countries that must be tracked by the system.
4602
4603   
4604 Daily traffic patterns must be monitored to determine which countries are overcrowded.
4605
4606   
4607 If you are doing a system for France or Germany, you would need security clearance.
4608
4609   
4610 Countries may change their names and/or borders over a period of time. (*)
4611
4612     
4613    
4614Correct  Correct
4615
4616     
4617  15.  When a relationship may or may not be transferable, depending on time, this is know as a/an: Mark for Review
4618(1) Points
4619     
4620   
4621 Conditional Non-transferable Relationship. (*)
4622
4623   
4624 Arc.
4625
4626   
4627 Transferable Relationship
4628
4629   
4630 Non-transferable Relationship.
4631
4632     
4633    
4634Correct  Correct
4635Section 9 Quiz
4636 (Answer all questions in this section)
4637     
4638  1.  The explanation below is an example of which constraint type?
4639A column must contain only values consistent with the defined data format of the column Mark for Review
4640(1) Points
4641     
4642   
4643 Entity integrity
4644
4645   
4646 Column integrity (*)
4647
4648   
4649 Referential integrity
4650
4651   
4652 User-defined integrity
4653
4654     
4655    
4656Correct  Correct
4657
4658     
4659  2.  Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three) Mark for Review
4660(1) Points
4661     
4662   (Choose all correct answers) 
4663     
4664   
4665 One or more columns in a table that uniquely identifies each row in that table.
4666
4667   
4668 Only one column that must be null. (*)
4669
4670   
4671 A single column that uniquely identifies each column in a table. (*)
4672
4673   
4674 A set of columns in one table that uniquely identifies each row in another table. (*)
4675
4676     
4677    
4678Incorrect  Incorrect. Refer to Section 9 Lesson 1.
4679
4680     
4681  3.  A table does not have to have a primary key. True or False? Mark for Review
4682(1) Points
4683     
4684   
4685 True (*)
4686
4687   
4688 False
4689
4690     
4691    
4692Correct  Correct
4693
4694     
4695  4.  A foreign key always refers to a primary key in the same table. True or False? Mark for Review
4696(1) Points
4697     
4698   
4699 True
4700
4701   
4702 False (*)
4703
4704     
4705    
4706Correct  Correct
4707
4708     
4709  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
4710(1) Points
4711     
4712   (Choose all correct answers) 
4713     
4714   
4715 Make all relationships mandatory
4716
4717   
4718 Make all relationships optional (*)
4719
4720   
4721 Create an additional check constraint to verify that one foreign key is populated and the others are not (*)
4722
4723   
4724 All the above
4725
4726     
4727    
4728Correct  Correct
4729
4730     
4731Page 1 of 3 Next Summary
4732
4733
4734Test: Section 9 Quiz
4735Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4736
4737 Section 9 Quiz
4738 (Answer all questions in this section)
4739     
4740  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
4741(1) Points
4742     
4743   
4744 True (*)
4745
4746   
4747 False
4748
4749     
4750    
4751Correct  Correct
4752
4753     
4754  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
4755(1) Points
4756     
4757   
4758 True
4759
4760   
4761 False (*)
4762
4763     
4764    
4765Incorrect  Incorrect. Refer to Section 9 Lesson 4.
4766
4767     
4768  8.  In a physical model, many to many relationships are resolved via a structure called a(n): ________________ Mark for Review
4769(1) Points
4770     
4771   
4772 Intersection Table
4773
4774   
4775 Subtype
4776
4777   
4778 Intersection Entity (*)
4779
4780   
4781 Supertype
4782
4783     
4784    
4785Incorrect  Incorrect. Refer to Section 9 Lesson 3.
4786
4787     
4788  9.  One-to-Many Optional to Mandatory becomes a _______________ on the Master table. Mark for Review
4789(1) Points
4790     
4791   
4792 Unique Key
4793
4794   
4795 Optional Foreign Key (*)
4796
4797   
4798 Mandatory Foreign Key
4799
4800   
4801 Primary Key
4802
4803     
4804    
4805Incorrect  Incorrect. Refer to Section 9 Lesson 3.
4806
4807     
4808  10.  It is possible to implement non-transferability via a simple Foreign Key Relationship. True or False? Mark for Review
4809(1) Points
4810     
4811   
4812 True
4813
4814   
4815 False (*)
4816
4817     
4818    
4819Incorrect  Incorrect. Refer to Section 9 Lesson 3.
4820
4821     
4822Previous Page 2 of 3 Next Summary
4823
4824
4825Test: Section 9 Quiz
4826Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4827
4828 Section 9 Quiz
4829 (Answer all questions in this section)
4830     
4831  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
4832(1) Points
4833     
4834   
4835 True (*)
4836
4837   
4838 False
4839
4840     
4841    
4842Correct  Correct
4843
4844     
4845  12.  The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review
4846(1) Points
4847     
4848   
4849 True (*)
4850
4851   
4852 False
4853
4854     
4855    
4856Correct  Correct
4857
4858     
4859  13.  The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ : Mark for Review
4860(1) Points
4861     
4862   
4863 Columns
4864
4865   
4866 Tables (*)
4867
4868   
4869 Unique Keys
4870
4871   
4872 Foreign Keys
4873
4874     
4875    
4876Incorrect  Incorrect. Refer to Section 9 Lesson 2.
4877
4878     
4879  14.  In a physical data model, an attribute becomes a _____________. Mark for Review
4880(1) Points
4881     
4882   
4883 Foreign Key
4884
4885   
4886 Constraint
4887
4888   
4889 Column (*)
4890
4891   
4892 Table
4893
4894     
4895    
4896Incorrect  Incorrect. Refer to Section 9 Lesson 2.
4897
4898     
4899  15.  In a physical data model, a relationship is represented as a: Mark for Review
4900(1) Points
4901     
4902   
4903 Column
4904
4905   
4906 Foreign Key (*)
4907
4908   
4909 Unique Identifier
4910
4911   
4912 Primary Key
4913
4914     
4915    
4916Incorrect  Incorrect. Refer to Section 9 Lesson 2.
4917
4918     
4919Previous Page 3 of 3 Summary
4920
4921
4922Test: Section 9 Quiz
4923Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
4924
4925 Section 9 Quiz
4926 (Answer all questions in this section)
4927     
4928  1.  A table does not have to have a primary key. True or False? Mark for Review
4929(1) Points
4930     
4931   
4932 True (*)
4933
4934   
4935 False
4936
4937     
4938    
4939Correct  Correct
4940
4941     
4942  2.  Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three) Mark for Review
4943(1) Points
4944     
4945   (Choose all correct answers) 
4946     
4947   
4948 A set of columns that uniquely identifies each row in a table (*)
4949
4950   
4951 A single column that uniquely identifies each row in a table (*)
4952
4953   
4954 A set of columns and keys in a single table that uniquely identifies each row in a single table (*)
4955
4956   
4957 Only one column that cannot be null
4958
4959     
4960    
4961Correct  Correct
4962
4963     
4964  3.  The explanation below is an example of which constraint type?
4965If 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
4966(1) Points
4967     
4968   
4969 User-defined integrity (*)
4970
4971   
4972 Entity integrity
4973
4974   
4975 Referential integrity
4976
4977   
4978 Column integrity
4979
4980     
4981    
4982Incorrect  Incorrect. Refer to Section 9 Lesson 1.
4983
4984     
4985  4.  The explanation below is an example of which constraint type?
4986A column must contain only values consistent with the defined data format of the column Mark for Review
4987(1) Points
4988     
4989   
4990 Entity integrity
4991
4992   
4993 Column integrity (*)
4994
4995   
4996 Referential integrity
4997
4998   
4999 User-defined integrity
5000
5001     
5002    
5003Correct  Correct
5004
5005     
5006  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
5007(1) Points
5008     
5009   
5010 True
5011
5012   
5013 False (*)
5014
5015     
5016    
5017Correct  Correct
5018
5019     
5020Page 1 of 3 Next Summary
5021
5022
5023Test: Section 9 Quiz
5024Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5025
5026 Section 9 Quiz
5027 (Answer all questions in this section)
5028     
5029  6.  To resolve a many to many relationship in a physical model you create a(n) ___________________? Mark for Review
5030(1) Points
5031     
5032   
5033 Two tables with Foreign key constraints between them
5034
5035   
5036 Unique key constraints
5037
5038   
5039 Intersection entity
5040
5041   
5042 Intersection table (*)
5043
5044     
5045    
5046Incorrect  Incorrect. Refer to Section 9 Lesson 3.
5047
5048     
5049  7.  It is possible to implement non-transferability via a simple Foreign Key Relationship. True or False? Mark for Review
5050(1) Points
5051     
5052   
5053 True
5054
5055   
5056 False (*)
5057
5058     
5059    
5060Correct  Correct
5061
5062     
5063  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
5064(1) Points
5065     
5066   
5067 True
5068
5069   
5070 False (*)
5071
5072     
5073    
5074Incorrect  Incorrect. Refer to Section 9 Lesson 3.
5075
5076     
5077  9.  Why would this table name NOT work in an Oracle database? this_year_end+next_year Mark for Review
5078(1) Points
5079     
5080   
5081 Table names must begin with an alphabetic character.
5082
5083   
5084 It is too long.
5085
5086   
5087 The Plus sign + is not allowed in object names. (*)
5088
5089   
5090 None of the above.
5091
5092     
5093    
5094Incorrect  Incorrect. Refer to Section 9 Lesson 2.
5095
5096     
5097  10.  In a physical data model, a relationship is represented as a combination of: (Choose Two) Mark for Review
5098(1) Points
5099     
5100   (Choose all correct answers) 
5101     
5102   
5103 Column
5104
5105   
5106 Check Constraint or Unique Key
5107
5108   
5109 Primary Key or Unique Key (*)
5110
5111   
5112 Foreign Key (*)
5113
5114     
5115    
5116Incorrect  Incorrect. Refer to Section 9 Lesson 2.
5117
5118     
5119Previous Page 2 of 3 Next Summary
5120
5121
5122Test: Section 9 Quiz
5123Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5124
5125 Section 9 Quiz
5126 (Answer all questions in this section)
5127     
5128  11.  The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review
5129(1) Points
5130     
5131   
5132 True (*)
5133
5134   
5135 False
5136
5137     
5138    
5139Correct  Correct
5140
5141     
5142  12.  In a physical data model, an attribute becomes a _____________. Mark for Review
5143(1) Points
5144     
5145   
5146 Constraint
5147
5148   
5149 Table
5150
5151   
5152 Column (*)
5153
5154   
5155 Foreign Key
5156
5157     
5158    
5159Correct  Correct
5160
5161     
5162  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
5163(1) Points
5164     
5165   
5166 True
5167
5168   
5169 False (*)
5170
5171     
5172    
5173Incorrect  Incorrect. Refer to Section 9 Lesson 4.
5174
5175     
5176  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
5177(1) Points
5178     
5179   
5180 True (*)
5181
5182   
5183 False
5184
5185     
5186    
5187Correct  Correct
5188
5189     
5190  15.  Which of the following is a valid reason for considering a Subtype Implementation? Mark for Review
5191(1) Points
5192     
5193   
5194 Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
5195
5196   
5197 The resulting table will reside in a single database and be used by just ONE user.
5198
5199   
5200 The common access paths for the supertypes are different.
5201
5202   
5203 Most of the relationships are at the supertype level.
5204
5205     
5206    
5207Incorrect  Incorrect. Refer to Section 9 Lesson 4.
5208
5209     
5210Previous Page 3 of 3 Summary
5211
5212
5213Test: Section 9 Quiz
5214Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5215
5216 Section 9 Quiz
5217 (Answer all questions in this section)
5218     
5219  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
5220(1) Points
5221     
5222   
5223 True
5224
5225   
5226 False (*)
5227
5228     
5229    
5230Correct  Correct
5231
5232     
5233  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
5234(1) Points
5235     
5236   
5237 True (*)
5238
5239   
5240 False
5241
5242     
5243    
5244Correct  Correct
5245
5246     
5247  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
5248(1) Points
5249     
5250   
5251 True
5252
5253   
5254 False (*)
5255
5256     
5257    
5258Correct  Correct
5259
5260     
5261  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
5262(1) Points
5263     
5264   
5265 True (*)
5266
5267   
5268 False
5269
5270     
5271    
5272Correct  Correct
5273
5274     
5275  5.  Relationships on an ERD can only be transformed into UIDs in the physical model? True or False? Mark for Review
5276(1) Points
5277     
5278   
5279 True
5280
5281   
5282 False (*)
5283
5284     
5285    
5286Incorrect  Incorrect. Refer to Section 9 Lesson 3.
5287
5288     
5289Page 1 of 3 Next Summary
5290
5291
5292Test: Section 9 Quiz
5293Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5294
5295 Section 9 Quiz
5296 (Answer all questions in this section)
5297     
5298  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
5299(1) Points
5300     
5301   
5302 True
5303
5304   
5305 False (*)
5306
5307     
5308    
5309Correct  Correct
5310
5311     
5312  7.  A barrred Relationship will result in a Foreign Key column that also is part of: Mark for Review
5313(1) Points
5314     
5315   
5316 The Primary Key (*)
5317
5318   
5319 The Check Constraint
5320
5321   
5322 The Column Name
5323
5324   
5325 The Table Name
5326
5327     
5328    
5329Correct  Correct
5330
5331     
5332  8.  The explanation below is an example of which constraint type?
5333If 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
5334(1) Points
5335     
5336   
5337 Referential integrity
5338
5339   
5340 User-defined integrity (*)
5341
5342   
5343 Entity integrity
5344
5345   
5346 Column integrity
5347
5348     
5349    
5350Correct  Correct
5351
5352     
5353  9.  The explanation below is an example of which constraint type?
5354A column must contain only values consistent with the defined data format of the column Mark for Review
5355(1) Points
5356     
5357   
5358 Entity integrity
5359
5360   
5361 Referential integrity
5362
5363   
5364 User-defined integrity
5365
5366   
5367 Column integrity (*)
5368
5369     
5370    
5371Correct  Correct
5372
5373     
5374  10.  The explanation below is an example of which constraint type?
5375A primary key must be unique, and no part of the primary key can be null. Mark for Review
5376(1) Points
5377     
5378   
5379 Entity integrity (*)
5380
5381   
5382 Column integrity
5383
5384   
5385 User-defined integrity
5386
5387   
5388 Referential integrity
5389
5390     
5391    
5392Incorrect  Incorrect. Refer to Section 9 Lesson 1.
5393
5394     
5395Previous Page 2 of 3 Next Summary
5396
5397
5398Test: Section 9 Quiz
5399Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5400
5401 Section 9 Quiz
5402 (Answer all questions in this section)
5403     
5404  11.  A foreign key always refers to a primary key in the same table. True or False? Mark for Review
5405(1) Points
5406     
5407   
5408 True
5409
5410   
5411 False (*)
5412
5413     
5414    
5415Correct  Correct
5416
5417     
5418  12.  The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review
5419(1) Points
5420     
5421   
5422 True (*)
5423
5424   
5425 False
5426
5427     
5428    
5429Correct  Correct
5430
5431     
5432  13.  In a physical data model, a relationship is represented as a combination of: (Choose Two) Mark for Review
5433(1) Points
5434     
5435   (Choose all correct answers) 
5436     
5437   
5438 Check Constraint or Unique Key
5439
5440   
5441 Foreign Key (*)
5442
5443   
5444 Column
5445
5446   
5447 Primary Key or Unique Key (*)
5448
5449     
5450    
5451Correct  Correct
5452
5453     
5454  14.  In a physical data model, an attribute becomes a _____________. Mark for Review
5455(1) Points
5456     
5457   
5458 Foreign Key
5459
5460   
5461 Constraint
5462
5463   
5464 Table
5465
5466   
5467 Column (*)
5468
5469     
5470    
5471Correct  Correct
5472
5473     
5474  15.  In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review
5475(1) Points
5476     
5477   
5478 There is no problem here. You can create a table called 1_TABLE.
5479
5480   
5481 TABLE is a reserved word.
5482
5483   
5484 The database does not understand all capital letters.
5485
5486   
5487 Object names must not start with a number. They must begin with a letter. (*)
5488
5489     
5490    
5491Incorrect  Incorrect. Refer to Section 9 Lesson 2.
5492
5493     
5494Previous Page 3 of 3 Summary
5495
5496
5497Test: Section 9 Quiz
5498Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5499
5500 Section 9 Quiz
5501 (Answer all questions in this section)
5502     
5503  1.  The explanation below is an example of which constraint type?
5504The 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
5505(1) Points
5506     
5507   
5508 Column integrity
5509
5510   
5511 User-defined integrity
5512
5513   
5514 Referential integrity (*)
5515
5516   
5517 Entity integrity
5518
5519     
5520    
5521Incorrect  Incorrect. Refer to Section 9 Lesson 1.
5522
5523     
5524  2.  The explanation below is an example of which constraint type?
5525If 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
5526(1) Points
5527     
5528   
5529 User-defined integrity (*)
5530
5531   
5532 Referential integrity
5533
5534   
5535 Column integrity
5536
5537   
5538 Entity integrity
5539
5540     
5541    
5542Correct  Correct
5543
5544     
5545  3.  Foreign keys must be null. True or False? Mark for Review
5546(1) Points
5547     
5548   
5549 True
5550
5551   
5552 False (*)
5553
5554     
5555    
5556Incorrect  Incorrect. Refer to Section 9 Lesson 1.
5557
5558     
5559  4.  Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three) Mark for Review
5560(1) Points
5561     
5562   (Choose all correct answers) 
5563     
5564   
5565 A set of columns and keys in a single table that uniquely identifies each row in a single table (*)
5566
5567   
5568 Only one column that cannot be null
5569
5570   
5571 A single column that uniquely identifies each row in a table (*)
5572
5573   
5574 A set of columns that uniquely identifies each row in a table (*)
5575
5576     
5577    
5578Correct  Correct
5579
5580     
5581  5.  One-to-Many Optional to Mandatory becomes a _______________ on the Master table. Mark for Review
5582(1) Points
5583     
5584   
5585 Primary Key
5586
5587   
5588 Optional Foreign Key (*)
5589
5590   
5591 Mandatory Foreign Key
5592
5593   
5594 Unique Key
5595
5596     
5597    
5598Correct  Correct
5599
5600     
5601Page 1 of 3 Next Summary
5602
5603
5604Test: Section 9 Quiz
5605Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5606
5607 Section 9 Quiz
5608 (Answer all questions in this section)
5609     
5610  6.  A barrred Relationship will result in a Foreign Key column that also is part of: Mark for Review
5611(1) Points
5612     
5613   
5614 The Column Name
5615
5616   
5617 The Table Name
5618
5619   
5620 The Primary Key (*)
5621
5622   
5623 The Check Constraint
5624
5625     
5626    
5627Correct  Correct
5628
5629     
5630  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
5631(1) Points
5632     
5633   
5634 The table B (*)
5635
5636   
5637 Both tables A and B get a new column and a Foreign Key.
5638
5639   
5640 Nowhere, One-to-One relationships are not transformed.
5641
5642   
5643 The table A
5644
5645     
5646    
5647Incorrect  Incorrect. Refer to Section 9 Lesson 3.
5648
5649     
5650  8.  To resolve a many to many relationship in a physical model you create a(n) ___________________? Mark for Review
5651(1) Points
5652     
5653   
5654 Intersection table (*)
5655
5656   
5657 Unique key constraints
5658
5659   
5660 Two tables with Foreign key constraints between them
5661
5662   
5663 Intersection entity
5664
5665     
5666    
5667Correct  Correct
5668
5669     
5670  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
5671(1) Points
5672     
5673   
5674 True
5675
5676   
5677 False (*)
5678
5679     
5680    
5681Correct  Correct
5682
5683     
5684  10.  The "Arc Implementation" is a synonym for what type of implementation? Mark for Review
5685(1) Points
5686     
5687   
5688 Subtype Implementation
5689
5690   
5691 Supertype and Subtype Implementation (*)
5692
5693   
5694 Supertype Implementation
5695
5696   
5697 Cascade Implementation
5698
5699     
5700    
5701Incorrect  Incorrect. Refer to Section 9 Lesson 4.
5702
5703     
5704Previous Page 2 of 3 Next Summary
5705
5706
5707Test: Section 9 Quiz
5708Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5709
5710 Section 9 Quiz
5711 (Answer all questions in this section)
5712     
5713  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
5714(1) Points
5715     
5716   
5717 True
5718
5719   
5720 False (*)
5721
5722     
5723    
5724Correct  Correct
5725
5726     
5727  12.  In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review
5728(1) Points
5729     
5730   
5731 TABLE is a reserved word.
5732
5733   
5734 There is no problem here. You can create a table called 1_TABLE.
5735
5736   
5737 Object names must not start with a number. They must begin with a letter. (*)
5738
5739   
5740 The database does not understand all capital letters.
5741
5742     
5743    
5744Correct  Correct
5745
5746     
5747  13.  In a physical data model, a relationship is represented as a: Mark for Review
5748(1) Points
5749     
5750   
5751 Foreign Key (*)
5752
5753   
5754 Unique Identifier
5755
5756   
5757 Primary Key
5758
5759   
5760 Column
5761
5762     
5763    
5764Correct  Correct
5765
5766     
5767  14.  In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'? Mark for Review
5768(1) Points
5769     
5770   
5771 EMPLOYEE is a reserved word
5772
5773   
5774 The database does not understand all capital letters
5775
5776   
5777 JOBS is a reserved word
5778
5779   
5780 You cannot have spaces between words in a table name (*)
5781
5782     
5783    
5784Incorrect  Incorrect. Refer to Section 9 Lesson 2.
5785
5786     
5787  15.  The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ : Mark for Review
5788(1) Points
5789     
5790   
5791 Foreign Keys
5792
5793   
5794 Tables (*)
5795
5796   
5797 Columns
5798
5799   
5800 Unique Keys
5801
5802     
5803    
5804Correct  Correct
5805
5806     
5807Previous Page 3 of 3 Summary
5808
5809
5810Test: Section 9 Quiz
5811Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5812
5813 Section 9 Quiz
5814 (Answer all questions in this section)
5815     
5816  1.  In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review
5817(1) Points
5818     
5819   
5820 TABLE is a reserved word.
5821
5822   
5823 Object names must not start with a number. They must begin with a letter. (*)
5824
5825   
5826 There is no problem here. You can create a table called 1_TABLE.
5827
5828   
5829 The database does not understand all capital letters.
5830
5831     
5832    
5833Correct  Correct
5834
5835     
5836  2.  In a physical data model, an entity becomes a _____________. Mark for Review
5837(1) Points
5838     
5839   
5840 Attribute
5841
5842   
5843 Table (*)
5844
5845   
5846 Column
5847
5848   
5849 Constraint
5850
5851     
5852    
5853Incorrect  Incorrect. Refer to Section 9 Lesson 2.
5854
5855     
5856  3.  The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? Mark for Review
5857(1) Points
5858     
5859   
5860 True (*)
5861
5862   
5863 False
5864
5865     
5866    
5867Correct  Correct
5868
5869     
5870  4.  In a physical data model, an attribute becomes a _____________. Mark for Review
5871(1) Points
5872     
5873   
5874 Constraint
5875
5876   
5877 Table
5878
5879   
5880 Column (*)
5881
5882   
5883 Foreign Key
5884
5885     
5886    
5887Correct  Correct
5888
5889     
5890  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
5891(1) Points
5892     
5893   
5894 True
5895
5896   
5897 False (*)
5898
5899     
5900    
5901Correct  Correct
5902
5903     
5904Page 1 of 3 Next Summary
5905
5906
5907Test: Section 9 Quiz
5908Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
5909
5910 Section 9 Quiz
5911 (Answer all questions in this section)
5912     
5913  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
5914(1) Points
5915     
5916   (Choose all correct answers) 
5917     
5918   
5919 Make all relationships mandatory
5920
5921   
5922 Make all relationships optional (*)
5923
5924   
5925 Create an additional check constraint to verify that one foreign key is populated and the others are not (*)
5926
5927   
5928 All the above
5929
5930     
5931    
5932Correct  Correct
5933
5934     
5935  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
5936(1) Points
5937     
5938   
5939 True (*)
5940
5941   
5942 False
5943
5944     
5945    
5946Correct  Correct
5947
5948     
5949  8.  A barrred Relationship will result in a Foreign Key column that also is part of: Mark for Review
5950(1) Points
5951     
5952   
5953 The Primary Key (*)
5954
5955   
5956 The Check Constraint
5957
5958   
5959 The Table Name
5960
5961   
5962 The Column Name
5963
5964     
5965    
5966Correct  Correct
5967
5968     
5969  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
5970(1) Points
5971     
5972   
5973 True
5974
5975   
5976 False (*)
5977
5978     
5979    
5980Correct  Correct
5981
5982     
5983  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
5984(1) Points
5985     
5986   
5987 True
5988
5989   
5990 False (*)
5991
5992     
5993    
5994Correct  Correct
5995
5996     
5997Previous Page 2 of 3 Next Summary
5998
5999
6000Test: Section 9 Quiz
6001Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
6002
6003 Section 9 Quiz
6004 (Answer all questions in this section)
6005     
6006  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
6007(1) Points
6008     
6009   
6010 Nowhere, One-to-One relationships are not transformed.
6011
6012   
6013 The table B (*)
6014
6015   
6016 Both tables A and B get a new column and a Foreign Key.
6017
6018   
6019 The table A
6020
6021     
6022    
6023Correct  Correct
6024
6025     
6026  12.  Foreign keys cannot be null when Mark for Review
6027(1) Points
6028     
6029   
6030 It refers to the same table
6031
6032   
6033 It contains three or more columns
6034
6035   
6036 It is part of a primary key (*)
6037
6038   
6039 It refers to another table
6040
6041     
6042    
6043Correct  Correct
6044
6045     
6046  13.  The explanation below is an example of which constraint type?
6047A column must contain only values consistent with the defined data format of the column Mark for Review
6048(1) Points
6049     
6050   
6051 Column integrity (*)
6052
6053   
6054 Referential integrity
6055
6056   
6057 Entity integrity
6058
6059   
6060 User-defined integrity
6061
6062     
6063    
6064Correct  Correct
6065
6066     
6067  14.  The explanation below is an example of which constraint type?
6068A primary key must be unique, and no part of the primary key can be null. Mark for Review
6069(1) Points
6070     
6071   
6072 User-defined integrity
6073
6074   
6075 Column integrity
6076
6077   
6078 Entity integrity (*)
6079
6080   
6081 Referential integrity
6082
6083     
6084    
6085Incorrect  Incorrect. Refer to Section 9 Lesson 1.
6086
6087     
6088  15.  Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three) Mark for Review
6089(1) Points
6090     
6091   (Choose all correct answers) 
6092     
6093   
6094 Only one column that must be null. (*)
6095
6096   
6097 A set of columns in one table that uniquely identifies each row in another table. (*)
6098
6099   
6100 One or more columns in a table that uniquely identifies each row in that table.
6101
6102   
6103 A single column that uniquely identifies each column in a table. (*)
6104
6105     
6106    
6107Correct  Correct
61086. 	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 
6109(1) Points
6110					
6111			
6112	True
6113	
6114			
6115	False (*)
6116	
6117					
6118				
6119[Incorrect] 		Incorrect. Refer to Section 9 Lesson 3.
6120	
6121				 	9. 	Column integrity refers to 	Mark for Review 
6122(1) Points
6123					
6124			
6125	Columns always having values
6126	
6127			
6128	Columns always containing values consistent with the defined data format (*)
6129	
6130			
6131	Columns always containing text data less than 255 characters
6132	
6133			
6134	Columns always containing positive numbers
6135	
6136					
6137				
6138[Correct] 		Correct 
613912. 	The Physical model is created by transforming which of the following models? 	Mark for Review 
6140(1) Points
6141					
6142			
6143	Conceptual (*)
6144	
6145			
6146	Constraint
6147	
6148			
6149	Table
6150	
6151			
6152	Physical
6153	
6154					
6155				
6156[Incorrect] 		Incorrect. Refer to Section 9 Lesson 2.
6157	
6158					
6159		13. 	Attributes become columns in a database table. True or False? 	Mark for Review 
6160(1) Points
6161					
6162			
6163	True (*)
6164	
6165			
6166	False
6167	
6168					
6169				
6170[Correct] 		Correct
61711. 	A candidate UID that is not chosen to be the Primary UID is called: 	Mark for Review 
6172(1) Points
6173					
6174			
6175	Composite
6176	
6177			
6178	Simple
6179	
6180			
6181	Secondary (*)
6182	
6183			
6184	Artificial
6185	
6186					
6187				
6188[Correct] 		Correct
6189	
6190					
6191		2. 	Where an entity has more than one attribute suitable to be the Primary UID, these are known as _____________ UIDs. 	Mark for Review 
6192(1) Points
6193					
6194			
6195	Secondary
6196	
6197			
6198	Composite
6199	
6200			
6201	Simple
6202	
6203			
6204	Candidate (*)
6205	
6206					
6207				
6208[Correct] 		Correct
6209	
6210					
6211		3. 	An entity could have more than one attribute that would be a suitable Primary UID. True or False? 	Mark for Review 
6212(1) Points
6213					
6214			
6215	True (*)
6216	
6217			
6218	False
6219	
6220					
6221				
6222[Correct] 		Correct
6223	
6224					
6225		4. 	A unique identifier can only be made up of one attribute. True or False? 	Mark for Review 
6226(1) Points
6227					
6228			
6229	True
6230	
6231			
6232	False (*)
6233	
6234					
6235				
6236[Correct] 		Correct
6237	
6238					
6239		5. 	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 
6240(1) Points
6241					
6242			
6243	True
6244	
6245			
6246	False (*)
6247	
6248					
6249				
6250[Correct] 		Correct 
62511. 	A candidate UID that is not chosen to be the Primary UID is called: 	Mark for Review 
6252(1) Points
6253					
6254			
6255	Composite
6256	
6257			
6258	Simple
6259	
6260			
6261	Secondary (*)
6262	
6263			
6264	Artificial
6265	
6266					
6267				
6268[Correct] 		Correct
6269	
6270					
6271		2. 	Where an entity has more than one attribute suitable to be the Primary UID, these are known as _____________ UIDs. 	Mark for Review 
6272(1) Points
6273					
6274			
6275	Secondary
6276	
6277			
6278	Composite
6279	
6280			
6281	Simple
6282	
6283			
6284	Candidate (*)
6285	
6286					
6287				
6288[Correct] 		Correct
6289	
6290					
6291		3. 	An entity could have more than one attribute that would be a suitable Primary UID. True or False? 	Mark for Review 
6292(1) Points
6293					
6294			
6295	True (*)
6296	
6297			
6298	False
6299	
6300					
6301				
6302[Correct] 		Correct
6303	
6304					
6305		4. 	A unique identifier can only be made up of one attribute. True or False? 	Mark for Review 
6306(1) Points
6307					
6308			
6309	True
6310	
6311			
6312	False (*)
6313	
6314					
6315				
6316[Correct] 		Correct
6317	
6318					
6319		5. 	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 
6320(1) Points
6321					
6322			
6323	True
6324	
6325			
6326	False (*)
6327	
6328					
6329				
6330[Correct] 		Correct 
63311. 	A candidate UID that is not chosen to be the Primary UID is called: 	Mark for Review 
6332(1) Points
6333					
6334			
6335	Composite
6336	
6337			
6338	Simple
6339	
6340			
6341	Secondary (*)
6342	
6343			
6344	Artificial
6345	
6346					
6347				
6348[Correct] 		Correct
6349	
6350					
6351		2. 	Where an entity has more than one attribute suitable to be the Primary UID, these are known as _____________ UIDs. 	Mark for Review 
6352(1) Points
6353					
6354			
6355	Secondary
6356	
6357			
6358	Composite
6359	
6360			
6361	Simple
6362	
6363			
6364	Candidate (*)
6365	
6366					
6367				
6368[Correct] 		Correct
6369	
6370					
6371		3. 	An entity could have more than one attribute that would be a suitable Primary UID. True or False? 	Mark for Review 
6372(1) Points
6373					
6374			
6375	True (*)
6376	
6377			
6378	False
6379	
6380					
6381				
6382[Correct] 		Correct
6383	
6384					
6385		4. 	A unique identifier can only be made up of one attribute. True or False? 	Mark for Review 
6386(1) Points
6387					
6388			
6389	True
6390	
6391			
6392	False (*)
6393	
6394					
6395				
6396[Correct] 		Correct
6397	
6398					
6399		5. 	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 
6400(1) Points
6401					
6402			
6403	True
6404	
6405			
6406	False (*)
6407	
6408					
6409				
6410[Correct] 		Correct 
64111. 	A candidate UID that is not chosen to be the Primary UID is called: 	Mark for Review 
6412(1) Points
6413					
6414			
6415	Composite
6416	
6417			
6418	Simple
6419	
6420			
6421	Secondary (*)
6422	
6423			
6424	Artificial
6425	
6426					
6427				
6428[Correct] 		Correct
6429	
6430					
6431		2. 	Where an entity has more than one attribute suitable to be the Primary UID, these are known as _____________ UIDs. 	Mark for Review 
6432(1) Points
6433					
6434			
6435	Secondary
6436	
6437			
6438	Composite
6439	
6440			
6441	Simple
6442	
6443			
6444	Candidate (*)
6445	
6446					
6447				
6448[Correct] 		Correct
6449	
6450					
6451		3. 	An entity could have more than one attribute that would be a suitable Primary UID. True or False? 	Mark for Review 
6452(1) Points
6453					
6454			
6455	True (*)
6456	
6457			
6458	False
6459	
6460					
6461				
6462[Correct] 		Correct
6463	
6464					
6465		4. 	A unique identifier can only be made up of one attribute. True or False? 	Mark for Review 
6466(1) Points
6467					
6468			
6469	True
6470	
6471			
6472	False (*)
6473	
6474					
6475				
6476[Correct] 		Correct
6477	
6478					
6479		5. 	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 
6480(1) Points
6481					
6482			
6483	True
6484	
6485			
6486	False (*)
6487	
6488					
6489				
6490[Correct] 		Correct 
649121. 	Every business has restrictions on which attribute values and which relationships are allowed. These are known as: 	Mark for Review 
6492(1) Points
6493					
6494			
6495	Attributes
6496	
6497			
6498	Entities.
6499	
6500			
6501	Constraints. (*)
6502	
6503			
6504	Relationships
6505	
6506					
6507				
6508[Correct] 		Correct
6509	
6510					
6511		22. 	Which of the following would best be represented by an arc? 	Mark for Review 
6512(1) Points
6513					
6514			
6515	STUDENT (Grade A student, Average Student)
6516	
6517			
6518	TEACHER (Female, Bob)
6519	
6520			
6521	PARENT (Girl, Bob)
6522	
6523			
6524	DELIVERY ADDRESS (Home, Office) (*)
6525	
6526					
6527				
6528[Correct] 		Correct
6529	
6530					
6531		23. 	An arc can often be modeled as Supertype and Subtypes. True or False? 	Mark for Review 
6532(1) Points
6533					
6534			
6535	True (*)
6536	
6537			
6538	False
6539	
6540					
6541				
6542[Correct] 		Correct
6543	
6544					
6545		24. 	Arcs model an Exclusive OR constraint. True or False? 	Mark for Review 
6546(1) Points
6547					
6548			
6549	True (*)
6550	
6551			
6552	False
6553	
6554					
6555				
6556[Correct] 		Correct
6557	
6558					
6559					
6560	Section 8
6561	(Answer all questions in this section)
6562					
6563		25. 	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 
6564(1) Points
6565					
6566			
6567	Allow them to enter whatever delivery charge they want.
6568	
6569			
6570	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. (*)
6571	
6572			
6573	Email current prices to all employees whenever a price changes.
6574	
6575			
6576	Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.
6577	
6578					
6579				
6580[Correct] 		Correct 
658126. 	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 
6582(1) Points
6583					
6584			
6585	True (*)
6586	
6587			
6588	False
6589	
6590					
6591				
6592[Correct] 		Correct
6593	
6594					
6595		27. 	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 
6596(1) Points
6597					
6598			
6599	True
6600	
6601			
6602	False (*)
6603	
6604					
6605				
6606[Correct] 		Correct
6607	
6608					
6609		28. 	Historical data must never be kept. True or False? 	Mark for Review 
6610(1) Points
6611					
6612			
6613	True
6614	
6615			
6616	False (*)
6617	
6618					
6619				
6620[Correct] 		Correct
6621	
6622					
6623		29. 	Which of the following would be a logical constraint when modeling time for a City entity? 	Mark for Review 
6624(1) Points
6625					
6626			
6627	If you are doing a system for any French City, you would need security clearance.
6628	
6629			
6630	People are born in the city and people die in the city.
6631	
6632			
6633	Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.
6634	
6635			
6636	Cites may change their names and/or country association if the borders of a country change. (*)
6637	
6638					
6639				
6640[Correct] 		Correct
6641	
6642					
6643		30. 	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 
6644(1) Points
6645					
6646			
6647	True (*)
6648	
6649			
6650	False
6651	
6652					
6653				
6654[Correct] 		Correct 
6655 		31. 	In an ERD, High Volume Entities usually have very few relationships to other entities. True or False? 	Mark for Review 
6656(1) Points
6657					
6658			
6659	True
6660	
6661			
6662	False (*)
6663	
6664					
6665				
6666[Correct] 		Correct
6667	
6668					
6669		32. 	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 
6670(1) Points
6671					
6672			
6673	True
6674	
6675			
6676	False (*)
6677	
6678					
6679				
6680[Correct] 		Correct
6681	
6682					
6683					
6684	Section 9
6685	(Answer all questions in this section)
6686					
6687		33. 	Foreign keys must be null. True or False? 	Mark for Review 
6688(1) Points
6689					
6690			
6691	True
6692	
6693			
6694	False (*)
6695	
6696					
6697				
6698[Correct] 		Correct
6699	
6700					
6701		34. 	A table must have a primary key. True or False? 	Mark for Review 
6702(1) Points
6703					
6704			
6705	True
6706	
6707			
6708	False (*)
6709	
6710					
6711				
6712[Correct] 		Correct
6713	
6714					
6715		35. 	The explanation below is an example of which constraint type?
6716A column must contain only values consistent with the defined data format of the column 	Mark for Review 
6717(1) Points
6718					
6719			
6720	Referential integrity
6721	
6722			
6723	Entity integrity
6724	
6725			
6726	Column integrity (*)
6727	
6728			
6729	User-defined integrity
6730	
6731					
6732				
6733[Correct] 		Correct 
6734 			
6735		36. 	The explanation below is an example of which constraint type?
6736The 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 
6737(1) Points
6738					
6739			
6740	User-defined integrity
6741	
6742			
6743	Entity integrity
6744	
6745			
6746	Column integrity
6747	
6748			
6749	Referential integrity (*)
6750	
6751					
6752				
6753[Correct] 		Correct
6754	
6755					
6756		37. 	The explanation below is an example of which constraint type?
6757A primary key must be unique, and no part of the primary key can be null. 	Mark for Review 
6758(1) Points
6759					
6760			
6761	User-defined integrity
6762	
6763			
6764	Referential integrity
6765	
6766			
6767	Column integrity
6768	
6769			
6770	Entity integrity (*)
6771	
6772					
6773				
6774[Correct] 		Correct
6775	
6776					
6777		38. 	An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False? 	Mark for Review 
6778(1) Points
6779					
6780			
6781	True
6782	
6783			
6784	False (*)
6785	
6786					
6787				
6788[Correct] 		Correct
6789	
6790					
6791		39. 	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 
6792(1) Points
6793					
6794			
6795	True
6796	
6797			
6798	False (*)
6799	
6800					
6801				
6802[Correct] 		Correct
6803	
6804					
6805		40. 	The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? 	Mark for Review 
6806(1) Points
6807					
6808			
6809	True (*)
6810	
6811			
6812	False
6813	
6814					
6815				
6816[Correct] 		Correct 
6817 			
6818		36. 	The explanation below is an example of which constraint type?
6819The 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 
6820(1) Points
6821					
6822			
6823	User-defined integrity
6824	
6825			
6826	Entity integrity
6827	
6828			
6829	Column integrity
6830	
6831			
6832	Referential integrity (*)
6833	
6834					
6835				
6836[Correct] 		Correct
6837	
6838					
6839		37. 	The explanation below is an example of which constraint type?
6840A primary key must be unique, and no part of the primary key can be null. 	Mark for Review 
6841(1) Points
6842					
6843			
6844	User-defined integrity
6845	
6846			
6847	Referential integrity
6848	
6849			
6850	Column integrity
6851	
6852			
6853	Entity integrity (*)
6854	
6855					
6856				
6857[Correct] 		Correct
6858	
6859					
6860		38. 	An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False? 	Mark for Review 
6861(1) Points
6862					
6863			
6864	True
6865	
6866			
6867	False (*)
6868	
6869					
6870				
6871[Correct] 		Correct
6872	
6873					
6874		39. 	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 
6875(1) Points
6876					
6877			
6878	True
6879	
6880			
6881	False (*)
6882	
6883					
6884				
6885[Correct] 		Correct
6886	
6887					
6888		40. 	The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? 	Mark for Review 
6889(1) Points
6890					
6891			
6892	True (*)
6893	
6894			
6895	False
6896	
6897					
6898				
6899[Correct] 		Correct 
6900 			
6901		36. 	The explanation below is an example of which constraint type?
6902The 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 
6903(1) Points
6904					
6905			
6906	User-defined integrity
6907	
6908			
6909	Entity integrity
6910	
6911			
6912	Column integrity
6913	
6914			
6915	Referential integrity (*)
6916	
6917					
6918				
6919[Correct] 		Correct
6920	
6921					
6922		37. 	The explanation below is an example of which constraint type?
6923A primary key must be unique, and no part of the primary key can be null. 	Mark for Review 
6924(1) Points
6925					
6926			
6927	User-defined integrity
6928	
6929			
6930	Referential integrity
6931	
6932			
6933	Column integrity
6934	
6935			
6936	Entity integrity (*)
6937	
6938					
6939				
6940[Correct] 		Correct
6941	
6942					
6943		38. 	An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False? 	Mark for Review 
6944(1) Points
6945					
6946			
6947	True
6948	
6949			
6950	False (*)
6951	
6952					
6953				
6954[Correct] 		Correct
6955	
6956					
6957		39. 	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 
6958(1) Points
6959					
6960			
6961	True
6962	
6963			
6964	False (*)
6965	
6966					
6967				
6968[Correct] 		Correct
6969	
6970					
6971		40. 	The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False? 	Mark for Review 
6972(1) Points
6973					
6974			
6975	True (*)
6976	
6977			
6978	False
6979	
6980					
6981				
6982[Correct] 		Correct