Kent State University
College of Business Administration
MIS 44043 (Call 13819) Syllabus – Data Base Management Systems – Fall 2003
Class Schedule: MWF 2:15pm – 3:05pm, Room 206 BSA
Text: Database Processing, Eighth Edition, David M. Kroenke, Prentice Hall Publishing
Instructor: Rick Goeke
Email:
Phone: 672-1164
Office: Room 402, Office hours: 3:15–6:15pm W and by appointment
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 relational database processing
Class Schedule
Week Chapter Topic Note
1 1 Intro to DB Processing
2 2 Intro to DB Development
3 3 Entity-Relationship (E-R) Model Quiz 1
4 5 Relational Model & Normalization
5 6 DB Design using E-R Model Exam 1
6 6 DB Design using E-R Model Homework 1
7 8 Foundations of Rel. Implementation
8 9 SQL
9 9 SQL Exam 2
10* 9 SQL
11 10 DB Application Design Homework 2
12 10 DB Application Design
13 11 Managing Multi-User DBs Quiz 2
14 11 Managing Multi-User DBs
15 Review
16 Final Exam Dec 12, 12:45-3:00 pm
*Note: Last day to withdraw is Saturday, November 1, 2003. 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 (i.e. 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, and again, those dates are inflexible 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.
Once grades for an exam, quiz or homework are received, you have three days to let me know by e-mail, that you feel a mistake has been made in your grade. If you fail to contact me about your grade within this three day period, then the grade will be considered final.
A letter grade of A will be earned if you have a total score of 90% or more. A grade of B will be earned for a total score that is at least 80% and less than 90%. For a C, you must have at least 70% and less than 80%. A D will be assigned with at least 60% and less than 70% for your total score. An F will be assigned to all students receiving a total score that is less than 60%. Note, a total score of 79.8% is less than 80% and will result in a final grade of C.
Academic Dishonesty
Cheating means to misrepresent the source, nature or other conditions of your academic work (e.g. tests, quizzes, projects, homework) so as to get undeserved credit. In addition, it is considered cheating when one cooperates with someone else in any such misrepresentation. Plagiarism means the use of the intellectual property of others without giving them appropriate credit. It is University policy that cheating or plagiarism result in receiving a failing grade for the work or course. Repeat offenses result in dismissal from the University.
Students With Disabilities
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).
Class Registration
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 Friday, September 5, 2003 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
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
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.
Readings
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.