Kennesaw State University
DEPARTMENT OF COMPUTER SCIENCE AND INFORMATION SYSTEMS
Spring 2008 (CL2005)
CSIS 3310 - Monday/Wednesday CSIS3310/03  6:30pm-7:45pm
Course Description:	Introduction to the database management systems, database processing, data modeling, database design, development, and implementation. Contrasts alternative modeling approaches. Includes implementation of current DBMS tools and SQL.
Prerequisites:	CSIS2301 w/ a C or better
Textbook:	Kroenke, David M., Database Processing, 10^th edition
Course Materials	Bin number QA76.9.D3.K7365 http://csmoodle.kennesaw.edu/
Other Resources	http://coffee.kennesaw.edu/
Instructor:	Dr. Ying Xie
Office:	Clendenin 3019
Email Address:	yxie2@kennesaw.edu
Phone:	(678)797-2143
Office Hours:	Monday/Wednesday 3:00-6:00 pm.
Fax Number:	770 423 6371
Website Address:	http://science.kennesaw.edu/~yxie2
Course Objectives:	To introduce students to current modeling, design and implementation methods for database systems, as well as to practical experience with at least one database product.
Learning Outcomes:	Upon completion of this course, students should be able to: Model data relevant to a database task, given written description, reports and other information from a systems user.  Results should represented as an Entity-relationship Diagram. Transform entity-relationship model into a logical design, following the relational approach. . Assess aspects of the physical design, and transform the logical design accordingly. Compose SQL statements for simple and intermediate queries against a database. Build and modify a database schema using SQL. Insert and modify data using SQL. Transfer data between different DBMSs and Insert data using batch processing. Gain basic concepts of Database Administration (security, recovery, performance, concurrency) Gain basic understanding of Client-Server Environments and Internet Database Environments Awareness of  ethical guidelines for data collection to database projects. Apply team/project concepts, as well as database concepts, to a small but realistic database problem. Improve oral, written, and graphical communication skills.
Policies: Attendance and Format for Deliverables
Class attendance: Regular attendance is required and expected. If you miss class, you are responsible for the work given in class as well as communicating with your project group member(s).
Withdrawal Policy:
The last day to withdrawal without academic penalty is March 10, 2008.  Ceasing to attend class or oral notice thereof DOES NOT constitute official withdrawal and will result in the rendering of a grade of  ‘F’ for the class.  Students wishing to withdrawal after the scheduled change period (add/drop) must obtain and complete a withdrawal form from the Academic Services Department in the Registrar’s Office.

Enrollment  Policy:

Only those students who are enrolled in the class may attend lectures, receive assignments, take quizzes and exams, and receive a grade in the class.  If a student is administratively withdrawn from this course, they will not be permitted to attend class nor will they receive any grade for the class.

Electronic Devices

In order to minimize the level of distraction, all beepers and cellular phones must be on quiet mode during class meeting times. Students who wish to use a computer/PDA for note taking need prior approval of the instructor since key clicks and other noises can distract other students. Recording of lectures by any method requires prior approval of the instructor.

Tentative Course Schedule: Subject to change
Week	Date	Topic	Chapter
1	01/07/08 01/09/08	Introduction to Database SQL Queries and Relational Algebra  Part 1	Chapter 1 Chapter 2
2	01/14/08 01/16/08	SQL Queries and Relational Algebra  Part 2 SQL Queries and Relational Algebra Part 3	Chapter 2 Chapter 2
3	01/21/08 01/23/08	MLK Day - No Class Relational Model	Chapter 3
4	01/28/08 01/30/08	Database Redesign ER Diagram	Chapter 4 Chapter 5
5	02/04/08 02/06/08	ER Modeling 1 ER Modeling 2	Chapter 5 Chapter 5
6	02/11/08 02/13/08	ER Modeling 3 Review for first test	Chapter 5
7	02/18/08 02/20/08	Test 1 Test 1 Discussion
8	02/25/08 02/27/08	Converting ER Diagrams to Tables Converting ER Diagrams to Tables	Chapter 6 Chapter 6
9	03/01/08 03/07/08	Spring Break – No Class
10	03/10/08 03/12/08	First Presentation on Course Project Converting ER Diagrams to Tables	Chapter 6
11	03/17.08 03/19/08	One-on-One help session Database Implementation	Chapter 7
12	03/24/08 03/26/08	Database Implementation Database Implementation lab	Chapter 7 Chapter 7
13	03/31/08 04/02/08	Database Implementation Second test review	Chapter 7 Chapter 6/7
14	04/07/08 04/09/08	Second test Database Application Development (java)	Chapter 6/7
15	04/14/08 04/16/08	Database Application Development (ACCESS) Database Application Development (NETBEANS); SQL Server Management
16		FINAL REVIEW
	Monday, May 5 6:30pm-8:30pm	FINALL EXAM
	TBD	TBD
Week	Date	Topic	Chapter

Special Dates:
Last day to withdrawal without penalty	March 10, 2008
Holidays/No Class Spring Break	January  21, 2008 March 1-7, 2008
Assessment:

Assignments and class participation (15%),

Exam #1 (15%), Exam #2 (15%), Exam #3 (10%)

Final Exam (25%),  Project (20%)

ASSIGNMENTS

Homework is posted on csmoodle. 10 Points will be taken off for each late day (unless explicitly specified otherwise). 

EXAMS

We have 3 exams and Final Exam. The final exam is cumulative. First two exams will be in class and are open book and open notes. Third exam is a take home that will be answered on csmoodle. Final is cumulative. It is open book and open notes. No new material will be given on the final. Final will be based on the three tests and assignments.

PROJECT

A team project due on the day of the final exam. You will work in groups of approximately 2-3 students, exceptionally 4 students, to complete the project. If you like, you can also work on your own.

Your project grade will be composed of   1) Final Deliverables 60%, 2) Intermediate Deliverables 10%, 3) Oral Presentation graded by class 10%, 4) Peer Evaluation from Group Members 20%.

The project consists of designing and implementing a Database using a DBMS. Students may suggest their own projects as well as select their own DBMS, and I can provide suggestions if needed. Examples of projects include a multi-store inventory system, a database system for a car dealer, a database that receives and analyzes evaluations of a specific product.

To receive a score in the "A" range, both the presentation and the written report must together be considered by the professor to be "good enough for the real world." A score in the "B" range will be assigned to presentations and reports that have minor problems, such as the need for clarification in a statement of problem. Lower scores will be assigned to reports and presentations which have problems that are not so minor, such as an inability of the group to adequately clarify a statement of problem during questions associated with the presentation.

Interesting links:

Cias.kennesaw.edu

Acm.kennesaw.edu

www.acm.org

Wit.kennesaw.edu

Career Service Center - Kennesaw Hall 2435, Pauline Jones

Summer Research Opportunity - http://www.nsf.gov/crssprgm/reu/reu_search.cfm