MIS 380 - FINAL EXAM STUDY GUIDE
***May 14, 1998: 1:30 - 4:30 in LH2 in the Science Annex***

• 30-50 Multiple Choice
• 10-15 Matching
• Discussion Questions including designing and normalizing relations
• a simple hands-on Access question (you are expected to know how to creates forms, queries, and reports from single and multiple tables) [this part of the test will be open book and notes and completed on the computer]

CONTENT

1. Introduction to Database Processing
   1. Examples of Databases
   2. File Processing Systems
   3. Definitions
   4. History of Database
2. Introduction to Database Development
   1. Creating a Database
   2. Components of a DBMS
   3. Database Development Processes
3. Entity-Relationship Model
   1. Elements of the Entity-Relationship Model (entity classes and instances, relationship classes and instances)
   2. Examples
   3. You need to be able to model a database with an E-R diagram
4. Semantic Object Model
   1. Elements of the Semantic Object Model (object classes and instances, types of objects (simple, composite, compound, hybrid)
   2. Examples
   3. Comparing the Semantic Object Model and the E-R Model
   4. You need to be able to model a database with the Semantic Object Model
5. Relational Model and Normalization
   1. Relational Model
   2. Normalization (First-Fifth, Boyce-Codd)
   3. Domain/Key Normal Form
   4. You need to be able to normalize relations so as to remove anomalies
6. Database Design using E-R Models
   1. You need to be able to design a database from an E-R model
7. Database Design using Semantic Object
   1. You need to be able to design a database from an E-R model
8. Chapter 8 – Database Application Design
   1. You should be able to develop all of the components of a database using Access and Salsa
9. Chapter 9 – Foundations of Relational Implementation
   1. You should have a good understanding of relational algebra
10. Chapter 10 – Structured Query Language
    1. You should be able to write SQL statements to query single and multiple tables
11. Chapter 11 – Relational Implementation for Personal Databases
    1. You should be able to develop a complete database database using Access
12. Chapter 12 – Introduction to Multi-User Database Processing
    1. You should a clear understanding of multi-user database processing
    2. You should have a good understanding of database reliability, security, and administration
13. Chapter 16 – Internet, Intranet, and Multimedia Database Processing
    1. You should have a good understanding of Internet and intranet database processing
    2. You should have a good understanding of multimedia database applications
14. Chapter 15 – Sharing Enterprise Data
    1. You should understand data administration
    2. You should understand the needs and uses of data warehousing
15. Chapter 17 – Object-Oriented Database Processing
    1. You should understand the terminology of object-oriented database processing

16. Access
    1. You should be able to discuss how to create a database
    2. You should be able to discuss how to modify a table
    3. You should be able to discuss how to create a form
    4. You should be able to discuss how to filter/query a table
17. Salsa
    1. You should be able to discuss how to create a database using objects