DATA MANAGMENT APPLICATION (C170)

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? Correct Answer Many-to-many Which two examples are attributes? A person attending a meeting An employee number A sales meeting A meeting code Correct Answer an employee number A meeting code Which delete rule sets column values in a child table to a missing value when the matching data is deleted from the parent table? Co...

What is a broad definition of data? Correct Answer Raw facts that are captured on printed or digital media What are data? Correct Answer Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? Correct Answer It does not follow a data model. Which is true about flat files? Correct Answer They contains no internal hierarchical organization. Which technology has no internal hierarchy? Correct Answer Flat files How data were ...

group of multiple entries of the same type for a single key attribute occurrence. For example, a car can have multiple colors for its top, interior, bottom, trim, and so on. and no independent multivalued dependencies A condition in which an attribute is dependent on only a portion (subset) of the primary key