Exam 3: CIW v5 Database Design Specialist

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return the Registration2 relation from the Registration relation?

A theta-join can be viewed as:

Which of the following definitions applies to all types of databases?

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

What is a relational database domain?

Consider the following SQL statement and the Orders relation shown in the exhibit: What is the output of this SQL statement? SELECT * FROM Orders WHERE NOT (Amount < 1000 AND Sales_Rep_No = 210);

The exhibit shows a relation for a company projects. Which candidate key(s) would best serve as the primary key for this relation?

Several SQL operations are performed by User 1 to access the Fee information for Bowling in the Act_Fee relation (shown in the exhibit). The first access returns a fee of 50. An unrelated SQL operation by another user updates the Bowling fee to 60. The second access by User 1 returns a fee of 60. What problem has occurred?

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

Consider the relations shown in the exhibit. Which of the following SQL statements would enter data from the Customers relation into the Atlanta_Customers relation?

Which subset of Structured Query Language (SQL) is used to limit access to a database or its data?

Consider the relational database shown in the exhibit. What is the foreign key in this database?

Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers. Which situation would occur if new supplier information were entered in the relation before any information about specific parts?

Consider the following database information: domain s_id: integer domain grd: fixed length character string length 1 STUDENT_GRADE( Student_Number: s_id NOT NULL Grade: grd ) Primary Key Student_Number During which phase of the database design process would this information be developed?

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

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?

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

Consider the table for an employee database shown in the exhibit. What is the degree of the table?

Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?

Consider the table for an employee database shown in the exhibit. What is the cardinality of the table?