Kennesaw
|
||
DEPARTMENT OF COMPUTER
SCIENCE AND INFORMATION SYSTEMS
|
||
Spring 2008
|
||
|
CSIS 3310 -
Monday/Wednesday CSIS3310 |
||
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, 10th edition |
|
|
|
Bin number
QA76.9.D3.K7365 |
|
Other Resources
|
||
Instructor:
|
Dr. |
|
|
Office: |
Clendenin 3029 |
|
|
Email Address: |
||
|
Phone: |
770 420 4424 |
|
|
Office Hours: |
Monday/Wednesday 2:00-3:00 pm., 5:00-6:00 pm. |
|
|
Fax Number: |
770 423 6371 |
|
|
Website Address: |
||
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:
|
|
|
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, DB
Environments, Oracle 10g Express: download/Install,
Launch |
Chapter 1 |
|
2 |
01/14/08 01/16/08 |
Lab on SQL – Part I |
Chapter 2 |
|
3 |
01/21/08 01/23/08 |
MLK Day - No Class SQL - More
DDL & DML |
|
|
4 |
01/28/08 01/30/08 |
Lab on SQL – Part II SQL, Referential Integrity |
|
|
5 |
02/04/08 02/06/08 |
Lab MS-Access/VB, lab on MS-Access/Oracle Test # 1 - in class |
|
|
6 |
02/11/08 02/13/08 |
Chapter 3 Chapter 4 |
|
|
7 |
02/18/08 02/20/08 |
E-R
Diagrams |
Chapter 5 Chapter 5 |
|
8 |
02/25/08 02/27/08 |
Converting
ER Diagrams to Tables Converting ER Diagrams to Tables |
Chapter 6 Chapter 6 |
|
9 |
03/03/08 03/05/08 |
Spring Break Spring Break |
|
|
10 |
03/10/08 03/12/08 |
Review for Test, Hw. Questions Test # 2 |
|
|
11 |
03/17/08 03/19/08 |
Views,
Triggers, Stored Procedures, |ASU
examples Lab/Triggers |
Chapter 7 Chapter 7 |
|
12 |
03/24/08 03/26/08 |
Chapter 8 Chapter 9 |
|
|
13 |
03/31/08 04/02/08 |
Database Administration, Security |
Chapter 12 |
|
14 |
04/07/08 04/09/08 |
Lab on JDBC Overview of Connectivity |
Chapter 14 Ch. 12-14 |
|
15 |
04/14/08 04/16/08 |
Lab-Transfer Data & XML Datawarehouse |
Chapter 15 |
|
16 |
04/21/08 04/23/08 |
Presentations |
|
|
|
04/28/08 |
Presentations Final Exam (in class; covers all topics) 04/30/08 - 11:00 am - 3310/01 – 11:00am-1pm 05/05/08 -
3:30 pm – 3310/02 - 3:30-5:30 pm 05/05/08 -
6:30 pm – 3310/03 – 6:30-8:30 pm |
|
|
Special Dates: |
|
|
|
|
Holidays/No Class |
January 21, 2008 MLK, March 1-7 (SB) |
|
|
|
Last day to withdrawal without penalty |
March 10, 2008 |
|
|
Assessment:
|
|
||
Assignments and class participation (15%),
Exam #1 (15%), Exam #2 (15%), Exam #3 (10%)
Final
Exam (25%), Project (20%)
|
|
|
|
|
ASSIGNMENTS All
homework is posted and delivered through Moodle. in the assignments folder. 10 Points will be taken off for
each late day (unless explicitly specified otherwise). Basically
all the assignments have already been posted. One or two additional
assignments may be posted during the course. Make sure you put your name on
any attachment you submit through moodle. Homework problems assigned throughout the term. Homework and Labs may be done in groups of two. If you choose a group of two, turn in one copy only with both names !! |
|
|
EXAMS 3 exams and a Final Exam is cumulative. First exam focuses on SQL. Second exam on Database Design. Third Exam focuses on advanced topics. Third exam is a take home that will be answered on Moodle. First two exams will be in class and you will be allowed one sheet of notes (front and back). No sharing notes. Final, you will be allowed two sheets of notes, front and back. Final is cumulative. No new material will be given on the final. Final will be based on the three tests and assignments. Sample tests from previous semesters are posted on the web-site. |
|
|
PROJECT A team project due on the day of the final exam. You will work in groups of approximately 4 students to complete the project. 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%. All your project deliverables (as well as examples) are posted at the course web-site at http://science.kennesaw.edu/~mguimara/3310/ProjectDeliverables.htm. All intermediate deliverables as well as the final project deliverables will be submitted through Moodle discussion group. The Discussion groups will be 1) Project Summary, 2) Project - E-R Diagram, 3) Project - Relational Schema and DD, 4) Project - Forms and CRUD, 5) Project - Final Deliverables. Final Deliverables will include all intermediate deliverables with modifications (if applicable). 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. Every project should have a sponsor (client). The sponsor can be the class instructor, another faculty member, an employer, etc. 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:
Summer Research Opportunity - http://www.nsf.gov/crssprgm/reu/reu_search.cfm
Brazil study abroad – http://brazil.kennesaw.edu/
Acm.kennesaw.edu
www.acm.org
Wit.kennesaw.edu