When you define a table’s primary key, the DBMS automatically creates a(n) _____ index on the primary key column(s) you declared.

 The one-to-many (1:M) relationship is easily implemented in the relational model by putting the _________of the “1” side in the table of the “many” side as a ________.

 A(n) _____ index is an index in which the index key can have only one pointer value (row) associated with it.

 Management wants to see a database design that is logical in nature. It must be easy to identify where and how each table is related to one another. How can a database designer achieve this design concept before the next meeting?

 _____ returns only the attributes requested, in the order in which they are requested.

 In an entity relationship diagram with objects EMPLOYEE, DEPENDENT, CUSTOMER and PRODUCT, which of the following would be the most appropriate example of a derived entity?

Comel, a student, takes four classes with her group of best friends. She sits in the front row with two friends and the others sit behind them. What type of relationship would Comel’s situation be described as? 

 If the PROFESSOR (1,1) and SCHOOL (0,1) were drawn into an ERD to conceptualize a professor’s role as a dean of one of the schools in a college, describe the logical relationship between these entities.

 Which of the answers below is not an example of a web browser that a database management system (DBMS) might use to provide access to the database?

 Although a student’s registration form may list information gathered from the COURSE, CLASS, BUILDING, and ROOM table, which of the following would be the most accurate phrase describing these table’s relationship with each other in an UML class diagram?