M&IS 44043 Fall 2006 Goeke
Kent State University
College of Business Administration
MIS 44043 (Call 14180) Syllabus – Data Base Management Systems – Fall 2006
Class Schedule: M-W 3:45–5:00pm, Room 324 BSA
Text: Database Processing, Tenth Edition, David M. Kroenke, Prentice Hall Publishing (ISBN 0131672673)
Instructor: Dr. Richard J. Goeke
Email: rgoeke@kent.edu
Phone: 672-1164 ext 3
Office: Room A402, Office hours: TBA
Web site: www.personal.kent.edu/~rgoeke
Course Overview
This is a high level course intended for IS majors and other students with a serious interest in relational database. It is therefore critical that you keep up with readings and participate in class. Course objectives include:
- Learn the role of databases and database applications in contemporary organizations
- Learn and practice data modeling using the entity-relationship model
- Learn and practice developing database designs
- Understand the use of SQL and learn SQL syntax
- Understand the special needs of multi-user database processing and learn techniques for controlling the consequences of concurrent data access
- Know the features and functions of a commercial-duty DBMS product and understand how these are implemented in Oracle
- Learn the need for both database administration and data administration
- Learn advanced concepts relevant to database processing
Class Schedule
Week Chapter Topic Note
1 1 Introduction
2 1 / 3 Relational Model and Normalization
3 3 / 4 Database Design using Normalization Quiz 1
4 4 / 5 Data Modeling with the E-R Model
5 5 Data Modeling with the E-R Model Exam 1
6 6 Transforming Data Models Homework 1
7 2 SQL - DML
8 2 SQL - DML
9 2 SQL - DML Exam 2
10* 7 SQL - DDL
11 8 SQL – DB Redesign Homework 2
12 9 Managing Multi-User DBs Quiz 2
13 9 Managing Multi-User DBs
14 15 Business Intelligence Systems
15 Review
16 Final Wed, Dec 14, 3:30pm
*Note: Last day to withdraw is Sunday, November 5, 2006. Withdrawal before the deadline results in a grade of “W” on the official transcript; after the deadline a grade must be calculated and reported.
Grading
Points %
Quizzes – 2 50 12.5%
Exams – 3@100 points each 300 75%
Homework - 2 50 12.5%
Total 400 100%
Grades
A = 360 – 400 points (90%)
B = 320 – 359 points (80%)
C = 280 – 319 points (70%)
D = 240 – 279 points (60%)
F = Below 240 points
A Note on Grading
Dates for exams, quizzes and homework are shown on the above schedule. Except for documented emergencies (ie death in the family, doctor’s excuse), no makeup exams or quizzes will be allowed. Homework due dates will be given at the time the homework is assigned – no late assignments will be accepted except for documented emergencies.
Exams, quizzes and homework will be based on your readings and material covered in class. Therefore, it is to your advantage to attend class regularly and to keep up with readings.
Academic Dishonesty
> <br> It is expected that all work you submit for a grade will be your own. If this is not the case, a failing grade will be assigned for the work and/or course, and the instructor reserves the right to pursue additional sanctions, as provided by University rules and regulations. If you are not familiar with these rules and regulations, you can find them in the current University Phone Directory.
> <br> In particular, each of you must submit your own work. Should two or more of you submit identical or substantially identical assignments/quizzes, then I can only assume that one (or more) of you copied from the other(s). In such a circumstance, every student involved will receive a failing grade for the assignment or course. Additional sanctions may be pursued in accord with University rules and regulations.
> <br> It is expected that all work you submit for a grade will be your own. If this is not the case, a failing grade will be assigned for the work and/or course, and the instructor reserves the right to pursue additional sanctions, as provided by University rules and regulations. If you are not familiar with these rules and regulations, you can find them in the current University Phone Directory.
> <br> In particular, each of you must submit your own work. Should two or more of you submit identical or substantially identical assignments/quizzes, then I can only assume that one (or more) of you copied from the other(s). In such a circumstance, every student involved will receive a failing grade for the assignment or course. Additional sanctions may be pursued in accord with University rules and regulations.
Students With Disabilities
> <br> In accordance with University policy, if you have a documented disability and require accommodations to obtain equal access in this course, please contact me at the beginning of the semester or when given an assignment for which an accommodation is required. Students with disabilities must verify their eligibility through the Office of Student Disability Services (SDS) in the Michael Schwartz Student Services Center (672-3391).
> <br> In accordance with University policy, if you have a documented disability and require accommodations to obtain equal access in this course, please contact me at the beginning of the semester or when given an assignment for which an accommodation is required. Students with disabilities must verify their eligibility through the Office of Student Disability Services (SDS) in the Michael Schwartz Student Services Center (672-3391).
Students have responsibility to ensure they are properly enrolled in classes. You are advised to review your official class schedule (using Web for Students) during the first two weeks of the semester to ensure you are properly enrolled in this class and section. Should you find an error in your class schedule, you have until Sunday, September 10, 2006 to correct the error with your advising office. If registration errors are not corrected by this date and you continue to attend and participate in classes for which you are not officially enrolled, you are advised now that you will not receive a grade at the conclusion of the semester for any class which you are not properly registered.
Course Pre-requisites
Pre-requisites for this course are MIS 24060 and MIS 24070. Students attending this course who do not have the proper prerequisites risk being deregistered from this class.
Class Attendance
> <br> Class attendance is not required. However, it is expected. And, you are responsible for all material covered in class in addition to that assigned outside of class.
> <br> Class attendance is not required. However, it is expected. And, you are responsible for all material covered in class in addition to that assigned outside of class.
A Note on Class Decorum
> <br> I interpret your coming to class as an expression of your interest in learning as much as you possibly can. Certainly, you should assume that this is your classmates' intention in being here. In fairness to your classmates (and me), I expect you to refrain from talking to others, reading newspapers, sleeping, playing radios or CDs, making telephone calls and other similar, disruptive activities. Don't be surprised if I ask you or someone else to leave because of conduct detrimental to the class. If you simply must study for a test later that day, stay home, go to the Library, find a bench outdoors. Don't do it in class.
> <br> I interpret your coming to class as an expression of your interest in learning as much as you possibly can. Certainly, you should assume that this is your classmates' intention in being here. In fairness to your classmates (and me), I expect you to refrain from talking to others, reading newspapers, sleeping, playing radios or CDs, making telephone calls and other similar, disruptive activities. Don't be surprised if I ask you or someone else to leave because of conduct detrimental to the class. If you simply must study for a test later that day, stay home, go to the Library, find a bench outdoors. Don't do it in class.
A Note on Extra Credit
In general, I do not make extra credit available. It is up to you to stay current with the material covered in class, and a poor grade on an assignment is not a reason for me to provide extra credit. On rare occasions, I may consider giving an extra credit assignment, but it will only be for a few points, and in order to be fair, must be made available to everyone.
Readings
> <br> This course is designed to help you develop skills that will serve you in an ever changing professional environment. In particular, your text and any other supplementary materials you may acquire are resources to help you master important concepts. You should take the extra time to familiarize yourself with them.
> <br> This course is designed to help you develop skills that will serve you in an ever changing professional environment. In particular, your text and any other supplementary materials you may acquire are resources to help you master important concepts. You should take the extra time to familiarize yourself with them.
Special Note
The instructor reserves the right to amend this syllabus.