CS219 – Database Management Systems

Course Syllabus

General Course Objectives:

1. To enable CIS majors to understand what a DBMS is and how it is used in organizations.

2. To provide all students including students who elect computer science as a secondary major a foundation for developing, designing and using DBMS systems.

Specific Objectives:

1. To present the definition, goals, objectives, components, and methods used for designing databases as part of an organization's MIS.
2. To teach specific concepts and tools for effective database design, data organization (including normalization), data retrieval using query languages (SQL), and database management.
3. To provide an in-depth understanding of designing, creating, querying, and maintaining a database using MS Access.
4. To have the student demonstrate his/her acquired skills through projects and case studies.

Textbook and Materials:

• Microsoft Access 2000 Complete Concepts and Techniques, Shelly, Cashman, and Pratt, 2000. ISBN #0-7895-4671-X.

• A medium-sized 3-ring binder to hold notes and handouts. I will provide supplemental readings from numerous sources including the Internet. Organize these materials in your notebook.

• 2-3 floppy disks to save group and individual projects.

Instructional Policies and Procedures:

Attendance: College policy states a student may not exceed 9 absences for a three-credit course meeting three times a week. A student who exceeds 9 absences will be dropped from the course. If you must be absent for a class, please tell me in advance to get class notes and assignments. If you must be absent for a scheduled test, you must make arrangements to take the test BEFORE the next class meeting because there are no test make-ups.

Homework and Group Assignments: Individual written assignments are to be completed and handed in weekly. These assignments will consist of review questions and application problems from each chapter in the text. Group assignments will consist of case studies that are written and then presented in class.

Comprehensive Database Project: Each student will design, develop, and present a complete database system built for either a fictitious or real organization. This project will begin about the 4th week and will be developed throughout the semester. The project will be submitted in written and oral form during the 15th week.

Class participation is extremely important for relevant, interesting, and lively class discussions. Prepare pertinent questions or topics you want to discuss before each class. Bring in current newspaper or magazine articles pertaining to topics discussed in class. Your involvement in this course will greatly improve your grade!

Code of Conduct: Cayuga Community College has published a code of conduct in the student handbook and on its web site. I fully support and adhere to these policies, including the following:

• Students should arrive on time to class and to be prepared to stay for the full hour.
• Students are to refrain from any behavior that is distracting to others.
• No food or drink is allowed in the classroom.
• Cell phones or electronic devices should be turned off or not brought to class.
• Students should put forth their best, honest effort. Any evidence of cheating or copying assignments will be dealt with as follows: 1st offense the student receives an "F" grade for the assignment or test; 2nd offense, the student receives an "F" for the course.

Grading:

Homework Assignments 20%

Database Lab Projects 20%

Hourly Tests (3). 40%

Comprehensive Database Project 20%

Grade Distribution:

90 - 100 = A 70 - 74 = C

85 - 89 = B+ 65 - 69 = D+

80 - 84 = B 60 - 64 = D

75 - 79 = C+

Course Schedule (Tentative)

Week	Content	Assignments
1 1/23-1/25	Intro to DBMS · Purposes and uses of DBMS DBMS vs. File Managers MIS Systems Approach	Read supplemental materials Complete written assignment Gather articles for "In the News …"
Week	Content	Assignments
2 1/28-2/1	The DBMS Environment (Networks) Components of a DBMS Database Models Hierarchical Network Relational · Object-Oriented Introduce MS Access—Project 1	Read supplemental materials Complete written assignments Discuss In the News … Start Access Project 1 assignment
3 2/4-2/8	The Relational Database Model · Entities and attributes · Tables and characteristics · Data Dictionary · Schemas and subschemas · Entity-Relationship Modeling	Read supplemental materials Read MS Access book Complete written assignment Complete Access Project 1
4 2/11-2/15	Data Normalization Tables, classes, and keys Normalization—1NF, 2NF, and 3NF · Data rules and integrity Query Basics in MS Access	Read supplemental materials Read MS Access book Complete written assignment Start Access Project 2
5 2/18-2/20	Data Normalization Examples and Project TEST #1: DBMS and the Relationship Model, ERDs and Normalization	Read supplemental materials Complete written assignment. Complete Access Project 2
6 2/25-3/1	Database Project Proposal Due Database Queries · Introduction to SQL · Boolean Algebra · Computations & Subtotals · Multiple tables	Read supplemental materials Read MS Access book Start Access Project 3
7 3/4-3/8	Maintaining and Updating a Database Records management Updating database structure Validation rules Indexing	Read supplemental materials Complete written assignment. Complete Access Project 3
Week	Content	Assignments
8 3/11-3/15	Publishing to the Internet Forms Design Design principles Form layout and creation Graphical objects (OLE)	Read supplementary materials Read MS Access book Complete written assignment Start Access Project 4
9 3/18-3/22	Report Design Design principles Report layout and creation Graphical objects Enhanced Forms Updating Fields Creating and using subforms Other advanced techniques	Read supplementary materials Complete written assignment Complete Access Project 4
10 4/1-4/5	Calculations and Manipulations Procedural languages Programming vs. Windows environment Data controls and properties Retrieving & saving with SQL Handling errors	Read supplementary materials Read MS Access book Complete written assignment Start Access Project 5
11 4/8-4/12	TEST #2: Database Design: Queries, Forms, and Reports Database Project ERD and Normalization Due	Read supplementary materials Complete written assignment Complete Access Project 5
12 4/15-4/19	Macros · Wizards · Creating and Using Macros · Creating and Using a Switchboard	Read supplementary materials Read MS Access book Complete written assignment Start Access Project 6
13 4/22-4/26	Database Administration DBA tasks and tools Database tasks Backup and recovery Security and Privacy	Read supplementary materials Complete written assignment Complete Access Project 6
Week	Content	Assignments
14 4/29-5/3	Distribution and Integration Role of DBMS in Networks and MIS Centralized vs. Distributed databases Client-Server databases Final Project due for grading	Read supplementary materials Complete written assignment
15 5/6-5/10	New Trends The Data Warehouse E-Commerce databases The Web as a database Test #3: Macros, DBA, and Distribution	Read supplementary materials Complete written assignment
16	Final -- Database Project Presentations