This course introduces the basic knowledge needed to analyze, evaluate, design, administer, implement and maintain database systems in business. Emphasis is placed on database and information resource management in an organization. Topics include fundamental concepts of business database systems, different data models, database schemas, data integrity the role of databases as a means for managing data resources, database reporting, data normalization, and the role of databases in decision making in business.
At the end of this course, the student should be able to
Instructor
Jim Miller, Fine Arts 200
jmiller@dom.edu
The best way to contact instructor is through email
Prerequisites
GBIS 703 or GBIS 710 or equivalent.
Text Books
There is one required textbook. You need the book and the software that comes with it on the first day of class.
Class attendance is highly recommended. It will greatly help you with your project, assignments and exams
Software
Microsoft Access, Microsoft SQL Server, Microsoft Visio, MySQL.
Grading
| Project | 30% | 90 points |
| Homework Assignments | 50% | 150 points |
| Exams | 20% | 60 points |
| Time Late | Grade Reduction | Multiply Base Grade by: |
| 1 minute through 24 hours late | 4% off | .96 |
| Up to 2 days late | 8% off | .92 |
| Up to 3 days late | 12% off | .88 |
| Up to 4 days late | 16% off | .84 |
| Up to 5 days late | 20% off | .80 |
| Up to 6 days late | 24% off | .76 |
| Up to 7 days late | 28% off | .72 |
| Up to 8 days late | 32% off | .68 |
| Up to 9 days late | 36% off | .64 |
| Up to 10 days late | 40% off | .60 |
| Up to 11 days late | 44% off | .56 |
| Up to 12 days late | 48% off | .52 |
| Up to 13 days late | 52% off | .48 |
| More than 13 days late | 100% off - No Credit | 0 |
All assignments and projects must be submitted in the appropriate Blackboard
assignment before the deadline.
All assignments must be done individually, unless otherwise specified. Working
together on non-group assignments is allowed BUT you must not let anyone else
touch your keyboard or mouse or accept files from other students. These rules
are designed so that you will have a good understanding of all assignments
and projects in this class.
You may use outside code (from web) for assignments and projects IF and ONLY IF you ask for permission from the instructor ahead of time.
Schedule
The course meets every Thursday from September 2 and December 16 (except November 25). Class starts at 6:30 PM and ends at 9:30 PM. The schedule below is approximate. Topics and assignment dates may change and the change will be announced in class. Changes will also appear on the schedule in Blackboard.
This is a tentative schedule that is subject to change.
Week |
Readings |
Topic(s) |
1-9/2 |
Chap. 1 |
Introduction, Database Environment |
2-9/9 |
Chap.2 |
Intro to Access/SQL Server, Database Development |
3-9/16 |
Chap. 3 |
Modeling Data in the Organization |
4-9/23 |
Chap. 4 |
Enhanced E-R Model and Business Rules |
5-9/30 |
Chap.5 |
Logical Database Design & the Relational Model, Access/SQL Server Queries |
6-10/7 |
Chap. 6 |
Midterm exam (take at home before 10/13) |
7-10/14 |
|
Visit by Assistant Dean Linda Puvogel (30 minutes) followed by Physical Database Design & Performance Assignment 5 due |
8-10/21 |
Chap. 7 |
Introduction to SQL. Assignment 6 due |
9-10/28 |
Chap. 8 |
Advanced SQL. 3 point optional bonus assignment given. Assignment 7 is due. Work on 90 point project |
10-11/4 |
|
SQL Wrap Up, Access/SQL Server Reports. Hw8 (Advanced SQL) assigned. 3 point bonus assignment 7b due (no credit for late submission). Work on 90 point project |
11-11/11 |
Chap. 9 |
The Client/Server Database Environment, Introduction to VB.Net. HW9(Internet Database environment) Assigned. Work on 90 point project |
| Extra Row | ||
12-11/18 |
Chap. 10 |
The Internet Database Environment. Hw8 due. Project 1a due (optional extension on Project 1a until 11/25) |
| 11/25 | Thanksgiving Holiday. No class. Project 1a is due if you did not finish it last week. | |
13-12/2 |
Chap. 11 |
Data Warehousing. HW9 due. Project 1b due. HW10 Assigned |
14-12/9 |
|
Data & Database Administration. Project 1c due. Final exam becomes available after class tonight. This is the final class meeting. |
12/16 |
|
Final Exam due before 9:00 pm in Blackboard. HW 10 due in Blackboard. All assignments due in Blackboard. No class. |
At the end of the course the final letter grade will be computed as follows:
|
||
Letter Grade |
|
Corresponding Percentage |
A: |
|
93-100% |
A-: |
|
90-92.9% |
B+: |
|
88-89.9% |
B: |
|
80-87.9% |
C+: |
|
78-79.9% |
C: |
|
70-77.9% |
C-: |
|
68-69.9% |
F: |
|
0-67.9% |