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?

A. Logical

B. Physical

C. Conceptual

D. Implementation

What is a virtual table?

A. A virtual table is a relation created as the result of data manipulation, and is not a permanent part of the database.

B. A virtual table is a relation stored in the databases memory; it is used when multiple users access the same relation in a database.

C. A virtual table is a relation created from a defined base table; it contains metadata about the base relation.

D. A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database.

Which mechanism provides database users with controlled access to the database through the use of virtual tables?

A. View

B. Data dictionary

C. Database control language

D. Database management system

Which of the following is a characteristic of the three-tier database architecture?

A. A Web browser is used as the application server.

B. The application logic is centralized on a dedicated server.

C. A thick client is used to perform business application logic functions locally.

D. Database application logic and database functionality are integrated and reside on a common server.

Consider the symbols shown in the exhibit. Which of the following correctly identifies these symbols when used in an entity-relationship (ER) diagram?

A. 1 = attribute, 2 = entity, 3 = relationship

B. 1 = entity, 2 = relationship, 3 = attribute

C. 1 = relationship, 2 = entity, 3 = attribute

D. 1 = relationship, 2 = attribute, 3 = entity