Your company must choose which type of database to use for a new project. Which of the
following lists three characteristics of file-based database systems?

Consider the Information Engineering diagram shown in the exhibit.

Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name and Res_Name are
represented by variable-length strings with a maximum of 20 characters. Location can be up to 50
characters long, and no building has more than 600 rooms. Which SQL statement best
implements the BUILDING relation shown in this diagram?

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?

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

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?

Which of the following definitions best describes an entity?

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?

Consider the entity-relationship (ER) diagram shown in the exhibit.

What do the characters at the ends of the connecting line indicate?

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);

Consider the following DBDL description of an entity:
Teachers (teach_num: variable length character string length 10 NOT NULL teach_name: variable length character string length 10 NOT NULL) Primary Key: teach_num which integrity constraint is satisfied?