CMIS 450- Database Design


Syllabus

Return to CMIS 450 Assignment Page

Prerequisite: CS 140 or completion of a prior course in computer programming with a grade of "C" or better, and CMIS 270.

Instructor: Jo Ellen Moore, Ph.D.

Phone: (618) 650-5816
Fax: (618) 650-3979
Office: Founders Hall (B2) Room 2327

Course Materials:


(1)Modern Database Management, McFadden & Hoffer, Benjamin/Cummings Publ. Co., 4th Edition, 1994, ISBN 0-8053-6047-6.

(2) Additional handouts distributed in class.

(3) Additional materials distributed via the web.

(4) You should also obtain a reference book for the Microsoft Access relational database management system software product. You can purchase one (your choice) at a local bookstore.

General Components of Course Content:

I. Database Design

II. Using MS Access to Implement a Database Application

III. Using SQL to Query Databases

IV. Database Administration
 

Course Objectives:

+ To master basic concepts of database management systems including typical DBMS architecture, how a DBMS interfaces with an operating system, and use of DBMS modules for screen, report, and code generation.

+ To extend knowledge and skills in conceptual data modeling and relational data modeling principles, including normalization.

+ To design and implement a basic database application using the MS Access DBMS.

+ To gain knowledge and understanding of physical database design principles, including index design, file access methods, and basic data structures.

+ To obtain the knowledge and skills necessary to perform basic SQL queries of database files.
 
Return to Top

Week-by-Week Syllabus:
 

Topics     

Associated Reading

Week 1 Syllabus (overview of course content, schedule, ground rules)

Intro to database concepts, database environment

Ch 1
Week 2 Overview of E-R Model, Relational Model, Physical Model

E-R Model (in-depth)

Ch 4

Assignment Distributed:     West Overshoe Municipal Library - Modeling the Library

Week 3 E-R Model (continued)

Overview of Access tables

Microsoft Access reference - the basics or intro, tables

Project #1 Distributed:        West Overshoe Municipal Library - Creating and Loading Tables

Week 4 E-R Model (continued)

Logical/Relational Model (in-depth)

Ch 6
Week 5

Due:  Project #1

Logical/Relational Model (continued)

Overview of Access queries

Microsoft Access reference - queries

Project #2 Distributed:     West Overshoe Municipal Library - Creating Queries

Week 6

Due:  Project #2

Logical/Relational Model (continued)

 Overview of Access forms

Microsoft Access reference - forms

Project #3 Distributed:     West Overshoe Municipal Library - Creating and Customizing Forms

Week 7 Physical Model (in-depth) Ch 7
Week 8

Due:   Project #3

Physical Model (continued)

Overview of Access reports

Microsoft Access reference - reports

Project #4 Distributed:     West Overshoe Municipal Library - Creating Reports

Week 9 Midterm Exam (All material up to but not including: Physical Model, Access reports)  
Week 10

Due:   Project #4

Physical Model (continued)

Overview of Access macros

 Microsoft Access reference - macros

Handout on macro programming with Microsoft Access

Project #5 Distributed:     West Overshoe Municipal Library - Automating with Macros

Week 11

Due:   Project #5

Physical Model (continued) Handout on rolling out an application in MS Access

 

Project #6 Distributed:     West Overshoe Municipal Library - Rolling Out an Application

Week 12 Database Administration Ch 12
Week 13

Due:  Project #6

Using SQL to query databases Handouts on SQL and Oracle

Ch 8

Project #7 Distributed:      SQL/Oracle project

Week 14 Database Administration (continued)

SQL (continued)

 
Week 15

Due:   Project #7

Pulling it all together : Project plan for developing a database application

Review for Final Exam

 
Week 16 Final Exam Week  

Return to Top

Grading:

The following scale will be used to assign grades.

Percent of Total Possible Points

Grade
90% or higher
A
80 to 89%   
B
70 to 79%
C
60 to 69% 
D
Less than 60%
E

The total possible points in the course is 330. The following assessments will determine the total points you earn in the class:
Assessment
Possible Points
Project #1
15
Project #2   
20
Project #3 
20
Project #4
15
Project #5
15
Project #6 
25
Project #7
20
Midterm Exam
100
Final Exam  
100
Total Possible 
330

Return to Top
     
                                 

Course Policies:

Policy for Late Assignments
Each assignment/project carries an explicit due date which will always be a class meeting date. The assignment is due at the beginning of class on that day. An assignment submitted after that day/time will receive a deduction of 10% for each weekday that it is late (note that deductions are not made for weekends and holidays).

After one full week has passed, the assignment will receive no credit. That is, if an assignment was due at the beginning of class on Tues, you need to turn it in by class time the following Tues to receive partial credit.

Grading Examples:

(a) You submit an assignment worth 20 points on Thursday that was due the previous Tuesday. You automatically receive a 20% deduction for being 2 days late (Tues and Wed). So you are at 16/20 when the grading begins. There are errors resulting in a deduction of 3 points. Your grade is 13/20.

(b) You submit an assignment worth 20 points on Monday that was due the previous Tuesday. You automatically receive a 40% deduction for being 4 days late (Tues, Wed, Thurs, and Friday). So you are at 12/20 when the grading begins. There are errors resulting in a deduction of 3 points. Your grade is 9/20.

(c) You submit an assignment worth 20 points at the end of the day Tuesday when it was due at the beginning of class that same day. You automatically receive a 10% deduction for being one day late (Tues). There are no errors in your project so your grade is 18/20.

Project due-date extensions may be granted in situations of illness, injury, or other personal problems. Requests for extensions will be considered by Jo Ellen on a case-by-case basis (i.e., extensions should not be assumed or expected). Do-Your-Own-Work Policy  All work in MIS 450 is expected to be completed INDIVIDUALLY unless the project specification document indicates that you may work in teams.

The university policy on plagiarism will be enforced to the fullest extent. A copy of this policy is available at the office of the Dean for Academic Affairs in Rendleman Hall.

 

Return to Top
Return to CMIS 450 Assignments Page

Jo Ellen Moore's Homepage
URL: http://www.siue.edu/~joemoor/htmis450.html 
Published by: Jo Ellen Moore <joemoor@siue.edu>

Created by: Faculty Technology Center <lmillio@siue.edu>

SIUE Edwardsville