CIS164AG - Data Modeling and Database Design

2 Credit Hour

 
College: Glendale Community College
Semester: Spring 2007
Section(s): 5698
Prerequisites: CIS105
Instructor: Tim Sylvester
Office: Main Campus 01-122
Phone: 623.845.3236
Email: tsylvest@student.gc.maricopa.edu

I. COURSE DESCRIPTION

Description

This course covers a top down, systematic approach to developing a relational database and defining requirements as entities, attributes, and relationships. Also, entity relationship (ER) diagrams that accurately reflects the business will be developed and the ER diagrams will be mapped to an initial database design.

The required textbook for this course is: CASE*METHOD* Entity Relationship Modeling by Richard Barker  Addison-Wesley Publishing

Course Objectives

Upon completion of this course, you should be able to:
 
  1. Describe the stages of the database development process.
  2. Analyze user information requirements
  3. Develop basic data models.
  4. Understand the terminology used in modeling
  5. Develop data models.
  6. Understand the components of an entity relationship diagram
  7. Map a simple ER diagram to an initial database table design.
  8. Map a complex ER diagram to an initial database table design.
  9. Use the principles of normalization
  10. Recognize and model exclusive relationships and entities
  11. Recognize and model recursive relationships
  12. Understand the principles of transferability and referential integrity
  13. Develop an initial relational database design from an entity relationship model
  14. Understand the implications of exclusivity in table design
  15. Understand the strategy for the use of supertypes and subtypes

II. COURSE REQUIREMENTS AND PROCEDURES

Satisfactory completion of this course REQUIRES the following:

A. Attendance and Participation.


Attendance will be taken every class or lab session.  Official absences are those stated in the 2002-2003 Student Handbook. The instructor can not and will not "play God" and decide that other absences are acceptable and others are not.  Attendance is taken at the beginning of every class period.

The learning process is an interactive process that often involves not only the instructor's lecture, but the questions and answers that arise from the people who make up the class. Therefore, there will be up to 10 points that may be earned though attendance and participation.

B. Text Assignments

Students should read and study the text PRIOR to coming to class. Prior exposure to the material that will be discussed in a class, will greatly increase your success in this subject.

C. Project Assignments

We will be doing the project assignments listed in the Project handout.  Additional information will be provided during scheduled lab/lecture periods.

Projects are due AT THE START of the class on the due dates announced in class.  At the beginning of class you should put your assignment that is due in the folder at the front of the room at the teachers desk.  If an assignment is handed in later during the class then it will be marked as late. Late assignments will receive an automatic deduction of  5 points.    If an assignments is not handed in after two class sessions, it will receive -10 points for the assignment.

NO ASSIGNMENTS CAN BE HANDED IN MORE THAN FOUR CLASS SESSIONS LATE.

You must hand in assignments during class time only - never attempt to hand in an assignment to any other location or time. Each student will receive a "Free Hand In Late" slip which they can use only once (it can not be used for the last assignment). This slip allows you to hand in an assignment at the next class and still be graded at full credit.

D. Quizzes, Midterm and Final Exam

There will be three unannounced in-class quizzes.  Each will consist of 15 matching questions. They will be closed book, closed notes and closed neighbor.  At least one class prior to the quiz, you will be given a one page listing of possible matching choices.  You will use this sheet and any notes that you have written on it when you take the quiz.

There is no make up of these quizzes.  If you are not there the class session when there is a quiz your score will be a zero.

Also, there will be two Exams - a Midterm Exam and a Final Exam.  Each exams is worth 100 points and will be taken on the computer.  Each exam will be a mix of multiple choice and true false questions. The exams are open books, open notes but closed neighbor and closed computer. There is a 50 minute time limit for each exam.

E. Worksheets

There will be 5 worksheets.  These sheets cover hands on design and modeling cases.  They will be done by groups of 3 to 5  students who will hand in one final group copy. Each worksheet will be worth 15 points.  If you are not in class when your group works on a worksheet, it will be your responsibility to complete the worksheet yourself.

F. Expectations

The instructor has certain expectations for your behavior during this semester.  Meeting these expectations make for a better learning environment for everyone.  Therefore, you are expected to:
 

III. GRADING

A. Grading Scale

The instructor believes that grades are an evaluation of the student's learning. Therefore, everyone who displays a certain level of competency will receive a certain grade. There is no curving of scores. Your grade will be based on the following point system:
 
 Points
10
  Attendance and class participation
75
  In-class worksheets  (5 at 15 points each)
170
  Project Assignments
45
  In-class unannounced quizzes (3 at 15 points each)
100
  Midterm
100
  Final Exam
500
  Total Possible

B. Converting Points to a Grade

Your letter grade will be determined by the following scale:

V. ADDITIONAL IMPORTANT POLICIES

A. Student's Requiring Special Accommodations.

The college will make reasonable accommodations for persons with documented disabilities. Student should notify Student Services and their instructors for any special needs.

B. Incomplete grades

An "I" grade will be given only for situations involving serious personal emergency or lengthy personal illness. An "I" grade will be given only when ALL of the following conditions are met:
  1. The student must have completed at least l/2 of the course requirement.
  2. The student must have completed at least l/2 of the course requirement.
  3. The student must request an incomplete prior to the last class.
A written contract must be filled out and signed indicating what work must be completed and the scheduled completion date. The contract must be filled out and signed no later than the last class session.

C. Academic Dishonesty

Students are expected to do their own assignments.  Instances of academic dishonesty will result in NO CREDIT for the assignments for all who participate; repeated instances will result in a final grade of F.

VI. STUDENT RESPONSIBLITIES

It is the student's responsibility to read and be familiar with the course syllabus. Additionally it is the student's responsibilty to be familiar with college policies covered in the Glendale Community College catalog and Student Handoook.

Students will be notified by the instructor of any changes in course requirements or policies.


Page maintained by Tim Sylvester
tim.sylvester@gcmail.maricopa.edu
Legal Disclaimer
Last updated: Saturday January 27 2007