quiz 2.docx - Section 2 Quiz(Answer all questions in this...

This preview shows page 1 - 5 out of 33 pages.

Section 2 Quiz (Answer all questions in this section) 1. A Unique Identifier has a NULL value for each instance of the entity for the lifetime of the instance. True or False Mark for Review (1) Points True False (*) Correct 2. What is the purpose of a Unique Identifier? Mark for Review (1) Points To identify a specific row within a table, using one or more columns and/or foreign keys. To identify one unique instance of an entity by using one or more attributes and/or relationships. (*) To uniquely determine a table and columns within that table. Create an entity that is unlike any other entity aside from itself. Correct 3. The physical model shows all table structures. True or False. Mark for Review (1) Points True (*) False Correct 4. The logical model becomes the blueprint for designing the ________ model Mark for Review (1) Points Physical (*) Network Data Integrity Data Flow
Image of page 1

Subscribe to view the full document.

Correct 5. Entities are usually _____________. Mark for Review (1) Points Adjectives Nouns (*) Verbs Adverbs Correct 6. Entity names are always singula r. True or False? Mark for Review (1) Points True (*) False Correct 7. 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 (1) Points True (*) False Correct 8. Which of the following is not an advantage of a relational database? Mark for Review (1) Points Efficiency
Image of page 2
Data Integrity One table with all the data. (*) Less Redundancy Correct 9. A table must have a primary key. True or False? Mark for Review (1) Points True (*) False Incorrect. Refer to Section 2 Lesson 1. 10. Using ERDish, which wording represents optionality? (Choose Two) Mark for Review (1) Points (Choose all correct answers) may (*) mandatory maybe must (*) Incorrect. Refer to Section 2 Lesson 6. Section 2 Quiz (Answer all questions in this section) 11. An ERD created using ERDish is a __________ representation of entities and their relationships to each other. Mark for Review (1) Points graphical (*) textual hierarchical technical Correct
Image of page 3

Subscribe to view the full document.

12. The conceptual model does all of the following except: Mark for Review (1) Points Describes the needs of the business. Documents type of operating system to be used. (*) Takes into account regulations and laws goverining the industry being addressed. Prevents mistakes and misunderstandings. Correct 13. Which of the following are true about Cardinality? (Choose two) Mark for Review (1) Points (Choose all correct answers) Cardinality specifies only singularity or plurality, but not a specific plural number. (*) Cardinality tells "how many". (*) Cardinality specifies whether something is required or not. Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship. Correct 14. The optionality of a relationship must be either _______ or _______. Mark for Review (1) Points Bidirectional or a single direction Mandatory or Optional (*) Single or Multiple One or (One or More) Correct 15. A __________ relationship is a relationship between an entity and itself.
Image of page 4
Image of page 5
  • Spring '17
  • azmat fatma
  • Entity-relationship model, Logical data model

{[ snackBarMessage ]}

Get FREE access by uploading your study materials

Upload your study materials now and get free access to over 25 million documents.

Upload now for FREE access Or pay now for instant access
Christopher Reinemann
"Before using Course Hero my grade was at 78%. By the end of the semester my grade was at 90%. I could not have done it without all the class material I found."
— Christopher R., University of Rhode Island '15, Course Hero Intern

Ask a question for free

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern