quizday1 (1)

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 Quiz

(Answer all questions in this section) 1. Data Integrity ensures the duplication of information.

Mark for Review (1) Points

rue False (*) Correct called a record. 2. A row is called


rue (*) False Correct records. 3. A table is a collection of records.


rue (*) False Correct 4. In the relational database model, each table n ame must be unique. The column names in the table must be unique too. You can have two different tables that have column names that are similar.


rue (*) False Correct 5. he advantages of object-oriented data model are:


Reduced Maintenance Real-World Modeling Both (*) None

Incorrect. Refer to Section 1 Lesson 3.

Page 1 of 3

Next Summary

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 1 Quiz

(Answer all questions in this section) 6. Physical data modeling is the examination of a business and business data in order to determine the structure of business information and the rules that govern it.


rue False (*) Incorrect. Refer to Section 1 Lesson 3. 7. Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure.


rue (*) False Correct 8. he Oracle Database stores data logically in tablespaces, and physically in datafiles associated with the c orresponding tablespace.


rue (*) False Correct 9. Oracle Database stores data logically in tablespaces and physically in datafiles associated with the corresponding tablespace.


rue (*) False Incorrect. Refer to Section 1 Lesson 5. 10. Business rules are used to understand business processes, and the nature, role, and scope of the data.


rue (*)

False Correct Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 1 Quiz

(Answer all questions in this section) 11. It is important to identify and document business rules when designing a database.


rue (*) False Correct interacts with the data and provides the following facilities: facilities: 12. A database interacts


Retrieving Inserting Both (*) Neither Incorrect. Refer to Section 1 Lesson 2. comprises of the following following elements: 13. A DBMS comprises (Choose 3)


(Choose all correct answers) Kernel code (*) Repository of metadata (*) Query language (*) Client Correct 14. he main subject areas taught by the Oracle Academy are:


Data Modeling, SQL, and PL/SQL (*) Computer Repairs Database performance tuning

Systems programming and computer architecture Correct 15. he 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?


rue (*) False Correct

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Section 2 Quiz

(Answer all questions in this section) 1. What does single table refer to? (Choose Two)


(Choose all correct answers) A type of database database storage method where where all of the data data elements are stored on top of each other. A fully-relational database system like like Microsoft's SQL Server or Oracle's Oracle's database systems. Non-relational systems that typically store each table and in dex in separate files and often do not support the SQL language. (*) A database where all of the data is stored in one large table. (*) Incorrect. Refer to Section 2 Lesson 1. 2. Which of the following statements is true?


(Choose all correct answers) Flat file database systems pay more attention to retrieving data and making it accessible to the user, whereas relational databases spend more energy updating indexes and data pointers. Relational database systems are the main thrust behind SQL since it provides the language elements needed to tie together the information in the database. Relational systems pay more attention to retrieving data and making it accessible to the user. Both B and C (*) Correct

Physical Model. True or False? 3. An ERD is an example of a Physical


rue False (*) Incorrect. Refer to Section 2 Lesson 3. 4. Entity names are always plural.


rue False (*) Correct 5. Which of the following are rea sons we create conceptual models?


It facilitates discussion; a picture is worth a thousand words It forms important ideal system documentation It takes into account government regulations and laws It forms a sound basis for physical database design All of the above (*) Correct 6. Primary Key can contain null values.


rue False (*)

Correct 7. What is the purpose of a Unique Identifier?


o identify one unique instance of an entity by using one or more attributes and/or relationships. (*) o uniquely determine a table and columns within that table. o identify a specific row within a table, using one or more columns and/or foreign keys.

Create an entity that is unlike any other entity aside from itself.

Incorrect. Refer to Section 2 Lesson 5. 8. Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?


rue False (*)

Correct relationship is mapped to a primary-key column on the many side, side, 9. A barred relationship ust like any other M:1 relationship.


rue False (*)

Correct 10. A table must have a primary key. True or False?


rue False (*)

Incorrect. Refer to Section 2 Lesson 2. 11. In the relational model, relationships between relations or tables are created by using?


Foreign Keys (*) Composite Keys Primary Keys Candidate Keys


12. In the relational model, data is organized in two-dimensional tables called ___________. _______ ____.


Field Relations (*) Row uples

Correct 13. he transformation from an ER diagram to a physical design involves changing terminology. Secondary Unique Identifiers become


Columns Primary Key Constraints ables Unique Constraints (*)

Correct 14. In a physical data model, a relationship is represented as a combination of: (Choose Two)


(Choose all correct answers) Foreign Key (*) Column Check Constraint or Unique Key Primary Key or Unique Key (*)

Correct become tables in a database. database. True or False? 15. Attributes become


rue False (*)

Correct Unique Identifier has a NULL value for each


instance of the entity for the lifetime of the instance. rue or False rue False (*)

Correct 2. Unique Identifiers:


Distinguish all entities in a database Distinguish one instance of an entity from all other instances of that entity (*) Distinguish one entity from another. Distinguish nothing

Correct 3. In the relational model, data is organized in two-dimensional tables called relations. True or False?


rue (*) False

Correct 4. In the relational model, data is organized in two-dimensional tables called ___________. ________ ___.


Field uples Row Relations (*)

Correct 5. In the relational model, relationships between relations or tables are created by using?


Candidate Keys Composite Keys Primary Keys Foreign Keys (*)

Correct 6. A flat file database is a type of database that stores data in a multiple tables.


rue False (*)

Incorrect. Refer to Section 2 Lesson 1. 7. Which of the following are exa mples of e-businesses that use database software? (Choose 3)


(Choose all correct answers) Online personal web page Online book store (*) Online clothing store (*) Online research paper Online personal shopping service (*)

Incorrect. Refer to Section 2 Lesson 1. 8. Entities are usually verbs. True or False?


rue False (*)



Primary Key Constraints Columns ables Unique Constraints (*)

Correct 10. Which of the following statements about attributes are true? (Choose Two)


(Choose all correct answers) hey are often adjectives. hey have a data type, such as number or character string. (*) hey must be single valued unless they belong to more than one entity. hey describe, qualify, quantify, classify, or specify an entity. (*)

Incorrect. Refer to Section 2 Lesson 4. 11. he Physical Model is derived from the Conceptual Model. rue or False?


rue (*) False

Correct 12. Data modeling is performed for the following reasons: (Choo se Two)


(Choose all correct answers) he ERD becomes a blueprint for designing the actual system. (*) It helps discussions and reviews. (*) We do not need datamodels; we can just start coding right away. 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. Correct

13. Which of the following are reasons we create conceptual models?


It facilitates discussion; a picture is worth a thousand words It forms important ideal system documentation It takes into account government regulations and laws It forms a sound basis for physical database design All of the above (*)

Correct 14. Foreign keys must be null. True or False?


rue False (*)

Correct 15. Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?


rue False (*)

Correct 1. here is no limit to how many columns that can make up an entity's UID. rue or False?


rue (*) False

Correct

2.

he candidate UID that is chosen to identify an entity is called the Primary UID; other candidate UIDs are called Secondary UIDs.


No, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc. No, each Entity can only have one UID, the secondary one. No, it is not possible to have more than one UID for an Entity. Yes, this is the way UID's are are named. (*)

Correct identifier must be made up of more than one attribute. attribute. True or 3. A unique identifier False?


rue False (*)

Correct 4. Business rules are important to data modelers. True or False?


rue (*) False

Correct and Structural 5. A new system would have a mixture of both Procedural and Business Rules as part of the do cumentation of that new system. True or False? rue (*) False

Correct 6. o identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it. True or False?



rue (*) False

Correct Instances. True or False? 7. Attributes have Instances.


rue False (*)

Correct Non-volatile attribute. True True or False. 8. Age is a Non-volatile


rue False (*)

Correct 9. 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?


rue (*) False

Correct 10. he Physical Model is derived from the Conceptual Model. True or False?


rue (*) False

Correct 11. 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. rue or False? rue (*) False

Incorrect. Refer to Section 3 Lesson 1. must be an instance of one of the subtypes. subtypes. 12. All instances of the supertype must rue or False?


rue (*) False

Correct create relationships to a Supertype, not to a Subtype. True or 13. You can only create False?


rue False (*)

Correct 14. Which of the following are suitable Entity names? (Choose Two)


(Choose all correct answers) ANIMALS DOGS DOG (*) ANIMAL (*)

Correct 15. Entity names are always singular. True or F alse?


rue (*) False

Correct

Section 3 - Quiz 1 L1-L5 (Answer all questions in this section)

UID. True or False? False? 1. All entities must be given a new artificial UID.


rue False (*)

Incorrect. Refer to Section 3 Lesson 5. 2. People are not born with "numbers", but a lot of systems assign student numbers, customer IDs, IDs, etc. A shoe has a color, color, a size, a style, but may not have a

descriptive "number". So, to be able to uniquely and efficiently identify one instance of the entity SHOE, a/an ______________ UID can be created.


Artificial (*) Structured Identification Unrealistic

Correct 3. here is no limit to how many columns that can make up an entity's UID. True or False?


rue (*) False

Correct 4. Business rules are important to data modelers. True or False?


rue (*) False

Correct

5. "Only teachers may supervise exams" is an example of which of the following?


An attribute that should should be stored on the PERSON entity A procedural business business rule (*) An attribute that is not be inherited from the PERSON supertype and is unique to the TEACHER subtype A structural business business rule

Incorrect. Refer to Section 3 Lesson 2. 6. An ERD is an example of a Physical Model. rue or False?


rue False (*)

Incorrect. Refer to Section 3 Lesson 1. 7. 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?


rue (*) False

Correct 8. Data modeling is performed for the following reasons: (Choose Two)


(Choose all correct answers) 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. It helps discussions and reviews. (*) We do not need datamodels; we can just start coding right away. he ERD becomes a blueprint for designing the actual system. (*)

Correct

Non-volatile attribute. True True or False. 9. Age is a Non-volatile


rue False (*)

Correct 10. o identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it. True or False?


rue (*) False

Correct 11. Which symbol is used to show that a particular attribute is mandatory?


# * (*) & o

Correct 12. he "Other" subtype is mandatory. True or F alse?


rue False (*)

Correct 13. Entity names are always singular. True or False?


rue (*) False

Correct

14. Entity Boxes are drawn with 90 degree angles, also known as Hard Boxes. rue or False?


rue False (*)

Correct 15. Which of the following is true about subtypes?


Subtypes should not be exhaustive. One instance of a supertype may belong to two subtypes. Subtypes must not be mutually exclusive. Subtypes must be mutually exclusive. (*)


Section 2 Quiz (Answer all questions in this section) 1. In the relational model, relationships between relations or tables are created by using?


Foreign Keys (*) Candidate Keys Composite Keys Primary Keys

Correct 2. In the relational model, data is organized in two-dimensional tables called ___________. ________ ___.


Field Relations (*) Row uples

Correct 3. In the relational model, data is organized in two-dimensional tables called relations. rue or False?


rue (*) False

Correct combination of columns in one table that uniquely 4. A foreign key is a column or combination identifies a row of another table.


rue (*) False

Correct 5. Relationships on an ERD can only be transformed into UIDs in the physical model? rue or False?


rue False (*)

Correct

6. Which of the following statements is true?


(Choose all correct answers) Flat file database systems pay more attention to retrieving data and making it accessible to the user, whereas relational databases spend more energy updating indexes and data pointers. Relational database systems are the main thrust behind SQL since it provides the language elements needed to tie together the information in the database. Relational systems pay more attention to retrieving data and making it accessible to the user. Both B and C (*)

Correct 7. Flat file databases avoids data duplication. True or False?


rue False (*)

Correct 8. Data modeling is performed for the following reasons: (Choose Two)


(Choose all correct answers) he ERD becomes a blueprint for designing the actual system. (*) It helps discussions and reviews. (*) We do not need datamodels; we can just start coding right away. 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. Correct data model is converted converted using a Relational Relational Data Base Base Management 9. A conceptual data System to which model?


Logical data model (*) External data model An entity-relation data model Internal data model

Incorrect. Refer to Section 2 Lesson 3. 10. he Physical Model is derived from the Conceptual Model. True or False?


rue (*) False

Correct 11. Primary Key can contain null values.


rue False (*)

Correct

12. Unique Identifiers:


Distinguish nothing Distinguish all entities in a database Distinguish one entity from another. Distinguish one instance of an entity from all other instances of that entity (*) Incorrect. Refer to Section 2 Lesson 5. 13. In a physical data model, a relationship is represented as a combination of: (Choose Two)


(Choose all correct answers) Foreign Key (*) Check Constraint or Unique Key Column Primary Key or Unique Key (*)

Incorrect. Refer to Section 2 Lesson 4. _________ is a piece of information information that in some way describes an an entity. It 14. A/an _________ is a property of the entity and it quantifies, qualifies, classifies, or specifies the entity.


ERD Attribute (*) able Process

Incorrect. Refer to Section 2 Lesson 4. 15. he transformation from an ER diagram to a physical design involves changing terminology. Primary Unique Identifiers in the ER diagram become __________ and relationships become _________ ____________. ___.

Primary keys, Foreign keys (*) Foreign keys, Primary keys Foreign keys, mandatory business rules Unique Keys, Primary keys

Correct


Section 2 Quiz (Answer all questions in this section)

become tables in a database. database. True or False? 1. Attributes become


rue False (*)

Incorrect. Refer to Section 2 Lesson 4. 2. Entities are usually verbs. True or False?


rue False (*)



Unique Constraints (*) Primary Key Constraints Columns ables

Correct 4. Primary Key can contain null values.


rue False (*)

Correct 5. Unique Identifier has a NULL value for each instance of the entity for the lifetime of the instance. True or False


rue False (*)

Correct

6. he Physical Model is derived from the Conceptual Model. rue or False?


rue (*) False

Correct 7. Entity names are always plural.


False (*) rue

Correct 8. 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. rue or False?


rue (*) False

Correct combination of columns in one table that uniquely uniquely 9. A foreign key is a column or combination identifies a row of another table.


rue (*) False

Correct 10. One-to-One relationships are transformed into Foreign Keys in the tables created at either end of that relationship. True or False?


rue False (*)


11. A table must have a primary key. rue or False?


rue False (*)

Correct 12. In the relational model, data is organized in two-dimensional tables called relations. True or False?


rue (*) False

Correct 13. In the relational model, data is organized in two-dimensional tables called ___________. _______ ____.


Field uples Relations (*) Row

Correct 14. Flat file databases avoids data duplication. True or False?


rue False (*)

Correct 15. Which of the following are examples of e-businesses that use database software? (Choose 3)


(Choose all correct answers) Online book store (*) Online clothing store (*)

Online personal shopping service (*) Online research paper Online personal web page

Correct

1. Relationships can be Redundant. rue or False?


rue (*) False

Incorrect. Refer to Section 3 Lesson 7. 2. No parts of an UID are mandatory. True or False?


rue False (*)

Correct problem may be solved solved using either a Recursive Relationship Relationship 3. A particular problem or a Hierarchical Relationship, though not at th e same time. True or False?


rue (*) False

Correct 4. Intersection Entities are at the Parent end of the newly created 1:M (Parent:Child) relationship; therefore, the original entities are the children of the newly created intersection entity. True or False?


rue False (*)

Correct relationship must be Mandatory at both ends. ends. True or False? 5. A recursive relationship


rue

False (*)


6. Which of the following would be a logical constraint when modeling time for a City entity?


People are born in the city and people die in the city. Daily traffic patterns must be monitored to determine how many law enforcement officers are needed. Cites may change their names and/or country association if the borders of a country change. (*) If you are doing a system for any French City, you would ne ed security clearance. Correct 7. Which of the following scenarios should be modeled so that historical data is kept? (Choose two)


(Choose all correct answers) EACHER and AGE CUSTOMER and PAYMENTS (*) CUSTOMER and ORDERS (*) BABY and AGE

Correct 8. A table is in 1NF if … (Choose 2)


(Choose all correct answers) here are no duplicate rows (*) he entries in a column are of different type Each row contains different columns he data is atomic (*)


9. Until all attributes are single-valued, the database model is said to be:


Not Normalized (*) Normalized in 2nd Normal Form in 1st Normal Form

Correct in 2NF if 10. A table is in


It meets the requirements for the 1 NF. Each non-key attribute is fully functional dependent on the table's primary key. Both (*) None

Correct If a relationship can NOT be moved between instances of the entities it connects, it is said to be:


Non-Transferable (*) Mandatory ransferable Optional

Correct 12. Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?


rue False (*)

Correct

Diagram should be developed developed by the end-users of your database. 13. A Matrix Diagram rue or False?


rue False (*)

Incorrect. Refer to Section 3 Lesson 6. 14. 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)


(Choose all correct answers) Each FOOD TYPE may be made from one or more ANIMALs. Each ANIMAL must be the seller of one or more FOOD TYPES. Each FOOD TYPE must be suitable for one or more ANIMALs. (*) Each FOOD TYPE may be given to one or more ANIMALs. (*)

Incorrect. Refer to Section 3 Lesson 6. 15. ransferable relationships can only be mandatory, not optional. True or False?


rue False (*)

Correct 1. If Audit trail attributes are added to an entity, they must be in the entities they are auditing. rue or False?


rue (*) False

Correct

2. Modeling historical data can produce a unique identifier that always excludes dates. True or False?


rue False (*)

Correct 3. Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False?


rue False (*)

Incorrect. Refer to Section 3 Lesson 7. 4. Intersection Entities are at the Parent end of the newly created 1:M (Parent:Child) relationship; therefore, the original entities are the children of the newly created intersection entity. True or False?


rue False (*)

Correct 5. Primary UIDs are:


Always comprised comprised of numbers Something that each Entity should have, but is not mandatory (*) Mandatory in data modeling Useful as an alternative means of identifying instances of an entity, independent of their datatype Correct 6. Arcs are used to visually represent _________ ________ _ between two or more relationships in an ERD.


Differences Exclusivity (*) Inheritance

Sameness

Correct 7. Relationships can be Redundant. True or False?


rue (*) False

Correct Normalization is the process of organizing the attributes and tables of a 8. Normalization relational database to minimize redundancy.


rue (*) False

Correct 9. A table is in 1NF if … (Choose 2)


(Choose all correct answers) he entries in a column are of different type here are no duplicate rows (*) Each row contains different columns he data is atomic (*)

Correct 10. Normalizing an Entity to 1st Normal Form is done by removing any attributes that contain muliple values. True or False?


rue (*) False

Correct 11. Relationship Cardinality is important. rue or False?


rue (*) False

Correct 12. Matrix Diagrams are developed BEFORE the ERD. True or False?


rue (*) False

Correct 13. A non-transferable relationship means the detail can be changed to point to a new master. True or False?


rue False (*)

Incorrect. Refer to Section 3 Lesson 6. 14. One Relationship can be mandatory in one direction and optional in the other direction. True or False?


rue (*) False

Correct 15. Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?


rue False (*)

Correct

1. One-to-One relationships are transformed into Foreign Keys in the tables created


at either end of that relationship. rue or False? rue False (*) Incorrect. Refer to Section 2 Lesson 6. 2. Foreign keys must be null. True or False?


rue False (*) Correct 3. In the relational model, data is organized in two-dimensional tables called relations. True or False?


rue (*) False Correct 4. Each column in a relation is called an entity. True or False?


rue False (*) Incorrect. Refer to Section 2 Lesson 2. 5. In the relational model, data is organized in two-dimensional tables called ___________.


uples Field Row Relations (*) Correct 6. Many reasons exist for creating


a conceptual model. Choose three appropriate reasons from the options below. (Choose 3) (Choose all correct answers) hey capture the implementation details of the physical model. hey model functional and informational needs. (*) hey model the information flow of data. hey accurately describe what a physical model will contain. (*) hey capture current and future needs. (*) Incorrect. Refer to Section 2 Lesson 3. 7. Data models are drawn to show users the actual Data that their new system will contain; only Data listed on th e Diagram can be entered into the Database. True or False?


rue (*) False Incorrect. Refer to Section 2 Lesson 3. data model is converted converted using a Relational Relational Data Base Base 8. A conceptual data Management System to which model?


External data model Logical data model (*) Internal data model An entity-relation data model Correct 9. Primary Key can contain null values.


rue False (*) Correct

10. Unique Identifier has a NULL value for each instance of the entity for the lifetime of the instance. True or False


rue False (*) Correct 11. A flat file database is a type of database that stores data in a multiple tables.


rue False (*) Correct 12. Which of the following statements is true?


(Choose all correct answers) Flat file database systems pay more attention to retrieving data and making it accessible to the user, whereas relational databases spend more energy updating indexes and data pointers. Relational database systems are the main thrust behind SQL since it provides the language elements needed to tie together the information in the database. Relational systems pay more attention to retrieving data and making it accessible to the user. Both B and C (*) Incorrect. Refer to Section 2 Lesson 1. 13. Entities are usually verbs. True or False?


rue False (*) Correct

14. he transformation from an ER diagram to a physical design involves changing terminology. Secondary Unique Identifiers become


Unique Constraints (*) Primary Key Constraints Columns ables Correct 15. Which of the following statements about attributes are true? (Choose Two)


(Choose all correct answers) hey have a data type, such as number or character string. (*) hey describe, qualify, quantify, classify, or specify an entity. (*) hey are often adjectives. hey must be single valued unless they belong to more than one entity. Incorrect. Refer to Section 2 Lesson 4. 1. What is the purpose of a Unique Identifier?


o identify a specific row within a table, using one or more columns and/or foreign keys. o uniquely determine a table and columns within that table. o identify one unique instance of an entity by using one o r more attributes and/or relationships. (*) Create an entity that is unlike any other entity aside from itself. Correct 2. Unique Identifiers:


Distinguish one entity from another. Distinguish all entities in a database Distinguish one instance of an entity from all other instances of that entity (*) Distinguish nothing Correct

database. True or False? 3. Attributes become tables in a database.


rue False (*) Correct _________ is a piece piece of information that in some way describes an 4. A/an _________ entity. It is a property of the entity and an d it quantifies, qualifies, classifies, or specifies the entity.


ERD Process Attribute (*) able Correct 5. Entities are usually verbs. True or False?


rue False (*) Correct 6. In the relational model, relationships between relations or tables are created by using?


Foreign Keys (*) Primary Keys Composite Keys Candidate Keys Correct 7. A table must have a primary key. True or False?


rue

False (*) Incorrect. Refer to Section 2 Lesson 2. 8. In the relational model, data is organized in two-dimensional tables called relations. True or False?


rue (*) False Correct 9. Which of the following are examples of e-businesses that use database software? (Choose 3)


(Choose all correct answers) Online personal shopping service (*) Online personal web page Online book store (*) Online clothing store (*) Online research paper Correct database is a type of database that stores stores data in a multiple 10. A flat file database tables.


rue False (*) Correct 11. 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.


rue or False? rue (*) False Correct 12. Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. (Choose 3)


(Choose all correct answers) hey capture the implementation details of the physical model. hey accurately describe what a physical model will contain. (*) hey model the information flow o f data. hey capture current and future needs. (*) hey model functional and informational needs. (*) Correct 13. Which of the following are reasons we create conceptual models?


It facilitates discussion; a picture is worth a thousand words It forms important ideal system documentation It takes into account government regulations and laws It forms a sound basis for physical database design All of the above (*) Correct 14. Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?


rue False (*) Correct combination of columns in one table that 15. A foreign key is a column or combination uniquely identifies a row of another table.


rue (*) False

Correct 1. A unique identifier must be made up of more than one attribute. rue or False?


rue False (*) Correct 2. he candidate UID that is chosen to identify an entity is called the Primary UID; other candidate UIDs are called Secondary UIDs.


Yes, this is the way UID's UID's are named. (*) (*) No, each Entity can only have one UID, the secondary one. No, after UIDs are first sorted, the first one is called the Primary UID, the second is the Secondary UID, etc. No, it is not possible to have more than one UID for an Entity. Correct 3. here is no limit to how many columns that can make up an entity's UID. rue or False?


rue (*) False Incorrect. Refer to Section 3 Lesson 5. must be an instance of one of the subtypes. subtypes. 4. All instances of the supertype must rue or False?


rue (*) False Incorrect. Refer to Section 3 Lesson 3. 5. Which of the following is true about subtypes?


Subtypes should not be exhaustive. One instance of a supertype may belong to two subtypes. Subtypes must not be mutually exclusive. Subtypes must be mutually exclusive. (*) Correct 6. Which of the following are suitable Entity names? (Choose wo)


(Choose all correct answers) DOGS ANIMALS DOG (*) ANIMAL (*) Correct create relationships to a Supertype, not to a Subtype. True or 7. You can only create False?


rue False (*) Incorrect. Refer to Section 3 Lesson 3. 8. Why is it important to identify and document structural rules?


Ensures we know what data to store and how that data works together. (*) 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. Ensures we know what processes are in place and how to program them. All of the Above. Correct 9. How would you model a business rule that states that girls and boys may not attend classes together?


You cannot model this. You need to document document it Make the attribute Gender mandatory Use a supertype Supertype STUDENT has two subtypes BOY and GIRL which are each related to GENDER which is related to CLASS (*) Incorrect. Refer to Section 3 Lesson 2. Model. True or False? 10. An ERD is an example of a Physical Model.


rue False (*) Correct 11. 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. rue or False?


rue (*) False Correct 12. he Physical Model is derived from the Conceptual Model. True or False?



Non-volatile attribute. True or False. 13. Age is a Non-volatile


rue False (*) Correct can be divided into smaller smaller subparts are 14. Attributes that can called________________.


Volatile Attribute Single Attribute Composite Attribute (*) Mandatory Attribute Correct 15. o identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it. True or False?


rue (*) False Correct (Answer all questions in this section) 1. ransferable relationships can only be mandatory, not optional. True or False?


rue False (*) Correct 2. One Relationship can be mandatory in one direction and optional in the other direction. True or False?



3. Relationship Names are optional. True or False?


rue False (*) Incorrect. Refer to Section 3 Lesson 6. 4. Relationship Cardinality is important. True or False?


rue (*) False Correct 5. Relationships represents something of significance to the business. True or False?


rue (*) False Correct 6. Which of the following would be a logical constraint when modeling time for a City entity?


People are born in the city and people die in the city. Cites may change their names and/or country association if the borders of a country change. (*) Daily traffic patterns must be monitored to determine how many law enforcement officers are needed. If you are doing a system for any French City, you would need security clearance. Incorrect. Refer to Section 3 Lesson 8. 7. If Audit trail attributes are added to an entity, they must be in the entities they are auditing. True or False?


rue (*) False

Correct Normalization is the process of organizing the attributes and tables of a 8. Normalization relational database to minimize redundancy.


rue (*) False Correct 9. Would it be a good idea to model age as an attribute of STUDENT?


Yes, it would prevent our having to calculate someone's someone's age every time we need it. No - it breaks the th e Normalization rules (*) Sometimes, but not all of the time Yes Incorrect. Refer to Section 3 Lesson 9. in 2NF if 10. A table is in


It meets the requirements for the 1 NF. Each non-key attribute is fully functional dependent on the table's primary key. Both (*) None Incorrect. Refer to Section 3 Lesson 9. 11. When you resolve a M:M, you simply redraw the relationships between the two original entities; no new entities are created. rue or False?


rue False (*) Incorrect. Refer to Section 3 Lesson 7.

represent _________ _________ between two or more 12. Arcs are used to visually represent relationships in an ERD.


Inheritance Exclusivity (*) Sameness Differences Correct problem may be solved solved using either a Recursive 13. A particular problem Relationship or a Hierarchical Relationship, though not at the same time. rue or False?


rue (*) False Correct Mandatory in Data modeling. modeling. All ERD's ERD's must have at least least one 14. Arcs are Mandatory Arc. True or False? False?


rue False (*) Incorrect. Refer to Section 3 Lesson 7. 15. Which of the following would best be represented by an arc?


EACHER (Female, Bob) DELIVERY ADDRESS (Home, Office) (*) PARENT (Girl, Bob) STUDENT (Grade A student, Average Student) Incorrect. Refer to Section 3 Lesson 7. . A Diamond on a relationship indicates the Relationship as Nonranferable. rue or False?


rue (*) False Correct 2. Relationship Names are optional. True or False?


rue False (*) Correct 3. Which of the following are true about Cardinality? (Choose two)


(Choose all correct answers) Cardinality specifies whether something is required or not. Cardinality specifies only singularity or plurality, but not a specific plural number. (*) Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship. Cardinality tells "how many". (*) Correct 4. ransferable relationships can only be mandatory, not optional. True or False?


rue False (*) Correct 5. Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?


rue False (*) Correct 6. Would it be a good idea to model age as an


attribute of STUDENT? Yes, it would prevent our having to to calculate someone's someone's age every time time we need it. No - it breaks the th e Normalization rules (*) Sometimes, but not all of the time Yes Correct 7. No commercial database systems in the world will accept tables that are not on 3rd Normal Form. True or False?


rue False (*) Correct 8. When is an entity in 2nd Normal Form?


When all non-UID attributes are dependent upon the entire UID. (*) When attributes with repeating or multi-values are removed. When no attritibutes are mutually independent and all are fully dependent on the primary key. None of the Above. Incorrect. Refer to Section 3 Lesson 9. 9. Historical data must never be kept. True or False?


rue False (*) Correct 10. If Audit trail attributes are added to an entity, they must be in the entities they are auditing. True or False?



11. Relationships can be Redundant. rue or False?


rue (*) False Correct 12. Primary UIDs are:


Useful as an alternative means of identifying instances of an entity, independent of their datatype Always comprised comprised of numbers Mandatory in data modeling Something that each Entity should have, but is not mandatory (*) Incorrect. Refer to Section 3 Lesson 7. 13. What do you call the entity created when you resolve a M:M relationship?


M:M entity Recursive entity Inclusion entity Intersection entity (*) Correct 14. Which of the following would best be represented by an arc?


PARENT (Girl, Bob) EACHER (Female, Bob) DELIVERY ADDRESS (Home, Office) (*) STUDENT (Grade A student, Average Student) Correct 15. Which of the following pairs of entities is most likely to be modeled as a M:M relationship?


REE and BRANCH

PERSON and FINGERPRINT EACHER and SUBJECT AREA (*) CAR and WHEEL Correct

quizday1 (1)

Recommend Documents