Section 2 Quiz
(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
(1) Points
True (*)
False
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
(1) Points
True
False (*)
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
(1) Points
True (*)
False
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
(1) Points
True (*)
False
5. A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False? Mark for Review
(1) Points
True (*)
False
6. Data modeling is performed for the following reasons: (Choose Two) Mark for Review
(1) Points
(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
(1) Points
(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
(1) Points
(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
(1) Points
(Choose all correct answers)
ANIMAL: Dog (*)
MEAT PRODUCT: Lettuce
BODY PART: Larry Ellison
TRANSPORTATION METHOD: Car (*)
10. Unique Identifiers: Mark for Review
(1) Points
Distinguish one instance of an entity from all other instances of that entity (*)
Distinguish all entities in a database
Distinguish one entity from another
Distinguish nothing
11. Which of the following statements about Entities are true? Mark for Review
(1) Points
(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
(1) Points
(Choose all correct answers)
VEGETABLE: grows
BOOK: Biography of Mahatma Gandhi (*)
TRAIN: runs
DAIRY PRODUCT: milk (*)
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
(1) Points
Table
ERD
Process
Attribute (*)
14. The word "Volatile" means: Mark for Review
(1) Points
Limited quantity
Changing constantly; unstable (*)
Large quantity
Static; unlikely to change
15. Entities are usually verbs. True or False? Mark for Review
(1) Points
True
False (*)
1. Unique Identifiers: Mark for Review
(1) Points
Distinguish one entity from another
Distinguish nothing
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
(1) Points
Large quantity
Static; unlikely to change
Limited quantity
Changing constantly; unstable (*)
3. Which of the following entities most likely contains valid attributes? (Choose two) Mark for Review
(1) Points
(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
(1) Points
Weight
Gender
Haircolor
Natacha Hansen (*)
5. Attributes can only have one value at any point for each instance in the entity. True or False? Mark for Review
(1) Points
True (*)
False
6. A/an _________'s value can be a number, a character string, a date, an image, a sound Mark for Review
(1) Points
ERD
Table
Attribute (*)
Entity
7. What is the purpose of a Unique Identifier? Mark for Review
(1) Points
To identify a specific row within a table, using one or more columns and/or foreign keys.
To identify one unique instance of an entity by using one or more attributes and/or relationships. (*)
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
(1) Points
Address
First name
Last name
Social Security Number (*)
9. An Entity Relationship model is independent of the hardware or software used for implementation. True or False? Mark for Review
(1) Points
True (*)
False
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
(1) Points
True
False (*)
11. Which of the following can be found in an ERD? (Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
Entities. (*)
Attributes. (*)
Tables.
Instances.
12. A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False? Mark for Review
(1) Points
True (*)
False
13. Data modeling is performed for the following reasons: (Choose Two) Mark for Review
(1) Points
(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
(1) Points
True
False (*)
15. The Physical Model is derived from the Conceptual Model. True or False? Mark for Review
(1) Points
True (*)
False
1. Which of the following statements about Entities are true? Mark for Review
(1) Points
(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
(1) Points
Date of Birth
Hire Date
Name
Age (*)
3. All of the following would be instances of the entity PERSON except which? Mark for Review
(1) Points
Male (*)
Grace Abinajam
David Jones
Angelina Rosalie
4. Attributes can only have one value at any point for each instance in the entity. True or False? Mark for Review
(1) Points
True (*)
False
5. All of the following would be instances of the entity ANIMAL SPECIES, except which one? Mark for Review
(1) Points
Elephant
Bird
Dog
Leaf (*)
6. A/an _________'s value can be a number, a character string, a date, an image, a sound Mark for Review
(1) Points
ERD
Entity
Attribute (*)
Table
7. A/an _________ is defined as "Something" of significance to the business about which data must be known. Mark for Review
(1) Points
Instance
Relationship
Entity (*)
None of the above
8. Attributes can be either mandatory or optional. True or False? Mark for Review
(1) Points
True (*)
False
9. Data models show users the data that their Physical Model will contain. True or False? Mark for Review
(1) Points
True (*)
False
10. A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False? Mark for Review
(1) Points
True (*)
False
11. Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. Mark for Review
(1) Points
(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
(1) Points
True (*)
False
13. Which of the following statements about ERD's is false? Mark for Review
(1) Points
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
(1) Points
True
False (*)
15. Which of the following statements are true about ERD's? (Choose Two) Mark for Review
(1) Points
(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
(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 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
(1) Points
(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
(1) Points
True (*)
False
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
(1) Points
True (*)
False
5. Which of the following attributes is suitable to be a Unique Identifier? Mark for Review
(1) Points
Last name
First name
Address
Social Security Number (*)
6. Which of the following statements about Entities are true? Mark for Review
(1) Points
(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
(1) Points
Instance
Relationship
Entity (*)
None of the above
8. Which of the following are examples of ENTITY: Instance ? (Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
ANIMAL: Dog (*)
TRANSPORTATION METHOD: Car (*)
MEAT PRODUCT: Lettuce
BODY PART: Larry Ellison
9. A/an _________'s value can be a number, a character string, a date, an image, a sound Mark for Review
(1) Points
Attribute (*)
Table
Entity
ERD
10. Entities are usually verbs. True or False? Mark for Review
(1) Points
True
False (*)
11. All of the following would be instances of the entity PERSON except which? Mark for Review
(1) Points
David Jones
Angelina Rosalie
Male (*)
Grace Abinajam
12. The word "Volatile" means: Mark for Review
(1) Points
Limited quantity
Static; unlikely to change
Large quantity
Changing constantly; unstable (*)
13. An Entity Relationship model is independent of the hardware or software used for implementation. True or False? Mark for Review
(1) Points
True (*)
False
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
(1) Points
True (*)
False
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
(1) Points
True
False (*)
(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
(1) Points
True (*)
False
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
(1) Points
True
False (*)
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
(1) Points
True (*)
False
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
(1) Points
True (*)
False
5. A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False? Mark for Review
(1) Points
True (*)
False
6. Data modeling is performed for the following reasons: (Choose Two) Mark for Review
(1) Points
(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
(1) Points
(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
(1) Points
(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
(1) Points
(Choose all correct answers)
ANIMAL: Dog (*)
MEAT PRODUCT: Lettuce
BODY PART: Larry Ellison
TRANSPORTATION METHOD: Car (*)
10. Unique Identifiers: Mark for Review
(1) Points
Distinguish one instance of an entity from all other instances of that entity (*)
Distinguish all entities in a database
Distinguish one entity from another
Distinguish nothing
11. Which of the following statements about Entities are true? Mark for Review
(1) Points
(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
(1) Points
(Choose all correct answers)
VEGETABLE: grows
BOOK: Biography of Mahatma Gandhi (*)
TRAIN: runs
DAIRY PRODUCT: milk (*)
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
(1) Points
Table
ERD
Process
Attribute (*)
14. The word "Volatile" means: Mark for Review
(1) Points
Limited quantity
Changing constantly; unstable (*)
Large quantity
Static; unlikely to change
15. Entities are usually verbs. True or False? Mark for Review
(1) Points
True
False (*)
1. Unique Identifiers: Mark for Review
(1) Points
Distinguish one entity from another
Distinguish nothing
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
(1) Points
Large quantity
Static; unlikely to change
Limited quantity
Changing constantly; unstable (*)
3. Which of the following entities most likely contains valid attributes? (Choose two) Mark for Review
(1) Points
(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
(1) Points
Weight
Gender
Haircolor
Natacha Hansen (*)
5. Attributes can only have one value at any point for each instance in the entity. True or False? Mark for Review
(1) Points
True (*)
False
6. A/an _________'s value can be a number, a character string, a date, an image, a sound Mark for Review
(1) Points
ERD
Table
Attribute (*)
Entity
7. What is the purpose of a Unique Identifier? Mark for Review
(1) Points
To identify a specific row within a table, using one or more columns and/or foreign keys.
To identify one unique instance of an entity by using one or more attributes and/or relationships. (*)
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
(1) Points
Address
First name
Last name
Social Security Number (*)
9. An Entity Relationship model is independent of the hardware or software used for implementation. True or False? Mark for Review
(1) Points
True (*)
False
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
(1) Points
True
False (*)
11. Which of the following can be found in an ERD? (Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
Entities. (*)
Attributes. (*)
Tables.
Instances.
12. A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False? Mark for Review
(1) Points
True (*)
False
13. Data modeling is performed for the following reasons: (Choose Two) Mark for Review
(1) Points
(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
(1) Points
True
False (*)
15. The Physical Model is derived from the Conceptual Model. True or False? Mark for Review
(1) Points
True (*)
False
1. Which of the following statements about Entities are true? Mark for Review
(1) Points
(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
(1) Points
Date of Birth
Hire Date
Name
Age (*)
3. All of the following would be instances of the entity PERSON except which? Mark for Review
(1) Points
Male (*)
Grace Abinajam
David Jones
Angelina Rosalie
4. Attributes can only have one value at any point for each instance in the entity. True or False? Mark for Review
(1) Points
True (*)
False
5. All of the following would be instances of the entity ANIMAL SPECIES, except which one? Mark for Review
(1) Points
Elephant
Bird
Dog
Leaf (*)
6. A/an _________'s value can be a number, a character string, a date, an image, a sound Mark for Review
(1) Points
ERD
Entity
Attribute (*)
Table
7. A/an _________ is defined as "Something" of significance to the business about which data must be known. Mark for Review
(1) Points
Instance
Relationship
Entity (*)
None of the above
8. Attributes can be either mandatory or optional. True or False? Mark for Review
(1) Points
True (*)
False
9. Data models show users the data that their Physical Model will contain. True or False? Mark for Review
(1) Points
True (*)
False
10. A Conceptual Model is not concerned with how the Physical Model will be implemented. True or False? Mark for Review
(1) Points
True (*)
False
11. Many reasons exist for creating a conceptual model. Choose three appropriate reasons from the options below. Mark for Review
(1) Points
(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
(1) Points
True (*)
False
13. Which of the following statements about ERD's is false? Mark for Review
(1) Points
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
(1) Points
True
False (*)
15. Which of the following statements are true about ERD's? (Choose Two) Mark for Review
(1) Points
(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
(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 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
(1) Points
(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
(1) Points
True (*)
False
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
(1) Points
True (*)
False
5. Which of the following attributes is suitable to be a Unique Identifier? Mark for Review
(1) Points
Last name
First name
Address
Social Security Number (*)
6. Which of the following statements about Entities are true? Mark for Review
(1) Points
(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
(1) Points
Instance
Relationship
Entity (*)
None of the above
8. Which of the following are examples of ENTITY: Instance ? (Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
ANIMAL: Dog (*)
TRANSPORTATION METHOD: Car (*)
MEAT PRODUCT: Lettuce
BODY PART: Larry Ellison
9. A/an _________'s value can be a number, a character string, a date, an image, a sound Mark for Review
(1) Points
Attribute (*)
Table
Entity
ERD
10. Entities are usually verbs. True or False? Mark for Review
(1) Points
True
False (*)
11. All of the following would be instances of the entity PERSON except which? Mark for Review
(1) Points
David Jones
Angelina Rosalie
Male (*)
Grace Abinajam
12. The word "Volatile" means: Mark for Review
(1) Points
Limited quantity
Static; unlikely to change
Large quantity
Changing constantly; unstable (*)
13. An Entity Relationship model is independent of the hardware or software used for implementation. True or False? Mark for Review
(1) Points
True (*)
False
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
(1) Points
True (*)
False
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
(1) Points
True
False (*)
1. Examples of
software are:
Data entry webpages, Spreadsheets, Google and Yahoo search
Engines, SQL Developer, Oracle Application Express
Microsoft Word, Microsoft Powerpoint, Microsoft Excel, Mouse pad
Mouse, Cables, Microsoft Word, Microsoft Powerpoint
Monitor, Microsoft Word, Microsoft PowerPoint, SQL Developer
Microsoft Word, Microsoft Powerpoint, Microsoft Excel, Mouse pad
Mouse, Cables, Microsoft Word, Microsoft Powerpoint
Monitor, Microsoft Word, Microsoft PowerPoint, SQL Developer
2.
Examples of hardware are:
Data
entry web pages, Mouse, Hard disk
Mouse, Hard disk, Monitor
Monitor, Mouse, Printer, Printed Reports
Monitor, Mouse, Mouse pad, Cables and Wires, Hard disk
Mouse, Hard disk, Monitor
Monitor, Mouse, Printer, Printed Reports
Monitor, Mouse, Mouse pad, Cables and Wires, Hard disk
3.
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.
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.
Test: Quiz: Entities, Instances, Attributes and Identifiers
1.
Which of the following statements about attributes are true?
They describe, qualify, quantify, classify, or specify an entity.
They are often adjectives.
They have a data type such as a number or character string.
They must be single valued unless they belong to more than one entity.
They are often adjectives.
They have a data type such as a number or character string.
They must be single valued unless they belong to more than one entity.
2.
All of the following would be instances of the entity PERSON except which?
David
Jones
Male
Angelina Rosalie
Grace Abinajam
Male
Angelina Rosalie
Grace Abinajam
3.
Some of the following could be attributes of an ENTITY called PERSON. Select
the incorrect attributes for PERSON.
Age
Freddy Wilson
Name
Priya Hansenna
Freddy Wilson
Name
Priya Hansenna
4.
Entities are usually verbs. True or False?
True
False
False
5.
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.
ERD
Process
Table
Attribute
Process
Table
Attribute
6.
Unique Identifiers…
distinguish
one entity from another
distinguish one instance of an entity from all other instances of that entity
distinguish all entities in a database
distinguishes nothing
distinguish one instance of an entity from all other instances of that entity
distinguish all entities in a database
distinguishes nothing
7.
An entity may have which of the following?
experiences
instances
tables
none of the above
instances
tables
none of the above
8. What
is the purpose of a Unique Identifier?
To
uniquely determine a table and columns within that table.
To 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.
To identify one unique instance of an entity, by using one or more attributes and/or relationships.
To 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.
To identify one unique instance of an entity, by using one or more attributes and/or relationships.
9.
In a physical data model, an attribute is represented as a/an
Column
Row
Instance
Foreign Key
Row
Instance
Foreign Key
10.
The word “Volatile” means…
Changing constantly; unstable
Static; unlikely to change
Large quantity
Limited quantity
Static; unlikely to change
Large quantity
Limited quantity
11.
Which of the following entities most likely contains invalid attributes?
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, Salary
Entity: Pet. Attributes: Name, Birthdate, Owner
Entity: Car. Attributes: Owner Occupation, Owner Salary, Speed
Entity: Mother. Attributes: Name, Birthdate, Occupation, Salary
12.
In the following statements, find two examples of ENTITY: Instance.
DAIRY PRODUCT: cow
VEGETABLE: grows
BOOK: Biography of Mahatma Gandhi
BODY PART: Marilyn Manson
VEGETABLE: grows
BOOK: Biography of Mahatma Gandhi
BODY PART: Marilyn Manson
Test: Quiz: Entity Relationship Modeling and ERDs
1.
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?
True
False
False
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?
True
False
False
3.
Entity Relationship model is independent of the hardware or software used for
implementation. True or False?
True
False
False
4.
Which of the following statements are true about ERD’s?
A
piece of information can be shown multiple times on an ERD.
A piece of information should only be found one place on an ERD.
You should not model derivable data.
All data must be represented on the ERD, including derived summaries and the result of calculations.
A piece of information should only be found one place on an ERD.
You should not model derivable data.
All data must be represented on the ERD, including derived summaries and the result of calculations.
at 12 :
ReplyDeleteData 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?
it is false not true