CIS 240

PCC > Academics > Areas of Study > Business & Technology > Technology > Computer Information Systems > Syllabi > CIS 240

COURSE SYLLABUS

1.	TITLE OF COURSE:	Database Design and Development
	PREFIX/NUMBER:	CIS 240	CREDIT HOURS:	3
2.	PREREQUISITE:	None

3.	RESOURCES NEEDED:
	TEXT:
	SUPPLIES:
4.	COURSE DESCRIPTION: Introduces the basic concepts of relational databases, data storage, and retrieval. Covers database design, data modeling, transaction processing, and introduces the Structured Query Language for databases.
5.	COURSE GOAL:

COURSE OBJECTIVES:

To demonstrate specific knowledge of the following:

(A)
(B)

(C)

(D)
(E)
(F)

The student will gain a working knowledge of Relational Database Systems.
The student will be able to effectively apply design tools to the design of a relational database.
The student will be able to properly execute queries to retrieve information from a relational database.
The student will be able to place database tables in the first three normal forms.
The student will be able to implement concurrency control in a relational database.
The student will be able to create a backup plan for a relational database.

EVALUATION PROCEDURES:
	Attendance and Quizzes	10%
	Marketing Projects	40%
	Tests	50%
	Grading Scale Raw Score Range	Letter Grade
	90 to 100	A
	80 to 89	B
	70 to 79	C
	60 to 69	D
	0 to 59	F

Special Remarks:
1.	Attendance: College policy states that students may be dropped from enrollment when absent 20% of the scheduled class meetings. If enrolled from the beginning of the term, 9 hours will usually constitute 20% of a three-credit semester course. Reinstatement procedures are described in the PCC catalog.
2.	Tardy Policy: A student who is late three times (enters classroom after the instructor has taken roll) will be charged with one full absence unless he/she can provide valid reasons for one or more of these tardies.
3.	Assignments/Missed Exams: It is the student's responsibility, whether present or absent, to obtain all material presented and to complete all course assignments. If prior arrangements are made or extenuating circumstances exist, makeup of tests may be allowed. Late homework papers will not be accepted unless those same extenuating circumstances exist.

COURSE OUTLINE

(I).

(II).

(III).

(IV).

(V).

(VI).

(VII).

(VIII).

Introduction to Relational Databases

Entity Relationship Modeling

Database Table Design

Table Normalization

Basic SQL code

Queries

Transaction Processing

Database Backup and Recovery

10.	METHODS OF INSTRUCTION:
	To be successful in this course, students are expected to participate in discussions, readings, in-class writing, and peer review activities. The instructor may assign point values to such activities.
11.	ACADEMIC INTEGRITY:
	The very nature of higher education requires that students adhere to accepted standards of academic integrity. Therefore, Pueblo Community College has adopted a policy of academic conduct as described in the Student Handbook. Violation of academic integrity may be defined to include the following: cheating, plagiarism, falsification and fabrication, abuse of academic materials, complicity in academic dishonesty, and personal misrepresentation. It is the student’s responsibility to be aware of the behaviors that constitute academic dishonesty. Sanctions for violating the standards of academic integrity may include warning, probation, suspension, and/or failure of the course or assignment at the discretion of the instructor.
12.	ADA NOTICE:
	Students who have a documented disability may be eligible to receive accommodations for this class. Please contact the Disability Resources Center at 549-3446 for further information.