Catalog Description: This course places its emphasis on data and Database Systems is a study of relational database concepts as applied to comprehensive information systems. These concepts include data design; modeling; normalization; the use of Structured Query Language (SQL) to define, manipulate and test the database; programmatic access to a database; and practical issues faced by database developers. Prerequisites: CPSC 130 or 140 or 210 (3 Credits)

Course Grade
The course grade will be based upon the grades from 3 exams, numerous assignments, a group project, and quizzes. The following is a tentative point assignment for the course.

Exam 1:	100
Exam 2:	100
Exam 3*:	100
Assignments and Project:	200
Quizzes:	50

The final grade is calculated by adding the number of points that the student earned divided by the total number of possible points. The final grade will be based on the scale:
100 to 90% -- A
89 to 80% -- B
79 to 70% -- C
69 to 60% -- D
59% and below -- F
The instructor may change this scale to benefit the students.
  ^* Exam 3 will be held May 7^th 2pm-4pm for Period 6; May 6^th, 3pm-5pm for period 7

Late Work: Assignments are due at the BEGINNING of class on the due day. Assignments will be accepted upto ONE class day late with a penalty of 20%. Assignments will not be accepted after ONE day late.
Academic Integrity: All work in this class will be the sole effort of the individual student. Cheating in any form will be cause for failure of the course and may result in dismissal from the University.
Attendance: You are expected to attend every minute of every class session. If you miss a class or portion of a class it is your responsibility to determine what was missed.
There are no makeups given for exams or quizzes unless a valid documented absence is provided. Please note that the health center will not provide excuses. If you are seen at the health center, they will tell you if your illness necessitates missing class. With your permission, the health center will report their recommendation to me when I call.

Course Outcomes: This course and its outcomes support the Information Systems and Information Technology Learning Outcomes of Problem Solving and Critical Thinking (PS&CT), Communication and Interpersonal Skills (C&IS), and Ethical and Professional Responsibilities (E&PR). These Information Systems and Information Technology Learning Outcomes are tied directly to the University Wide Outcome of Critical Thinking and Problem Solving, Communication, and Values and Ethics.

Objectives	Strategies	Assessment Methods
The student will be able to: Identify the advantages and the disadvantages of database systems vis-à-vis file processing. [IS: PS&CT b, e; C&IS b; E&PR e | IT: PS&CT c, d; C&IS b; E&PR e] Use a graphical user interface to create/modify database structure. [IS: PS&CT b, c | IT: PS&CT a, b] Use database query language to create/modify the user data. [IS: PS&CT d; C&IS c | IT: PS&CT c; C&IS b] Design & develop database applications of moderate complexity from the user needs including menu-driven user interface for processing the database. [IS: PS&CT a, b, c; C&IS d | IT: PS&CT a, b, c; C&IS c] Identify the concerns prevalent in multi-user database processing. [IS: E&PR a, b | IT: E&PR b, d]	Together, the students and the professor will: Compare and contrast database processing with file processing. Discuss in detail the issues affecting database design. Investigate the semantics of popular database query languages. Study existing databases and database applications examining design and efficiency issues. Compare and contrast single-user with multi-user database processing. Discuss in detail the past, present, and future of database processing. Discuss in detail the hardware considerations in database processing.	The student will: Answer end-of-chapter exercises or questions presented in class by the instructor. Use a popular database query language to access data and database structure in a given database. Produce a database application from the design of the database to the implementation of the menu-driven application. Complete graded exams/ quizzes that assess information storage and retrieval skills and database processing fundamentals. Course-Embedded: PS&CT through assignments, homework and exams, C&IS through homework, database documentation, and exams, and E&PR at professor's discretion.