C175 - Data Management Foundations PA Exam All Possible Questions and Answers with complete solution

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 entityrelationship 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