1. Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

2. NULL) Primary Key Class_Num Consider the Information Engineering diagram shown in the exhibit. Which DBDL definition best describes this diagram?

3. What is a virtual table?

4. Consider the following relation definitions: STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 ) Primary Key Student_Number HOUSING( Housing_ID: integer NOT NULL Student_Number: integer NOT NULL Building: variable length character string length 25 ) Primary Key Housing_ID Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO ACTION ON UPDATE CASCADE What are the referential constraints for the relations defined in these relation definitions?

5. Consider the following relation definition: STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number HOUSING( Housing_ID: integer NOT NULL Student_Number: integer NOT NULL Building: variable length character string length 25 NOT NULL) Primary Key Housing_ID Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO CHECK ON UPDATE Which integrity constraint is violated in this relation definition?

6. Which concurrency control method should be used only when conflicts between transactions rarely occur?

7. Which characteristic is an advantage of a database management system?

8. Which of the following definitions best describes an entity?

9. Which of the following occurs in a relation when records are added or removed?

10. Which subset of Structured Query Language (SQL) is used to perform operations such as data retrieval or deletion on the data contained in a database?

11. Which of the following ACID properties requires that a transaction be executed in its entirety or not all?

12. A large enterprise uses a two-tier database architecture and runs complex database applications. Which term best describes the client in this system?

13. Which type of relational integrity is violated if a primary key in a database has a null value?

14. Which process is used to prevent the current database operation from reading or writing a data item while that data item is being accessed by another operation?

15. Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples for Student_ID 1003 must be performed. It is necessary to change one of the activities from swimming to tennis. The Student_ID and Activity attributes make up the primary key for the Recreation relation. All related information must be altered, as well. Which SQL statement or statements would best accomplish this?

16. Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

17. Which statement best describes a candidate key?

18. Consider the relations shown in the exhibit. Due to restructuring, the sales department has been eliminated and the employees working in that department have been dismissed. All ID information is stored as integers. Which SQL statement would be used to return a relation with all information for the employees who have been dismissed?

19. The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?

20. The exhibit shows a table called Activity Relation that relates a unique student identification number with a sports activity and a fee for participating in that activity. A student can participate in only one activity. The key for the relation is Student_ID. What consequence would occur if the tuple for Student_ID 1001 were removed?

21. Consider the following four database design activities: 1 -Design user views. 2 -Select a DBMS. 3 -Apply normalization. 4 -Determine entities. Which choice shows the correct ordering of these activities, from first to last, by assigned numbers?

22. What is the highest normal form of the relation(s) shown in the exhibit?

23. Your enterprise is involved in planning a database project. The exhibit shows the result of one phase of the database design life cycle. Which term best describes the diagram shown in the exhibit?

24. Which database security technique prevents invalid data from being entered into the database?

25. A theta-join can be viewed as: