CS3310 Database Systems
M
8:00pm – 10:45 pm
Clendenin Building Room 2008
Fall 2009 Syllabus
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. The objective of this course is 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.. |
|
Prerequisites:
|
CS2301 w/ a C or better. |
|
Main Textbook
|
Kroenke, David M., Database Concepts 3rd edition [ISBN 0131986251] |
|
Other Resources
|
1) http://adbc.kennesaw.edu/, 2) http://www.w3schools.com/ 3) http://www.eas.asu.edu/~advdb/ 4) http://www.eas.asu.edu/~winrdbi/ |
|
Instructor:
|
Dr. Mario Guimaraes |
|
|
Office: |
Clendenin 3029 |
|
|
Email Address: |
|
|
|
Skype id: |
marioamg931 - go to www.skype.com and download a free copy |
|
|
Phone: |
770 420 4424 (no messages) |
|
|
Office Hours: |
M-W 5:00 pm. – 6:30 pm. or Skype and e-mail or by appointment |
|
|
Fax Number: |
770 423 6371 |
|
Learning Outcomes:
|
Upon completion of this course, students should be able to: - Describe and discuss the role of data and information in
society - Model data relevant to a database task, given a written
description, reports and other information from a system user. Results should
represented as an EntityRelationship
Diagram. - Transform the entity relationship model into a logical
design, following the relational approach - Normalize a given set of tables to third normal form. - Compose working SQL statements for simple and intermediate
queries. - Build and modify a database schema using SQL. - Insert and modify data using SQL. - Define locking techniques used to control the consequences of
concurrent data access - Name and describe common database security issues and identify
ways to address potential database security vulnerabilities. - State ethical guidelines for data collection for database
projects. - Using a programming language, such as Java, construct a set of simple
input forms and output reports which connects to a database system |
|
Policies:
|
Delivery work: All assignments, project deliverables, etc. should be turned in through csmoodle. Hard copies or e-mailed copies are not accepted. If moodle is down or your assignment is too large to include as an attachment, e-mail me and I will make the necessary changes. Do NOT e-mail me attachments. Communication with professor: the best way to reach me fast is to send me an e-mail or skype. You can phone me through skype at any time. The first time connecting to skype, please identify yourself as being a csis3310 student. Skype is totally free and you can download it at www.skype.com |
|
Withdrawal: |
The last day to withdrawal without academic penalty is October 12, 2009. 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. |
Assessment:
|
|
|
Homework (10%) |
Homework problems assigned throughout the term. Homework grade will be binary: 5 (completed the assignment with 100% effort), 2 (partially completed), 0 (incomplete). Homework can be discussed with your colleagues, but should be turned in individually. Concepts of homework will frequently appear on the tests. No homework may be turned in after the solutions are posted. |
|
Class Participation (10%) |
This is a subjective component. It includes participation in labs, in class and in discussion groups. |
|
Exams (30 %) |
3 exams, 10 points each. |
|
Project (25%) |
Projects teams can include up to four members. The goal of the project is to design, model and implement a small but real-world database scenario. Project criteria will be posted on Moodle. |
Final Exam (25%)
A
tentative course schedule is below. The schedule is subject to change during
the semester.
|
Weeks |
|
|
|
|
1 |
08/17/09 |
Introduction
to Databases, DB
Environments,
Oracle 10g Express: download/Install, Launch |
Chapter
1 |
|
|
|
Data
Modeling and the ER Diagram |
Chapter
4 |
|
2 |
08/24/09 |
ER
Diagrams |
Chapter
4 |
|
|
|
Transforming
Data Models into Database Design |
Chapter
5 |
|
3 |
08/31/09 |
Transforming
Data Models into Database Design |
Chapter
5 |
|
|
|
Relational
Model and Normalization |
Chapter
2 |
|
4 |
09/07/09 |
Labor
Day – no classes |
|
|
|
|
Relational
Model and Normalization |
Chapter
2 |
|
5 |
09/14/09 |
Exam
# 1 |
|
|
|
|
Simple
Queries – Using one table |
Chapter
3 |
|
6 |
09/21/09 |
Simple
Queries using multiple tables (joins) |
Chapter
3 |
|
|
|
Creating
and Using views (queries) |
Chapter
3 |
|
7 |
09/28/09 |
DDL
and DML constraints |
Chapter
3 |
|
|
|
DDL
and DML constraints |
Chapter
3 |
|
8 |
10/05/09 |
Exam
# 2 |
|
|
|
|
Data
Connectivity (ODBC, OLE-DB, ADO and JDBC) |
Chapter
7 |
|
9 |
10/12/09 |
Triggers
and Stored Procedures |
Chapter
7 |
|
|
|
Triggers
and Stored Procedures |
Chapter
7 |
|
10 |
10/19/09 |
Multiuser
Database |
Chapter
6 |
|
|
|
Database
Administration |
Chapter
6 |
|
11 |
10/26/09 |
Database
Security |
Chapter
7 |
|
|
|
Database
Security |
Chapter
7 |
|
12 |
11/02/09 |
Exam
# 3 (take home) |
|
|
|
|
|
|
|
13 |
11/09/09 |
Project
Work Day |
|
|
|
|
|
|
|
14 |
11/16/09 |
Ethics
in Data Collection |
|
|
|
|
|
|
|
15 |
11/23/09 |
Prepare
for Final & Presentations |
|
|
|
|
|
|
|
16 |
11/30/09 |
Presentations
|
|
|
|
12/02/09 |
Presentations |
|
|
|
12/07/09 |
Final
Exam (comprehensive) 9-11pm. |
|