CIS 111
Introduction to Related Data Management
Midterm Exam

1. Since database data items are stored in compatible formats and logical connections among them are also stored we describe database data as

2. Analyzing data stored in a data warehouse to find trends is called

3. Faster development of new applications is often possible in a database environment because

4. A project management tool that shows tasks, resources, task dependencies, and timelines for a project is a(n)

5. The phase in which the conceptual model is mapped to the DBMS is the development of the

6. The organization for which the database is designed is referred to as

7. The two parts of a data sublanguage are

8. In a business, if a department can have many workers, but each worker belongs to only one department, the cardinality of the department-to-worker relationship is

9. The basic objects in the E-R model include all of the following EXCEPT

10. If every member of an entity set must participate in a relationship, the participation is described as

11. A dashed oval is used to indicate which kind of attribute?

12. Of the following types of keys, the one that does not appear in the Entity-Relational model is a

13. If changes to the underlying table are immediately reflected in a view, the view is said to be

14. The table in which a foreign key appears as the primary key is called its

15. In converting from an E-R diagram to a relational model, tables are used to represent

16. An SQL index specification that causes records with the same values on the indexed field to be stored close together is

17. Which of the following is the proper way to create an alias, E, for table Employee and retrieve all employee data?

18. Each of the following is a standard view in an Oracle data dictionary EXCEPT

19. The highest normal form that always allows us to always preserve functional dependencies is

20. A relation is second normal form if it is 1NF and

21. A relation is first normal form if

22. A projection is lossless if

23. If we have defined a ROW type called club_row_type, and we wish to construct an array of club information for students using SQL:1999 syntax, which of the following could appear in the CREATE TABLE command for the Student table?

24. In an EE-R diagram, the symbol placed on the line connecting a subclass to the specialization circle is a(n)

25. In Oracle, a table consisting of only one user-defined type is called a(n)