(Answer all questions in this
section)
1.
An Entity Relationship model is
independent of the hardware or software used for implementation. True or False? Mark for Review
2.
A well structured ERD will show only
some parts of the finished data model. You should never try to model the entire
system in one diagram, no matter how small the diagram might be. True or False? Mark for Review
3.
The purpose of an ERD is to
document the proposed system and facilitate discussion and understanding of the
requirements captured by the developer. True or False? Mark for Review
4.
Documenting Business Requirements helps developers control the scope of the
system and prevents users from claiming that the new system does not meet their
business requirements. True or False? Mark for Review
5.
A Conceptual Model is not
concerned with how the Physical Model will be implemented. True or False? Mark for Review
6.
Data modeling is performed for the
following reasons: (Choose Two) Mark for Review
(Choose all
correct answers)
It helps discussions and reviews.
(*)
The ERD becomes a blueprint for
designing the actual system. (*)
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.
We do not need datamodels; we can
just start coding right away.
7.
Data modeling is performed for the
following reasons: (Choose Two) Mark for Review
(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.
(*)
The ERD becomes a blueprint for
designing the actual system. (*)
We do not need datamodels; we can
just start coding right away.
8.
Which of the following entities
most likely contains valid attributes? (Choose two) Mark for Review
(Choose all
correct answers)
Entity: Home. Attributes: Number of
Bedrooms, Owner, Address, Date Built (*)
Entity: Pet. Attributes: Name,
Birthdate, Owner (*)
Entity: Car. Attributes: Owner
Occupation, Owner Salary, Speed
Entity: Mother. Attributes: Name,
Birthdate, Occupation, Start Date
9.
Which of the following are
examples of ENTITY: Instance ? (Choose Two) Mark for Review
(Choose all
correct answers)
TRANSPORTATION METHOD: Car (*)
10. Unique
Identifiers: Mark for Review
Distinguish one instance of an
entity from all other instances of that entity (*)
Distinguish all entities in a
database
Distinguish one entity from another
11. Which
of the following statements about Entities are true? Mark for Review
(Choose all
correct answers)
"Something" of
significance to the business about which data must be known. (*) They never have Instances They are usually a noun. (*) A name for a set of similar "things" (*) 12. In the following statements, find two good examples of ENTITY: Instance. (Choose Two) Mark for Review (Choose all correct answers) BOOK: Biography of Mahatma Gandhi (*) 13. 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 14. The word "Volatile" means: Mark for Review Changing constantly; unstable (*) Static; unlikely to change 15. Entities are usually verbs. True or False? Mark for Review 1. Unique Identifiers: Mark for Review Distinguish one entity from another Distinguish all entities in a database Distinguish one instance of an entity from all other instances of that entity (*) 2. The word "Volatile" means: Mark for Review Static; unlikely to change Changing constantly; unstable (*) 3. Which of the following entities most likely contains valid attributes? (Choose two) Mark for Review (Choose all correct answers) Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed Entity: Pet. Attributes: Name, Birthdate, Owner (*) Entity: Mother. Attributes: Name, Birthdate, Occupation, Start Date Entity: Home. Attributes: Number of Bedrooms, Owner, Address, Date Built (*) 4. All of the following could be attributes of an ENTITY called PERSON, except which one? Mark for Review 5. Attributes can only have one value at any point for each instance in the entity. True or False? Mark for Review 6. A/an _________'s value can be a number, a character string, a date, an image, a sound Mark for Review 7. What is the purpose of a Unique Identifier? Mark for Review 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. (*) Create an entity that is unlike any other entity aside from itself. To uniquely determine a table and columns within that table. 8. Which of the following attributes is suitable to be a Unique Identifier? Mark for Review Social Security Number (*) 9. An Entity Relationship model is independent of the hardware or software used for implementation. True or False? Mark for Review 10. A well structured ERD will show only some parts of the finished data model. You should never try to model the entire system in one diagram, no matter how small the diagram might be. True or False? Mark for Review 11. Which of the following can be found in an ERD? (Choose Two) Mark for Review (Choose all correct answers) 12. A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False? Mark for Review 13. Data modeling is performed for the following reasons: (Choose Two) Mark for Review (Choose all correct answers) It helps discussions and reviews. (*) 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. We do not need datamodels; we can just start coding right away. The ERD becomes a blueprint for designing the actual system. (*) 14. An ERD is an example of a Physical Model. True or False? Mark for Review 15. The Physical Model is derived from the Conceptual Model. True or False? Mark for Review 1. Which of the following statements about Entities are true? Mark for Review (Choose all correct answers) They are usually a noun. (*) "Something" of significance to the business about which data must be known. (*) They never have Instances A name for a set of similar "things" (*) 2. Which of the following is an example of a volatile attribute? Mark for Review 3. All of the following would be instances of the entity PERSON except which? Mark for Review 4. Attributes can only have one value at any point for each instance in the entity. True or False? Mark for Review 5. All of the following would be instances of the entity ANIMAL SPECIES, except which one? Mark for Review 6. A/an _________'s value can be a number, a character string, a date, an image, a sound Mark for Review 7. A/an _________ is defined as "Something" of significance to the business about which data must be known. Mark for Review 8. Attributes can be either mandatory or optional. True or False? Mark for Review 9. Data models show users the data that their Physical Model will contain. True or False? Mark for Review 10. A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False? Mark for Review 11. Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. Mark for Review (Choose all correct answers) They capture current and future needs. (*) They model the information flow of data. They accurately describe what a physical model will contain. (*) They model functional and informational needs. (*) They capture the implementation details of the physical model. 12. Data models are drawn to show users the actual Data that their new system will contain; only Data listed on the Diagram can be entered into the Database. True or False? Mark for Review 13. Which of the following statements about ERD's is false? Mark for Review Ensure that information appears only once. Capture all required information. Model all information that is derivable from other information already modeled. (*) Locate information in a predictable, logical place. 14. A well structured ERD will show only some parts of the finished data model. You should never try to model the entire system in one diagram, no matter how small the diagram might be. True or False? Mark for Review 15. Which of the following statements are true about ERD's? (Choose Two) Mark for Review (Choose all correct answers) You should not model derivable data. (*) A piece of information should only be found in one place on an ERD. (*) A piece of information can be shown multiple times on an ERD. All data must be represented on the ERD, including derived summaries and the result of calculations. 1. Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. Mark for Review (Choose all correct answers) They capture the implementation details of the physical model. They accurately describe what a physical model will contain. (*) They model the information flow of data. They model functional and informational needs. (*) They capture current and future needs. (*) 2. Data modeling is performed for the following reasons: (Choose Two) Mark for Review (Choose all correct answers) It helps discussions and reviews. (*) The ERD becomes a blueprint for designing the actual system. (*) 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. We do not need datamodels; we can just start coding right away. 3. A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False? Mark for Review 4. Data models are drawn to show users the actual Data that their new system will contain; only Data listed on the Diagram can be entered into the Database. True or False? Mark for Review 5. Which of the following attributes is suitable to be a Unique Identifier? Mark for Review Social Security Number (*) 6. Which of the following statements about Entities are true? Mark for Review (Choose all correct answers) They are usually a noun. (*) They never have Instances "Something" of significance to the business about which data must be known. (*) A name for a set of similar "things" (*) 7. A/an _________ is defined as "Something" of significance to the business about which data must be known. Mark for Review 8. Which of the following are examples of ENTITY: Instance ? (Choose Two) Mark for Review (Choose all correct answers) TRANSPORTATION METHOD: Car (*) 9. A/an _________'s value can be a number, a character string, a date, an image, a sound Mark for Review 10. Entities are usually verbs. True or False? Mark for Review 11. All of the following would be instances of the entity PERSON except which? Mark for Review 12. The word "Volatile" means: Mark for Review Static; unlikely to change Changing constantly; unstable (*) 13. An Entity Relationship model is independent of the hardware or software used for implementation. True or False? Mark for Review 14. The purpose of an ERD is to document the proposed system and facilitate discussion and understanding of the requirements captured by the developer. True or False? Mark for Review 15. Entity Relationship modeling is dependent on the hardware or software used for implementation, so you will need to change your ERD if you decide to change Hardware Vendor. True or False? Mark for Review
Section 6 Quiz (Answer all questions in this section) 1. Given the following descriptions of the employees and jobs tables, which of the following scripts will display each employee メ s possible minimum and maximum salaries based on their job title? EMPLOYEES Table: Name Null? Type EMPLOYEE_ID NOT NULL NUMBER (6) FIRST_NAME VARCHAR2 (20) LAST_NAME NOT NULL VARCHAR2 (25) EMAIL NOT NULL VARCHAR2 (25) PHONE_NUMBER VARCHAR2 (20) HIRE_DATE NOT NULL DATE JOB_ID NOT NULL VARCHAR2 (10) SALARY NUMBER (8,2) COMMISSION_PCT NUMBER (2,2) MANAGER_ID NUMBER (6) DEPARTMENT_ID NUMBER (4) JOBS Table: Name Null? Type JOB_ID NOT NULL VARCHAR2 (10) JOB_TITLE NOT NULL VARCHAR2 (35) MIN_SALARY
Section 1 Quiz (Answer all questions in this section) 1. A specialized type of software, which controls and manages the hardware in a computer system. Mark for Review (1) Points Operating System (*) Hardware Software Client 2. Personal computers (PCs) have been in existence since 1950. True or False? Mark for Review (1) Points True False (*) 3. The overall mission of the Oracle Corporation is to use the internet and fast processing servers to build its own network. Mark for Review (1) Points True False (*) 4. Users could directly interact with which of the following software to access essential business applications? (Choose three) Mark for Review (1) Points (Choose all correct answers) |