M&IS 44043 Fall 2007 Ghosh
M&IS 44043 - Database Management Systems
SYLLABUS
Fall 2007
|
COURSE INFORMATION:
Name of Course:
|
Database Management Systems
|
|
|
Term:
|
Fall 2007
|
|
|
Room:
|
324 BSA
|
|
|
Meeting Time:
|
3:45pm-5:00pm MW
|
|
|
Web Sites:
|
Course: http://vista.kent.edu
|
|
|
Prerequisites:
|
M&IS 24060, M&IS 24070
|
|
|
Course Description:
|
The design, implementation and management of data base management systems within organizations are studied from both theoretical and applied perspectives.
|
|
|
INSTRUCTOR INFORMATION:
Name of Instructor:
|
Suvankar Ghosh, MBA, MS (Electrical Engineering), MA
|
Office Address:
|
BSA A422
|
Telephone:
|
(330) 672-1149
|
Office Hours:
|
TBD
|
E-mail:
|
sghosh1@kent.edu
|
|
|
COURSE MATERIALS:
Required Text:
|
Hoffer, Prescott,.McFadden. Modern Database Management. 8th ed. Prentice Hall 2007.
|
Vista
|
All powerpoint presentations, assignments, and other materials will be placed on http://vista.kent.edu
|
COURSE OBJECTIVES, REQUIREMENTS & EVALUATION:
Course Objectives:
|
Upon completion of this course, students will:
|
|
1. Understand the role of databases in business and other environments.
|
|
2. Be acquainted with the various concepts associated with designing, implementing, and using databases.
|
|
3. Understand the use of relevant analysis and design tools (e.g. entity relationship diagrams).
|
|
4. Obtain a working understanding of structured query language (SQL), normalization, transaction management and concurrency control.
|
|
5. Learn Embedded SQL programming. I will use C# as the programming language to explain Embedded SQL programming.
|
|
|
Homework:
|
Four case study-based homework assignments will be given. All homework assignments and the group project will be based on the ArcTel, Inc. case. Each homework assignment is to be an individual effort though discussion is permitted among members of your group. Assignments must be handed in at the end of the class on the due date. If you have an excused absence you must turn in the assignment before the due date when the absence allows for planning ahead (weddings, group trips, interviews, athletics, etc.). Excused absences that are true emergencies and do not allow planning ahead will be dealt with individually. No makeups will be given to compensate for a missed assignment once the due date has passed.
|
|
|
|
|
Projects:
|
Project teams will be composed of 4 students with one group possibly having either fewer or more to account for the actual number of students. The group project is to create a working database for ArcTel, Inc. All members in a group will get the same grade for the project unless there are some exceptional circumstances which dictate that some differentiation be done among the members in the grading of the project.
|
|
|
Reading:
|
The chapter or portion of a chapter that is to be discussed in class should be read by the student before class.
|
|
|
Quizzes:
|
No quizzes are planned, however, if problems are encountered concerning attendance or keeping up with the material, unannounced quizzes may be given at the discretion of the instructor.
|
|
|
Exams:
|
Three examinations will be given at regular intervals during the semester. Dates for exams are on the syllabus and, unless unforeseen conflicts occur, are firm. Since some flexibility in time allowed each topic is necessary, the topics covered on each exam may vary slightly from those on the syllabus. The content relevant to each exam will be announced before the exam is given.
|
|
Students may feel free to inquire into any aspect of examinations or their scores during office hours. However, to encourage quick resolution of problems or concerns that may arise, issues must be raised with the instructor within one week following return of the exam grade. If the instructor is not contacted prior to that time the examination will be considered closed and grades finalized.
|
|
|
Attendance:
|
Students are responsible for all in-class announcements and material whether absence is excused or unexcused. Missed assignments/quizzes will not be made up. In certain cases (emergencies) the score will be dropped. All other cases receive a score of 0.
|
|
|
GRADES:
Exam I
|
15%
|
Exam II
|
15%.
|
Exam III
|
15%
|
All Homework Combined
|
30%
|
Group Project
|
25%
|
TOTAL
|
100%
|
Letter grades will be based on the following thresholds:
A
|
90 to 100%
|
B
|
80 to 90%
|
C
|
70 to 80%
|
D
|
60 to 70%
|
F
|
< 60%
|
POLICIES
The following policies apply to all students in this course:
A. Students attending the course who do not have the proper prerequisite risk being deregistered from the class.
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 9, 2007 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 in which you are not properly registered.
B. Academic Honesty: Cheating means to misrepresent the source, nature, or other conditions of your academic work (e.g., tests, papers, projects, assignments) so as to get undeserved credit. The use of the intellectual property of others without giving them appropriate credit is a serious academic offense. It is the University's policy that cheating or plagiarism result in receiving a failing grade (0 points) for the work or course. Repeat offenses may result in dismissal from the University.
C. Course Withdrawal:
For Fall 2007, the course withdrawal deadline is Sunday, November 4, 2007.
D. Students with disabilities:
University policy 3342-3-18 requires that students with disabilities be provided reasonable accommodations to ensure their equal access equal access course content. If you have documented disability and require accommodations, please contact the instructor at the beginning of the semester to make arrangements for necessary classroom adjustments. Please note, you must first verify your eligibility for these through the Student Disability Services (contact 330-672-3391 or visit www.kent.edu/sds for more information on registration procedures).
This Syllabus including the class schedule is subject to change at the discretion of the instructor.
Recording of any lecture or other instructional activity occurring as part of the course is prohibited.
TENTATIVE SCHEDULE:
Day
|
Topics
|
Readings
|
|
Student
Deliverable
|
Aug 27
|
Course Overview, Introduction to Databases
|
Chapter 1
|
|
|
Aug 29
|
The Database Development Process
|
Chapter 2
|
|
|
Sep 5, 10
|
E-R Modeling
|
Chapter 3, 4
|
|
|
Sep 12, 17
|
Logical Database Design
|
Chapter 5
|
|
Sept 17 – Homework #1
|
Sep 19
|
Review
|
Chapters 1,2,3,4,5
|
|
|
Sep 24
|
Exam I
|
Chapters 1,2,3,4,5
|
|
|
Sep 26
|
Physical Database Design and Performance
|
Chapter 6
|
|
|
Oct 1,3
|
SQL
|
Chapter 7
|
|
|
Oct 8,10
|
Advanced SQL
|
Chapter 8
|
|
Oct 8 –
Homework #2
|
Oct 15, 17
|
Embedded SQL Programming
|
|
|
|
Oct 22, 24
|
Client/Server & Internet Database Environment
|
Chapter 9, 10
|
|
Oct 24 –
Homework #3
|
Oct 29
|
Review
|
|
|
|
Oct 31
|
Exam II
|
Chapters 6,7,8,9,10
|
|
|
Nov 5,7
|
Data Warehousing
|
Chapter 11
|
|
|
Nov 14, 21
|
Database Administration
|
Chapter 12
|
|
Nov 14 –
Homework #4
|
Nov 26
|
Distributed Databases
|
Chapter 13
|
|
|
Nov 28, Dec 3
|
Object-Oriented Data Modeling
|
Chapter 14, 15
|
|
|
Dec 5
|
Demo of Group Projects
|
|
|
Dec 5 –
Group Projects
|
Dec 10
|
Final Exam
|
Chapters 11,12,13,
14, 15
|
|
|