C175 - Data Management Foundations PA
What is a broad definition of data? - ANS-*Raw facts* that are captured on printed or
digital media
What are data? - ANS-Facts that are collected and stored in a database system
What is a determining characteristic of unstructured data? - ANS-It does not follow a
data model.
Which item represents unstructured data? - ANS-Training Video Content
Which is true about flat files? - ANS-They contain no internal hierarchical organization.
Which technology has no internal hierarchy? - ANS-Flat files
How were data retrieved before database management systems? - ANS-Sequentially
from simple files
What is the *uniquely identifiable element* about which data can be categorized in an
entity-relationship diagram? - ANS-Entity types
Which classification is correct for the box marked "Quantity" in the given
entity-relationship diagram? - ANS-Intersection data
Which data classification is an entity? - ANS-event
What is the entity-relationship diagram about a car rental agency showing? - ANS-One
manufacturer created at least one of the agency's cars.
A salesperson is authorized to sell 12 products; a product can be sold by 10
salespersons.
Which kind of binary relationship is described in this example? - ANS-Many-to-many
Which relationship does the cardinality in the diagram represent? - ANS-Many
customers to many products
, How is the cardinality of the customers misrepresented? - ANS-There are many
customers, but the cardinality indicates one customer.
What is the correct way to read the modality on the right side of the association? -
ANS-A minimum of zero customers
What is the modality of the product? - ANS-At least one
Which kind of relationship does this diagram depict? - ANS-Unary one-to-one
Which kind of relationship does this diagram depict? - ANS-Unary one-to-many
Which three kinds of rules for *referential integrity* are provided by modern relational
database management systems? - ANS-Insert
Delete
Update
What is an important aspect of "referential integrity"? - ANS-*Reference to data in one
relation is *based on* values in another relation.*
A foreign key in a table must refer to a valid primary key in another table.
Refer to the given SQL statement.
*SELECT SPNUM, SPNAME*
*FROM SALESPERSON*
What is the correct line to add to the end of this statement to find salespersons with a
commission percentage of 15? - ANS-WHERE COMMPERCT=15;
Refer to the given SQL statement.
*SELECT COMMPERCT, YEARHIRE*
*FROM SALESPERSON WHERE SPNUM=22;*
How should this statement be altered to retrieve the *entire record* instead of the
commission percentage and year of hire? - ANS-Replace COMMPERCT, YEARHIRE
with an *asterisk*
What is a broad definition of data? - ANS-*Raw facts* that are captured on printed or
digital media
What are data? - ANS-Facts that are collected and stored in a database system
What is a determining characteristic of unstructured data? - ANS-It does not follow a
data model.
Which item represents unstructured data? - ANS-Training Video Content
Which is true about flat files? - ANS-They contain no internal hierarchical organization.
Which technology has no internal hierarchy? - ANS-Flat files
How were data retrieved before database management systems? - ANS-Sequentially
from simple files
What is the *uniquely identifiable element* about which data can be categorized in an
entity-relationship diagram? - ANS-Entity types
Which classification is correct for the box marked "Quantity" in the given
entity-relationship diagram? - ANS-Intersection data
Which data classification is an entity? - ANS-event
What is the entity-relationship diagram about a car rental agency showing? - ANS-One
manufacturer created at least one of the agency's cars.
A salesperson is authorized to sell 12 products; a product can be sold by 10
salespersons.
Which kind of binary relationship is described in this example? - ANS-Many-to-many
Which relationship does the cardinality in the diagram represent? - ANS-Many
customers to many products
, How is the cardinality of the customers misrepresented? - ANS-There are many
customers, but the cardinality indicates one customer.
What is the correct way to read the modality on the right side of the association? -
ANS-A minimum of zero customers
What is the modality of the product? - ANS-At least one
Which kind of relationship does this diagram depict? - ANS-Unary one-to-one
Which kind of relationship does this diagram depict? - ANS-Unary one-to-many
Which three kinds of rules for *referential integrity* are provided by modern relational
database management systems? - ANS-Insert
Delete
Update
What is an important aspect of "referential integrity"? - ANS-*Reference to data in one
relation is *based on* values in another relation.*
A foreign key in a table must refer to a valid primary key in another table.
Refer to the given SQL statement.
*SELECT SPNUM, SPNAME*
*FROM SALESPERSON*
What is the correct line to add to the end of this statement to find salespersons with a
commission percentage of 15? - ANS-WHERE COMMPERCT=15;
Refer to the given SQL statement.
*SELECT COMMPERCT, YEARHIRE*
*FROM SALESPERSON WHERE SPNUM=22;*
How should this statement be altered to retrieve the *entire record* instead of the
commission percentage and year of hire? - ANS-Replace COMMPERCT, YEARHIRE
with an *asterisk*
