Quiz 1 4r3d4s
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 3l3c15
Overview 3z723u
& View Quiz 1 as PDF for free.
More details 2i4a6q
- Words: 6,633
- Pages: 50
1. Business rules help you understand the standardization procedure an organization follows when handling huge data. Mark for Review (1) Points True (*) False
Correct
Correct
2. Business rules are used to understand business processes, and the nature, role, and scope of the data. Mark for Review (1) Points True (*) False
Correct
Correct
3. In a network database model the data is organized into a treelike structure and to retrieve data the whole tree needs to be traversed starting from the root node. Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 1 Lesson 3.
4. In the relational database model, each table name 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. Mark for Review (1) Points True (*) False
Incorrect
Incorrect. Refer to Section 1 Lesson 3.
5. 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. Mark for Review (1) Points True False (*)
Incorrect Incorrect. Refer to Section 1 Lesson 3. 6. Data Integrity ensures the duplication of information. (1) Points
Mark for Review
True False (*)
Incorrect
Incorrect. Refer to Section 1 Lesson 4. 7.
A row is called a record.
Mark for Review
(1) Points True (*) False
Incorrect
Incorrect. Refer to Section 1 Lesson 4. 8.
In a relational database a table is referred to as .. Mark for
Review (1) Points Cardinality Relation (*) Attribute
None
Correct
(Choose 3) (1) Points
Correct 9. A DBMS comprises of the following elements: Mark for Review (Choose all correct answers)
Kernel code (*) Repository of metadata (*) Query language (*) Client
Correct
Correct
10. Information can be defined as facts from which you can deduce new facts Mark for Review (1) Points True False (*)
Incorrect Incorrect. Refer to Section 1 Lesson 2. 11. 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 (1) Points True (*) False
Correct
Correct
12. Once you have learned how to write programs and build systems, you no longer need any input or involvement from any s as you are perfectly capable of delivering the systems that businesses need and want. Mark for Review (1) Points True. s delay the delivery of a system by changing their minds and adding new requirements. True. The only requirement for creating a perfect system is a perfect programmer. False. Business requirements can and will change. For instance new legal requirements may arise. (*) True. s never know what they want anyway, so building systems is best left to the professionals.
Correct
Correct
13. A segment is a set of extents which have been allocated for a specific type of data structure, and all are stored in the same tablespace. Mark for Review (1) Points True (*) False
Correct
Correct
14. Oracle Database stores data logically in tablespaces and physically in datafiles associated with the corresponding tablespace. Mark for Review (1) Points True (*) False
Incorrect
Incorrect. Refer to Section 1 Lesson 5. 15.
The smallest logical storage unit of a database is ...
Mark
for Review (1) Points Data Blocks (*) Extents Segments Tablespaces
Incorrect Incorrect. Refer to Section 1 Lesson 5. 1. A relational model describes a database in of tables, columns, and s between tables. Mark for Review (1) Points True (*) False
Correct
Correct
2. In a network database model the data is organized into a treelike structure and to retrieve data the whole tree needs to be traversed starting from the root node. Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 1 Lesson 3.
3. A flat file may contain many fields, often, with duplicate data that are prone to data corruption. Mark for Review (1) Points True (*) False
Correct
Correct 4.
The main subject areas taught by the Oracle Academy are:
Mark
for Review (1) Points Data Modeling, SQL, and PL/SQL (*) Computer Repairs Systems programming and computer architecture Database performance tuning
Correct
Correct
5. 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 (1) Points True (*) False
Correct Correct 6. A database instance is a set of memory structures that manage database files. Mark for Review (1) Points True (*) False
Correct
Correct 7.
for Review (1) Points
The smallest logical storage unit of a database is ...
Mark
Data Blocks (*) Segments Extents Tablespaces
Correct
Correct
8. perspective. (1) Points
A database can be considered only from a physical storage Mark for Review
True False (*)
Correct
been ... (Choose 3) (1) Points
Correct 9.
The reason or drive for using databases rather than files has
Mark for Review (Choose all correct answers)
Availability of data to a diverse set of s (*) Integration of data for easier access and modification for complex transactions (*) Reduced redundancy of data (*) Use of blocks
Incorrect
Incorrect. Refer to Section 1 Lesson 6.
10. Business rules help you understand the standardization procedure an organization follows when handling huge data. Mark for Review
(1) Points True (*) False
Correct Correct 11. A row is called a record. (1) Points
Mark for Review
True (*) False
Correct
columns. (1) Points
Correct 12. A relational database stores information in tables with rows and Mark for Review
True (*) False
Correct
Correct
13. By defining primary and foreign keys, you can ensure that the integrity of the data in a table is maintained. Mark for Review (1) Points True (*) False
Incorrect
facilities: (1) Points
Incorrect. Refer to Section 1 Lesson 4. 14. A database interacts with the data and provides the following Mark for Review
Retrieving Inserting Both (*) Neither
Correct
(Choose 3) (1) Points
Correct 15. A DBMS comprises of the following elements: Mark for Review (Choose all correct answers)
Kernel code (*) Repository of metadata (*) Query language (*) Client
Correct
Correct
QUIZ 2 1. Data modeling is performed for the following reasons: (Choose Two) for Review (1) Points
Mark
(Choose all correct answers) The ERD becomes a blueprint for deg 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 s; once completed, the ERD is never referred to again as it serves no purpose in the real world.
Incorrect
Incorrect. Refer to Section 2 Lesson 3.
2. A conceptual data model is converted using a Relational Data Base Management System to which model? Mark for Review (1) Points External data model Logical data model (*) An entity-relation data model Internal data model
Incorrect
Incorrect. Refer to Section 2 Lesson 3.
3. Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. (Choose 3) Mark for Review (1) Points (Choose all correct answers) They capture current and future needs. (*) They model functional and informational needs. (*) They accurately describe what a physical model will contain. (*) They model the information flow of data. They capture the implementation details of the physical model.
Incorrect
(1) Points True
Incorrect. Refer to Section 2 Lesson 3. 4.
Primary Key can contain null values.
Mark for Review
False (*)
Correct
Correct 5.
Unique Identifiers:
Mark for Review
(1) Points Distinguish one entity from another. Distinguish nothing Distinguish one instance of an entity from all other instances of that entity (*) Distinguish all entities in a database
Correct Correct 6. Which of the following are examples of e-businesses that use database software? (Choose 3) Mark for Review (1) Points (Choose all correct answers) Online research paper Online clothing store (*) Online book store (*) Online personal shopping service (*) Online personal web page
Incorrect
Incorrect. Refer to Section 2 Lesson 1. 7.
for Review (1) Points
Flat file databases avoids data duplication. True or False? Mark
True False (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 1.
8. In the relational model, data is organized in two-dimensional tables called relations. True or False? Mark for Review (1) Points True (*) False
Correct
databases? (Choose 1) (1) Points
Correct 9.
Which of the following statements does not apply to relational
Mark for Review (Choose all correct answers)
Relational databases have a strong mathematical foundation. Relational databases are simple to understand. Tables are one of the basic components of relational databases Relational databases have a strong procedural orientation (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 2.
10. In the relational model, data is organized in two-dimensional tables called ___________. Mark for Review (1) Points Relations (*) Row
Field Tuples
Incorrect Incorrect. Refer to Section 2 Lesson 2. 11. In a physical data model, an attribute is represented as a/an Review (1) Points
Mark for
Instance Row Foreign Key Column (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 4.
12. The transformation from an ER diagram to a physical design involves changing terminology. Secondary Unique Identifiers become Mark for Review (1) Points Primary Key Constraints Tables Unique Constraints (*) Columns
Incorrect
attributes? (1) Points
Incorrect. Refer to Section 2Lesson 4. 13. Which of the following entities most likely contains invalid Mark for Review
Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built
Entity: Mother. Attributes: Name, Birthdate, Occupation, Number of Children Entity: Pet. Attributes: Name, Birthdate, Owner Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 4.
14. A barred relationship is mapped to a primary-key column on the many side, just like any other M:1 relationship. Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 6.
15. 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 (1) Points True False (*)
Incorrect Incorrect. Refer to Section 2 Lesson 6. 1. In a physical data model, a relationship is represented as a combination of: (Choose Two) Mark for Review (1) Points (Choose all correct answers) Check Constraint or Unique Key Column Foreign Key (*)
Primary Key or Unique Key (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 4.
2. (Choose Two) (1) Points
Which of the following statements about attributes are true? Mark for Review (Choose all correct answers)
They describe, qualify, quantify, classify, or specify an entity. (*) They are often adjectives. They must be single valued unless they belong to more than one entity. They have a data type, such as number or character string. (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 4.
3. 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 (1) Points Process ERD Attribute (*) Table
Correct
Correct 4.
(1) Points True
A table must have a primary key. True or False? Mark for Review
False (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 2.
5. In the relational model, data is organized in two-dimensional tables called ___________. Mark for Review (1) Points Field Relations (*) Tuples Row
Correct Correct 6. Each column in a relation is called an entity. True or False? Review (1) Points
Mark for
True False (*)
Correct
Correct
7. multiple tables. (1) Points
A flat file database is a type of database that stores data in a Mark for Review
True False (*)
Correct
Correct 8.
(1) Points
Which of the following statements is true?
Mark for Review
(Choose all correct answers) Flat file database systems pay more attention to retrieving data and making it accessible to the , 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 . Both B and C (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 1.
9. Mark for Review (1) Points
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 government regulations and laws It forms a sound basis for physical database design All of the above (*)
Incorrect
(1) Points
Incorrect. Refer to Section 2 Lesson 3. 10.
True False (*)
Entity names are always plural.
Mark for Review
Incorrect
Incorrect. Refer to Section 2 Lesson 3.
11. A conceptual data model is converted using a Relational Data Base Management System to which model? Mark for Review (1) Points Internal data model An entity-relation data model External data model Logical data model (*)
Incorrect
(1) Points
Incorrect. Refer to Section 2 Lesson 3. 12.
What is the purpose of a Unique Identifier?
Mark for Review
To uniquely determine a table and columns within that table. Create an entity that is unlike any other entity aside from itself. 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. (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 5.
13. 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 (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 5.
14. Relationships on an ERD can only be transformed into UIDs in the physical model? True or False? Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 6.
15. 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 (1) Points True False (*)
Incorrect Incorrect. Refer to Section 2 Lesson 6. 1. Data models are drawn to show s 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 (1) Points True (*) False
Correct
Correct
2. Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. (Choose 3) Mark for Review (1) Points (Choose all correct answers) They capture the implementation details of the physical model. They accurately describe what a physical model will contain. (*)
They model functional and informational needs. (*) They model the information flow of data. They capture current and future needs. (*)
Correct
Correct
3. A conceptual data model is converted using a Relational Data Base Management System to which model? Mark for Review (1) Points External data model Internal data model An entity-relation data model Logical data model (*)
Correct
Correct
4. Mark for Review (1) Points
Each column in a relation is called an entity. True or False?
True False (*)
Correct
Correct
5. Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three) Mark for Review (1) Points (Choose all correct answers) A set of columns in one table that uniquely identifies each row in another
table. (*) Only one column that must be null. (*) A single column that uniquely identifies each column in a table. (*) One or more columns in a table that uniquely identifies each row in that table.
Correct Correct 6. In the relational model, data is organized in two-dimensional tables called relations. True or False? Mark for Review (1) Points True (*) False
Correct
(1) Points
Correct 7.
What is the purpose of a Unique Identifier?
Mark for Review
To identify one unique instance of an entity by using one or more attributes and/or relationships. (*) Create an entity that is unlike any other entity aside from itself. To identify a specific row within a table, using one or more columns and/or foreign keys. To uniquely determine a table and columns within that table.
Correct
Correct
8. 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
Correct
9. 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 (1) Points Process ERD Table Attribute (*)
Correct
attributes? (1) Points
Correct 10. Which of the following entities most likely contains invalid Mark for Review
Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built Entity: Pet. Attributes: Name, Birthdate, Owner Entity: Mother. Attributes: Name, Birthdate, Occupation, Number of Children Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed (*) for Review (1) Points Experiences Instances (*) Tables
11.
An entity may have which of the following?
Mark
None of the above
Correct
Correct
12. A barred relationship is mapped to a primary-key column on the many side, just like any other M:1 relationship. Mark for Review (1) Points True False (*)
Correct
Correct
13. A foreign key is a column or combination of columns in one table that uniquely identifies a row of another table. Mark for Review (1) Points True (*) False
Correct
(1) Points
Correct 14.
What does single table refer to? (Choose Two)
Mark for Review
(Choose all correct answers) A type of database storage method where all of the data elements are stored on top of each other. A fully-relational database system like Microsoft's SQL Server or Oracle's database systems. Non-relational systems that typically store each table and index in separate files and often do not the SQL language. (*) A database where all of the data is stored in one large table. (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 1.
15. Which of the following are examples of e-businesses that use database software? (Choose 3) Mark for Review (1) Points (Choose all correct answers) Online book store (*) Online personal shopping service (*) Online clothing store (*) Online personal web page Online research paper
Correct Correct 1. 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 (1) Points True (*) False
Correct
Correct
2. Mark for Review (1) Points
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
Correct
3. Data models are drawn to show s 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 (1) Points True (*) False
Correct
Correct
4. Data modeling is performed for the following reasons: (Choose Two) Mark for Review (1) Points (Choose all correct answers) The ERD becomes a blueprint for deg the actual system. (*) We do not need datamodels; we can just start coding right away. We draw an ERD solely to please the s; once completed, the ERD is never referred to again as it serves no purpose in the real world. It helps discussions and reviews. (*)
Incorrect
Incorrect. Refer to Section3Lesson 1. 5.
for Review (1) Points True (*) False
Physical Model shows all table structures. True or False.
Mark
Correct Correct 6. All instances of the supertype must be an instance of one of the subtypes. True or False? Mark for Review (1) Points True (*) False
Incorrect
Incorrect. Refer to Section 3 Lesson 3.
7. Mark for Review (1) Points
Which of the following are suitable Entity names? (Choose Two)
(Choose all correct answers) DOGS DOG (*) ANIMALS ANIMAL (*)
Incorrect
False? (1) Points
Incorrect. Refer to Section 3 Lesson 3. 8. A supertype can only have two subtypes and no more. True or Mark for Review
True False (*)
Incorrect
(1) Points
Incorrect. Refer to Section 3 Lesson 3. 9.
Which of the following is true about subtypes?
Mark for Review
One instance of a supertype may belong to two subtypes. Subtypes should not be exhaustive. Subtypes must not be mutually exclusive. Subtypes must be mutually exclusive. (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 3.
10. There is no limit to how many columns that can make up an entity's UID. True or False? Mark for Review (1) Points True (*) False
Correct Correct 11. All entities must be given a new artificial UID. True or False? Review (1) Points
Mark for
True False (*)
Correct
Correct
12. 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 (1) Points 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.
Yes, this is the way UID's are named. (*)
Incorrect
mandatory? (1) Points
Incorrect. Refer to Section 3 Lesson 5. 13. Which symbol is used to show that a particular attribute is Mark for Review
* (*) # & o
Incorrect
Incorrect. Refer to Section 3 Lesson 4.
14. Attributes that can be divided into smaller subparts are called________________. Mark for Review (1) Points Composite Attribute (*) Mandatory Attribute Single Attribute Volatile Attribute
Correct
Correct
15. 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 Correct Entity names are always singular. True or False? (1) Points
Mark for Review
True (*) False
Incorrect
Incorrect. Refer to Section 3 Lesson 3.
2. Entity Boxes are drawn with 90 degree angles, also known as Hard Boxes. True or False? Mark for Review (1) Points True False (*)
Incorrect
False? (1) Points
Incorrect. Refer to Section 3 Lesson 3. 3. A supertype can only have two subtypes and no more. True or Mark for Review
True False (*)
Correct
(1) Points
Correct 4.
Which of the following is true about subtypes?
One instance of a supertype may belong to two subtypes. Subtypes must not be mutually exclusive. Subtypes must be mutually exclusive. (*)
Mark for Review
Subtypes should not be exhaustive.
Correct
Correct
5. Data models are drawn to show s 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 (1) Points True (*) False
Correct
Correct
6. Data modeling is performed for the following reasons: (Choose Two) Mark for Review (1) Points (Choose all correct answers) We do not need datamodels; we can just start coding right away. The ERD becomes a blueprint for deg the actual system. (*) We draw an ERD solely to please the s; once completed, the ERD is never referred to again as it serves no purpose in the real world. It helps discussions and reviews. (*)
Correct
Correct
7. Documenting Business Requirements helps developers control the scope of the system and prevents s from claiming that the new system does not meet their business requirements. True or False? Mark for Review (1) Points True (*) False
Correct
Correct
8. How would you model a business rule that states that girls and boys may not attend classes together? Mark for Review (1) Points You cannot model this. You need to document it Supertype STUDENT has two subtypes BOY and GIRL which are each related to GENDER which is related to CLASS (*) Make the attribute Gender mandatory Use a supertype
Correct
Correct
9. 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 (1) Points True (*) False
Correct
Correct
10. All the Attributes in a system are just written on the ERD, and they all go in the Top Left Hand Corner of the paper. True or False? Mark for Review (1) Points True False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 4. 11. 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
Correct 12.
Attributes have Instances. True or False? Mark for Review
(1) Points True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 4.
13. People are not born with "numbers", but a lot of systems assign student numbers, customer IDs, etc. ﾠ A shoe has a 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. Mark for Review (1) Points Unrealistic Identification Artificial (*) Structured
Incorrect
Incorrect. Refer to Section 3 Lesson 5.
14. Mark for Review (1) Points
All entities must be given a new artificial UID. True or False?
True
False (*)
Correct
Correct
15. True or False? (1) Points
A unique identifier must be made up of more than one attribute. Mark for Review
True False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 5. 1. People are not born with "numbers", but a lot of systems assign student numbers, customer IDs, etc. ﾠ A shoe has a 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. Mark for Review (1) Points Artificial (*) Identification Unrealistic Structured
Correct
Correct
2. 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 (1) Points 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.
Yes, this is the way UID's are named. (*)
Correct
Correct
3. True or False? (1) Points
A unique identifier must be made up of more than one attribute. Mark for Review
True False (*)
Correct
False? (1) Points
Correct 4. The Physical Model is derived from the Conceptual Model. True or Mark for Review
True (*) False
Incorrect
Incorrect. Refer to Section 3 Lesson 1.
5. Data models are drawn to show s 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 (1) Points True (*) False
Correct Correct 6. An ERD is an example of a Physical Model. True or False? (1) Points True False (*)
Mark for Review
Incorrect
False? (1) Points
Incorrect. Refer to Section 3 Lesson 1. 7. A supertype can only have two subtypes and no more. True or Mark for Review
True False (*)
Correct
Correct
8. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 3.
9. Entity Boxes are drawn with 90 degree angles, also known as Hard Boxes. True or False? Mark for Review (1) Points True False (*)
Correct
Correct 10.
Review (1) Points True
The "Other" subtype is mandatory. True or False?
Mark for
False (*)
Correct Correct 11. "Only teachers may supervise exams" is an example of which of the following? Mark for Review (1) Points A structural business rule An attribute that should be stored on the PERSON entity A procedural business rule (*) An attribute that is not be inherited from the PERSON supertype and is unique to the TEACHER subtype
Incorrect
Incorrect. Refer to Section 3 Lesson 2.
12. A business rule such as "We only ship goods after customers have completely paid any outstanding balances on their " is best enforced by: Mark for Review (1) Points We need to trust our customers, and we know they will pay some day. Hiring a programmer to create additional programming code to no goods are shipped until the has been settled in full. (*) Making the payment attribute optional. Making the payment attribute null.
Correct
mandatory? (1) Points & #
Correct 13. Which symbol is used to show that a particular attribute is Mark for Review
* (*) o
Correct
(1) Points
Correct 14.
Attributes have Instances. True or False? Mark for Review
True False (*)
Correct
Correct
15. 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
Correct
1. An entity without repeated values is said to be in 1st Normal Form. True or False? Mark for Review (1) Points True (*) False
Correct
Correct
2. 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 (1) Points
True (*) False
Correct
is met? (1) Points
Correct 3. A table is in 2NF if the table is in 1NF and what other condition Mark for Review
There are no null values in primary key fields. There are no attributes that are not functionally dependent on the relation's primary key. (*) There are no functional dependencies. There are no repeating groups.
Incorrect
Incorrect. Refer to Section 3 Lesson 9.
4. A non-transferable relationship means the detail can be changed to point to a new master. True or False? Mark for Review (1) Points True False (*)
Correct
Correct
5. Matrix Diagrams are used to that all relationships have been identified for an ERD. True or False? Mark for Review (1) Points True (*) False
Correct Correct 6. Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False? Mark for Review (1) Points True False (*)
Correct
Correct
7. Mark for Review (1) Points
Matrix Diagrams are developed BEFORE the ERD. True or False?
True (*) False
Incorrect
Incorrect. Refer to Section 3 Lesson 6.
8. True or False? (1) Points
Transferable relationships can only be mandatory, not optional. Mark for Review
True False (*)
Correct
Correct
9. Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review (1) Points People are born in the city and people die in the city. If you are doing a system for any French City, you would need security clearance.
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. (*)
Incorrect
Review (1) Points
Incorrect. Refer to Section 3 Lesson 8. 10.
Modeling historical data is optional. True or False?
Mark for
True (*) False 11. 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 (1) Points True (*) False
Incorrect
(1) Points
Incorrect. Refer to Section 3 Lesson 7. 12.
Primary UIDs are:
Mark for Review
Something that each Entity should have, but is not mandatory (*) Always comprised of numbers Useful as an alternative means of identifying instances of an entity, independent of their datatype Mandatory in data modeling
Incorrect
Incorrect. Refer to Section 3 Lesson 7.
13. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review (1) Points True (*) False
Correct
or False? (1) Points
Correct 14. All relationships participating in an arc must be mandatory. True Mark for Review
True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 7. 15.
No parts of an UID are mandatory. True or False?
Mark for
Review (1) Points True False (*)
Correct Correct 1. Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False? Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 6.
2. 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 (1) Points (Choose all correct answers) Each FOOD TYPE may be given to 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 made from one or more ANIMALs.
Incorrect
Incorrect. Refer to Section 3 Lesson 6.
3. Matrix Diagrams are used to that all relationships have been identified for an ERD. True or False? Mark for Review (1) Points True (*) False
Correct
Correct
4. Mark for Review (1) Points
Which of the following are true about Cardinality? (Choose two)
(Choose all correct answers) Cardinality specifies whether something is required or not. Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship. Cardinality specifies only singularity or plurality, but not a specific plural number. (*) Cardinality tells "how many". (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 6.
5. A Matrix Diagram should be developed by the end-s of your database. True or False? Mark for Review (1) Points True False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 6. 6. Normalization is the process of organizing the attributes and tables of a relational database to minimize redundancy. Mark for Review (1) Points True (*) False
Correct
Correct
7. No commercial database systems in the world will accept tables that are not on 3rd Normal Form. True or False? Mark for Review (1) Points True False (*)
Correct
Correct
8. A table is in 3NF if it has met all database requirements for both 1NF and 2NF and ll transitive dependencies are eliminated. Mark for Review (1) Points True (*) False
Correct
Correct
9. Modeling historical data can produce a unique identifier that always excludes dates. True or False? Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 8.
10. Which of the following scenarios should be modeled so that historical data is kept? (Choose two) Mark for Review (1) Points (Choose all correct answers) CUSTOMER and PAYMENTS (*) CUSTOMER and ORDERS (*) TEACHER and AGE BABY and AGE
Incorrect Incorrect. Refer to Section 3 Lesson 8. 11. Primary UIDs are: Mark for Review (1) Points Mandatory in data modeling Useful as an alternative means of identifying instances of an entity, independent of their datatype Always comprised of numbers Something that each Entity should have, but is not mandatory (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 7.
12. 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 (1) Points Many to Many Mandatory One to Many Mandatory One to Many Optional One to One Optional (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 7.
13. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review (1) Points True (*) False
Correct
False? (1) Points
Correct 14. An arc can also be modeled as Supertype and Subtypes. True or Mark for Review
True (*) False
Correct
Correct
15. relationship? (1) Points
What do you call the entity created when you resolve a M:M Mark for Review
Inclusion entity M:M entity Recursive entity Intersection entity (*)
Incorrect Incorrect. Refer to Section 3 Lesson 7. 1. Relationships can be Redundant. True or False? Mark for Review (1) Points True (*) False
Incorrect
Incorrect. Refer to Section 3 Lesson 7.
2. 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? Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 7.
3. 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 (1) Points True False (*)
Correct
Correct
4. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review (1) Points True (*) False
Correct
Correct
5. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review (1) Points TEACHER and SUBJECT AREA (*) TREE and BRANCH PERSON and FINGERPRINT CAR and WHEEL
Incorrect Incorrect. Refer to Section 3 Lesson 7. 6. Matrix Diagrams are used to that all relationships have been identified for an ERD. True or False? Mark for Review (1) Points True (*) False
Correct
Correct
7. 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 (1) Points (Choose all correct answers)
Each ANIMAL must be the seller of one or more FOOD TYPES. Each FOOD TYPE may be made from one or more ANIMALs. Each FOOD TYPE may be given to one or more ANIMALs. (*) Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
Correct
Correct
8. A Matrix Diagram should be developed by the end-s of your database. True or False? Mark for Review (1) Points True False (*)
Correct
Correct
9. One Relationship can be mandatory in one direction and optional in the other direction. True or False? Mark for Review (1) Points True (*) False
Correct
Correct
10. Mark for Review (1) Points
Matrix Diagrams are developed BEFORE the ERD. True or False?
True (*) False
Correct
Correct
11. Normalization is the process of organizing the attributes and tables of a relational database to minimize redundancy. Mark for Review (1) Points True (*) False
Correct
(Choose 2) (1) Points
Correct 12. A table is in 1NF if … Mark for Review (Choose all correct answers)
The data is atomic (*) There are no duplicate rows (*) Each row contains different columns The entries in a column are of different type
Incorrect
Incorrect. Refer to Section 3 Lesson 9.
13. According to 3rd Normal Form, an attribute must be dependent on its entity’s entire unique identifier. True or False. Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 9.
14. Which of the following scenarios should be modeled so that historical data is kept? (Choose two) Mark for Review (1) Points
(Choose all correct answers) BABY and AGE CUSTOMER and ORDERS (*) TEACHER and AGE CUSTOMER and PAYMENTS (*)
Correct
Correct
15. Modeling historical data can produce a unique identifier that always excludes dates. True or False? Mark for Review (1) Points True False (*)
Correct
Correct
Correct
Correct
2. Business rules are used to understand business processes, and the nature, role, and scope of the data. Mark for Review (1) Points True (*) False
Correct
Correct
3. In a network database model the data is organized into a treelike structure and to retrieve data the whole tree needs to be traversed starting from the root node. Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 1 Lesson 3.
4. In the relational database model, each table name 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. Mark for Review (1) Points True (*) False
Incorrect
Incorrect. Refer to Section 1 Lesson 3.
5. 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. Mark for Review (1) Points True False (*)
Incorrect Incorrect. Refer to Section 1 Lesson 3. 6. Data Integrity ensures the duplication of information. (1) Points
Mark for Review
True False (*)
Incorrect
Incorrect. Refer to Section 1 Lesson 4. 7.
A row is called a record.
Mark for Review
(1) Points True (*) False
Incorrect
Incorrect. Refer to Section 1 Lesson 4. 8.
In a relational database a table is referred to as .. Mark for
Review (1) Points Cardinality Relation (*) Attribute
None
Correct
(Choose 3) (1) Points
Correct 9. A DBMS comprises of the following elements: Mark for Review (Choose all correct answers)
Kernel code (*) Repository of metadata (*) Query language (*) Client
Correct
Correct
10. Information can be defined as facts from which you can deduce new facts Mark for Review (1) Points True False (*)
Incorrect Incorrect. Refer to Section 1 Lesson 2. 11. 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 (1) Points True (*) False
Correct
Correct
12. Once you have learned how to write programs and build systems, you no longer need any input or involvement from any s as you are perfectly capable of delivering the systems that businesses need and want. Mark for Review (1) Points True. s delay the delivery of a system by changing their minds and adding new requirements. True. The only requirement for creating a perfect system is a perfect programmer. False. Business requirements can and will change. For instance new legal requirements may arise. (*) True. s never know what they want anyway, so building systems is best left to the professionals.
Correct
Correct
13. A segment is a set of extents which have been allocated for a specific type of data structure, and all are stored in the same tablespace. Mark for Review (1) Points True (*) False
Correct
Correct
14. Oracle Database stores data logically in tablespaces and physically in datafiles associated with the corresponding tablespace. Mark for Review (1) Points True (*) False
Incorrect
Incorrect. Refer to Section 1 Lesson 5. 15.
The smallest logical storage unit of a database is ...
Mark
for Review (1) Points Data Blocks (*) Extents Segments Tablespaces
Incorrect Incorrect. Refer to Section 1 Lesson 5. 1. A relational model describes a database in of tables, columns, and s between tables. Mark for Review (1) Points True (*) False
Correct
Correct
2. In a network database model the data is organized into a treelike structure and to retrieve data the whole tree needs to be traversed starting from the root node. Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 1 Lesson 3.
3. A flat file may contain many fields, often, with duplicate data that are prone to data corruption. Mark for Review (1) Points True (*) False
Correct
Correct 4.
The main subject areas taught by the Oracle Academy are:
Mark
for Review (1) Points Data Modeling, SQL, and PL/SQL (*) Computer Repairs Systems programming and computer architecture Database performance tuning
Correct
Correct
5. 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 (1) Points True (*) False
Correct Correct 6. A database instance is a set of memory structures that manage database files. Mark for Review (1) Points True (*) False
Correct
Correct 7.
for Review (1) Points
The smallest logical storage unit of a database is ...
Mark
Data Blocks (*) Segments Extents Tablespaces
Correct
Correct
8. perspective. (1) Points
A database can be considered only from a physical storage Mark for Review
True False (*)
Correct
been ... (Choose 3) (1) Points
Correct 9.
The reason or drive for using databases rather than files has
Mark for Review (Choose all correct answers)
Availability of data to a diverse set of s (*) Integration of data for easier access and modification for complex transactions (*) Reduced redundancy of data (*) Use of blocks
Incorrect
Incorrect. Refer to Section 1 Lesson 6.
10. Business rules help you understand the standardization procedure an organization follows when handling huge data. Mark for Review
(1) Points True (*) False
Correct Correct 11. A row is called a record. (1) Points
Mark for Review
True (*) False
Correct
columns. (1) Points
Correct 12. A relational database stores information in tables with rows and Mark for Review
True (*) False
Correct
Correct
13. By defining primary and foreign keys, you can ensure that the integrity of the data in a table is maintained. Mark for Review (1) Points True (*) False
Incorrect
facilities: (1) Points
Incorrect. Refer to Section 1 Lesson 4. 14. A database interacts with the data and provides the following Mark for Review
Retrieving Inserting Both (*) Neither
Correct
(Choose 3) (1) Points
Correct 15. A DBMS comprises of the following elements: Mark for Review (Choose all correct answers)
Kernel code (*) Repository of metadata (*) Query language (*) Client
Correct
Correct
QUIZ 2 1. Data modeling is performed for the following reasons: (Choose Two) for Review (1) Points
Mark
(Choose all correct answers) The ERD becomes a blueprint for deg 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 s; once completed, the ERD is never referred to again as it serves no purpose in the real world.
Incorrect
Incorrect. Refer to Section 2 Lesson 3.
2. A conceptual data model is converted using a Relational Data Base Management System to which model? Mark for Review (1) Points External data model Logical data model (*) An entity-relation data model Internal data model
Incorrect
Incorrect. Refer to Section 2 Lesson 3.
3. Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. (Choose 3) Mark for Review (1) Points (Choose all correct answers) They capture current and future needs. (*) They model functional and informational needs. (*) They accurately describe what a physical model will contain. (*) They model the information flow of data. They capture the implementation details of the physical model.
Incorrect
(1) Points True
Incorrect. Refer to Section 2 Lesson 3. 4.
Primary Key can contain null values.
Mark for Review
False (*)
Correct
Correct 5.
Unique Identifiers:
Mark for Review
(1) Points Distinguish one entity from another. Distinguish nothing Distinguish one instance of an entity from all other instances of that entity (*) Distinguish all entities in a database
Correct Correct 6. Which of the following are examples of e-businesses that use database software? (Choose 3) Mark for Review (1) Points (Choose all correct answers) Online research paper Online clothing store (*) Online book store (*) Online personal shopping service (*) Online personal web page
Incorrect
Incorrect. Refer to Section 2 Lesson 1. 7.
for Review (1) Points
Flat file databases avoids data duplication. True or False? Mark
True False (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 1.
8. In the relational model, data is organized in two-dimensional tables called relations. True or False? Mark for Review (1) Points True (*) False
Correct
databases? (Choose 1) (1) Points
Correct 9.
Which of the following statements does not apply to relational
Mark for Review (Choose all correct answers)
Relational databases have a strong mathematical foundation. Relational databases are simple to understand. Tables are one of the basic components of relational databases Relational databases have a strong procedural orientation (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 2.
10. In the relational model, data is organized in two-dimensional tables called ___________. Mark for Review (1) Points Relations (*) Row
Field Tuples
Incorrect Incorrect. Refer to Section 2 Lesson 2. 11. In a physical data model, an attribute is represented as a/an Review (1) Points
Mark for
Instance Row Foreign Key Column (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 4.
12. The transformation from an ER diagram to a physical design involves changing terminology. Secondary Unique Identifiers become Mark for Review (1) Points Primary Key Constraints Tables Unique Constraints (*) Columns
Incorrect
attributes? (1) Points
Incorrect. Refer to Section 2Lesson 4. 13. Which of the following entities most likely contains invalid Mark for Review
Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built
Entity: Mother. Attributes: Name, Birthdate, Occupation, Number of Children Entity: Pet. Attributes: Name, Birthdate, Owner Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 4.
14. A barred relationship is mapped to a primary-key column on the many side, just like any other M:1 relationship. Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 6.
15. 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 (1) Points True False (*)
Incorrect Incorrect. Refer to Section 2 Lesson 6. 1. In a physical data model, a relationship is represented as a combination of: (Choose Two) Mark for Review (1) Points (Choose all correct answers) Check Constraint or Unique Key Column Foreign Key (*)
Primary Key or Unique Key (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 4.
2. (Choose Two) (1) Points
Which of the following statements about attributes are true? Mark for Review (Choose all correct answers)
They describe, qualify, quantify, classify, or specify an entity. (*) They are often adjectives. They must be single valued unless they belong to more than one entity. They have a data type, such as number or character string. (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 4.
3. 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 (1) Points Process ERD Attribute (*) Table
Correct
Correct 4.
(1) Points True
A table must have a primary key. True or False? Mark for Review
False (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 2.
5. In the relational model, data is organized in two-dimensional tables called ___________. Mark for Review (1) Points Field Relations (*) Tuples Row
Correct Correct 6. Each column in a relation is called an entity. True or False? Review (1) Points
Mark for
True False (*)
Correct
Correct
7. multiple tables. (1) Points
A flat file database is a type of database that stores data in a Mark for Review
True False (*)
Correct
Correct 8.
(1) Points
Which of the following statements is true?
Mark for Review
(Choose all correct answers) Flat file database systems pay more attention to retrieving data and making it accessible to the , 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 . Both B and C (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 1.
9. Mark for Review (1) Points
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 government regulations and laws It forms a sound basis for physical database design All of the above (*)
Incorrect
(1) Points
Incorrect. Refer to Section 2 Lesson 3. 10.
True False (*)
Entity names are always plural.
Mark for Review
Incorrect
Incorrect. Refer to Section 2 Lesson 3.
11. A conceptual data model is converted using a Relational Data Base Management System to which model? Mark for Review (1) Points Internal data model An entity-relation data model External data model Logical data model (*)
Incorrect
(1) Points
Incorrect. Refer to Section 2 Lesson 3. 12.
What is the purpose of a Unique Identifier?
Mark for Review
To uniquely determine a table and columns within that table. Create an entity that is unlike any other entity aside from itself. 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. (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 5.
13. 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 (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 5.
14. Relationships on an ERD can only be transformed into UIDs in the physical model? True or False? Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 6.
15. 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 (1) Points True False (*)
Incorrect Incorrect. Refer to Section 2 Lesson 6. 1. Data models are drawn to show s 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 (1) Points True (*) False
Correct
Correct
2. Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. (Choose 3) Mark for Review (1) Points (Choose all correct answers) They capture the implementation details of the physical model. They accurately describe what a physical model will contain. (*)
They model functional and informational needs. (*) They model the information flow of data. They capture current and future needs. (*)
Correct
Correct
3. A conceptual data model is converted using a Relational Data Base Management System to which model? Mark for Review (1) Points External data model Internal data model An entity-relation data model Logical data model (*)
Correct
Correct
4. Mark for Review (1) Points
Each column in a relation is called an entity. True or False?
True False (*)
Correct
Correct
5. Identify all of the incorrect statements that complete this sentence: A primary key is...(Choose three) Mark for Review (1) Points (Choose all correct answers) A set of columns in one table that uniquely identifies each row in another
table. (*) Only one column that must be null. (*) A single column that uniquely identifies each column in a table. (*) One or more columns in a table that uniquely identifies each row in that table.
Correct Correct 6. In the relational model, data is organized in two-dimensional tables called relations. True or False? Mark for Review (1) Points True (*) False
Correct
(1) Points
Correct 7.
What is the purpose of a Unique Identifier?
Mark for Review
To identify one unique instance of an entity by using one or more attributes and/or relationships. (*) Create an entity that is unlike any other entity aside from itself. To identify a specific row within a table, using one or more columns and/or foreign keys. To uniquely determine a table and columns within that table.
Correct
Correct
8. 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
Correct
9. 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 (1) Points Process ERD Table Attribute (*)
Correct
attributes? (1) Points
Correct 10. Which of the following entities most likely contains invalid Mark for Review
Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built Entity: Pet. Attributes: Name, Birthdate, Owner Entity: Mother. Attributes: Name, Birthdate, Occupation, Number of Children Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed (*) for Review (1) Points Experiences Instances (*) Tables
11.
An entity may have which of the following?
Mark
None of the above
Correct
Correct
12. A barred relationship is mapped to a primary-key column on the many side, just like any other M:1 relationship. Mark for Review (1) Points True False (*)
Correct
Correct
13. A foreign key is a column or combination of columns in one table that uniquely identifies a row of another table. Mark for Review (1) Points True (*) False
Correct
(1) Points
Correct 14.
What does single table refer to? (Choose Two)
Mark for Review
(Choose all correct answers) A type of database storage method where all of the data elements are stored on top of each other. A fully-relational database system like Microsoft's SQL Server or Oracle's database systems. Non-relational systems that typically store each table and index in separate files and often do not the SQL language. (*) A database where all of the data is stored in one large table. (*)
Incorrect
Incorrect. Refer to Section 2 Lesson 1.
15. Which of the following are examples of e-businesses that use database software? (Choose 3) Mark for Review (1) Points (Choose all correct answers) Online book store (*) Online personal shopping service (*) Online clothing store (*) Online personal web page Online research paper
Correct Correct 1. 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 (1) Points True (*) False
Correct
Correct
2. Mark for Review (1) Points
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
Correct
3. Data models are drawn to show s 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 (1) Points True (*) False
Correct
Correct
4. Data modeling is performed for the following reasons: (Choose Two) Mark for Review (1) Points (Choose all correct answers) The ERD becomes a blueprint for deg the actual system. (*) We do not need datamodels; we can just start coding right away. We draw an ERD solely to please the s; once completed, the ERD is never referred to again as it serves no purpose in the real world. It helps discussions and reviews. (*)
Incorrect
Incorrect. Refer to Section3Lesson 1. 5.
for Review (1) Points True (*) False
Physical Model shows all table structures. True or False.
Mark
Correct Correct 6. All instances of the supertype must be an instance of one of the subtypes. True or False? Mark for Review (1) Points True (*) False
Incorrect
Incorrect. Refer to Section 3 Lesson 3.
7. Mark for Review (1) Points
Which of the following are suitable Entity names? (Choose Two)
(Choose all correct answers) DOGS DOG (*) ANIMALS ANIMAL (*)
Incorrect
False? (1) Points
Incorrect. Refer to Section 3 Lesson 3. 8. A supertype can only have two subtypes and no more. True or Mark for Review
True False (*)
Incorrect
(1) Points
Incorrect. Refer to Section 3 Lesson 3. 9.
Which of the following is true about subtypes?
Mark for Review
One instance of a supertype may belong to two subtypes. Subtypes should not be exhaustive. Subtypes must not be mutually exclusive. Subtypes must be mutually exclusive. (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 3.
10. There is no limit to how many columns that can make up an entity's UID. True or False? Mark for Review (1) Points True (*) False
Correct Correct 11. All entities must be given a new artificial UID. True or False? Review (1) Points
Mark for
True False (*)
Correct
Correct
12. 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 (1) Points 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.
Yes, this is the way UID's are named. (*)
Incorrect
mandatory? (1) Points
Incorrect. Refer to Section 3 Lesson 5. 13. Which symbol is used to show that a particular attribute is Mark for Review
* (*) # & o
Incorrect
Incorrect. Refer to Section 3 Lesson 4.
14. Attributes that can be divided into smaller subparts are called________________. Mark for Review (1) Points Composite Attribute (*) Mandatory Attribute Single Attribute Volatile Attribute
Correct
Correct
15. 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 Correct Entity names are always singular. True or False? (1) Points
Mark for Review
True (*) False
Incorrect
Incorrect. Refer to Section 3 Lesson 3.
2. Entity Boxes are drawn with 90 degree angles, also known as Hard Boxes. True or False? Mark for Review (1) Points True False (*)
Incorrect
False? (1) Points
Incorrect. Refer to Section 3 Lesson 3. 3. A supertype can only have two subtypes and no more. True or Mark for Review
True False (*)
Correct
(1) Points
Correct 4.
Which of the following is true about subtypes?
One instance of a supertype may belong to two subtypes. Subtypes must not be mutually exclusive. Subtypes must be mutually exclusive. (*)
Mark for Review
Subtypes should not be exhaustive.
Correct
Correct
5. Data models are drawn to show s 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 (1) Points True (*) False
Correct
Correct
6. Data modeling is performed for the following reasons: (Choose Two) Mark for Review (1) Points (Choose all correct answers) We do not need datamodels; we can just start coding right away. The ERD becomes a blueprint for deg the actual system. (*) We draw an ERD solely to please the s; once completed, the ERD is never referred to again as it serves no purpose in the real world. It helps discussions and reviews. (*)
Correct
Correct
7. Documenting Business Requirements helps developers control the scope of the system and prevents s from claiming that the new system does not meet their business requirements. True or False? Mark for Review (1) Points True (*) False
Correct
Correct
8. How would you model a business rule that states that girls and boys may not attend classes together? Mark for Review (1) Points You cannot model this. You need to document it Supertype STUDENT has two subtypes BOY and GIRL which are each related to GENDER which is related to CLASS (*) Make the attribute Gender mandatory Use a supertype
Correct
Correct
9. 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 (1) Points True (*) False
Correct
Correct
10. All the Attributes in a system are just written on the ERD, and they all go in the Top Left Hand Corner of the paper. True or False? Mark for Review (1) Points True False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 4. 11. 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
Correct 12.
Attributes have Instances. True or False? Mark for Review
(1) Points True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 4.
13. People are not born with "numbers", but a lot of systems assign student numbers, customer IDs, etc. ﾠ A shoe has a 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. Mark for Review (1) Points Unrealistic Identification Artificial (*) Structured
Incorrect
Incorrect. Refer to Section 3 Lesson 5.
14. Mark for Review (1) Points
All entities must be given a new artificial UID. True or False?
True
False (*)
Correct
Correct
15. True or False? (1) Points
A unique identifier must be made up of more than one attribute. Mark for Review
True False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 5. 1. People are not born with "numbers", but a lot of systems assign student numbers, customer IDs, etc. ﾠ A shoe has a 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. Mark for Review (1) Points Artificial (*) Identification Unrealistic Structured
Correct
Correct
2. 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 (1) Points 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.
Yes, this is the way UID's are named. (*)
Correct
Correct
3. True or False? (1) Points
A unique identifier must be made up of more than one attribute. Mark for Review
True False (*)
Correct
False? (1) Points
Correct 4. The Physical Model is derived from the Conceptual Model. True or Mark for Review
True (*) False
Incorrect
Incorrect. Refer to Section 3 Lesson 1.
5. Data models are drawn to show s 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 (1) Points True (*) False
Correct Correct 6. An ERD is an example of a Physical Model. True or False? (1) Points True False (*)
Mark for Review
Incorrect
False? (1) Points
Incorrect. Refer to Section 3 Lesson 1. 7. A supertype can only have two subtypes and no more. True or Mark for Review
True False (*)
Correct
Correct
8. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 3.
9. Entity Boxes are drawn with 90 degree angles, also known as Hard Boxes. True or False? Mark for Review (1) Points True False (*)
Correct
Correct 10.
Review (1) Points True
The "Other" subtype is mandatory. True or False?
Mark for
False (*)
Correct Correct 11. "Only teachers may supervise exams" is an example of which of the following? Mark for Review (1) Points A structural business rule An attribute that should be stored on the PERSON entity A procedural business rule (*) An attribute that is not be inherited from the PERSON supertype and is unique to the TEACHER subtype
Incorrect
Incorrect. Refer to Section 3 Lesson 2.
12. A business rule such as "We only ship goods after customers have completely paid any outstanding balances on their " is best enforced by: Mark for Review (1) Points We need to trust our customers, and we know they will pay some day. Hiring a programmer to create additional programming code to no goods are shipped until the has been settled in full. (*) Making the payment attribute optional. Making the payment attribute null.
Correct
mandatory? (1) Points & #
Correct 13. Which symbol is used to show that a particular attribute is Mark for Review
* (*) o
Correct
(1) Points
Correct 14.
Attributes have Instances. True or False? Mark for Review
True False (*)
Correct
Correct
15. 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
Correct
1. An entity without repeated values is said to be in 1st Normal Form. True or False? Mark for Review (1) Points True (*) False
Correct
Correct
2. 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 (1) Points
True (*) False
Correct
is met? (1) Points
Correct 3. A table is in 2NF if the table is in 1NF and what other condition Mark for Review
There are no null values in primary key fields. There are no attributes that are not functionally dependent on the relation's primary key. (*) There are no functional dependencies. There are no repeating groups.
Incorrect
Incorrect. Refer to Section 3 Lesson 9.
4. A non-transferable relationship means the detail can be changed to point to a new master. True or False? Mark for Review (1) Points True False (*)
Correct
Correct
5. Matrix Diagrams are used to that all relationships have been identified for an ERD. True or False? Mark for Review (1) Points True (*) False
Correct Correct 6. Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False? Mark for Review (1) Points True False (*)
Correct
Correct
7. Mark for Review (1) Points
Matrix Diagrams are developed BEFORE the ERD. True or False?
True (*) False
Incorrect
Incorrect. Refer to Section 3 Lesson 6.
8. True or False? (1) Points
Transferable relationships can only be mandatory, not optional. Mark for Review
True False (*)
Correct
Correct
9. Which of the following would be a logical constraint when modeling time for a City entity? Mark for Review (1) Points People are born in the city and people die in the city. If you are doing a system for any French City, you would need security clearance.
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. (*)
Incorrect
Review (1) Points
Incorrect. Refer to Section 3 Lesson 8. 10.
Modeling historical data is optional. True or False?
Mark for
True (*) False 11. 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 (1) Points True (*) False
Incorrect
(1) Points
Incorrect. Refer to Section 3 Lesson 7. 12.
Primary UIDs are:
Mark for Review
Something that each Entity should have, but is not mandatory (*) Always comprised of numbers Useful as an alternative means of identifying instances of an entity, independent of their datatype Mandatory in data modeling
Incorrect
Incorrect. Refer to Section 3 Lesson 7.
13. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review (1) Points True (*) False
Correct
or False? (1) Points
Correct 14. All relationships participating in an arc must be mandatory. True Mark for Review
True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 7. 15.
No parts of an UID are mandatory. True or False?
Mark for
Review (1) Points True False (*)
Correct Correct 1. Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False? Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 6.
2. 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 (1) Points (Choose all correct answers) Each FOOD TYPE may be given to 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 made from one or more ANIMALs.
Incorrect
Incorrect. Refer to Section 3 Lesson 6.
3. Matrix Diagrams are used to that all relationships have been identified for an ERD. True or False? Mark for Review (1) Points True (*) False
Correct
Correct
4. Mark for Review (1) Points
Which of the following are true about Cardinality? (Choose two)
(Choose all correct answers) Cardinality specifies whether something is required or not. Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship. Cardinality specifies only singularity or plurality, but not a specific plural number. (*) Cardinality tells "how many". (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 6.
5. A Matrix Diagram should be developed by the end-s of your database. True or False? Mark for Review (1) Points True False (*)
Incorrect Incorrect. Refer to Section 3 Lesson 6. 6. Normalization is the process of organizing the attributes and tables of a relational database to minimize redundancy. Mark for Review (1) Points True (*) False
Correct
Correct
7. No commercial database systems in the world will accept tables that are not on 3rd Normal Form. True or False? Mark for Review (1) Points True False (*)
Correct
Correct
8. A table is in 3NF if it has met all database requirements for both 1NF and 2NF and ll transitive dependencies are eliminated. Mark for Review (1) Points True (*) False
Correct
Correct
9. Modeling historical data can produce a unique identifier that always excludes dates. True or False? Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 8.
10. Which of the following scenarios should be modeled so that historical data is kept? (Choose two) Mark for Review (1) Points (Choose all correct answers) CUSTOMER and PAYMENTS (*) CUSTOMER and ORDERS (*) TEACHER and AGE BABY and AGE
Incorrect Incorrect. Refer to Section 3 Lesson 8. 11. Primary UIDs are: Mark for Review (1) Points Mandatory in data modeling Useful as an alternative means of identifying instances of an entity, independent of their datatype Always comprised of numbers Something that each Entity should have, but is not mandatory (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 7.
12. 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 (1) Points Many to Many Mandatory One to Many Mandatory One to Many Optional One to One Optional (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 7.
13. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review (1) Points True (*) False
Correct
False? (1) Points
Correct 14. An arc can also be modeled as Supertype and Subtypes. True or Mark for Review
True (*) False
Correct
Correct
15. relationship? (1) Points
What do you call the entity created when you resolve a M:M Mark for Review
Inclusion entity M:M entity Recursive entity Intersection entity (*)
Incorrect Incorrect. Refer to Section 3 Lesson 7. 1. Relationships can be Redundant. True or False? Mark for Review (1) Points True (*) False
Incorrect
Incorrect. Refer to Section 3 Lesson 7.
2. 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? Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 7.
3. 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 (1) Points True False (*)
Correct
Correct
4. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review (1) Points True (*) False
Correct
Correct
5. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review (1) Points TEACHER and SUBJECT AREA (*) TREE and BRANCH PERSON and FINGERPRINT CAR and WHEEL
Incorrect Incorrect. Refer to Section 3 Lesson 7. 6. Matrix Diagrams are used to that all relationships have been identified for an ERD. True or False? Mark for Review (1) Points True (*) False
Correct
Correct
7. 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 (1) Points (Choose all correct answers)
Each ANIMAL must be the seller of one or more FOOD TYPES. Each FOOD TYPE may be made from one or more ANIMALs. Each FOOD TYPE may be given to one or more ANIMALs. (*) Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
Correct
Correct
8. A Matrix Diagram should be developed by the end-s of your database. True or False? Mark for Review (1) Points True False (*)
Correct
Correct
9. One Relationship can be mandatory in one direction and optional in the other direction. True or False? Mark for Review (1) Points True (*) False
Correct
Correct
10. Mark for Review (1) Points
Matrix Diagrams are developed BEFORE the ERD. True or False?
True (*) False
Correct
Correct
11. Normalization is the process of organizing the attributes and tables of a relational database to minimize redundancy. Mark for Review (1) Points True (*) False
Correct
(Choose 2) (1) Points
Correct 12. A table is in 1NF if … Mark for Review (Choose all correct answers)
The data is atomic (*) There are no duplicate rows (*) Each row contains different columns The entries in a column are of different type
Incorrect
Incorrect. Refer to Section 3 Lesson 9.
13. According to 3rd Normal Form, an attribute must be dependent on its entity’s entire unique identifier. True or False. Mark for Review (1) Points True False (*)
Incorrect
Incorrect. Refer to Section 3 Lesson 9.
14. Which of the following scenarios should be modeled so that historical data is kept? (Choose two) Mark for Review (1) Points
(Choose all correct answers) BABY and AGE CUSTOMER and ORDERS (*) TEACHER and AGE CUSTOMER and PAYMENTS (*)
Correct
Correct
15. Modeling historical data can produce a unique identifier that always excludes dates. True or False? Mark for Review (1) Points True False (*)
Correct
Correct
Related Documents g842
Quiz 1 4r3d4s
November 2020 0
Quiz 1 4r3d4s
January 2021 0
Quiz 1 4r3d4s
November 2019 73
Quiz 1 4r3d4s
October 2020 0
Quiz 1 4r3d4s
December 2022 0
Quiz 1 4r3d4s
November 2020 0More Documents from "lala" 6b53y
Bar Organization Chart 1q4u3m
October 2019 234
Gerencia Sostenible Y Ambiental - Copia.pdf 2g4w1k
January 2022 0
Quiz 1 4r3d4s
December 2021 0
Chapter 002 Wongs Infants And Children 9th Edition 1r4g1n
January 2022 0
Para Tu Amor, Juanes_ Acordes 617241
May 2022 0