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
|