H5p90XWG

1 Section 1 Quiz Database Design Oracle
2Section 1 Quiz
3                (Answer all questions in this section)
4
51.            A specialized type of software, which controls and manages the hardware in a computer system.             Mark for Review
6(1) Points
7                Operating System (*)
8                Hardware
9                Software
10                Client
11
122.            Personal computers (PCs) have been in existence since 1950. True or False?       Mark for Review
13(1) Points
14                True
15                False (*)
16
173.            The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network.   Mark for Review
18(1) Points
19                True
20                False (*)
21
224.            Users could directly interact with which of the following software to access essential business applications? (Choose three) Mark for Review
23(1) Points
24                                                (Choose all correct answers)      
25                GUI software (*)
26                Internet Browser software (*)
27                Operating System software (*)
28                Server software
29
305.            Software cannot operate without Hardware. True or False?        Mark for Review
31(1) Points
32                True (*)
33                False
34
356.            Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is the total number of books out on loan in one given month considered Data or Information?         Mark for Review
36(1) Points
37                Data
38                Information (*)
39                Both
40                Neither
41
427.            Information which was gained from data is the same as: (Choose Two)  Mark for Review
43(1) Points
44                                                (Choose all correct answers)      
45                Intelligence (*)
46                There is no difference between data and information.
47                Raw Materials
48                Knowledge (*)
49
508.            Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is a detail of one student borrowing one book considered Data or Information?      Mark for Review
51(1) Points
52                Data (*)
53                Information
54                Both
55                Neither
56
579.            Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False?            Mark for Review
58(1) Points
59                True (*)
60                False
61
6210.          The work of E.F. Codd in the early 1970s led to the development of Relational databases. True or False?                Mark for Review
63(1) Points
64                True (*)
65                False
66
6711.          SQL became the most commonly used query language in the 1980s. True or False?          Mark for Review
68(1) Points
69                True (*)
70                False
71
7212.          Which of the following represents the correct sequence of steps in the Database Development Process?                Mark for Review
73(1) Points
74                Design, Build, Analyze
75                Analyze, Build, Design
76                Analyze, Design, Build (*)
77                Build, Analyze, Design
78
7913.          The market for IT professionals is still increasing and will continue to do so in the future as the world gets ever more dependent on computer systems. True or False?       Mark for Review
80(1) Points
81                True (*)
82                False
83
8414.          The main subject areas taught by the Oracle Academy are:          Mark for Review
85(1) Points
86                Systems programming and computer architecture
87                Database performance tuning
88                Computer Repairs
89                Data Modeling, SQL, and PL/SQL (*)
90
9115.          The demand for Information Technology professionals in today's market is increasing. True or False?      Mark for Review
92(1) Points
93                True (*)
94                False
95
961.            The demand for Information Technology professionals in today's market is increasing. True or False?      Mark for Review
97(1) Points
98                True (*)
99                False
100
1012.            The market for IT professionals is still increasing and will continue to do so in the future as the world gets ever more dependent on computer systems. True or False?       Mark for Review
102(1) Points
103                True (*)
104                False
105
1063.            Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users as you are perfectly capable of delivering the systems that businesses need and want.                Mark for Review
107(1) Points
108                False. Business requirements can and will change. For instance new legal requirements may arise. (*)
109
110                True. Users delay the delivery of a system by changing their minds and adding new requirements.
111
112                True. The only requirement for creating a perfect system is a perfect programmer.
113
114                True. Users never know what they want anyway, so building systems is best left to the professionals.
115
1164.            In the grid computing model, resources are pooled together for efficiency. True or False?            Mark for Review
117(1) Points
118                True (*)
119                False
120
1215.            Users could directly interact with which of the following software to access essential business applications? (Choose three) Mark for Review
122(1) Points
123                                                (Choose all correct answers)      
124                Operating System software (*)
125                Server software
126                GUI software (*)
127                Internet Browser software (*)
128
1296.            A specialized type of software, which controls and manages the hardware in a computer system.             Mark for Review
130                Software
131                Hardware
132                Operating System (*)
133                Client
134
1357.            Software cannot operate without Hardware. True or False?        Mark for Review
136(1) Points
137                True (*)
138                False
139
1408.            The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network.   Mark for Review
141(1) Points
142                True
143                False (*)
144
1459.            Information which was gained from data is the same as: (Choose Two)  Mark for Review
146(1) Points
147                                                (Choose all correct answers)      
148                Knowledge (*)
149                There is no difference between data and information.
150                Intelligence (*)
151                Raw Materials
152
15310.          Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is a detail of one student borrowing one book considered Data or Information?      Mark for Review
154(1) Points
155                Data (*)
156                Information
157                Both
158                Neither
159
16011.          Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is the total number of books out on loan in one given month considered Data or Information?         Mark for Review
161(1) Points
162                Data
163                Information (*)
164                Both
165                Neither
166
16712.          Every time you shop online, it is likely you will be accessing a database. True or False?    Mark for Review
168(1) Points
169                True (*)
170                False
171
17213.          The work of E.F. Codd in the early 1970s led to the development of Relational databases. True or False?                Mark for Review
173                True (*)
174                False
175
17614.          Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False?            Mark for Review
177(1) Points
178                True (*)
179                False
180
18115.          SQL became the most commonly used query language in the 1980s. True or False?          Mark for Review
182(1) Points
183                True (*)
184                False
185
1861.            Data Modeling is the last step in the database development process. True or False?        Mark for Review
187(1) Points
188                True
189                False (*)
190
1912.            Every time you shop online, it is likely you will be accessing a database. True or False?    Mark for Review
192(1) Points
193                True (*)
194                False
195
1963.            The work of E.F. Codd in the early 1970s led to the development of Relational databases. True or False?                Mark for Review
197(1) Points
198                True (*)
199                False
200
2014.            Oracle was one of the first relational database systems available commercially. True or False?    Mark for Review
202(1) Points
203                True (*)
204                False
205
2065.            Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users as you are perfectly capable of delivering the systems that businesses need and want.                Mark for Review
207                True. The only requirement for creating a perfect system is a perfect programmer.
208
209                True. Users never know what they want anyway, so building systems is best left to the professionals.
210
211                False. Business requirements can and will change. For instance new legal requirements may arise. (*)
212
213                True. Users delay the delivery of a system by changing their minds and adding new requirements.
214
2156.            The main subject areas taught by the Oracle Academy are:          Mark for Review
216(1) Points
217                Data Modeling, SQL, and PL/SQL (*)
218                Systems programming and computer architecture
219                Computer Repairs
220                Database performance tuning
221
2227.            The demand for Information Technology professionals in today's market is increasing. True or False?      Mark for Review
223(1) Points
224                True (*)
225                False
226
2278.            Which term describes the physical components of a computer system? Mark for Review
228(1) Points
229                Hardware (*)
230                Operating System
231                Software
232                Client
233
2349.            Changes in computing have affected many of our day-to-day activities. Are all of the following activities examples of this change? Yes or No?
235In the past you used to use the phone system to call directory assistance to get a phone number. Today you can use your PC to look up a phone number online.
236
237In the past you used to have to go to the shoe store to buy shoes. Today you can use your PC to order shoes online.
238
239In the past you had to use your PC to send a person an email. Today you can use your phone to send a text message.
240
241 Mark for Review
242(1) Points
243                No
244                Yes (*)
245
24610.          Which of the following are examples of e-businesses that use database software?          Mark for Review
247(1) Points
248                                                (Choose all correct answers)      
249                Online research paper
250                Online clothing store (*)
251                Online personal web page
252                Online book store (*)
253                Online personal shopping service (*)
254
25511.          Personal computers (PCs) have been in existence since 1950. True or False?       Mark for Review
256(1) Points
257                True
258                False (*)
259
26012.          Businesses involved in any of the following typically use databases to handle their data: Finance, Logistics, Commerce, Procurement, and Distribution? True or False?          Mark for Review
261(1) Points
262                True (*)
263                False
264
26513.          What is the difference between "information" and "data"?         Mark for Review
266(1) Points
267                Information is held and understood only by users.
268                Data is held and understood only by users.
269                Information and data have no differences - they are two words for the same thing.
270                Data turns into useful information. It is stored in a database and accessed by systems and users. (*)
271
27214.          Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is the total number of books out on loan in one given month considered Data or Information?         Mark for Review
273(1) Points
274                Data
275                Information (*)
276                Both
277                Neither
278
27915.          Information which was gained from data is the same as: (Choose Two)  Mark for Review
280(1) Points
281                                                (Choose all correct answers)      
282                Knowledge (*)
283                There is no difference between data and information.
284                Intelligence (*)
285                Raw Materials
286
2871.            The main subject areas taught by the Oracle Academy are:          Mark for Review
288(1) Points
289                Computer Repairs
290                Systems programming and computer architecture
291                Database performance tuning
292                Data Modeling, SQL, and PL/SQL (*)
293
2942.            Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users as you are perfectly capable of delivering the systems that businesses need and want.                Mark for Review
295(1) Points
296                True. Users never know what they want anyway, so building systems is best left to the professionals.
297
298                False. Business requirements can and will change. For instance new legal requirements may arise. (*)
299
300                True. Users delay the delivery of a system by changing their minds and adding new requirements.
301                True. The only requirement for creating a perfect system is a perfect programmer.
302
3033.            The demand for Information Technology professionals in today's market is increasing. True or False?      Mark for Review
304(1) Points
305                True (*)
306                False
307
3084.            Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is a detail of one student borrowing one book considered Data or Information?      Mark for Review
309(1) Points
310                Data (*)
311                Information
312                Both
313                Neither
314
3155.            Which of the following are examples of data becoming information:       Mark for Review
316(1) Points
317                A. Student age -> average age of all students in class
318                B. Bank deposit amount -> total account balance
319                C. Winning time for a race -> length of race
320                D. Price of a computer -> total sales of all computers for a company
321                E. A, B, and D (*)
322
3236.            What is the difference between "information" and "data"?         Mark for Review
324(1) Points
325                Information and data have no differences - they are two words for the same thing.
326                Data is held and understood only by users.
327
328                Data turns into useful information. It is stored in a database and accessed by systems and users. (*)
329
330                Information is held and understood only by users.
331
3327.            Which of the following represents the correct sequence of steps in the Database Development Process?                Mark for Review
333(1) Points
334                Analyze, Build, Design
335                Design, Build, Analyze
336                Build, Analyze, Design
337                Analyze, Design, Build (*)
338
3398.            Entities are transformed into Tables during the Database Design process. True or False?                Mark for Review
340(1) Points
341                True (*)
342                False
343
3449.            Every time you shop online, it is likely you will be accessing a database. True or False?    Mark for Review
345(1) Points
346                True (*)
347                False
348
34910.          Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False?            Mark for Review
350(1) Points
351                True (*)
352                False
353
35411.          Personal computers (PCs) have been in existence since 1950. True or False?       Mark for Review
355(1) Points
356                True
357                False (*)
358
35912.          Software cannot operate without Hardware. True or False?        Mark for Review
360(1) Points
361                True (*)
362                False
363
36413.          In the grid computing model, resources are pooled together for efficiency. True or False?            Mark for Review
365(1) Points
366                True (*)
367                False
368
36914.          Which of the following are examples of e-businesses that use database software?          Mark for Review
370(1) Points
371                                                (Choose all correct answers)      
372                Online personal shopping service (*)
373                Online personal web page
374                Online clothing store (*)
375                Online research paper
376                Online book store (*)
377
37815.          Users could directly interact with which of the following software to access essential business applications? (Choose three) Mark for Review
379(1) Points
380                                                (Choose all correct answers)      
381                Internet Browser software (*)
382                Server software
383                GUI software (*)
384                Operating System software (*)
385
3861.            What is the difference between "information" and "data"?         Mark for Review
387(1) Points
388                Information is held and understood only by users.
389
390                Data turns into useful information. It is stored in a database and accessed by systems and users. (*)
391
392                Data is held and understood only by users.
393                Information and data have no differences - they are two words for the same thing.
394
3952.            How do you turn "data" into "information"?        Mark for Review
396(1) Points
397                By testing it
398                By storing it on a server
399                By storing it in a database
400                By querying it or accessing it (*)
401
4023.            Which of the following are examples of data becoming information:       Mark for Review
403(1) Points
404                A. Student age -> average age of all students in class
405                B. Bank deposit amount -> total account balance
406                C. Winning time for a race -> length of race
407                D. Price of a computer -> total sales of all computers for a company
408                E. A, B, and D (*)
409
4104.            Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False?            Mark for Review
411(1) Points
412                True (*)
413                False
414
4155.            Every time you shop online, it is likely you will be accessing a database. True or False?    Mark for Review
416(1) Points
417                True (*)
418                False
419
4206.            Oracle was one of the first relational database systems available commercially. True or False?    Mark for Review
421(1) Points
422                True (*)
423                False
424
4257.            Most of the well known Internet search engines use databases to store data. True or False?       Mark for Review
426(1) Points
427                True (*)
428                False
429
4308.            Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users as you are perfectly capable of delivering the systems that businesses need and want.                Mark for Review
431(1) Points
432                True. Users delay the delivery of a system by changing their minds and adding new requirements.
433
434                False. Business requirements can and will change. For instance new legal requirements may arise. (*)
435
436                True. The only requirement for creating a perfect system is a perfect programmer.
437
438                True. Users never know what they want anyway, so building systems is best left to the professionals.
439
4409.            The main subject areas taught by the Oracle Academy are:          Mark for Review
441(1) Points
442                Data Modeling, SQL, and PL/SQL (*)
443                Database performance tuning
444                Computer Repairs
445                Systems programming and computer architecture
446
44710.          The market for IT professionals is still increasing and will continue to do so in the future as the world gets ever more dependent on computer systems. True or False?       Mark for Review
448(1) Points
449                True (*)
450                False
451
45211.          Changes in computing have affected many of our day-to-day activities. Are all of the following activities examples of this change? Yes or No?
453In the past you used to use the phone system to call directory assistance to get a phone number. Today you can use your PC to look up a phone number online.
454
455In the past you used to have to go to the shoe store to buy shoes. Today you can use your PC to order shoes online.
456
457In the past you had to use your PC to send a person an email. Today you can use your phone to send a text message.
458
459 Mark for Review
460(1) Points
461                No
462                Yes (*)
463
46412.          In the grid computing model, resources are pooled together for efficiency. True or False?            Mark for Review
465(1) Points
466                True (*)
467                False
468
46913.          Which of the following are examples of e-businesses that use database software?          Mark for Review
470(1) Points
471                                                (Choose all correct answers)      
472                Online personal web page
473                Online clothing store (*)
474                Online personal shopping service (*)
475                Online research paper
476                Online book store (*)
477
47814.          Software cannot operate without Hardware. True or False?        Mark for Review
479(1) Points
480                True (*)
481                False
482
48315.          The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network.   Mark for Review
484(1) Points
485                True
486
487                False (*)
488 Section 2 Quiz Database Design Oracle
489Section 2 Quiz
490            (Answer all questions in this section)
491
4921.         An Entity Relationship model is independent of the hardware or software used for implementation. True or False?  Mark for Review
493(1) Points
494            True (*)
495            False
496
4972.         A well structured ERD will show only some parts of the finished data model. You should never try to model the entire system in one diagram, no matter how small the diagram might be. True or False?           Mark for Review
498(1) Points
499            True
500            False (*)
501
5023.         The purpose of an ERD is to document the proposed system and facilitate discussion and understanding of the requirements captured by the developer. True or False?          Mark for Review
503(1) Points
504            True (*)
505            False
506
5074. Documenting Business Requirements helps developers control the scope of the system and prevents users from claiming that the new system does not meet their business requirements. True or False?         Mark for Review
508(1) Points
509            True (*)
510            False
511
5125.         A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False?  Mark for Review
513(1) Points
514            True (*)
515            False
516
5176.         Data modeling is performed for the following reasons: (Choose Two)         Mark for Review
518(1) Points
519                                    (Choose all correct answers)  
520            It helps discussions and reviews. (*)
521            The ERD becomes a blueprint for designing the actual system. (*)
522            We draw an ERD solely to please the users; once completed, the ERD is never referred to again as it serves no purpose in the real world.
523            We do not need datamodels; we can just start coding right away.
524
5257.         Data modeling is performed for the following reasons: (Choose Two)         Mark for Review
526(1) Points
527                                    (Choose all correct answers)  
528
529            We draw an ERD solely to please the users; once completed, the ERD is never referred to again as it serves no purpose in the real world.
530
531            It helps discussions and reviews. (*)
532            The ERD becomes a blueprint for designing the actual system. (*)
533            We do not need datamodels; we can just start coding right away.
534
5358.         Which of the following entities most likely contains valid attributes? (Choose two)            Mark for Review
536(1) Points
537                                    (Choose all correct answers)  
538            Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built (*)
539            Entity: Pet. Attributes: Name, Birthdate, Owner (*)
540            Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed
541            Entity: Mother. Attributes: Name, Birthdate, Occupation, Start Date
542
5439.         Which of the following are examples of ENTITY: Instance ? (Choose Two)           Mark for Review
544(1) Points
545                                    (Choose all correct answers)  
546            ANIMAL: Dog (*)
547            MEAT PRODUCT: Lettuce
548            BODY PART: Larry Ellison
549            TRANSPORTATION METHOD: Car (*)
550
55110.       Unique Identifiers:      Mark for Review
552(1) Points
553            Distinguish one instance of an entity from all other instances of that entity (*)
554            Distinguish all entities in a database
555            Distinguish one entity from another
556            Distinguish nothing
557
55811.       Which of the following statements about Entities are true?   Mark for Review
559(1) Points
560                                    (Choose all correct answers)  
561            "Something" of significance to the business about which data must be known. (*)
562            They never have Instances
563            They are usually a noun. (*)
564            A name for a set of similar "things" (*)
565
56612.       In the following statements, find two good examples of ENTITY: Instance. (Choose Two)           Mark for Review
567(1) Points
568                                    (Choose all correct answers)  
569            VEGETABLE: grows
570            BOOK: Biography of Mahatma Gandhi (*)
571            TRAIN: runs
572            DAIRY PRODUCT: milk (*)
573
57413.       A/an _________ is a piece of information that in some way describes an entity. It is a property of the entity and it quantifies, qualifies, classifies, or specifies the entity.   Mark for Review
575(1) Points
576            Table
577            ERD
578            Process
579            Attribute (*)
580
58114.       The word "Volatile" means:    Mark for Review
582(1) Points
583            Limited quantity
584            Changing constantly; unstable (*)
585            Large quantity
586            Static; unlikely to change
587
58815.       Entities are usually verbs. True or False?        Mark for Review
589(1) Points
590            True
591            False (*)
592
5931.         Unique Identifiers:      Mark for Review
594(1) Points
595            Distinguish one entity from another
596            Distinguish nothing
597            Distinguish all entities in a database
598            Distinguish one instance of an entity from all other instances of that entity (*)
599
6002.         The word "Volatile" means:    Mark for Review
601(1) Points
602            Large quantity
603            Static; unlikely to change
604            Limited quantity
605            Changing constantly; unstable (*)
606
6073.         Which of the following entities most likely contains valid attributes? (Choose two)            Mark for Review
608(1) Points
609                                    (Choose all correct answers)  
610            Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed
611            Entity: Pet. Attributes: Name, Birthdate, Owner (*)
612            Entity: Mother. Attributes: Name, Birthdate, Occupation, Start Date
613            Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built (*)
614
6154. All of the following could be attributes of an ENTITY called PERSON, except which one?      Mark for Review
616(1) Points
617            Weight
618            Gender
619            Haircolor
620            Natacha Hansen (*)
621
6225.         Attributes can only have one value at any point for each instance in the entity. True or False?        Mark for Review
623(1) Points
624            True (*)
625            False
626
6276.         A/an _________'s value can be a number, a character string, a date, an image, a sound       Mark for Review
628(1) Points
629            ERD
630            Table
631            Attribute (*)
632            Entity
633
6347.         What is the purpose of a Unique Identifier?  Mark for Review
635(1) Points
636
637            To identify a specific row within a table, using one or more columns and/or foreign keys.
638
639            To identify one unique instance of an entity by using one or more attributes and/or relationships. (*)
640
641            Create an entity that is unlike any other entity aside from itself.
642            To uniquely determine a table and columns within that table.
643                                                           
6448. Which of the following attributes is suitable to be a Unique Identifier?   Mark for Review
645(1) Points
646            Address
647            First name
648            Last name
649            Social Security Number (*)
650
6519.         An Entity Relationship model is independent of the hardware or software used for implementation. True or False?  Mark for Review
652(1) Points
653            True (*)
654            False
655
65610.       A well structured ERD will show only some parts of the finished data model. You should never try to model the entire system in one diagram, no matter how small the diagram might be. True or False?           Mark for Review
657(1) Points
658            True
659            False (*)
660
66111. Which of the following can be found in an ERD? (Choose Two)           Mark for Review
662(1) Points
663                                    (Choose all correct answers)  
664            Entities. (*)
665            Attributes. (*)
666            Tables.
667            Instances.
668
66912.       A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False?  Mark for Review
670(1) Points
671            True (*)
672            False
673
67413.       Data modeling is performed for the following reasons: (Choose Two)         Mark for Review
675(1) Points
676                                    (Choose all correct answers)  
677            It helps discussions and reviews. (*)
678
679            We draw an ERD solely to please the users; once completed, the ERD is never referred to again as it serves no purpose in the real world.
680            We do not need datamodels; we can just start coding right away.
681
682            The ERD becomes a blueprint for designing the actual system. (*)
683                                                           
68414.       An ERD is an example of a Physical Model. True or False?  Mark for Review
685(1) Points
686            True
687            False (*)
688
68915.       The Physical Model is derived from the Conceptual Model. True or False?  Mark for Review
690(1) Points
691            True (*)
692            False
693
6941.         Which of the following statements about Entities are true?   Mark for Review
695(1) Points
696                                    (Choose all correct answers)  
697            They are usually a noun. (*)
698            "Something" of significance to the business about which data must be known. (*)
699            They never have Instances
700            A name for a set of similar "things" (*)
701
7022.         Which of the following is an example of a volatile attribute?            Mark for Review
703(1) Points
704            Date of Birth
705            Hire Date
706            Name
707            Age (*)
708
7093.         All of the following would be instances of the entity PERSON except which?       Mark for Review
710(1) Points
711            Male (*)
712            Grace Abinajam
713            David Jones
714            Angelina Rosalie
715
7164.         Attributes can only have one value at any point for each instance in the entity. True or False?        Mark for Review
717(1) Points
718            True (*)
719            False
720
7215.         All of the following would be instances of the entity ANIMAL SPECIES, except which one?      Mark for Review
722(1) Points
723            Elephant
724            Bird
725            Dog
726            Leaf (*)
727
7286.         A/an _________'s value can be a number, a character string, a date, an image, a sound       Mark for Review
729(1) Points
730            ERD
731            Entity
732            Attribute (*)
733            Table
734
7357.         A/an _________ is defined as "Something" of significance to the business about which data must be known.            Mark for Review
736(1) Points
737            Instance
738            Relationship
739            Entity (*)
740            None of the above
741
7428.         Attributes can be either mandatory or optional. True or False?          Mark for Review
743(1) Points
744            True (*)
745            False
746
7479.         Data models show users the data that their Physical Model will contain. True or False?      Mark for Review
748(1) Points
749            True (*)
750            False
751
75210.       A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False?  Mark for Review
753(1) Points
754            True (*)
755            False
756
75711.       Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. Mark for Review
758(1) Points
759                                    (Choose all correct answers)  
760            They capture current and future needs. (*)
761            They model the information flow of data.
762            They accurately describe what a physical model will contain. (*)
763            They model functional and informational needs. (*)
764            They capture the implementation details of the physical model.
765
76612.       Data models are drawn to show users the actual Data that their new system will contain; only Data listed on the Diagram can be entered into the Database. True or False?        Mark for Review
767(1) Points
768            True (*)
769            False
770
77113.       Which of the following statements about ERD's is false?     Mark for Review
772(1) Points
773            Ensure that information appears only once.
774            Capture all required information.
775            Model all information that is derivable from other information already modeled. (*)
776            Locate information in a predictable, logical place.
777
77814.       A well structured ERD will show only some parts of the finished data model. You should never try to model the entire system in one diagram, no matter how small the diagram might be. True or False?           Mark for Review
779(1) Points
780            True
781            False (*)
782
78315. Which of the following statements are true about ERD's? (Choose Two)           Mark for Review
784(1) Points
785                                    (Choose all correct answers)  
786            You should not model derivable data. (*)
787            A piece of information should only be found in one place on an ERD. (*)
788            A piece of information can be shown multiple times on an ERD.
789            All data must be represented on the ERD, including derived summaries and the result of calculations.
790
7911.         Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. Mark for Review
792(1) Points
793                                    (Choose all correct answers)  
794            They capture the implementation details of the physical model.
795            They accurately describe what a physical model will contain. (*)
796            They model the information flow of data.
797            They model functional and informational needs. (*)
798            They capture current and future needs. (*)
799
8002.         Data modeling is performed for the following reasons: (Choose Two)         Mark for Review
801(1) Points
802                                    (Choose all correct answers)  
803            It helps discussions and reviews. (*)
804            The ERD becomes a blueprint for designing the actual system. (*)
805
806            We draw an ERD solely to please the users; once completed, the ERD is never referred to again as it serves no purpose in the real world.
807            We do not need datamodels; we can just start coding right away.
808
8093.         A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False?  Mark for Review
810(1) Points
811            True (*)
812            False
813
8144.         Data models are drawn to show users the actual Data that their new system will contain; only Data listed on the Diagram can be entered into the Database. True or False?        Mark for Review
815(1) Points
816            True (*)
817            False
818
8195.         Which of the following attributes is suitable to be a Unique Identifier?       Mark for Review
820(1) Points
821            Last name
822            First name
823            Address
824            Social Security Number (*)
825
8266.         Which of the following statements about Entities are true?   Mark for Review
827(1) Points
828                                    (Choose all correct answers)  
829            They are usually a noun. (*)
830            They never have Instances
831            "Something" of significance to the business about which data must be known. (*)
832            A name for a set of similar "things" (*)
833
8347.         A/an _________ is defined as "Something" of significance to the business about which data must be known.            Mark for Review
835(1) Points
836            Instance
837            Relationship
838            Entity (*)
839            None of the above
840
8418. Which of the following are examples of ENTITY: Instance ? (Choose Two)       Mark for Review
842(1) Points
843                                    (Choose all correct answers)  
844            ANIMAL: Dog (*)
845            TRANSPORTATION METHOD: Car (*)
846            MEAT PRODUCT: Lettuce
847            BODY PART: Larry Ellison
848
8499.         A/an _________'s value can be a number, a character string, a date, an image, a sound       Mark for Review
850(1) Points
851            Attribute (*)
852            Table
853            Entity
854            ERD
855
85610.       Entities are usually verbs. True or False?        Mark for Review
857(1) Points
858            True
859            False (*)
860
86111.       All of the following would be instances of the entity PERSON except which?       Mark for Review
862(1) Points
863            David Jones
864            Angelina Rosalie
865            Male (*)
866            Grace Abinajam
867
86812.       The word "Volatile" means:    Mark for Review
869(1) Points
870            Limited quantity
871            Static; unlikely to change
872            Large quantity
873            Changing constantly; unstable (*)
874
87513. An Entity Relationship model is independent of the hardware or software used for implementation. True or False?          Mark for Review
876(1) Points
877            True (*)
878            False
879
88014.       The purpose of an ERD is to document the proposed system and facilitate discussion and understanding of the requirements captured by the developer. True or False?          Mark for Review
881(1) Points
882            True (*)
883            False
884
88515.       Entity Relationship modeling is dependent on the hardware or software used for implementation, so you will need to change your ERD if you decide to change Hardware Vendor. True or False?       Mark for Review
886(1) Points
887            True
888
889            False (*)
890
891 Section 3 Quiz Database Design Oracle
892Section 3 Quiz
893                (Answer all questions in this section)
8941.            What are the three properties that every relationship should have?        Mark for Review
895(1) Points
896                Name, optionality, cardinality (*)
897                A UID bar, a diamond, an arc
898                Name, optionality, arcs
899                Transferability, degree, name
900
9012.            Relationships can be either mandatory or optional. True or False?            Mark for Review
902(1) Points
903                True (*)
904                False
905
9063.            In a business that sells pet food, choose the best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse, or cat). (Choose Two)            Mark for Review
907(1) Points
908                                                (Choose all correct answers)      
909                Each ANIMAL must be the seller of one or more FOOD TYPES.
910                Each FOOD TYPE may be manufactured by one or more ANIMALs.
911                Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
912                Each FOOD TYPE may be given to one or more ANIMALs. (*)
913
9144.            One Relationship can be mandatory in one direction and optional in the other direction. True or False?  Mark for Review
915(1) Points
916                True (*)
917                False
918
9195.            Which of the following are used to show Cardinality on an ERD? (Choose two)    Mark for Review
920(1) Points
921                                                (Choose all correct answers)      
922                Crow's foot. (*)
923                Solid line.
924                Single toe. (*)
925                Dashed line.
926
9276.            Which of the following are true about Cardinality? (Choose two)               Mark for Review
928(1) Points
929                                                (Choose all correct answers)      
930                Cardinality tells "how many". (*)
931                Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
932                Cardinality specifies whether something is required or not.
933                Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
934
9357. Which symbol is used to show that a particular attribute is mandatory?             Mark for Review
936(1) Points
937                &
938                #
939                o
940                * (*)
941
9428.            Entity boxes are drawn as            Mark for Review
943(1) Points
944                Soft Boxes (*)
945                Hard Boxes
946                Normal Circles
947                Bold Circles
948
9499.            ERDish describes a relationship in words. True or False? Mark for Review
950(1) Points
951                True (*)
952                False
953
95410.          Which of the following are used to show a relationship on an ERD? (Choose Three)          Mark for Review
955(1) Points
956                                                (Choose all correct answers)      
957                Dashed line. (*)
958                Crow's foot. (*)
959                Solid line. (*)
960                # symbol.
961
96211. When reading a relationship between 2 entities, the relationship is read both from left to right and right to left. True or False?    Mark for Review
963(1) Points
964                True (*)
965                False
966
96712. Relationship names are not shown on an ERD. True or False?               Mark for Review
968(1) Points
969                True
970                False (*)
971
97213. Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?              Mark for Review
973(1) Points
974                True
975                False (*)
976
97714.          Matrix Diagrams are developed BEFORE the ERD. True or False?                Mark for Review
978(1) Points
979                True (*)
980                False
981
98215.          Matrix Diagrams are used to verify that all relationships have been identified for an ERD. True or False? Mark for Review
983(1) Points
984                True (*)
985                False
9861.            Which of the following are used to show a relationship on an ERD? (Choose Three)          Mark for Review
987(1) Points
988                                                (Choose all correct answers)      
989                # symbol.
990                Solid line. (*)
991                Dashed line. (*)
992                Crow's foot. (*)
993
9942.            Relationship names are not shown on an ERD. True or False?      Mark for Review
995(1) Points
996                True
997                False (*)
998
9993.            When reading the relationships in an ERD, you are said to be speaking:  Mark for Review
1000(1) Points
1001                Entity-ish
1002                Gibberish
1003                ERDish (*)
1004                Relationship-ish
1005
10064.            ERDish describes a relationship in words. True or False? Mark for Review
1007(1) Points
1008                True (*)
1009                False
1010
10115.            What are the three properties that every relationship should have?        Mark for Review
1012(1) Points
1013                Name, optionality, arcs
1014                Transferability, degree, name
1015                Name, optionality, cardinality (*)
1016                A UID bar, a diamond, an arc
1017
10186.            Relationships can be either mandatory or optional. True or False?            Mark for Review
1019(1) Points
1020                True (*)
1021                False
1022
10237.            Which of the following are used to show Cardinality on an ERD? (Choose two)    Mark for Review
1024(1) Points
1025                                                (Choose all correct answers)      
1026                Single toe. (*)
1027                Dashed line.
1028                Crow's foot. (*)
1029                Solid line.
1030
10318.            Relationships always exist between        Mark for Review
1032(1) Points
1033                3 or more attributes
1034                3 or more entities
1035                2 entities (or one entity and itself) (*)
1036                2 attributes
1037
10389.            In a business that sells pet food, choose the best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse, or cat). (Choose Two)            Mark for Review
1039(1) Points
1040                                                (Choose all correct answers)      
1041                Each ANIMAL must be the seller of one or more FOOD TYPES.
1042                Each FOOD TYPE may be given to one or more ANIMALs. (*)
1043                Each FOOD TYPE may be manufactured by one or more ANIMALs.
1044                Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
1045
104610.          Which of the following are true about Cardinality? (Choose two)               Mark for Review
1047(1) Points
1048                                                (Choose all correct answers)      
1049                Cardinality specifies whether something is required or not.
1050                Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
1051                Cardinality tells "how many". (*)
1052                Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
1053
105411.          To identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it. True or False?              Mark for Review
1055(1) Points
1056                True (*)
1057                False
1058
105912.          Entity names are always singular. True or False?                Mark for Review
1060(1) Points
1061                True (*)
1062                False
1063
106413.          Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?     Mark for Review
1065(1) Points
1066                True
1067                False (*)
1068
106914.          Matrix Diagrams are developed BEFORE the ERD. True or False?                Mark for Review
1070(1) Points
1071                True (*)
1072                False
1073
107415.          Matrix Diagrams are used to verify that all relationships have been identified for an ERD. True or False? Mark for Review
1075(1) Points
1076                True (*)
1077                False
1078
10791.            Entity names are always singular. True or False?                Mark for Review
1080(1) Points
1081                True (*)
1082                False
1083
10842.            Entity boxes are drawn as            Mark for Review
1085(1) Points
1086                Normal Circles
1087                Hard Boxes
1088                Soft Boxes (*)
1089                Bold Circles
1090
10913.            Relationship names are not shown on an ERD. True or False?      Mark for Review
1092(1) Points
1093                True
1094                False (*)
1095
10964.            ERDish describes a relationship in words. True or False? Mark for Review
1097(1) Points
1098                True (*)
1099                False
1100
11015.            Which of the following are used to show a relationship on an ERD? (Choose Three)          Mark for Review
1102(1) Points
1103                                                (Choose all correct answers)      
1104                Crow's foot. (*)
1105                Solid line. (*)
1106                # symbol.
1107                Dashed line. (*)
1108
11096.            When reading a relationship between 2 entities, the relationship is read both from left to right and right to left. True or False?          Mark for Review
1110(1) Points
1111                True (*)
1112                False
1113
11147.            Which of the following are true about Cardinality? (Choose two)               Mark for Review
1115(1) Points
1116                                                (Choose all correct answers)      
1117                Cardinality specifies whether something is required or not.
1118                Cardinality tells "how many". (*)
1119                Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
1120                Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
1121
11228.            Which of the following are true about Relationship Optionality? (Choose two)    Mark for Review
1123(1) Points
1124                                                (Choose all correct answers)      
1125                Optionality specifies only singularity or plurality, but not a specific plural number.
1126                Optionality answers "may or must". (*)
1127                Optionality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
1128                Optionality specifies whether something is required or not. (*)
1129
11309.            In a business that sells pet food, choose the best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse, or cat). (Choose Two)            Mark for Review
1131(1) Points
1132                                                (Choose all correct answers)      
1133                Each FOOD TYPE may be given to one or more ANIMALs. (*)
1134                Each FOOD TYPE may be manufactured by one or more ANIMALs.
1135                Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
1136                Each ANIMAL must be the seller of one or more FOOD TYPES.
1137
113810. What are the three properties that every relationship should have? Mark for Review
1139(1) Points
1140                Transferability, degree, name
1141                Name, optionality, arcs
1142                Name, optionality, cardinality (*)
1143                A UID bar, a diamond, an arc
1144
114511.          Relationship Cardinality is important. True or False?         Mark for Review
1146(1) Points
1147                True (*)
1148                False
1149
115012.          Relationships can be either mandatory or optional. True or False?            Mark for Review
1151(1) Points
1152                True (*)
1153                False
1154
115513.          Matrix Diagrams are used to verify that all relationships have been identified for an ERD. True or False? Mark for Review
1156(1) Points
1157                True (*)
1158                False
1159
116014.          Matrix Diagrams are developed BEFORE the ERD. True or False?                Mark for Review
1161(1) Points
1162                True (*)
1163                False
1164
116515.          Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?     Mark for Review
1166(1) Points
1167                True
1168                False (*)
1169
11701.            Entity boxes are drawn as            Mark for Review
1171(1) Points
1172                Normal Circles
1173                Hard Boxes
1174                Bold Circles
1175                Soft Boxes (*)
1176
11772.            Entity names are always singular. True or False?                Mark for Review
1178(1) Points
1179                True (*)
1180                False
1181
11823.            Matrix Diagrams are developed BEFORE the ERD. True or False?                Mark for Review
1183(1) Points
1184                True (*)
1185                False
1186
11874.            Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?     Mark for Review
1188(1) Points
1189                True
1190                False (*)
1191
11925.            Matrix Diagrams are used to verify that all relationships have been identified for an ERD. True or False? Mark for Review
1193(1) Points
1194                True (*)
1195                False
1196
11976.            Which of the following are used to show a relationship on an ERD? (Choose Three)          Mark for Review
1198(1) Points
1199                                                (Choose all correct answers)      
1200                # symbol.
1201                Dashed line. (*)
1202                Crow's foot. (*)
1203                Solid line. (*)
1204
12057.            When reading the relationships in an ERD, you are said to be speaking:  Mark for Review
1206(1) Points
1207                Entity-ish
1208                Relationship-ish
1209                Gibberish
1210                ERDish (*)
1211
12128.            Relationship names are not shown on an ERD. True or False?      Mark for Review
1213(1) Points
1214                True
1215                False (*)
1216
12179.            ERDish describes a relationship in words. True or False? Mark for Review
1218(1) Points
1219                True (*)
1220                False
1221
122210.          Which of the following are true about Relationship Optionality? (Choose two)    Mark for Review
1223(1) Points
1224                                                (Choose all correct answers)      
1225                Optionality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
1226                Optionality answers "may or must". (*)
1227                Optionality specifies only singularity or plurality, but not a specific plural number.
1228                Optionality specifies whether something is required or not. (*)
1229
123011.          One Relationship can be mandatory in one direction and optional in the other direction. True or False?  Mark for Review
1231(1) Points
1232                True (*)
1233                False
1234
123512.          Relationships always exist between        Mark for Review
1236(1) Points
1237                3 or more attributes
1238                3 or more entities
1239                2 entities (or one entity and itself) (*)
1240                2 attributes
1241
124213.          Which of the following are true about Cardinality? (Choose two)               Mark for Review
1243(1) Points
1244                                                (Choose all correct answers)      
1245                Cardinality specifies whether something is required or not.
1246                Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
1247                Cardinality tells "how many". (*)
1248                Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
1249
125014. Which of the following are used to show Cardinality on an ERD? (Choose two)             Mark for Review
1251(1) Points
1252                                                (Choose all correct answers)      
1253                Single toe. (*)
1254                Crow's foot. (*)
1255                Dashed line.
1256                Solid line.
1257
125815.          What are the three properties that every relationship should have?        Mark for Review
1259(1) Points
1260                A UID bar, a diamond, an arc
1261                Transferability, degree, name
1262                Name, optionality, cardinality (*)
1263                Name, optionality, arcs
1264 Section 4 Quiz Database Design Oracle
1265Section 4 Quiz
1266            (Answer all questions in this section)
12671.         A business rule such as "All accounts must be paid in full within 10 days of billing" is best enforced by:       Mark for Review
1268(1) Points
1269                                                           
1270            Creating a message to be printed on every bill that reminds the customer to pay within ten days.
1271
1272            Making the relationship between CUSTOMER and PAYMENT fully mandatory and 1:1 on both sides.
1273
1274            Creating additional programming code to identify and report accounts past due. (*)
1275
1276            Making the payment attribute mandatory.
1277
12782.         A business rule such as "We only ship goods after customers have completely paid any outstanding balances on their account" is best enforced by:          Mark for Review
1279(1) Points
1280
1281            Creating additional programming code to verify no goods are shipped until the account has been settled in full. (*)
1282            Making the payment attribute null.
1283            We need to trust our customers, and we know they will pay some day.
1284            Making the payment attribute optional.
1285
12863. How should you handle constraints that cannot be modeled on an ER diagram? Mark for Review
1287(1) Points
1288            Always let the network architect handle them
1289            Explain them to the users so they can enforce them
1290            All constraints must be modeled and shown on the ER diagram
1291            List them on a separate document to be handled programmatically (*)
1292
12934.         Which of the following is an example of a structural business rule?  Mark for Review
1294(1) Points
1295            All employees must belong to at least one department. (*)
1296            All products will have a selling price no less than 30 % greater than wholesale.
1297            All overdue payments will have an added 10 % late fee.
1298            Buildings to be purchased by the business must be current with earthquake building code.
1299
13005.         Can all constraints be modeled on an ER diagram?   Mark for Review
1301(1) Points
1302
1303            No, and those that cannot be modeled should be listed on a separate document to be handled programmatically (*)
1304
1305            No, in which case you should let the database administrator handle them
1306            Yes, all constraints must be modeled and shown on the ER diagram
1307            No, but you just explain them to the users so they can enforce them
1308
13096.         Why is it important to identify and document business rules?           Mark for Review
1310(1) Points
1311            It allows you to create a complete data model and then check it for accuracy. (*)
1312            It allows you to improve the client's business.
1313            It ensures that the data model will automate all manual processes.
1314            None of the above
1315
13167.         How would you model a business rule that states that girls and boys may not attend classes together?            Mark for Review
1317(1) Points
1318
1319            Supertype STUDENT has two subtypes BOY and GIRL which are related to GENDER, which is related to CLASS (*)
1320            Use a supertype
1321            Make the attribute Gender optional
1322            Make the attribute Gender mandatory
1323
13248.         A subtype can have a relationship not shared by the supertype. True or False?         Mark for Review
1325(1) Points
1326            True (*)
1327            False
1328
13299.         A subtype is drawn on an ERD as an entity inside the "softbox" of the supertype. True or False?  Mark for Review
1330(1) Points
1331            True (*)
1332            False
1333
133410.       A subtype is shown on an ERD as an entity with a one to many relationship to the supertype. True or False?  Mark for Review
1335(1) Points
1336            True
1337            False (*)
1338
133911.       Which of the following is true about subtypes?         Mark for Review
1340(1) Points
1341            One instance of a supertype may belong to two subtypes.
1342            Subtypes should not be exhaustive.
1343            Subtypes must be mutually exclusive. (*)
1344            Subtypes must not be mutually exclusive.
1345
134612.       All instances of a subtype must be an instance of the supertype. True or False?       Mark for Review
1347(1) Points
1348            True (*)
1349            False
1350
135113.       A supertype can only have two subtypes and no more. True or False?          Mark for Review
1352(1) Points
1353            True
1354            False (*)
1355
135614.       You can only create relationships to a Supertype, not to a Subtype. True or False?  Mark for Review
1357(1) Points
1358            True
1359            False (*)
1360
136115.       A Supertype can have only one subtype. True or False?        Mark for Review
1362(1) Points
1363            True
1364            False (*)
1365
13661.         How would you model a business rule that states that on a student's birthday, he does not have to attend his classes?       Mark for Review
1367(1) Points
1368            Use a supertype
1369            Make the attribute Birthdate mandatory
1370            You cannot model this. You need to document it (*)
1371            Use a subtype
1372
13732.         Why is it important to identify and document business rules?           Mark for Review
1374(1) Points
1375            It allows you to create a complete data model and then check it for accuracy. (*)
1376            It allows you to improve the client's business.
1377            It ensures that the data model will automate all manual processes.
1378            None of the above
1379
13803.A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system. True or False?    Mark for Review
1381(1) Points
1382            True (*)
1383            False
1384
13854.         A business rule such as "All accounts must be paid in full within 10 days of billing" is best enforced by:       Mark for Review
1386(1) Points
1387            Creating additional programming code to identify and report accounts past due. (*)
1388
1389            Making the relationship between CUSTOMER and PAYMENT fully mandatory and 1:1 on both sides.
1390            Making the payment attribute mandatory.
1391            Creating a message to be printed on every bill that reminds the customer to pay within ten days.
1392
13935.         How should you handle constraints that cannot be modeled on an ER diagram?     Mark for Review
1394(1) Points
1395            Always let the network architect handle them
1396            List them on a separate document to be handled programmatically (*)
1397            All constraints must be modeled and shown on the ER diagram
1398            Explain them to the users so they can enforce them
13996.         Why is it important to identify and document structural rules?         Mark for Review
1400(1) Points
1401            Ensures we know what data to store and how that data works together. (*)
1402
1403            Ensures nothing. There are no benefits to be gained from documenting your Structural Business Rules. We need to concentrate on the Procedural Business Rules only.
1404
1405            Ensures we know what processes are in place and how to program them.
1406
1407            All of the Above.
1408
14097.         How would you model a business rule that states that girls and boys may not attend classes together?            Mark for Review
1410(1) Points
1411
1412            Supertype STUDENT has two subtypes BOY and GIRL which are related to GENDER, which is related to CLASS (*)
1413            Make the attribute Gender mandatory
1414            Make the attribute Gender optional
1415            Use a supertype
1416
14178.         A supertype can only have two subtypes and no more. True or False?          Mark for Review
1418(1) Points
1419            True
1420            False (*)
1421
14229.         All instances of the supertype must be an instance of one of the subtypes. True or False?   Mark for Review
1423(1) Points
1424            True (*)
1425            False
1426
142710.       A subtype is shown on an ERD as an entity with a one to many relationship to the supertype. True or False?  Mark for Review
1428(1) Points
1429            True
1430            False (*)
1431
143211.       Which of the following is true about subtypes?         Mark for Review
1433(1) Points
1434            Subtypes should not be exhaustive.
1435            Subtypes must not be mutually exclusive.
1436            Subtypes must be mutually exclusive. (*)
1437            One instance of a supertype may belong to two subtypes.
1438
143912.       You can only create relationships to a Supertype, not to a Subtype. True or False?  Mark for Review
1440(1) Points
1441            True
1442            False (*)
1443
144413.       A subtype can have a relationship not shared by the supertype. True or False?         Mark for Review
1445(1) Points
1446            True (*)
1447            False
1448
144914.       A Supertype can have only one subtype. True or False?        Mark for Review
1450(1) Points
1451            True
1452            False (*)
1453
145415.       All instances of a subtype must be an instance of the supertype. True or False?       Mark for Review
1455(1) Points
1456            True (*)
1457            False
1458
14591.         How would you model a business rule that states that girls and boys may not attend classes together?            Mark for Review
1460(1) Points
1461            Use a supertype
1462            Supertype STUDENT has two subtypes BOY and GIRL which are related to GENDER, which is related to CLASS (*)
1463            Make the attribute Gender optional
1464            Make the attribute Gender mandatory
1465
14662.         A business rule such as "We only ship goods after customers have completely paid any outstanding balances on their account" is best enforced by:          Mark for Review
1467(1) Points
1468            Making the payment attribute null.
1469
1470            Creating additional programming code to verify no goods are shipped until the account has been settled in full. (*)
1471
1472            We need to trust our customers, and we know they will pay some day.
1473
1474            Making the payment attribute optional.
1475
14763.         A business rule such as "All accounts must be paid in full within 10 days of billing" is best enforced by:       Mark for Review
1477(1) Points
1478
1479            Making the relationship between CUSTOMER and PAYMENT fully mandatory and 1:1 on both sides.
1480            Making the payment attribute mandatory.
1481            Creating a message to be printed on every bill that reminds the customer to pay within ten days.
1482            Creating additional programming code to identify and report accounts past due. (*)
1483
14844.         Can all constraints be modeled on an ER diagram?   Mark for Review
1485(1) Points
1486
1487            No, and those that cannot be modeled should be listed on a separate document to be handled programmatically (*)
1488
1489            No, in which case you should let the database administrator handle them
1490            Yes, all constraints must be modeled and shown on the ER diagram
1491            No, but you just explain them to the users so they can enforce them
1492
14935.         How would you model a business rule that states that on a student's birthday, he does not have to attend his classes?       Mark for Review
1494(1) Points
1495            Use a supertype
1496            You cannot model this. You need to document it (*)
1497            Make the attribute Birthdate mandatory
1498            Use a subtype
1499
15006.         A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system. True or False?    Mark for Review
1501(1) Points
1502            True (*)
1503            False
1504
15057.         Why is it important to identify and document business rules?           Mark for Review
1506(1) Points
1507            It allows you to create a complete data model and then check it for accuracy. (*)
1508            It allows you to improve the client's business.
1509            It ensures that the data model will automate all manual processes.
1510            None of the above
1511
15128.         All instances of a subtype may be an instance of the supertype but does not have to. True or False?            Mark for Review
1513(1) Points
1514            True
1515            False (*)
1516
15179.         A subtype can have a relationship not shared by the supertype. True or False?         Mark for Review
1518(1) Points
1519            True (*)
1520            False
1521
152210.       A subtype is shown on an ERD as an entity with a one to many relationship to the supertype. True or False?  Mark for Review
1523(1) Points
1524            True
1525            False (*)
1526
152711.       You can only create relationships to a Supertype, not to a Subtype. True or False?  Mark for Review
1528(1) Points
1529            True
1530            False (*)
1531
153212.       All ER diagrams must have one of each of the following: (Choose two)      Mark for Review
1533(1) Points
1534                                    (Choose all correct answers)  
1535            At least one supertype and subtype
1536            One or more Entities (*)
1537            Relationships between entities (*)
1538            Arcs
1539
154013.       Which of the following is true about subtypes?         Mark for Review
1541(1) Points
1542            Subtypes should not be exhaustive.
1543            Subtypes must be mutually exclusive. (*)
1544            Subtypes must not be mutually exclusive.
1545            One instance of a supertype may belong to two subtypes.
1546
154714.       A Supertype can have only one subtype. True or False?        Mark for Review
1548(1) Points
1549            True
1550            False (*)
1551
155215.       All instances of the supertype must be an instance of one of the subtypes. True or False?   Mark for Review
1553(1) Points
1554            True (*)
1555
1556            False
1557 Section 5 Quiz Database Design Oracle
1558Section 5 Quiz
1559            (Answer all questions in this section)
15601.         Relationships can be Redundant. True or False?          Mark for Review
1561(1) Points
1562            True (*)
1563            False
1564
15652.         If two entities have two relationships between them, these relationships can be either _____________ or _____________ .        Mark for Review
1566(1) Points
1567            Redundant and Replicated
1568            Resourced and Really Good
1569            Redundant or Required (*)
1570            Replicated or Required
1571
15723.         What uncommon relationship is described by the statements: "Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE"        Mark for Review
1573(1) Points
1574            One to One Optional (*)
1575            Many to Many Mandatory
1576            One to Many Mandatory
1577            One to Many Optional
1578
15794.         What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER"       Mark for Review
1580(1) Points
1581            One to Many (*)
1582            Many to Many
1583            Many to More
1584            One to One
1585
15865.         If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
1587(1) Points
1588            Replicated
1589            Redundant (*)
1590            Removable
1591            Resourceful
1592
15936.         A non-transferable relationship is represented by which of the following symbols?   Mark for Review
1594(1) Points
1595            Diamond (*)
1596            Heart
1597            Triangle
1598            Circle
1599
16007.         If a relationship can NOT be moved between instances of the entities it connects, it is said to be:      Mark for Review
1601(1) Points
1602            Mandatory
1603            Non-Transferable (*)
1604            Optional
1605            Transferable
1606
16078.         Every ERD must have at least one non-transferable relationship. True or False?         Mark for Review
1608(1) Points
1609            True
1610            False (*)
1611
16129.         Non-transferable relationships can only be mandatory, not optional. True or False?   Mark for Review
1613(1) Points
1614            True
1615            False (*)
1616
161710.       Which of the following is an example of a non-transferable relationship        Mark for Review
1618(1) Points
1619            PERSON to BIRTH PLACE (*)
1620            EMPLOYEE to DEPARTMENT
1621            TEACHER to SCHOOL
1622            STUDENT to COURSE
1623
162411.       When you resolve a M:M by creating an intersection entity, this new entity will always inherit:         Mark for Review
1625(1) Points
1626            The attributes of both related entities.
1627            The UID's from the entities in the original M:M.
1628            Nothing is inherited from the original entities and relationship.
1629            A relationship to each entity from the original M:M. (*)
1630
163112.       What do you call the entity created when you resolve a M:M relationship?     Mark for Review
1632(1) Points
1633            M:M entity
1634            Intersection entity (*)
1635            Inclusion entity
1636            Recursive entity
1637
163813.       Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False?  Mark for Review
1639(1) Points
1640            True (*)
1641            False
1642
164314.       When you resolve a M:M, you simply re-draw the relationships between the two original entities; no new entities are created. True or False?       Mark for Review
1644(1) Points
1645            True
1646            False (*)
1647
164815.       A relationship on an ERD can have attributes. True or False? Mark for Review
1649(1) Points
1650            True
1651            False (*)
1652
16531.         If a relationship can NOT be moved between instances of the entities it connects, it is said to be:      Mark for Review
1654(1) Points
1655            Non-Transferable (*)
1656            Optional
1657            Transferable
1658            Mandatory
1659
16602.         Every ERD must have at least one non-transferable relationship. True or False?         Mark for Review
1661(1) Points
1662            True
1663            False (*)
1664
16653.         If a relationship can be moved between instances of the entities it connects, it is said to be:   Mark for Review
1666(1) Points
1667            Recursive
1668            Committed
1669            Implicit
1670            Transferable (*)
1671
16724.         Non-transferable relationships can only be mandatory, not optional. True or False?   Mark for Review
1673(1) Points
1674            True
1675            False (*)
1676
16775.         A non-transferable relationship means the relationship is manatory at both sides. True or False?       Mark for Review
1678(1) Points
1679            True
1680            False (*)
1681
16826.         If two entities have two relationships between them, these relationships can be either _____________ or _____________ .        Mark for Review
1683(1) Points
1684            Replicated or Required
1685            Redundant or Required (*)
1686            Redundant and Replicated
1687            Resourced and Really Good
1688
16897.         If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
1690(1) Points
1691            Removable
1692            Replicated
1693            Resourceful
1694            Redundant (*)
1695
16968.         Which of the following pairs of entities is most likely to be modeled as a 1:1 relationship?    Mark for Review
1697(1) Points
1698            TEACHER and SUBJECT AREA
1699            TREE and BRANCH
1700            PERSON and FINGERPRINT (*)
1701            CAR and WHEEL
1702
17039.         Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
1704(1) Points
1705            TREE and BRANCH
1706            TEACHER and SUBJECT AREA (*)
1707            CAR and WHEEL
1708            PERSON and FINGERPRINT
1709
171010.       One to many relationships are the most uncommon type of relationships in an ERD. True or False?  Mark for Review
1711(1) Points
1712            True
1713            False (*)
1714
171511.       When you resolve a M:M by creating an intersection entity, this new entity will always inherit:         Mark for Review
1716(1) Points
1717            The attributes of both related entities.
1718            The UID's from the entities in the original M:M.
1719            Nothing is inherited from the original entities and relationship.
1720            A relationship to each entity from the original M:M. (*)
1721
172212.       A barred relationship on an ERD signifies that the UID of the intersection entity is inherited from the entities that made up the original many to many relationship. True or False?  Mark for Review
1723(1) Points
1724            True (*)
1725            False
1726
172713.       Many to many relationships between entities usually hide what?        Mark for Review
1728(1) Points
1729            More attributes
1730            Uniqueness
1731            Another relationship
1732            Another entity (*)
1733
173414.       If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by        Mark for Review
1735(1) Points
1736            Creating new attributes.
1737            Barring the relationships to the original entities. (*)
1738            Placing the UID attributes from the original entities into the intersection entity.
1739            None of the above.
1740
174115.       Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False?  Mark for Review
1742(1) Points
1743            True (*)
1744            False
1745
17461.         Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False?  Mark for Review
1747(1) Points
1748            True
1749            False (*)
1750
17512.         What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER"       Mark for Review
1752(1) Points
1753            Many to Many
1754            Many to More
1755            One to One
1756            One to Many (*)
1757
17583.         If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
1759(1) Points
1760            Redundant (*)
1761            Resourceful
1762            Removable
1763            Replicated
1764
17654.         One to many relationships are the most uncommon type of relationships in an ERD. True or False?  Mark for Review
1766(1) Points
1767            True
1768            False (*)
1769
17705.         Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
1771(1) Points
1772            CAR and WHEEL
1773            TREE and BRANCH
1774            PERSON and FINGERPRINT
1775            TEACHER and SUBJECT AREA (*)
1776
17776.         A Diamond on a relationship indicates the Relationship as Non-Tranferable. True or False?  Mark for Review
1778(1) Points
1779            True (*)
1780            False
1781
17827.         Every ERD must have at least one non-transferable relationship. True or False?         Mark for Review
1783(1) Points
1784            True
1785            False (*)
1786
17878.         If a relationship can NOT be moved between instances of the entities it connects, it is said to be:      Mark for Review
1788(1) Points
1789            Optional
1790            Mandatory
1791            Non-Transferable (*)
1792            Transferable
1793
17949.         The relationship between CUSTOMER and RECEIPT is an example of a non-transferable relationship. True or False?  Mark for Review
1795(1) Points
1796            True (*)
1797            False
1798
179910.       If a relationship can be moved between instances of the entities it connects, it is said to be:   Mark for Review
1800(1) Points
1801            Recursive
1802            Implicit
1803            Transferable (*)
1804            Committed
1805
180611.       If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by        Mark for Review
1807(1) Points
1808            Creating new attributes.
1809            Barring the relationships to the original entities. (*)
1810            Placing the UID attributes from the original entities into the intersection entity.
1811            None of the above.
1812
181312.       When you resolve a M:M, you simply re-draw the relationships between the two original entities; no new entities are created. True or False?       Mark for Review
1814(1) Points
1815            True
1816            False (*)
1817
181813.       Many to many relationships between entities usually hide what?        Mark for Review
1819(1) Points
1820            More attributes
1821            Another relationship
1822            Uniqueness
1823            Another entity (*)
1824
182514.       A barred relationship on an ERD signifies that the UID of the intersection entity is inherited from the entities that made up the original many to many relationship. True or False?  Mark for Review
1826(1) Points
1827            True (*)
1828            False
1829
183015.       Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False?  Mark for Review
1831(1) Points
1832            True (*)
1833            False
1834
18351.         When you resolve a M:M by creating an intersection entity, this new entity will always inherit:         Mark for Review
1836(1) Points
1837            A relationship to each entity from the original M:M. (*)
1838            The attributes of both related entities.
1839            The UID's from the entities in the original M:M.
1840            Nothing is inherited from the original entities and relationship.
1841
18422.         What do you call the entity created when you resolve a M:M relationship?     Mark for Review
1843(1) Points
1844            M:M entity
1845            Inclusion entity
1846            Intersection entity (*)
1847            Recursive entity
1848
18493.         Many to many relationships between entities usually hide what?        Mark for Review
1850(1) Points
1851            Uniqueness
1852            Another relationship
1853            Another entity (*)
1854            More attributes
1855
18564.         A relationship on an ERD can have attributes. True or False? Mark for Review
1857(1) Points
1858            True
1859            False (*)
1860
18615.         If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by        Mark for Review
1862(1) Points
1863            Creating new attributes.
1864            Barring the relationships to the original entities. (*)
1865            Placing the UID attributes from the original entities into the intersection entity.
1866            None of the above.
1867
18686.         A Diamond on a relationship indicates the Relationship as Non-Tranferable. True or False?  Mark for Review
1869(1) Points
1870            True (*)
1871            False
1872
18737.         Non-transferable relationships can only be mandatory, not optional. True or False?   Mark for Review
1874(1) Points
1875            True
1876            False (*)
1877
18788.         The relationship between CUSTOMER and RECEIPT is an example of a non-transferable relationship. True or False?  Mark for Review
1879(1) Points
1880            True (*)
1881            False
1882
18839.         If a relationship can NOT be moved between instances of the entities it connects, it is said to be:      Mark for Review
1884(1) Points
1885            Non-Transferable (*)
1886            Optional
1887            Transferable
1888            Mandatory
1889
189010.       A non-transferable relationship means the relationship is manatory at both sides. True or False?       Mark for Review
1891(1) Points
1892            True
1893            False (*)
1894
189511.       Which of the following pairs of entities is most likely to be modeled as a 1:1 relationship?    Mark for Review
1896(1) Points
1897            PERSON and FINGERPRINT (*)
1898            CAR and WHEEL
1899            TEACHER and SUBJECT AREA
1900            TREE and BRANCH
1901
190212.       What uncommon relationship is described by the statements: "Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE"        Mark for Review
1903(1) Points
1904            One to One Optional (*)
1905            One to Many Mandatory
1906            Many to Many Mandatory
1907            One to Many Optional
1908
190913.       Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
1910(1) Points
1911            TREE and BRANCH
1912            PERSON and FINGERPRINT
1913            CAR and WHEEL
1914            TEACHER and SUBJECT AREA (*)
1915
191614.       What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER"       Mark for Review
1917(1) Points
1918            One to Many (*)
1919            One to One
1920            Many to More
1921            Many to Many
1922
192315.       Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False?  Mark for Review
1924(1) Points
1925            True
1926
1927            False (*)
1928
1929 Section 6 Quiz Database Design Oracle
1930Section 6 Quiz
1931            (Answer all questions in this section)
1932
19331.         Examine the following Entity and decide which rule of Normal Form is being violated:
1934ENTITY: CLIENT
1935ATTRIBUTES:
1936    # CLIENT ID
1937    FIRST NAME
1938    LAST NAME
1939    STREET
1940    CITY
1941    ZIP CODE
1942 Mark for Review
1943(1) Points
1944            1st Normal Form.
1945            2nd Normal Form.
1946            3rd Normal Form.
1947            None of the above, the entity is fully normalised. (*)
1948
19492.         A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity.            Mark for Review
1950(1) Points
1951            True (*)
1952            False
1953
19543.         When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:        Mark for Review
1955(1) Points
1956            Functional dependency
1957            Dependency
1958            Transitive dependency (*)
1959            Non-dependency
1960
19614.         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
1962(1) Points
1963            True (*)
1964            False
1965
19665.         Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False?  Mark for Review
1967(1) Points
1968            True (*)
1969            False
1970
19716.         When all attributes are single-valued, the database model is said to conform to:      Mark for Review
1972(1) Points
1973            2nd Normal Form
1974            4th Normal Form
1975            1st Normal Form (*)
1976            3rd Normal Form
1977
19787.         If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we:     Mark for Review
1979(1) Points
1980
1981            Create an additional entity and relate it to the original entity with a 1:M relationship. (*)
1982
1983            Make the attribute optional
1984            Create an additional entity and relate it to the original entity with a M:M relationship.
1985            Do nothing, an entity does not have to be in 1st Normal Form
1986
19878.         When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review
1988(1) Points
1989            Reduction
1990            Normality
1991            Multiplication
1992            Normalization (*)
1993
19949. There is no limit to how many columns can make up an entity's UID. True or False?       Mark for Review
1995(1) Points
1996            True (*)
1997            False
1998
199910.       If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?            Mark for Review
2000(1) Points
2001            True (*)
2002            False
2003
200411.       A unique identifier can only be made up of one attribute. True or False?     Mark for Review
2005(1) Points
2006            True
2007            False (*)
2008
200912.       An entity can only have one Primary UID. True or False?     Mark for Review
2010(1) Points
2011            True (*)
2012            False
2013
201413.       To resolve a 2nd Normal Form violation, we: Mark for Review
2015(1) Points
2016
2017            Move the attribute that violates 2nd Normal Form to a new entity with a relationship to the original entity. (*)
2018
2019            Move the attribute that violates 2nd Normal Form to a new ERD.
2020            Do nothing, an entity does not need to be in 2nd Normal Form.
2021            Delete the attribute that was causing the violation.
2022
202314.       Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:
2024ENTITY: RECEIPT
2025ATTRIBUTES:
2026   #CUSTOMER ID
2027   #STORE ID
2028   STORE LOCATION
2029   DATE
2030 Mark for Review
2031(1) Points
2032            Do nothing, it is already in 2nd Normal Form.
2033            Delete the attribute STORE ID
2034
2035            Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity. (*)
2036
2037            Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.
2038
203915.       Any Non-UID attribute must be dependent upon the entire UID. True or False?    Mark for Review
2040(1) Points
2041            True (*)
2042            False
2043
20441.         Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two)          Mark for Review
2045(1) Points
2046                                    (Choose all correct answers)  
2047            Social Security Number (*)
2048            Last Name
2049            Employee ID (*)
2050            Address
2051
20522.         There is no limit to how many columns can make up an entity's UID. True or False?           Mark for Review
2053(1) Points
2054            True (*)
2055            False
2056
20573.         A unique identifier can only be made up of one attribute. True or False?     Mark for Review
2058(1) Points
2059            True
2060            False (*)
2061
20624.         If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?            Mark for Review
2063(1) Points
2064            True (*)
2065            False
2066
20675.         Examine the following Entity and decide which rule of Normal Form is being violated:
2068ENTITY: CLIENT
2069ATTRIBUTES:
2070    # CLIENT ID
2071    FIRST NAME
2072    LAST NAME
2073    ORDER ID
2074    STREET
2075    ZIP CODE
2076 Mark for Review
2077(1) Points
2078            1st Normal Form. (*)
2079            2nd Normal Form.
2080            3rd Normal Form.
2081            None of the above, the entity is fully normalised.
2082
20836.         A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity.            Mark for Review
2084(1) Points
2085            True (*)
2086            False
2087
20887.         Examine the following Entity and decide which rule of Normal Form is being violated:
2089ENTITY: CLIENT
2090ATTRIBUTES:
2091    # CLIENT ID
2092    FIRST NAME
2093    LAST NAME
2094    STREET
2095    CITY
2096    ZIP CODE
2097 Mark for Review
2098(1) Points
2099            1st Normal Form.
2100            2nd Normal Form.
2101            3rd Normal Form.
2102            None of the above, the entity is fully normalised. (*)
2103
21048.         Examine the following Entity and decide which rule of Normal Form is being violated:
2105ENTITY: CLIENT ORDER
2106ATTRIBUTES:
2107    # CLIENT ID
2108    # ORDER ID
2109    FIRST NAME
2110    LAST NAME
2111    ORDER DATE
2112    CITY
2113    ZIP CODE
2114 Mark for Review
2115(1) Points
2116            1st Normal Form.
2117            2nd Normal Form. (*)
2118            3rd Normal Form.
2119            None of the above, the entity is fully normalised.
2120
21219.         Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False?  Mark for Review
2122(1) Points
2123            True (*)
2124            False
2125
212610.       If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we:     Mark for Review
2127(1) Points
2128            Do nothing, an entity does not have to be in 1st Normal Form
2129            Create an additional entity and relate it to the original entity with a M:M relationship.
2130            Make the attribute optional
2131            Create an additional entity and relate it to the original entity with a 1:M relationship. (*)
2132
213311.       An entity can have repeated values and still be in 1st Normal Form. True or False? Mark for Review
2134(1) Points
2135            True
2136            False (*)
2137
213812.       When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review
2139(1) Points
2140            Reduction
2141            Multiplication
2142            Normalization (*)
2143            Normality
2144
214513.       To resolve a 2nd Normal Form violation, we: Mark for Review
2146(1) Points
2147            Do nothing, an entity does not need to be in 2nd Normal Form.
2148            Delete the attribute that was causing the violation.
2149            Move the attribute that violates 2nd Normal Form to a new ERD.
2150            Move the attribute that violates 2nd Normal Form to a new entity with a relationship to the original entity. (*)
2151
215214.       Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:
2153ENTITY: RECEIPT
2154ATTRIBUTES:
2155   #CUSTOMER ID
2156   #STORE ID
2157   STORE LOCATION
2158   DATE
2159 Mark for Review
2160(1) Points
2161
2162            Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity. (*)
2163
2164            Do nothing, it is already in 2nd Normal Form.
2165            Delete the attribute STORE ID
2166
2167            Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.
2168
216915.       Any Non-UID attribute must be dependent upon the entire UID. True or False?   
2170Mark for Review
2171(1) Points
2172            True (*)
2173            False
2174
21751.         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
2176(1) Points
2177            True
2178            False (*)
2179
21802.         Examine the following Entity and decide which rule of Normal Form is being violated:
2181ENTITY: CLIENT
2182ATTRIBUTES:
2183    # CLIENT ID
2184    FIRST NAME
2185    LAST NAME
2186    STREET
2187    CITY
2188    ZIP CODE
2189 Mark for Review
2190(1) Points
2191            1st Normal Form.
2192            2nd Normal Form.
2193            3rd Normal Form.
2194            None of the above, the entity is fully normalised. (*)
2195
21963.         When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:        Mark for Review
2197(1) Points
2198            Transitive dependency (*)
2199            Functional dependency
2200            Dependency
2201            Non-dependency
2202
22034.         A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity.            Mark for Review
2204(1) Points
2205            True (*)
2206            False
2207
22085.         An entity can only have one Primary UID. True or False?     Mark for Review
2209(1) Points
2210            True (*)
2211            False
2212
22136.         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
2214(1) Points
2215            Yes, this is the way UID's are named. (*)
2216            No, each Entity can only have one UID, the secondary one.
2217            No, it is not possible to have more than one UID for an Entity.
2218            No, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc.
2219
22207.         Where an entity has more than one attribute suitable to be the Primary UID, these are known as _____________ UIDs.           Mark for Review
2221(1) Points
2222            Composite
2223            Simple
2224            Secondary
2225            Candidate (*)
2226
22278.         Which of the following would be suitable UIDs for the entity EMPLOYEE: (Choose Two)          Mark for Review
2228(1) Points
2229                                    (Choose all correct answers)  
2230            Address
2231            Employee ID (*)
2232            Social Security Number (*)
2233            Last Name
2234
22359.         Any Non-UID attribute must be dependent upon the entire UID. True or False?    Mark for Review
2236(1) Points
2237            True (*)
2238            False
2239
224010. What is the rule of Second Normal Form?           Mark for Review
2241(1) Points
2242            No non-UID attributes can be dependent on any part of the UID.
2243            Some non-UID attributes can be dependent on the entire UID.
2244            All non-UID attributes must be dependent upon the entire UID. (*)
2245            None of the above
2246
224711.       Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:
2248ENTITY: RECEIPT
2249ATTRIBUTES:
2250   #CUSTOMER ID
2251   #STORE ID
2252   STORE LOCATION
2253   DATE
2254 Mark for Review
2255(1) Points
2256            Delete the attribute STORE ID
2257
2258            Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.
2259
2260            Do nothing, it is already in 2nd Normal Form.
2261
2262            Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity. (*)
2263
226412.       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
2265(1) Points
2266            True
2267            False (*)
2268
226913.       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
2270(1) Points
2271            True
2272            False (*)
2273
227414.       An entity can have repeated values and still be in 1st Normal Form. True or False? Mark for Review
2275(1) Points
2276            True
2277            False (*)
2278
227915.       Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False?  Mark for Review
2280(1) Points
2281            True (*)
2282            False
2283
22841.         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
2285(1) Points
2286            No, it is not possible to have more than one UID for an Entity.
2287            No, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc.
2288            No, each Entity can only have one UID, the secondary one.
2289            Yes, this is the way UID's are named. (*)
2290
22912.         Where an entity has more than one attribute suitable to be the Primary UID, these are known as _____________ UIDs.           Mark for Review
2292(1) Points
2293            Secondary
2294            Composite
2295            Candidate (*)
2296            Simple
2297
22983.         If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?            Mark for Review
2299(1) Points
2300            True (*)
2301            False
2302
23034.         A candidate UID that is not chosen to be the Primary UID is called:           Mark for Review
2304(1) Points
2305            Composite
2306            Secondary (*)
2307            Simple
2308            Artificial
2309
23105.         What is the rule of Second Normal Form?     Mark for Review
2311(1) Points
2312            No non-UID attributes can be dependent on any part of the UID.
2313            Some non-UID attributes can be dependent on the entire UID.
2314            All non-UID attributes must be dependent upon the entire UID. (*)
2315            None of the above
2316
23176.         Examine the following entity and decide which attribute breaks the 2nd Normal Form rule:
2318ENTITY: RECEIPT
2319ATTRIBUTES:
2320   #CUSTOMER ID
2321   #STORE ID
2322   STORE LOCATION
2323   DATE
2324 Mark for Review
2325(1) Points
2326            STORE LOCATION (*)
2327            CUSTOMER ID
2328            DATE
2329            STORE ID
2330
23317.         When is an entity in 2nd Normal Form?         Mark for Review
2332(1) Points
2333            When all non-UID attributes are dependent upon the entire UID. (*)
2334            When attributes with repeating or multi-values are present.
2335            When no attritibutes are mutually independent and all are fully dependent on the primary key.
2336            None of the Above.
2337
23388.         When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:        Mark for Review
2339(1) Points
2340            Non-dependency
2341            Functional dependency
2342            Dependency
2343            Transitive dependency (*)
2344
23459.         Examine the following Entity and decide which rule of Normal Form is being violated:
2346ENTITY: CLIENT
2347ATTRIBUTES:
2348    # CLIENT ID
2349    FIRST NAME
2350    LAST NAME
2351    ORDER ID
2352    STREET
2353    ZIP CODE
2354 Mark for Review
2355(1) Points
2356            1st Normal Form. (*)
2357            2nd Normal Form.
2358            3rd Normal Form.
2359            None of the above, the entity is fully normalised.
2360
236110.       Examine the following Entity and decide which rule of Normal Form is being violated:
2362ENTITY: CLIENT
2363ATTRIBUTES:
2364    # CLIENT ID
2365    FIRST NAME
2366    LAST NAME
2367    STREET
2368    CITY
2369    ZIP CODE
2370 Mark for Review
2371(1) Points
2372            1st Normal Form.
2373            2nd Normal Form.
2374            3rd Normal Form.
2375            None of the above, the entity is fully normalised. (*)
2376
237711.       A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity.            Mark for Review
2378(1) Points
2379            True (*)
2380            False
2381
238212.       Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False?  Mark for Review
2383(1) Points
2384            True (*)
2385            False
2386
238713.       If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we:     Mark for Review
2388(1) Points
2389            Make the attribute optional
2390            Do nothing, an entity does not have to be in 1st Normal Form
2391            Create an additional entity and relate it to the original entity with a M:M relationship.
2392            Create an additional entity and relate it to the original entity with a 1:M relationship. (*)
2393
239414.       When data is only stored in one place in a database, the database conforms to the rules of ___________. Mark for Review
2395(1) Points
2396            Multiplication
2397            Normality
2398            Reduction
2399            Normalization (*)
2400
240115.       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
2402(1) Points
2403            True
2404
2405            False (*)
2406
2407 Section 7 Quiz Database Design Oracle
2408Section 7 Quiz
2409                (Answer all questions in this section)
2410
24111.            Which of the following would best be represented by an arc?    Mark for Review
2412(1) Points
2413                STUDENT (senior, male)
2414                STUDENT (Grade A student, Average Student)
2415                STUDENT (graduating, female)
2416                STUDENT ( University, Technical College) (*)
2417
24182.            Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False?            Mark for Review
2419(1) Points
2420                True
2421                False (*)
2422
24233.            To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.         Mark for Review
2424(1) Points
2425                Arc (*)
2426                Relationship
2427                Attribute
2428                UID
2429
24304.            An arc can often be modeled as Supertype and Subtypes. True or False?              Mark for Review
2431(1) Points
2432                True (*)
2433                False
2434
24355.            Which of the following would best be represented by an arc?    Mark for Review
2436(1) Points
2437                TEACHER (Female, Bob)
2438                PARENT (Girl, Bob)
2439                DELIVERY ADDRESS (Home, Office) (*)
2440                STUDENT (Grade A student, Average Student)
2441
24426.            All relationships participating in an arc must be mandatory. True or False?             Mark for Review
2443(1) Points
2444                True
2445                False (*)
2446
24477.            Every business has restrictions on which attribute values and which relationships are allowed. These are known as:           Mark for Review
2448(1) Points
2449                Constraints. (*)
2450                Relationships
2451                Entities.
2452                Attributes
2453
24548.            Arcs are used to visually represent _________ between two or more relationships in an ERD.   Mark for Review
2455(1) Points
2456                Differences
2457                Inheritance
2458                Sameness
2459                Exclusivity (*)
2460
24619.            Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
2462(1) Points
2463                Invalid Relationship
2464                Recursive Relationship
2465                General Relationship
2466                Heirarchical Relationship (*)
2467
246810.          A relationship between an entity and itself is called a/an:             Mark for Review
2469(1) Points
2470                Recursive Relationship (*)
2471                Invalid Relationship
2472                Heirarchical Relationship
2473                General Relationship
2474
247511.          A Recursive Relationship is represented on an ERD by a/an:         Mark for Review
2476(1) Points
2477                Single Toe
2478                Pig's Ear (*)
2479                Crow's Foot
2480                Dog's Tail
2481
248212.          A single relationship can be both Recursive and Hierarchical at the same time. True or False?       Mark for Review
2483(1) Points
2484                True
2485                False (*)
2486
248713.          Business organizational charts are often modeled as a Hierarchical relationship. True or False?    Mark for Review
2488(1) Points
2489                True (*)
2490                False
2491
249214.          A recursive relationship must be Mandatory at both ends. True or False?              Mark for Review
2493(1) Points
2494                True
2495                False (*)
2496
249715.          A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?    Mark for Review
2498(1) Points
2499                True (*)
2500                False
2501
25021.            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
2503(1) Points
2504                True (*)
2505                False
2506
25072.            A single relationship can be both Recursive and Hierarchical at the same time. True or False?       Mark for Review
2508(1) Points
2509                True
2510                False (*)
2511
25123.            A Recursive Relationship is represented on an ERD by a/an:         Mark for Review
2513(1) Points
2514                Single Toe
2515                Dog's Tail
2516                Pig's Ear (*)
2517                Crow's Foot
2518
25194.            Business organizational charts are often modeled as a Hierarchical relationship. True or False?    Mark for Review
2520(1) Points
2521                True (*)
2522                False
2523
25245.            A relationship between an entity and itself is called a/an:             Mark for Review
2525(1) Points
2526                General Relationship
2527                Recursive Relationship (*)
2528                Heirarchical Relationship
2529                Invalid Relationship
2530
25316.            A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?    Mark for Review
2532(1) Points
2533                True (*)
2534                False
2535
25367.            Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
2537(1) Points
2538                Recursive Relationship
2539                General Relationship
2540                Invalid Relationship
2541                Heirarchical Relationship (*)
2542
25438. Which of the following would best be represented by an arc?                Mark for Review
2544(1) Points
2545                STUDENT (senior, male)
2546                STUDENT ( University, Technical College) (*)
2547                STUDENT (Grade A student, Average Student)
2548                STUDENT (graduating, female)
2549
25509.            To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.         Mark for Review
2551(1) Points
2552                Relationship
2553                Arc (*)
2554                UID
2555                Attribute
2556
255710.          All relationships participating in an arc must be mandatory. True or False?             Mark for Review
2558(1) Points
2559                True
2560                False (*)
2561
256211.          An arc can often be modeled as Supertype and Subtypes. True or False?              Mark for Review
2563(1) Points
2564                True (*)
2565                False
2566
256712.          Arcs are used to visually represent _________ between two or more relationships in an ERD.   Mark for Review
2568(1) Points
2569                Sameness
2570                Differences
2571                Exclusivity (*)
2572                Inheritance
2573
257413.          Which of the following can be added to a relationship?  Mark for Review
2575(1) Points
2576                An optional attribute can be created
2577                A composite attribute
2578                An attribute
2579                An arc can be assigned (*)
2580
258114.          Which of the following would best be represented by an arc?    Mark for Review
2582(1) Points
2583                TEACHER (Female, Bob)
2584                STUDENT (Grade A student, Average Student)
2585                DELIVERY ADDRESS (Home, Office) (*)
2586                PARENT (Girl, Bob)
2587
258815.          Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False?            Mark for Review
2589(1) Points
2590                True
2591                False (*)
2592
25931.            A relationship between an entity and itself is called a/an:             Mark for Review
2594(1) Points
2595                Invalid Relationship
2596                Recursive Relationship (*)
2597                General Relationship
2598                Heirarchical Relationship
2599
26002.            A recursive relationship must be Mandatory at both ends. True or False?              Mark for Review
2601(1) Points
2602                True
2603                False (*)
2604
26053.            A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?    Mark for Review
2606(1) Points
2607                True (*)
2608                False
2609
26104.            A single relationship can be both Recursive and Hierarchical at the same time. True or False?       Mark for Review
2611(1) Points
2612                True
2613                False (*)
2614
26155.            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
2616(1) Points
2617                True (*)
2618                False
2619
26206.            Business organizational charts are often modeled as a Hierarchical relationship. True or False?    Mark for Review
2621(1) Points
2622                True (*)
2623                False
2624
26257.            A Recursive Relationship is represented on an ERD by a/an:         Mark for Review
2626(1) Points
2627                Single Toe
2628                Pig's Ear (*)
2629                Crow's Foot
2630                Dog's Tail
2631
26328.            Which of the following can be added to a relationship?  Mark for Review
2633(1) Points
2634                An arc can be assigned (*)
2635                An optional attribute can be created
2636                An attribute
2637                A composite attribute
2638
26399.            Every business has restrictions on which attribute values and which relationships are allowed. These are known as:           Mark for Review
2640(1) Points
2641                Attributes
2642                Constraints. (*)
2643                Entities.
2644                Relationships
2645
264610.          Which of the following would best be represented by an arc?    Mark for Review
2647(1) Points
2648                TEACHER (Female, Bob)
2649                DELIVERY ADDRESS (Home, Office) (*)
2650                PARENT (Girl, Bob)
2651                STUDENT (Grade A student, Average Student)
2652
265311.          An arc can often be modeled as Supertype and Subtypes. True or False?              Mark for Review
2654(1) Points
2655                True (*)
2656                False
2657
265812.          Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False?            Mark for Review
2659(1) Points
2660                True
2661                False (*)
2662
266313.          To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.         Mark for Review
2664(1) Points
2665                Attribute
2666                Relationship
2667                UID
2668                Arc (*)
2669
267014.          Arcs model an Exclusive OR constraint. True or False?     Mark for Review
2671(1) Points
2672                True (*)
2673                False
2674
267515.          Arcs are used to visually represent _________ between two or more relationships in an ERD.   Mark for Review
2676(1) Points
2677                Differences
2678                Sameness
2679                Exclusivity (*)
2680                Inheritance
2681
26821.            All relationships participating in an arc must be mandatory. True or False?             Mark for Review
2683(1) Points
2684                True
2685                False (*)
2686
26872.            Arcs model an Exclusive OR constraint. True or False?     Mark for Review
2688(1) Points
2689                True (*)
2690                False
2691
26923.            An arc can often be modeled as Supertype and Subtypes. True or False?              Mark for Review
2693(1) Points
2694                True (*)
2695                False
2696
26974.            Which of the following would best be represented by an arc?    Mark for Review
2698(1) Points
2699                STUDENT (Grade A student, Average Student)
2700                TEACHER (Female, Bob)
2701                DELIVERY ADDRESS (Home, Office) (*)
2702                PARENT (Girl, Bob)
2703
27045.            To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.         Mark for Review
2705(1) Points
2706                UID
2707                Arc (*)
2708                Attribute
2709                Relationship
2710
27116.            Which of the following would best be represented by an arc?    Mark for Review
2712(1) Points
2713                STUDENT (graduating, female)
2714                STUDENT ( University, Technical College) (*)
2715                STUDENT (Grade A student, Average Student)
2716                STUDENT (senior, male)
2717
27187.            Arcs are used to visually represent _________ between two or more relationships in an ERD.   Mark for Review
2719(1) Points
2720                Exclusivity (*)
2721                Differences
2722                Inheritance
2723                Sameness
2724
27258.            Every business has restrictions on which attribute values and which relationships are allowed. These are known as:           Mark for Review
2726(1) Points
2727                Entities.
2728                Relationships
2729                Constraints. (*)
2730                Attributes
2731
27329.            A single relationship can be both Recursive and Hierarchical at the same time. True or False?       Mark for Review
2733(1) Points
2734                True
2735                False (*)
2736
273710.          A recursive relationship must be Mandatory at both ends. True or False?              Mark for Review
2738(1) Points
2739                True
2740                False (*)
2741
274211.          Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
2743(1) Points
2744                Recursive Relationship
2745                General Relationship
2746                Heirarchical Relationship (*)
2747                Invalid Relationship
2748
274912.          A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?    Mark for Review
2750(1) Points
2751                True (*)
2752                False
2753
275413.          A Recursive Relationship is represented on an ERD by a/an:         Mark for Review
2755(1) Points
2756                Crow's Foot
2757                Single Toe
2758                Pig's Ear (*)
2759                Dog's Tail
2760
276114.          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
2762(1) Points
2763                True (*)
2764                False
2765
276615.          Business organizational charts are often modeled as a Hierarchical relationship. True or False?    Mark for Review
2767(1) Points
2768                True (*)
2769
2770                False
2771
2772 Section 8 Quiz Database Design Oracle
2773Section 8 Quiz
2774                (Answer all questions in this section)
2775
27761.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
2777(1) Points
2778                                                (Choose all correct answers)      
2779                BABY and AGE
2780                CUSTOMER and ORDERS (*)
2781                TEACHER and AGE
2782                CUSTOMER and PAYMENTS (*)
2783
27842.            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
2785(1) Points
2786                True
2787                False (*)
2788
27893.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
2790(1) Points
2791                                                (Choose all correct answers)      
2792                LIBRARY and BOOK (*)
2793                STUDENT and GRADE (*)
2794                STUDENT and AGE
2795                LIBRARY and NUMBER OF BOOKS
2796
27974.            Which of the following statements are true for ERD's to enhance their readability. (Choose Two)              Mark for Review
2798(1) Points
2799                                                (Choose all correct answers)      
2800
2801                You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram.
2802
2803                The crows feet (many ends) can point whichever way is the easiest to draw.
2804
2805                Avoid crossing one relationship line with another. (*)
2806
2807                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. (*)
2808
28095.            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
2810(1) Points
2811                True (*)
2812                False
2813
28146.            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
2815(1) Points
2816                True
2817                False (*)
2818
28197. 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
2820(1) Points
2821                True
2822                False (*)
2823
28248.            All systems must include functionality to provide logging or journaling in conceptual data models. True or False?   Mark for Review
2825(1) Points
2826                True
2827                False (*)
2828
28299.            Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?               Mark for Review
2830(1) Points
2831                End Date must be before the Start Date.
2832                EMPLOYEE periods can overlap causing the database to crash.
2833                Dates must be stored with Time.
2834
2835                An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)
2836
283710.          What is the function of logging or journaling in conceptual data models?               Mark for Review
2838(1) Points
2839                Represents entities as time in the data model.
2840                Creates a fixed time for all events in a data model.
2841                Gives a timestamp to all entities.
2842                Allows you to track the history of attribute values, relationships, and/or entire entities (*)
2843
284411.          How do you know when to use the different types of time in your design?          Mark for Review
2845(1) Points
2846                It depends on the functional needs of the system . (*)
2847                Always model time; you can take it out later if it is not needed.
2848                You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
2849                The rules are fixed and should be followed.
2850
285112.          Which of the following would be a logical constraint when modeling time for a country entity?   Mark for Review
2852(1) Points
2853                If you are doing a system for France or Germany, you would need security clearance.
2854                Daily traffic patterns must be monitored to determine which countries are overcrowded.
2855                Countries may change their names and/or borders over a period of time. (*)
2856                People have births and deaths in their countries that must be tracked by the system.
2857
285813.          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
2859(1) Points
2860                True (*)
2861                False
2862
286314.          Modeling historical data is optional. True or False?           Mark for Review
2864(1) Points
2865                True (*)
2866                False
2867
286815.          When a relationship may or may not be transferable, depending on time, this is know as a/an:  Mark for Review
2869(1) Points
2870                Transferable Relationship
2871                Non-transferable Relationship.
2872                Conditional Non-transferable Relationship. (*)
2873                Arc.
2874
28751.            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
2876(1) Points
2877                True
2878                False (*)
2879
28802.            Which of the following statements are true for ERD's to enhance their readability. (Choose Two)              Mark for Review
2881(1) Points
2882                                                (Choose all correct answers)      
2883                You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram.
2884
2885                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. (*)
2886
2887                The crows feet (many ends) can point whichever way is the easiest to draw.
2888
2889                Avoid crossing one relationship line with another. (*)
2890
28913.            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
2892(1) Points
2893                True (*)
2894                False
2895
28964.            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
2897(1) Points
2898                True
2899                False (*)
2900
29015.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
2902(1) Points
2903                                                (Choose all correct answers)      
2904                CUSTOMER and ORDERS (*)
2905                CUSTOMER and PAYMENTS (*)
2906                TEACHER and AGE
2907                BABY and AGE
2908
29096.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
2910(1) Points
2911                                                (Choose all correct answers)      
2912                LIBRARY and NUMBER OF BOOKS
2913                STUDENT and GRADE (*)
2914                LIBRARY and BOOK (*)
2915                STUDENT and AGE
2916
29177.            Modeling historical data can produce a unique identifier that includes a date. True or False?        Mark for Review
2918(1) Points
2919                True (*)
2920                False
2921
29228.            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
2923(1) Points
2924                True (*)
2925                False
2926
29279.            Which of the following would be a logical constraint when modeling time for a City entity?           Mark for Review
2928(1) Points
2929                If you are doing a system for any French City, you would need security clearance.
2930                People are born in the city and people die in the city.
2931
2932                Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.
2933
2934                Cites may change their names and/or country association if the borders of a country change. (*)
2935
293610.          When you add the concept of time to your data model, your model becomes more complex. True or False?                Mark for Review
2937(1) Points
2938                True (*)
2939                False
2940
294111.          If you have an entity with a DATE attribute, in addition to other attributes that track date characteristics, you should create a DAY entity. True or False?            Mark for Review
2942(1) Points
2943                True (*)
2944                False
2945
294612.          There are no circumstances where you would create a DAY entity. True or False?             Mark for Review
2947(1) Points
2948                True
2949                False (*)
2950
295113.          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
2952(1) Points
2953
2954                Email current prices to all employees whenever a price changes.
2955
2956                Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.
2957
2958                Allow them to enter whatever delivery charge they want.
2959
2960                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. (*)
2961
296214.          Why would you want to model a time component when designing a system that lets people buy bars of gold?     Mark for Review
2963(1) Points
2964                The Government of your country might want to be notified of this transaction.
2965                You would not want to model this; it is not important.
2966
2967                The price of gold fluctuates and, to determine the current price, you need to know the time of purchase. (*)
2968
2969                Sales people must determine where the gold is coming from.
2970
297115.          All systems must include functionality to provide logging or journaling in conceptual data models. True or False?   Mark for Review
2972(1) Points
2973                True
2974                False (*)
2975
29761.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
2977(1) Points
2978                                                (Choose all correct answers)      
2979                LIBRARY and BOOK (*)
2980                STUDENT and AGE
2981                LIBRARY and NUMBER OF BOOKS
2982                STUDENT and GRADE (*)
2983
29842.            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
2985(1) Points
2986                True
2987                False (*)
2988
29893.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
2990(1) Points
2991                                                (Choose all correct answers)      
2992                CUSTOMER and PAYMENTS (*)
2993                CUSTOMER and ORDERS (*)
2994                BABY and AGE
2995                TEACHER and AGE
2996
29974.            When a relationship may or may not be transferable, depending on time, this is know as a/an:  Mark for Review
2998(1) Points
2999                Transferable Relationship
3000                Non-transferable Relationship.
3001                Conditional Non-transferable Relationship. (*)
3002                Arc.
3003
30045.            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
3005(1) Points
3006                True
3007                False (*)
3008
30096.            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
3010(1) Points
3011                True (*)
3012                False
3013
30147.            When you add the concept of time to your data model, your model becomes more complex. True or False?                Mark for Review
3015(1) Points
3016                True (*)
3017                False
3018
30198.            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
3020(1) Points
3021                True (*)
3022                False
3023
30249.            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
3025(1) Points
3026                True (*)
3027                False
3028
302910.          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
3030(1) Points
3031                True
3032                False (*)
3033
303411.          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
3035(1) Points
3036                True (*)
3037                False
3038
303912.          In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?        Mark for Review
3040(1) Points
3041                True
3042                False (*)
3043
304413.          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
3045(1) Points
3046                Email current prices to all employees whenever a price changes.
3047
3048                Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.
3049
3050                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. (*)
3051
3052                Allow them to enter whatever delivery charge they want.
3053
305414.          Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?               Mark for Review
3055(1) Points
3056                EMPLOYEE periods can overlap causing the database to crash.
3057                Dates must be stored with Time.
3058                End Date must be before the Start Date.
3059
3060                An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)
3061
306215.          Why would you want to model a time component when designing a system that lets people buy bars of gold?     Mark for Review
3063(1) Points
3064                You would not want to model this; it is not important.
3065                The Government of your country might want to be notified of this transaction.
3066
3067                The price of gold fluctuates and, to determine the current price, you need to know the time of purchase. (*)
3068
3069                Sales people must determine where the gold is coming from.
3070
30711.            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
3072(1) Points
3073
3074                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.
3075                B. Create a new item and a new price every day.
3076                C. Use a price entity with a start and end date
3077                D. Allow them to delete the item and enter a new one.
3078                E. Both A and C (*)
3079
30802.            Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?               Mark for Review
3081(1) Points
3082
3083                An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)
3084
3085                Dates must be stored with Time.
3086                End Date must be before the Start Date.
3087                EMPLOYEE periods can overlap causing the database to crash.
3088
30893.            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
3090(1) Points
3091
3092                Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.
3093
3094                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. (*)
3095
3096                Email current prices to all employees whenever a price changes.
3097                Allow them to enter whatever delivery charge they want.
3098
30994. Historical data must never be kept. True or False?       Mark for Review
3100(1) Points
3101                True
3102                False (*)
3103
31045.            Modeling historical data can produce a unique identifier that includes a date. True or False?        Mark for Review
3105(1) Points
3106                True (*)
3107                False
3108
31096.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
3110(1) Points
3111                                                (Choose all correct answers)      
3112                BABY and AGE
3113                TEACHER and AGE
3114                CUSTOMER and ORDERS (*)
3115                CUSTOMER and PAYMENTS (*)
3116
31177.            In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?        Mark for Review
3118(1) Points
3119                True
3120                False (*)
3121
31228.            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
3123(1) Points
3124                True (*)
3125                False
3126
31279.            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
3128(1) Points
3129                True
3130                False (*)
3131
313210.          Which of the following statements are true to enhance the readability of ERDs? (Choose Two)  Mark for Review
3133(1) Points
3134                                                (Choose all correct answers)      
3135                Crossing relationship lines help the readability of the diagram.
3136
3137                Crows feet (the many-ends of relationships) should consistently point the same direction where possible, either South & East or North & West (*)
3138
3139                Relationship lines should not cross. (*)
3140
3141                It does not matter which way the crows feet (many ends of a relationship) point.
3142
314311.          Modeling historical data is optional. True or False?           Mark for Review
3144(1) Points
3145                True (*)
3146                False
3147
314812.          When a relationship may or may not be transferable, depending on time, this is know as a/an:  Mark for Review
3149(1) Points
3150                Conditional Non-transferable Relationship. (*)
3151                Arc.
3152                Transferable Relationship
3153                Non-transferable Relationship.
3154
315513.          When you add the concept of time to your data model, your model becomes more complex. True or False?                Mark for Review
3156(1) Points
3157                True (*)
3158                False
3159
316014.          All systems must have an entity called WEEK with a holiday attribute so that you know when to give employees a holiday. True or False?        Mark for Review
3161(1) Points
3162                True
3163                False (*)
3164
316515.          How do you know when to use the different types of time in your design?          Mark for Review
3166(1) Points
3167
3168                You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
3169
3170                The rules are fixed and should be followed.
3171                Always model time; you can take it out later if it is not needed.
3172                It depends on the functional needs of the system . (*)
3173
31741.            Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
3175(1) Points
3176                                                (Choose all correct answers)      
3177                STUDENT and GRADE (*)
3178                STUDENT and AGE
3179                LIBRARY and BOOK (*)
3180                LIBRARY and NUMBER OF BOOKS
3181
31822.            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
3183(1) Points
3184                True
3185                False (*)
3186
31873.            Modeling historical data can produce a unique identifier that includes a date. True or False?        Mark for Review
3188(1) Points
3189                True (*)
3190                False
3191
31924.            All systems must include functionality to provide logging or journaling in conceptual data models. True or False?   Mark for Review
3193(1) Points
3194                True
3195                False (*)
3196
31975.            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
3198(1) Points
3199
3200                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.
3201                B. Create a new item and a new price every day.
3202                C. Use a price entity with a start and end date
3203                D. Allow them to delete the item and enter a new one.
3204                E. Both A and C (*)
3205
32066.            Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?               Mark for Review
3207(1) Points
3208                End Date must be before the Start Date.
3209                EMPLOYEE periods can overlap causing the database to crash.
3210                An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)
3211                Dates must be stored with Time.
3212
32137.            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
3214(1) Points
3215                True
3216                False (*)
3217
32188.            In an ERD, High Volume Entities usually have very few relationships to other entities. True or False?        Mark for Review
3219(1) Points
3220                True
3221                False (*)
3222
32239.            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
3224(1) Points
3225                True (*)
3226                False
3227
322810.          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
3229(1) Points
3230                True (*)
3231                False
3232
323311.          How do you know when to use the different types of time in your design?          Mark for Review
3234(1) Points
3235
3236                You would first determine the existence of the concept of time and map it against the Greenwich Mean Time.
3237                Always model time; you can take it out later if it is not needed.
3238                The rules are fixed and should be followed.
3239                It depends on the functional needs of the system . (*)
3240
324112.          All systems must have an entity called WEEK with a holiday attribute so that you know when to give employees a holiday. True or False?        Mark for Review
3242(1) Points
3243                True
3244                False (*)
3245
324613.          When a relationship may or may not be transferable, depending on time, this is know as a/an:  Mark for Review
3247(1) Points
3248                Conditional Non-transferable Relationship. (*)
3249                Transferable Relationship
3250                Non-transferable Relationship.
3251                Arc.
3252
325314.          Which of the following would be a logical constraint when modeling time for a country entity?   Mark for Review
3254(1) Points
3255                Daily traffic patterns must be monitored to determine which countries are overcrowded.
3256                Countries may change their names and/or borders over a period of time. (*)
3257                People have births and deaths in their countries that must be tracked by the system.
3258                If you are doing a system for France or Germany, you would need security clearance.
3259
326015.          Which of the following would be a logical constraint when modeling time for a City entity?           Mark for Review
3261(1) Points
3262
3263                Cites may change their names and/or country association if the borders of a country change. (*)
3264
3265                Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.
3266
3267                People are born in the city and people die in the city.
3268
3269
3270                If you are doing a system for any French City, you would need security clearance.
3271 Section 9 Quiz Database Design Oracle
3272Section 9 Quiz
3273            (Answer all questions in this section)
32741.         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
3275(1) Points
3276                                    (Choose all correct answers)  
3277            Make all relationships mandatory
3278            Make all relationships optional (*)
3279
3280            Create an additional check constraint to verify that one foreign key is populated and the others are not (*)
3281
3282            All the above
3283
3284
32852.         Which of the following is a valid reason for considering a Subtype Implementation?          Mark for Review
3286(1) Points
3287            The common access paths for the supertypes are different.
3288            The resulting table will reside in a single database and be used by just ONE user.
3289
3290            Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
3291
3292            Most of the relationships are at the supertype level.
3293
32943.         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
3295(1) Points
3296            True
3297            False (*)
3298
32994.         In an Oracle database, why would 1_TABLE not work as a table name?     Mark for Review
3300(1) Points
3301            The database does not understand all capital letters.
3302            TABLE is a reserved word.
3303            There is no problem here. You can create a table called 1_TABLE.
3304            Object names must not start with a number. They must begin with a letter. (*)
3305
33065.         In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?            Mark for Review
3307(1) Points
3308            The database does not understand all capital letters
3309            JOBS is a reserved word
3310            EMPLOYEE is a reserved word
3311            You cannot have spaces between words in a table name (*)
3312
33136.         Why would this table name NOT work in an Oracle database? this_year_end+next_year   Mark for Review
3314(1) Points
3315            Table names must begin with an alphabetic character.
3316            It is too long.
3317            The Plus sign + is not allowed in object names. (*)
3318            None of the above.
3319
33207.         In a physical data model, an attribute becomes a _____________.   Mark for Review
3321(1) Points
3322            Constraint
3323            Table
3324            Foreign Key
3325            Column (*)
3326
33278.         To resolve a many to many relationship in a physical model you create a(n) ___________________?            Mark for Review
3328(1) Points
3329            Unique key constraints
3330            Intersection entity
3331            Intersection table (*)
3332            Two tables with Foreign key constraints between them
3333
33349.         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
3335(1) Points
3336            True
3337            False (*)
3338
333910.       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
3340(1) Points
3341            True
3342            False (*)
3343
334411.       A barrred Relationship will result in a Foreign Key column that also is part of:        Mark for Review
3345(1) Points
3346            The Primary Key (*)
3347            The Column Name
3348            The Check Constraint
3349            The Table Name
3350
335112.       Column integrity refers to       Mark for Review
3352(1) Points
3353            Columns always containing positive numbers
3354            Columns always containing values consistent with the defined data format (*)
3355            Columns always containing text data less than 255 characters
3356            Columns always having values
3357
335813. The explanation below is an example of which constraint type?
3359A column must contain only values consistent with the defined data format of the column            Mark for Review
3360(1) Points
3361            Column integrity (*)
3362            User-defined integrity
3363            Referential integrity
3364            Entity integrity
3365
336614.       Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three)            Mark for Review
3367(1) Points
3368                                    (Choose all correct answers)  
3369            Only one column that must be null. (*)
3370            A single column that uniquely identifies each column in a table. (*)
3371            One or more columns in a table that uniquely identifies each row in that table.
3372            A set of columns in one table that uniquely identifies each row in another table. (*)
3373
337415.       Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three)            Mark for Review
3375(1) Points
3376                                    (Choose all correct answers)  
3377            Only one column that cannot be null
3378
3379            A set of columns and keys in a single table that uniquely identifies each row in a single table (*)
3380
3381            A single column that uniquely identifies each row in a table (*)
3382            A set of columns that uniquely identifies each row in a table (*)
3383
33841.         The explanation below is an example of which constraint type?
3385A column must contain only values consistent with the defined data format of the column            Mark for Review
3386(1) Points
3387            User-defined integrity
3388            Column integrity (*)
3389            Referential integrity
3390            Entity integrity
3391
33922.         Identify all of the correct statements that complete this sentence: A primary key is: (Choose Three)            Mark for Review
3393(1) Points
3394                                    (Choose all correct answers)  
3395
3396            A set of columns and keys in a single table that uniquely identifies each row in a single table (*)
3397            Only one column that cannot be null
3398            A single column that uniquely identifies each row in a table (*)
3399            A set of columns that uniquely identifies each row in a table (*)
3400
34013.         Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three)            Mark for Review
3402(1) Points
3403                                    (Choose all correct answers)  
3404            A single column that uniquely identifies each column in a table. (*)
3405            One or more columns in a table that uniquely identifies each row in that table.
3406            Only one column that must be null. (*)
3407            A set of columns in one table that uniquely identifies each row in another table. (*)
3408
34094. Foreign keys cannot be null when  Mark for Review
3410(1) Points
3411            It refers to another table
3412            It is part of a primary key (*)
3413            It contains three or more columns
3414            It refers to the same table
3415
34165.         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
3417(1) Points
3418            True
3419            False (*)
3420
34216.         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
3422(1) Points
3423            True (*)
3424            False
3425
34267.         The "Arc Implementation" is a synonym for what type of implementation? Mark for Review
3427(1) Points
3428            Supertype and Subtype Implementation (*)
3429            Cascade Implementation
3430            Supertype Implementation
3431            Subtype Implementation
3432
34338.         The Physical model is created by transforming which of the following models?      Mark for Review
3434(1) Points
3435            Constraint
3436            Table
3437            Physical
3438            Conceptual (*)
3439
34409.         Why would this table name NOT work in an Oracle database? this_year_end+next_year   Mark for Review
3441(1) Points
3442            Table names must begin with an alphabetic character.
3443            It is too long.
3444            The Plus sign + is not allowed in object names. (*)
3445            None of the above.
3446
344710.       In an Oracle database, why would 1_TABLE not work as a table name?     Mark for Review
3448(1) Points
3449            There is no problem here. You can create a table called 1_TABLE.
3450            The database does not understand all capital letters.
3451            TABLE is a reserved word.
3452            Object names must not start with a number. They must begin with a letter. (*)
3453
345411.       Attributes become columns in a database table. True or False?         Mark for Review
3455(1) Points
3456            True (*)
3457            False
3458
345912.       Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?            Mark for Review
3460(1) Points
3461            True
3462            False (*)
3463
346413.       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
3465(1) Points
3466            True (*)
3467            False
3468
346914.       One-to-One relationships are transformed into Check Constraints in the tables created at either end of that relationship. True or False?          Mark for Review
3470(1) Points
3471            True
3472            False (*)
3473
347415.       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
3475(1) Points
3476            True
3477            False (*)
3478
34791.         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
3480(1) Points
3481            True
3482            False (*)
3483
34842.         Which of the following is a valid reason for considering a Subtype Implementation?          Mark for Review
3485(1) Points
3486            The common access paths for the supertypes are different.
3487
3488            Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
3489
3490            Most of the relationships are at the supertype level.
3491            The resulting table will reside in a single database and be used by just ONE user.
3492
34933.         The "Arc Implementation" is a synonym for what type of implementation? Mark for Review
3494(1) Points
3495            Supertype and Subtype Implementation (*)
3496            Supertype Implementation
3497            Cascade Implementation
3498            Subtype Implementation
3499
35004.         In a physical data model, an attribute becomes a _____________.   Mark for Review
3501(1) Points
3502            Constraint
3503            Column (*)
3504            Table
3505            Foreign Key
3506                                                           
35075.The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?          Mark for Review
3508(1) Points
3509            True (*)
3510            False
3511
35126.         In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?            Mark for Review
3513(1) Points
3514            The database does not understand all capital letters
3515            JOBS is a reserved word
3516            You cannot have spaces between words in a table name (*)
3517            EMPLOYEE is a reserved word
3518
35197. In an Oracle database, why would 1_TABLE not work as a table name? Mark for Review
3520(1) Points
3521            There is no problem here. You can create a table called 1_TABLE.
3522            Object names must not start with a number. They must begin with a letter. (*)
3523            The database does not understand all capital letters.
3524            TABLE is a reserved word.
3525
35268.         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
3527(1) Points
3528            True
3529            False (*)
3530
35319.         One-to-Many Optional to Mandatory becomes a _______________ on the Master table.   Mark for Review
3532(1) Points
3533            Optional Foreign Key (*)
3534            Unique Key
3535            Primary Key
3536            Mandatory Foreign Key
3537
353810.       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
3539(1) Points
3540            True (*)
3541            False
3542
354311.       A barrred Relationship will result in a Foreign Key column that also is part of:        Mark for Review
3544(1) Points
3545            The Check Constraint
3546            The Column Name
3547            The Table Name
3548            The Primary Key (*)
3549
355012.       Foreign keys must be null. True or False?       Mark for Review
3551(1) Points
3552            True
3553            False (*)
3554
355513.       The explanation below is an example of which constraint type?
3556A primary key must be unique, and no part of the primary key can be null.  Mark for Review
3557(1) Points
3558            Column integrity
3559            User-defined integrity
3560            Referential integrity
3561            Entity integrity (*)
3562
356314.       Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three)            Mark for Review
3564(1) Points
3565                                    (Choose all correct answers)  
3566            A set of columns in one table that uniquely identifies each row in another table. (*)
3567            One or more columns in a table that uniquely identifies each row in that table.
3568            Only one column that must be null. (*)
3569            A single column that uniquely identifies each column in a table. (*)
3570
357115.       A foreign key always refers to a primary key in the same table. True or False?         Mark for Review
3572(1) Points
3573            True
3574            False (*)
3575
35761.         The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?      Mark for Review
3577(1) Points
3578            True (*)
3579            False
3580
35812. In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?       Mark for Review
3582(1) Points
3583            You cannot have spaces between words in a table name (*)
3584            The database does not understand all capital letters
3585            EMPLOYEE is a reserved word
3586            JOBS is a reserved word
3587
35883.         Attributes become columns in a database table. True or False?         Mark for Review
3589(1) Points
3590            True (*)
3591            False
3592
35934. The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ :     Mark for Review
3594(1) Points
3595            Unique Keys
3596            Tables (*)
3597            Columns
3598            Foreign Keys
3599
36005.         Foreign keys must be null. True or False?       Mark for Review
3601(1) Points
3602            True
3603            False (*)
3604
36056.         A table does not have to have a primary key. True or False? Mark for Review
3606(1) Points
3607            True (*)
3608            False
3609
36107.         The explanation below is an example of which constraint type?
3611If 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
3612(1) Points
3613            Column integrity
3614            Referential integrity
3615            Entity integrity
3616            User-defined integrity (*)
3617
36188.         Column integrity refers to       Mark for Review
3619(1) Points
3620            Columns always containing text data less than 255 characters
3621            Columns always containing positive numbers
3622            Columns always containing values consistent with the defined data format (*)
3623            Columns always having values
3624
36259.         Which of the following is a valid reason for considering a Subtype Implementation?          Mark for Review
3626(1) Points
3627            The resulting table will reside in a single database and be used by just ONE user.
3628            The common access paths for the supertypes are different.
3629            Most of the relationships are at the supertype level.
3630
3631            Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
3632
363310.       An "Arc Implementation" can be done just like any other Relationship - you simply add the required Foreign Keys. True or False?  Mark for Review
3634(1) Points
3635            True
3636            False (*)
3637
363811.       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
3639(1) Points
3640            True (*)
3641            False
3642
364312.       To resolve a many to many relationship in a physical model you create a(n) ___________________?            Mark for Review
3644(1) Points
3645            Two tables with Foreign key constraints between them
3646            Intersection table (*)
3647            Unique key constraints
3648            Intersection entity
3649
365013.       Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?            Mark for Review
3651(1) Points
3652            True
3653            False (*)
3654
365514.       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
3656(1) Points
3657            True
3658            False (*)
3659
366015.       One-to-One relationships are transformed into Check Constraints in the tables created at either end of that relationship. True or False?          Mark for Review
3661(1) Points
3662            True
3663            False (*)
3664
36651.         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
3666(1) Points
3667            True (*)
3668            False
3669
36702.         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
3671(1) Points
3672            True
3673            False (*)
3674
36753.         Which of the following is a valid reason for considering a Subtype Implementation?          Mark for Review
3676(1) Points
3677
3678            Business functionality, business rules, access paths, and frequency of access are all very different between the subtypes. (*)
3679
3680            Most of the relationships are at the supertype level.
3681            The common access paths for the supertypes are different.
3682            The resulting table will reside in a single database and be used by just ONE user.
3683
36844.         The explanation below is an example of which constraint type?
3685A column must contain only values consistent with the defined data format of the column            Mark for Review
3686(1) Points
3687            Column integrity (*)
3688            User-defined integrity
3689            Entity integrity
3690            Referential integrity
3691
36925.         A table must have a primary key. True or False?        Mark for Review
3693(1) Points
3694            True
3695            False (*)
3696
36976.         Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three)            Mark for Review
3698(1) Points
3699                                    (Choose all correct answers)  
3700            A single column that uniquely identifies each column in a table. (*)
3701            A set of columns in one table that uniquely identifies each row in another table. (*)
3702            Only one column that must be null. (*)
3703            One or more columns in a table that uniquely identifies each row in that table.
3704
37057.         The explanation below is an example of which constraint type?
3706The 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
3707(1) Points
3708            Referential integrity (*)
3709            Column integrity
3710            User-defined integrity
3711            Entity integrity
3712
37138.         In a physical model, many to many relationships are resolved via a structure called a(n): ________________    Mark for Review
3714(1) Points
3715            Intersection Entity
3716            Intersection Table (*)
3717            Subtype
3718            Supertype
3719
37209.         To resolve a many to many relationship in a physical model you create a(n) ___________________?            Mark for Review
3721(1) Points
3722            Two tables with Foreign key constraints between them
3723            Intersection entity
3724            Intersection table (*)
3725            Unique key constraints
3726
372710.       A barrred Relationship will result in a Foreign Key column that also is part of:        Mark for Review
3728(1) Points
3729            The Check Constraint
3730            The Column Name
3731            The Primary Key (*)
3732            The Table Name
3733
373411.       Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?            Mark for Review
3735(1) Points
3736            True
3737            False (*)
3738
373912.       Attributes become columns in a database table. True or False?         Mark for Review
3740(1) Points
3741            True (*)
3742            False
3743
374413.       Why would this table name NOT work in an Oracle database? this_year_end+next_year   Mark for Review
3745(1) Points
3746            Table names must begin with an alphabetic character.
3747            It is too long.
3748            The Plus sign + is not allowed in object names. (*)
3749            None of the above.
3750
375114.       In an Oracle database, why would 1_TABLE not work as a table name?     Mark for Review
3752(1) Points
3753            TABLE is a reserved word.
3754            There is no problem here. You can create a table called 1_TABLE.
3755            The database does not understand all capital letters.
3756            Object names must not start with a number. They must begin with a letter. (*)
3757
375815.       In a physical data model, an attribute becomes a _____________.   Mark for Review
3759(1) Points
3760            Constraint
3761            Table
3762            Foreign Key
3763
3764            Column (*)
3765
3766 1.            An entity can only have one Primary UID. True or False?                Mark for Review
3767(1) Points
3768                True (*)
3769                False
3770
37712.            If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?  Mark for Review
3772(1) Points
3773                True (*)
3774                False
3775
37763.            There is no limit to how many columns can make up an entity's UID. True or False?          Mark for Review
3777(1) Points
3778                True (*)
3779                False
3780
37814.            A unique identifier can only be made up of one attribute. True or False?               Mark for Review
3782(1) Points
3783                True
3784                False (*)
3785
37865.            When is an entity in 2nd Normal Form? Mark for Review
3787(1) Points
3788                When all non-UID attributes are dependent upon the entire UID. (*)
3789                When attributes with repeating or multi-values are present.
3790                When no attritibutes are mutually independent and all are fully dependent on the primary key.
3791                None of the Above.
3792
37936.            What is the rule of Second Normal Form?             Mark for Review
3794(1) Points
3795                No non-UID attributes can be dependent on any part of the UID.
3796                Some non-UID attributes can be dependent on the entire UID.
3797                All non-UID attributes must be dependent upon the entire UID. (*)
3798                None of the above
3799
38007.            Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:
3801ENTITY: RECEIPT
3802ATTRIBUTES:
3803   #CUSTOMER ID
3804   #STORE ID
3805   STORE LOCATION
3806   DATE
3807 Mark for Review
3808(1) Points
3809                Do nothing, it is already in 2nd Normal Form.
3810                Delete the attribute STORE ID
3811                Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity. (*)
3812                Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.
3813
38148.            When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:                Mark for Review
3815(1) Points
3816                Dependency
3817                Functional dependency
3818                Non-dependency
3819                Transitive dependency (*)
3820
38219.            Examine the following Entity and decide which rule of Normal Form is being violated:
3822ENTITY: CLIENT
3823ATTRIBUTES:
3824    # CLIENT ID
3825    FIRST NAME
3826    LAST NAME
3827    ORDER ID
3828    STREET
3829    ZIP CODE
3830 Mark for Review
3831(1) Points
3832                1st Normal Form. (*)
3833                2nd Normal Form.
3834                3rd Normal Form.
3835                None of the above, the entity is fully normalised.
3836
383710.          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
3838(1) Points
3839                True
3840                False (*)
3841
384211.          Examine the following Entity and decide which rule of Normal Form is being violated:
3843ENTITY: CLIENT
3844ATTRIBUTES:
3845    # CLIENT ID
3846    FIRST NAME
3847    LAST NAME
3848    STREET
3849    CITY
3850    ZIP CODE
3851 Mark for Review
3852(1) Points
3853                1st Normal Form.
3854                2nd Normal Form.
3855                3rd Normal Form.
3856                None of the above, the entity is fully normalised. (*)
3857
385812.          When data is stored in more than one place in a database, the database violates the rules of ___________.                Mark for Review
3859(1) Points
3860                Normalcy
3861                Replication
3862                Normalization (*)
3863                Decency
3864
386513.          If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we: Mark for Review
3866(1) Points
3867                Make the attribute optional
3868                Do nothing, an entity does not have to be in 1st Normal Form
3869                Create an additional entity and relate it to the original entity with a 1:M relationship. (*)
3870                Create an additional entity and relate it to the original entity with a M:M relationship.
3871
387214.          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
3873(1) Points
3874                True
3875                False (*)
3876
387715.          An entity can have repeated values and still be in 1st Normal Form. True or False?            Mark for Review
3878(1) Points
3879                True
3880                False (*)
3881
388216.          Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
3883(1) Points
3884                Invalid Relationship
3885                General Relationship
3886                Heirarchical Relationship (*)
3887                Recursive Relationship
3888
388917.          A relationship between an entity and itself is called a/an:             Mark for Review
3890(1) Points
3891                General Relationship
3892                Recursive Relationship (*)
3893                Heirarchical Relationship
3894                Invalid Relationship
3895
389618.          A single relationship can be both Recursive and Hierarchical at the same time. True or False?       Mark for Review
3897(1) Points
3898                True
3899                False (*)
3900
390119.          A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?    Mark for Review
3902(1) Points
3903                True (*)
3904                False
3905
390620.          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
3907(1) Points
3908                True (*)
3909                False
3910
391121.          Which of the following would best be represented by an arc?    Mark for Review
3912(1) Points
3913                STUDENT (Grade A student, Average Student)
3914                PARENT (Girl, Bob)
3915                TEACHER (Female, Bob)
3916                DELIVERY ADDRESS (Home, Office) (*)
3917
391822.          Arcs are used to visually represent _________ between two or more relationships in an ERD.   Mark for Review
3919(1) Points
3920                Sameness
3921                Differences
3922                Exclusivity (*)
3923                Inheritance
3924
392523.          An arc can often be modeled as Supertype and Subtypes. True or False?              Mark for Review
3926(1) Points
3927                True (*)
3928                False
3929
393024.          Which of the following would best be represented by an arc?    Mark for Review
3931(1) Points
3932                STUDENT (Grade A student, Average Student)
3933                STUDENT (senior, male)
3934                STUDENT ( University, Technical College) (*)
3935                STUDENT (graduating, female)
3936
3937Section 8
3938                (Answer all questions in this section)
3939
394025.          Which of the following would be a logical constraint when modeling time for a country entity?   Mark for Review
3941(1) Points
3942                Daily traffic patterns must be monitored to determine which countries are overcrowded.
3943                People have births and deaths in their countries that must be tracked by the system.
3944                If you are doing a system for France or Germany, you would need security clearance.
3945                Countries may change their names and/or borders over a period of time. (*)
3946
3947Section 8
3948                (Answer all questions in this section)
3949
395026.          Which of the following would be a logical constraint when modeling time for a City entity?           Mark for Review
3951(1) Points
3952                Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.
3953                If you are doing a system for any French City, you would need security clearance.
3954                Cites may change their names and/or country association if the borders of a country change. (*)
3955                People are born in the city and people die in the city.
3956
395727.          All systems must include functionality to provide logging or journaling in conceptual data models. True or False?   Mark for Review
3958(1) Points
3959                True
3960                False (*)
3961
396228.          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
3963(1) Points
3964                True (*)
3965                False
3966
396729.          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
3968(1) Points
3969                True
3970                False (*)
3971
397230.          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
3973(1) Points
3974                True
3975                False (*)
3976
397731.          Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
3978(1) Points
3979                                                (Choose all correct answers)      
3980                LIBRARY and NUMBER OF BOOKS
3981                STUDENT and GRADE (*)
3982                STUDENT and AGE
3983                LIBRARY and BOOK (*)
3984
398532.          Historical data must never be kept. True or False?            Mark for Review
3986(1) Points
3987                True
3988                False (*)
3989
3990Section 9
3991                (Answer all questions in this section)
3992
399333.          The explanation below is an example of which constraint type?
3994A primary key must be unique, and no part of the primary key can be null.           Mark for Review
3995(1) Points
3996                Referential integrity
3997                Column integrity
3998                Entity integrity (*)
3999                User-defined integrity
4000
400134.          Foreign keys cannot be null when            Mark for Review
4002(1) Points
4003                It refers to the same table
4004                It is part of a primary key (*)
4005                It refers to another table
4006                It contains three or more columns
4007
400835.          The explanation below is an example of which constraint type?
4009If 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
4010(1) Points
4011                User-defined integrity (*)
4012                Entity integrity
4013                Column integrity
4014                Referential integrity
4015
4016Section 9
4017                (Answer all questions in this section)
4018
401936.          A foreign key cannot refer to a primary key in the same table. True or False?      Mark for Review
4020(1) Points
4021                True
4022                False (*)
4023
402437.          Column integrity refers to            Mark for Review
4025(1) Points
4026                Columns always containing text data less than 255 characters
4027                Columns always containing values consistent with the defined data format (*)
4028                Columns always having values
4029                Columns always containing positive numbers
4030
403138.          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
4032(1) Points
4033                True
4034                False (*)
4035
403639.          One-to-Many Optional to Mandatory becomes a _______________ on the Master table.          Mark for Review
4037(1) Points
4038                Unique Key
4039                Optional Foreign Key (*)
4040                Mandatory Foreign Key
4041                Primary Key
4042
404340.          A barrred Relationship will result in a Foreign Key column that also is part of:       Mark for Review
4044(1) Points
4045                The Column Name
4046                The Check Constraint
4047                The Table Name
4048                The Primary Key (*)
4049
4050Section 9
4051                (Answer all questions in this section)
4052
405341.          Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?              Mark for Review
4054(1) Points
4055                True
4056                False (*)
4057
405842.          One-to-One relationships are transformed into Check Constraints in the tables created at either end of that relationship. True or False?         Mark for Review
4059(1) Points
4060                True
4061                False (*)
4062
406343.          The "Arc Implementation" is a synonym for what type of implementation?          Mark for Review
4064(1) Points
4065                Cascade Implementation
4066                Supertype Implementation
4067                Subtype Implementation
4068                Supertype and Subtype Implementation (*)
4069
407044.          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
4071(1) Points
4072                True (*)
4073                False
4074
407545.          The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ :                Mark for Review
4076(1) Points
4077                Columns
4078                Tables (*)
4079                Foreign Keys
4080                Unique Keys
4081
4082Section 9
4083                (Answer all questions in this section)
4084
408546.          The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?               Mark for Review
4086(1) Points
4087                True (*)
4088                False
4089
409047.          In an Oracle database, why would 1_TABLE not work as a table name?   Mark for Review
4091(1) Points
4092                There is no problem here. You can create a table called 1_TABLE.
4093                Object names must not start with a number. They must begin with a letter. (*)
4094                TABLE is a reserved word.
4095                The database does not understand all capital letters.
4096
409748.          In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?   Mark for Review
4098(1) Points
4099                JOBS is a reserved word
4100                The database does not understand all capital letters
4101                You cannot have spaces between words in a table name (*)
4102                EMPLOYEE is a reserved word
4103
4104Section 10
4105                (Answer all questions in this section)
4106
410749.          In which phases of the System Development Life Cycle will we need to use SQL as a language? (Choose Two)                Mark for Review
4108(1) Points
4109                                                (Choose all correct answers)      
4110                Build and Document (*)
4111                Analysis
4112                Transition (*)
4113                Strategy
4114
411550.          During which phases of the System Development Life Cycle would you roll out the system to the users?                Mark for Review
4116(1) Points
4117                Build and Transition
4118                Design and Production
4119                Strategy and Analysis
4120
4121                Transition and Production (*)