Understanding database technology is essential to building modern business computer applications in either a classical environment or in the new Internet environment. In a recent national Information Week survey, database technologies were noted in 3 out of the top 5 IT areas where more qualified IS professional would be needed in the next decade.
Course Objectives
- Know how to model business situations and design corresponding databases
- Develop a basic understanding of database management
- Know how to use modern database design and management tools
- Understand basic data definition and manipulation via SQL
- Know how to implement a practical database project
Course Grading
- 60 points - Three or four tests
- 10 points - Homework
- 30 Points - Course Project
Textbook
Database Processing by David Kroenke, 10th Edition ISBN:9780131672673
Additional Materials
USB Drive or diskettes
Links
- General policies for all my courses
- Home page for contact information
- Textbook Home Page (Do not open in framing environment !)
- ER Design Tool
- SP Database (Access)
- SQL Lab Database (Access)
- Example Project
- PHP/MySql Query
COURSE OUTLINE
Session # Subject Text Reference Notes 1 Database Overview Chapter 1 Project Teams 2 Introduction to SQL Chapter 2 ... 3 The Relational Model & Normalization Chapter 3 & 4 ... 4 Entity Relationship Model Chapter 5 Test 1 5 ER Lab ... ... 6 Database Design with ER Chapter 6 ... 7 Database Design Lab ... Test 2 8 Relational Algebra ... Design Report 9 SQL I ... ... 10 SQL II ... ... 11 Database Implementation Chapters 7 & 8 ... 12 MySQL Chapter 14 Test 3 13 Database Environments & Distributed Processing Chapters 12 - 14 ... 14 Project Presentations ... ... A session is one week for the day program and one class for evening or graduate school. The above schedule is a tentative guideline. The progress of the class will typically vary somewhat from this outline and additional material may be added. Scheduled homework and tests will be announced in class, therefore it is important to stay informed if absent from class.