CIS 2210 - Database Management and Design

Review for First Test

The following questions are provided to help you study for the first test. Do not expect to see these exact questions on the test.


  1. What is the difference between data and information?

  2. What are some advantages to using a DBMS based database? What are some disadvantages?

  3. What is unstructured data? Where is it likely to be found?
    What is structured data? Where is is likely to be found?
    What is semistructured data?

  4. What is an entity, with respect to databases?

  5. What is an instance, and how is it related to an entity?

  6. What are other names for attributes? What are they, generally?

  7. What is a general name for most files that are in a relational database?

  8. What are structural dependence and independence? Why do you want to have one of them?

  9. What are the three kinds of anomalies mentioned in chapter 1?

  10. Where is information about the objects in a database kept?

  11. How are relationships characterized/quantized?

  12. How is this information shown in an ERD? How does an ERD show the minimum and maximum possibilities in a relationship?

  13. What do we call a rule that controls the kind of data that is allowed to go in a given field?

  14. What are business rules?

  15. When studying the business rules of a company, what will the nouns and verbs usually correspond to?

  16. What is the difference between the DDL and the DML of a DBMS?

  17. What does it mean if we say that A is functionally dependent on B?
    What does it mean if we say that A functionally determines B?

  18. What is entity integrity?

  19. What is referential integrity?

  20. What is a natural join?
    What is an inner join?
    How is an outer join different from an inner join?

  21. What is an index?

  22. What is the index that a DBMS will probably create by default?

  23. What