c
What is a broad definition of data?
A.) Alphanumeric combinations that can be captured on media that a computer can read
B.) Any information that
... [Show More] can be transferred from print to digital
C.) Raw facts that are captured on printed or digital media
D.) Numbers that are captured on digital media
b
What are data?
A.) Facts that have been organized in a meaningful way
B.) Facts that are collected and stored in a database system
C.) Facts that are the result of a query of a database system
D.) Facts that have been processed and used for decision making
a
What is a determining characteristic of unstructured data?
A.) It does not follow a data model.
B.) It is stored in rows and columns.
C.) It does not allow copying and pasting.
D.) It is easy to query and retrieve by business applications.
a
Refer to this diagram.
Which item represents unstructured data?
A.) A
B.) B
C.) C
D.) D
b
Which is true about flat files?
A.) They have a limit of 256 records.
B.) They contain no internal hierarchical organization.
C.) They can only contain two-dimensional data.
D.) They are always encrypted.
b
Which technology has no internal hierarchy?
A.) Hashed tables
B.) Flat files
C.) Relational databases
D.) Heap files
c
How were data retrieved before database management systems?
A.) Randomly from linked files
B.) Using set operations on complex files
C.) Sequentially from simple files
D.) Using relationships between logical entities
d
What is the uniquely identifiable element about which data can be categorized in an entity-relationship diagram?
A.) Intersection data points
B.) Unary relationships
C.) Primary keys
D.) Entity types
b
Refer to this diagram.
Which classification is correct for the box marked "Quantity" in the given entity-relationship diagram?
A.) Quantity data
B.) Intersection data
C.) Modality data
D.) Product sales data
b
Which data classification is an entity?
A.) Attendance
B.) Event
C.) Duration
D.) Directions
a
Refer to this diagram.
What is the entity-relationship diagram about a car rental agency showing?
A.) One manufacturer created at least one of the agency's cars.
B.) An agency's cars were provided by multiple manufacturers.
C.) The model, year, and class of the car are part of the primary key.
D.) The manufacturer maintains database records for its sales representatives.
b
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?
A.) Associative
B.) Many-to-many
C.) One-to-one
D.) One-to-many
c
Refer to this diagram.
Which relationship does the cardinality in the diagram represent?
A.) One customer to many products
B.) Many customers to one product
C.) Many customers to many products
D.) One customer to one product number
E.) One customer to many product numbers
b
Refer to this entity-relationship diagram.
How is the cardinality of the customers misrepresented?
A.) The cardinality of the salesperson number and the customer number do not match.
B.) There are many customers, but the cardinality indicates one customer.
C.) There is more than one salesperson, but the cardinality indicates multiple salespersons.
D.) There is one customer number, but the cardinality indicates many customers.
c
Refer to this diagram.
What is the correct way to read the modality on the right side of the association?
A.) A maximum of many customers
B.) A maximum of zero customers
C.) A minimum of zero customers
D.) A maximum of one customer [Show Less]