IFSM 410

Database Concepts

Topics:

Summary:

An introduction to the design and management of database systems in a business environment. Topics include the role of databases in organizations; the management of information as a critical business resource; types and functions of database management systems; conceptual data modeling and entity/relationship and semantic data models; and the fundamental principles of relational and object-oriented database design. The implementation and maintenance of database management systems and the role of the database administrator are discussed.

Essentials:

Syllabus

Slide Set 1: Database Introduction
Slide Set 2: Relational Databases
Slide Set 3: Entity Relationship Diagrams
Slide Set 4: Normalization
Slide Set 5: Database Design Life Cycle
Slide Set 6: Conceptual Database Design
Slide Set 7: Logical Design and Implementation
Slide Set 8: Beginning SQL
Slide Set 9: Advanced SQL

Projects:

   1. Due Week 2 - Class 2:
          Ch. 1 Probs. 7 to 13;
          Ch. 2 Probs. 1, 4, 5

    2. Due Week 3 - Class 2:
          Ch. 1 Create an ERD for Prob 13 (include attributes).
          Ch. 2 Probs. 6 (include attributes), 7, 8, 9, 14 (no attributes), 15
          Ch. 4 Probs. 1, 2, 3, 7, 9 (ERD's have no attributes)

3. Due Week 4 - Class 2:
Ch. 5 Probs. 1-5, 10-13

    4. Due Week 8 - Class 3:
        Database Design Project
              Customer Data
              Movie Data
              Project Modifications 1
              Project Modifications 2

    5. Due Week 8 - Class 1: Project 5 and Take Home Exam:
        Chapter 3 Review Questions: 1, 2, 3, 5, 6, 15  [30 Points]
        Chapter 3 Problems 2, 4, 5, 6, 7, 8{NO Mileage Charge} [50 Points]
                  Download SQL Corrected - Vendor/Product Database
                  Download AVIA Database

Data Definition Query Instructions

All documents are in Adobe Acrobat format.

(If doesn't load in browser save as file and open with Acrobat Reader)