Data redundancies produce unusual and undesirable data management problems caused by __________.
A) transitive requirements
B) dependencies
C) normalization
D) data anomalies
5
Removing the __________ is part of the database design process.
A) foreign keys
B) primary key dependencies
C) recursive relationships
D) partial and transitive dependencies
1
In a POS system, what do the major transaction modules define?
A) Inventory management, shipping, invoice calculations, and product returns
B) Sales, inventory management, shipping, back ordering, and product returns
C) Sales, invoice calculations, back ordering, and product returns
D) Inventory management, shipping, invoice calculations, back ordering, and product returns
2
What are the fourth and fifth steps in developing a POS?
A) Define the entities, attributes, relationships, connectivities, cardinalities, and constraints. Create the initial ERD segments.
B) Develop business rules. Create the initial ERD segments.
C) Develop business rules. Define the entities, attributes, relationships, connectivities, cardinalities, and constraints.
D) Define the major transaction modules. Create the initial ERD segments.
3
After creating the initial ERD segments, the next step is to
A) define the major transaction modules.
B) perform the appropriate normalization checks based on the data dictionary contents.
C) create a basic data dictionary for all the components found in each ERD segment.
D) define the entities, attributes, relationships, connectivities, cardinalities, and constraints.
4
What will the following questions help you define? What types of transactions take place? How many different types of transactions are there?
A) Available resources
B) Data environment
C) Current operations
D) Business objectives
5
Which of the following is an advantage of having a precisely written set of current operations.
A) It clarifies the assignment of data types.
B) It highlights the best possible way to perform each task.
C) It forces careful assessment of the procedures.
D) It makes the creation of the data dictionary much easier.
