PREREQUISITES: CIS 110 CIS111 or departmental approval

Instructor: Randall Perry, Email: [email protected]
For homework submission go to: http://domain-logic.com, Links then Online Classroom

COURSE DESCRIPTION: This course is an introduction to the concepts involved with database processing. Discussion covers database processing objectives, terminology, database models and database design. Programming exercises include creating, querying and updating a relational database.

LEARNING OBJECTIVES: By the end of this course the student should be able to:

1. Discuss advantages and disadvantages of database processing compared to conventional file processing.
2. Explain the functions of a DBMS.
3. Explain and compare the relational, network and hierarchical database models.
4. Use the normalization process in database design.
5. Create ERDs (Entity Relationship Diagrams)
6. Demonstrate knowledge and use of SQL by creating, querying and maintaining a database.
   1. Demonstrate the following Sucess System ® Abilities
   2. Problem Solving by analyzing the problems presented by the programming assignments, developing the logic of program solutions, and implementing solutions to the program assignments.
   3. Self-initiative and Reliability by regular, punctual class attendance and by taking responsibility for completing assignments by the deadlines
   4. Computer Application Skills by executing SQL commands through both the graphical interfaces and command line interface.
7. Identify other major operating systems, their major components and the type of systems that use them.

DU Excellence System
Davenport University believes that those students who successfully complete any certificate, associate, bachelor or master's program at the University should be able to demonstrate certain professional and academic abilities. These abilities embody both the key practical and theoretical skills taught and measured throughout all Davenport University academic programs and, in accordance with the mission of the University, prepare students for success in their chosen profession.

Dynamic Leadership
Leadership; Reasoning and Problem Solving; Teamwork.

Universal Communication
Interpersonal, Oral, and Written Communication; Global Perspective

Professional Excellence
Honesty and Integrity; Computer Proficiency; Information Literacy; Mathematical Literacy; Career Skills

EVALUATION: Includes four specific areas; they are homework assignments, quizzes, the final examination and a project. Class participation although not specifically quantifiable for grading, provides the instructor insight into the students understanding of the subject matter vital if the instructor is required to make any subject decisions concerning grading. Each specific area will receive equal weight in the overall class grade. If the quality of any assignment does meet the common sense test for quality it will be returned to the student for resubmission.

CIS240 FINAL PROJECT
Students will be required to produce a small final project for this class.

1. The deliverables to be turned in are: ERD, process of Normalization, data definitions, and SQL code.

2. The essential elements of the solution include as a minimum:

• 3 Tables-these tables should have foreign keys that tie them together.
• 1 Query to retrieve information from 2 or more tables (you can use the Union, Intersect or Minus joins here).
• Web interface to view and/or update information (not all database contents need to be displayed-only what makes sense)
• 2nd Normal Form (2NF)
• Input form- this can either be an Access frontend, Web Page, Data Block form, Custom form or other.