C175 - Data Management Foundations PA

What is a broad definition of data? - answer-*Raw facts* that are captured on printed or digital media What are data? - answer-Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? - answer-It does not follow a data model. Which item represents unstructured data? - answer-Training Video Content Which is true about flat files? - answer-They contain no internal hierarchical organization. Which technology has no internal hierarchy? - answer-Flat files How were data retrieved before database management systems? - answer-Sequentially from simple files What is the *uniquely identifiable element* about which data can be categorized in an entity-relationship diagram? - answer-Entity types Which classification is correct for the box marked "Quantity" in the given entity-relationship diagram? - answer-Intersection data Which data classification is an entity? - answer-event What is the entity-relationship diagram about a car rental agency showing? - answer-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? - answer-Many-to-many Which relationship does the cardinality in the diagram represent? - answer-Many customers to many products How is the cardinality of the customers misrepresented? - answer-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? - answer-A minimum of zero customers What is the modality of the product? - answer-At least one Which kind of relationship does this diagram depict? - answer-Unary one-to-one Which kind of relationship does this diagram depict? - answer-Unary one-to-many Which three kinds of rules for *referential integrity* are provided by modern relational database management systems? - answer-Insert Delete Update What is an important aspect of "referential integrity"? - answer-*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? - answer-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? - answer-Replace COMMPERCT, YEARHIRE with an *asterisk*