The University of Texas

CS 327e

Spring 2002

Quiz 1

Date: 2002-04-15

Duration: 45 minutes

Total: 100 points, 25 questions. Each question is weighted equally, and is worth 4 points.

Use a pencil to fill in the appropriate circle for the correct answer in the electronic answer sheet.

Fill in your FIRST NAME, LAST NAME, and full SSN circles on the sheet.

ALL SOLUTIONS ARE IN BOLD.

1. Knowing the complete organizational structure is important even when a system is designed for only one component.

a. | True
b. | False

2. A well-designed database system should be able to address most of the Lab's stated problems. Constraints within which the system is to be designed must be carefully defined.

a. | True
b. | False

3. University Computer Lab's Business Rule 8 states that each user may check out zero, one, or many items, and zero, one, or many users may check out each item during the semester.

a. | True
b. | False

4. University Computer Lab's Business Rule 14 states that each LA accumulates hours worked during each two-week pay period, and each "hours worked" entry is associated with one or more LAs.

a. | True
b. | False

5. The software will automatically check for inconsistent relationships, circular relationships, and incorrectly defined relationships.

a. | True
b. | False

6. The verification process leads to modifications in the initial E-R model.

a. | True
b. | False

7. Once the verification process is completed, the designer will complete the design process by formulating the logical and physical models.

a. | True
b. | False

8. As the revised model is developed, designers must keep in mind the often conflicting requirements of design elegance, information requirements, and processing speed.

a. | True
b. | False

9. Verification represents the link between database modeling and design activities, database implementation, and database application design.

a. | True
b. | False

10. The conceptual model's entities do not need to be normalized before they can be properly implemented.

a. | True
b. | False

11. The logical design process is used to translate the conceptual design into the internal model for the selected DBMS.

a. | True
b. | False

12. Because the conceptual modeling process does not preclude the definition of attributes, you can reasonably argue that normalization occasionally straddles the line between conceptual and logical modeling.

a. | True
b. | False

13. When all the tables required by the design have been created, the relationships specified in the design are established. A good CASE tool will let the designer accomplish these tasks directly from the design.

a. | True
b. | False

14. Most modern DBMSs automatically index on the primary key components.

a. | True
b. | False

15. Views cannot be used for security purposes.

a. | True
b. | False

16. The University Computer Lab provides

a. | Controlled access to microcomputers, laser printers, and supplies.
b. | Controlled access to application software, and software documentation.
c. | General problem solving services.
d. | a and b
e. | a, b, and c

17. The University Computer Lab's items are classified as

a. | Hardware and software.
b. | Literature and supplies.
c. | Hardware, literature, and supplies.
d. | Software, hardware, supplies, and literature.

18. The verification process is used to establish that:

a. | The design properly reflects the end-user or application views of the database.
b. | All database transactions - inserts, updates, deletes are defined and modeled to ensure that the implementation of the design will support all transaction-processing requirements.
c. | a only
d. | b only
e. | a and b

19. The verification process is used to establish that:

a. | The design is sufficiently flexible to support expected enhancements and modifications
b. | The database design is capable of meeting all output requirements, such as query screens, forms, and report formats.
c. | a only
d. | a and b
e. | b only

20. In spite of the fact that we sometimes are forced to revise an E-R diagram it is still possible that:

a. | Some of the relationships are not clearly identified and may have been misidentified.
b. | The model contains design redundancies.
c. | a only
d. | a and b
e. | b only

21. The advantage(s) of letting CASE tool write all of the table structures and relationships are:

a. | The database will match the design precisely.
b. | All the relationships have already been tested by CASE tool to ensure that they are logically correct and that they are implementable as design.
c. | a only
d. | a and b
e. | b only

22. The advantage(s) of letting CASE tool write all the table structures and relationships are:

a. | All the relationships have already been tested by CASE tool to ensure that they are logically correct and that they are implementable as design.
b. | All of the FK attribute definitions and characteristics match those of the referenced PKs.
c. | a only
d. | a and b
e. | b only

23. Several indexes can be created to improve access time, such as

a. | Indexes created for all primary keys will increase access speed when a foreign key references in tables is made.
b. | Indexes can also be created for all alternate search keys.
c. | Indexes can be created for all columns used in the WHERE, ORDER BY, and GROUP BY clauses of a SELECT statement.
d. | a and b
e. | a, b and c

24. There are several techniques used to ensure appropriate data entries. Among some of these techniques we can find

a. | Drop-down lists to limit the input selections.
b. | Automated data entry completions based on the input selections.
c. | System-generated computations to avoid end-user computational errors.
d. | b and c only
e. | a, b and c

25. The DBA's responsibilities should include:

a. | Providing preventive and corrective maintenance.
b. | Providing end-user management services.
c. | Performing periodic security audits.
d. | a and c only
e. | a, b and c