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 not allowed. If you work together on a
non-group assignment, both students will be given a zero. Unauthorized
group work is also considered cheating and will be reported to the Dean
of the School of Business.
You may use any code that you find in the required text in your assignments
and projects.
However, you may use outside code (from web or any other book) for assignments
and projects IF and ONLY IF you ask for permission from the instructor ahead
of time. Otherwise, you will be given a zero on that assignment or
project.
Schedule
The course meets every Monday September 14 and December 14. 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/14 |
Chap. 1 |
Introduction, Database Environment |
2-9/14 |
Chap.2 |
Intro to Access/SQL Server, Database Development |
3-9/21 |
Chap. 3 |
Modeling Data in the Organization |
4-9/28 |
Chap. 4 |
Enhanced E-R Model and Business Rules |
5-10/05 |
Chap.5 |
Logical Database Design & the Relational Model, Access/SQL Server Queries |
6-10/12 |
Chap. 6 |
Physical Database Design & Performance |
7-10/19 |
|
Visit by Arvid Johnson followed by Midterm exam |
8-10/26 |
Chap. 7 |
Introduction to SQL |
9-11/2 |
Chap. 8 |
Advanced SQL. 3 point optional bonus assignment given. |
10-11/9 |
|
SQL Wrap Up, Access/SQL Server Reports. Hw8 (Advanced SQL) assigned. 3 point bonus assignment due (no credit for late submission) |
11-11/16 |
Chap. 9 |
The Client/Server Database Environment, Introduction to VB.Net. HW9(Internet Database environment) Assigned |
| Extra Credit 11/18 | Attend Ethics Lecture in Lund Audtiorium 7:00 pm for Extra Credit (details by email). | |
12-11/23 |
Chap. 10 |
The Internet Database Environment. Hw8 due. Project 1a due. |
13-11/30 |
Chap. 11 |
Data Warehousing. HW9 due. Project 1b due. HW10 Assigned (Will be either Data Warehousing or Database Administration). |
14-12/7 |
|
Data & Database Administration. Project 1c due. |
12/14 |
|
Final Exam. HW10 due. |
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% |