DESIGN AND IMPLEMENTATION OF DATABASE ORIENTED SYSTEMS
MIS 390
Spring Semester 2008
COURSE DESCRIPTION:
Databases are one of the most important and useful tools available to management and information technology professionals. Databases provide the foundation for collecting, organizing, and sharing data across an organization. This course will present the processes involved in designing, documenting and implementing database oriented systems in the business organization. It will include the hands-on experience of working with database management system software, especially MS Access, and the standard query language, SQL. At the end of the course, students should be able to evaluate a business situation and build a database application that will satisfy the business needs.
Prerequisites: MIS 388 (may be taken concurrently)
Credit: 3 semester hours
COURSE OBJECTIVE:
1. To develop an understanding of the design and implementation process for database applications.
2. To gain an understanding of how database management software works and how to include it in the design solutions.
3. To learn the basics of the Microsoft’s DBMS software Access.
4. To learn the basics of SQL, the standard query language used in all DBMS software.
REQUIRED TEXT:
Cable, Sandra. Succeeding in Business with Microsoft Office Access 2007. Thomson Course Technology. 2008. ISBN 1-4239-0606-3.
GRADING CRITERIA:
Class Involvement 10%
Homework
(6 cases @ 4%) 24%
(1 SQL exercise) 6%
Exams (3 @ 20%) 60%
COURSE GRADE:
A 90 and above
B 80-89
C 70-79
D 60-69
F below 60
OTHER:
Students are
responsible for abiding by all published University rules and regulations as
printed in the Undergraduate Catalogue, Student Guidelines, and in other official
University publications.
HOMEWORK: Except for any group projects, all homework assignments are expected to reflect ENTIRELY your own work. If you have trouble understanding the nature of an assignment, you may seek clarification from a fellow student or your instructor. You should not, however, partially or totally copy any other student’s work or “work with” another student on the solution to the assignment. In addition to being cheating, this will not benefit you from a learning standpoint. If you are at all unclear as to what would constitute cheating, you may discuss it with your instructor at any time. The first incident of cheating will be penalized with a zero for the plagiarized assignment plus the loss of a letter grade. A second incident of cheating will result in an automatic F for the course. THESE PENALTIES WILL APPLY TO BOTH THE PERSON WHO COPIES AND TO THE ONE WHO ALLOWS THEIR WORK TO BE COPIED. Unless otherwise instructed, homework/projects are due on the due date at the beginning of class. Homework turned in late (within 24 hours) will be penalized one-half credit in addition to any deductions for errors or incompleteness. No credit will be given for homework turned in more than 24 hours late.
CLASS ATTENDANCE: Regular and timely class attendance is expected and is in your best interest. You will get out of this class what you put into it. Lack of attendance will negatively impact your class involvement grade. University policy requires that attendance be taken each class period. This will be accomplished by circulating a sign-in sheet. It is the student’s responsibility to be sure that they have signed the sheet each day.
EXTRA CREDIT: There are no extra credit assignments.
MISSED EXAMS: If you miss an exam other than because of religious reasons (see below) you will receive a zero for that exam. At my discretion, and based on your reason for missing the exam, I might either count the final exam grade as a substitute or give you a make-up exam.
RELIGIOUS HOLY DAY POLICY: Section 51.911(b) of the Texas Education Code requires that an institution of higher education excuse a student from attending classes or other required activities, including examinations, for the observance of a religious holy day, including travel for that purpose. A student whose absence is excused under this subsection may not be penalized for that absence and shall be allowed to take an examination or complete an assignment from which the student is excused within a reasonable time after the absence. The instructor will notify the student of a reasonable timeframe in which the missed assignments and/or examinations are to be completed.
DISABLED STUDENT POLICY: It is the policy of Sam Houston State
University that no otherwise qualified disabled individual shall, solely by
reason of his/her handicap, be excluded from the participation in, be denied
the benefits of, or be subjected to discrimination under any academic or
Student Life program or activity. Disabled students may request
help with academically related problems stemming from individual disabilities
from their instructors, school/department chair, or by contacting the Chair of
the Committee for Continuing Assistance for Disabled Students and Director of
the
FOOD AND/OR DRINKS IN CLASSROOMS: According to University policies and Dean Lewis’ specific request, students are not allowed to consume food or drinks in the classrooms.
COURSE OUTLINE:
|
CLASS |
DATE |
TOPIC |
PRE-CLASS
READING |
ASSIGNMENT DUE |
|
1 |
1/16/08 |
Introduction
to Course |
|
|
|
1/21/08 |
MLK
Holiday |
|
|
|
|
2 |
1/23/08 |
Discuss
Intro & Chapter 1 |
Intro pp
2-23 & Chapter 1/ Level 1 |
|
|
3 |
1/28/08 |
(Cont.) |
Level 2 |
|
|
4 |
1/30/08 |
(Cont.) |
Level 3 |
|
|
5 |
2/4/08 |
Chapter 1
Wrap-up |
|
|
|
6 |
2/6/08 |
Chapter 1
Wrap-up |
|
|
|
7 |
2/11/08 |
Review
Chapter 1, Case 3 |
|
Chapter 1,
Case 3 |
|
8 |
2/13/08 |
Discuss
Chapter 2 |
Chapter
2/Level 1 |
|
|
9 |
2/18/08 |
(Cont.) |
Level 2
& 3 |
|
|
10 |
2/20/08 |
LAB:
Chapter 2 Wrap-up |
|
|
|
11 |
2/25/08 |
LAB:
Review Chapter 2, Case 3 |
|
|
|
12 |
2/27/08 |
TEST 1 |
Intro,
Chapters 1 & 2 |
|
|
13 |
3/3/08 |
Review
Test 1 & Discuss Chapter 3 |
Chapter
3/Level 1 |
|
|
14 |
3/5/08 |
LAB:
(Cont.) |
Level 2 |
|
|
3/10/08
thru 3/14/08 |
SPRING
BREAK |
|
||
|
15 |
3/17/08 |
LAB:
(Cont.) |
Level 3 |
|
|
16 |
3/19/08 |
LAB:
Chapter 3 Wrap-up |
|
|
|
17 |
3/24/08 |
LAB:
Review Chapter 3, Case 3 |
||
|
18 |
3/26/08 |
LAB: SQL
programming review |
Pages 259
to 263 |
|
|
19 |
3/31/08 |
LAB: SQL
(cont.) |
|
|
|
20 |
4/2/08 |
LAB: SQL
(cont.) |
|
|
|
21 |
4/7/08 |
LAB:
Discuss Chapter 4 |
Chapter
4/Level 1 & 2 |
|
|
22 |
4/9/08 |
LAB: (Cont.) |
Level 2
& 3 |
|
|
23 |
4/14/08 |
LAB:
Chapter 4 Wrap-up |
SQL
Exercise |
|
|
24 |
4/16/08 |
LAB:
Review Chapter 4, Case 3 |
||
|
25 |
4/21/08 |
TEST 2 |
Chapter 3
& 4 |
|
|
26 |
4/23/08 |
Review
Test 2 & LAB:
Discuss Chapter 5 |
Chapter
5/Level 1 & 2 |
|
|
27 |
4/28/08 |
LAB:
(Cont.) |
Level 2
& 3 |
|
|
28 |
4/30/08 |
LAB:
Review Chap 5, Case 3 |
Chapter
5, Case 3 (Due at end
of Lab) |
|
|
29 |
5/5/08 |
LAB: Discuss
Chapter 6/Level 1 |
Chapter
6/Level 1 |
|
|
30 |
5/7/08 |
LAB: Work
on Chapter 6 Homework |
|
(Due at end of Lab) |
|
|
5/14/08
8:00 to 10:00am |
FINAL
EXAM |
|
|