Review for the Final:
Databases

November 1996

If you can't answer these questions from your notes, ask about them in class or during office hours before the final!


1. What is a database? What is a DBMS?

2. What are the physical, logical and view layers of a DBMS?

3. What is a relational database? What is a relation?

4. What is a transaction?

5. What are some of the reasons to choose a database over a spreadsheet?

6. What is a record?

7. What is a field?

8. What is a key field?

9. What is a view?

10. What are the roles of the systems programmer, the application programmer, and the user in developing and working with a DBMS?

11. What is SQL? What is QBE?

12. Why are databases sometimes worthless for casual users?


RETURN to CSCI 1200 Home Page

- John Rieman