CSCI 4710
Databases
Course
Syllabus, Fall 2010
PROFESSOR
INFORMATION
Name:
Dr.
Yao
Office:
Atk 317
Telephone: (478) 445-5483
Email:
jf.yao@gcsu.edu
URL:
http://abacus2.gcsu.edu
Office Hours: 8:20a.m.--9:20a.m.,
10:50a.m.-12:20p.m. on Tu. and Th. or by appointments
CLASSROOM AND LAB: A&S 143
REQUIRED TEXT: Database Systems, by Thomas Connolly and Carolyn Begg
Oracle 10g Programming, by Rajshekhar Sunderraman
REQUIRED TEXT: C or above in CSCI 3410 - Data Structures
COURSE DESCRIPTION :
An introduction to basic concepts, design techniques, and
theories in database management systems. The primary emphasis is on
the relational database management systems. The goal is for students
to be able to design and maintain a relational database management
system as a DBA after taking this course. (back to
top)
EXPECTED COURSE OUTCOME:
Students will become acquainted with basic principles, structure, and functions of database management systems.
Students will be able to use SQL comfortably.
Students will be able to develop a relational database system.
Students will be able to refine schema and to tune a DBMS
Students will be able to create and modify storage structures and access methods
GRADING CRITERIA:
Students learning will be assessed primarily through participation in programming homework, written homework, written responses to tests, and a cumulative final exam.
A-level work will meet the following criteria:
A demonstrated proficiency and mastery in basic principles, structure, and functions of database management systems
A demonstrated proficiency and mastery in developing and modifying a database management system with the basic features of a database management system learned in the course
A demonstrated proficiency and mastery in using SQL
Attend class regularly, complete homework assignments in time, and actively participate in classroom activities
Demonstrate an understanding of the applications problems studied in the course
Exceptional performance on all tests, and the cumulative final examination
GRADE
DISTRIBUTION:
Percentage
Date
Exam I
25%
Sept. 16, 2010
Exam II
25%
Oct. 28, 2010
Final Exam 25%
Dec. 9, 2010, Th (8:00a.m.-10:45a.m.)
Projects
25%
-------------------------------------------------------------------------
Total
100%
FINAL
GRADES:
Grade
Percentage
A
90% and up
B
80% - 89.99%
C
70% - 79.99%
D
60% - 69.99%
F
59.99% or less
COURSE POLICY:
You are expected to read the textbook prior to and after each class.
Class and lab participation is essential in learning computer technology. It is your responsibility to attend the class/lab in order to achieve good learning, therefore obtain a good grade.
You must NOT miss an exam unless you have a verifiable written excuse. An unexcused absence from an exam will result in a numerical grade of zero for that exam.
The homework material will be included in the exams. Therefore, doing the homework assignments by yourself is essential in obtaining a good score in an exam.
Late assignments will be penalized 10% per day after the assignment due date.
Prior to mid-semester, you will receive feedback on your academic performance in this course. Your overall grades are updated on a regular basis on WebCT throughout the semester.
ACADEMIC HONESTY:
The integrity of students is a critical component of the academic process. All written work submitted in this course must be individual work unless the instructor assigns a team of students to work on an assignment. Students must properly document all outside sources used for projects, programs, and homework. The submission of another’s work as one’s own is plagiarism, and will be dealt with using the procedures outlined on the Undergraduate Catalog.
TENTATIVE COURSE OUTLINE:
WEEK TOPICS
=============================================================
1
Introduction to Databases(Ch. 1 & 2)
2
The Relational Model (Ch. 4)
3 Relational Algebra and Relational Calculus (Ch. 5)
4 SQL: Data Manipulation & Data Definition (ch. 6 and 7)
5 Advanced SQL (Ch. 8)
6 Query-By-Example [QBE] (Ch. 9)
7 Schema Refinement and Normal Forms (Ch. 14)
8 Advanced Normalization (Ch. 15)
9 Conceptual Database Design (Ch. 16)
10 Logical Database Design for the Relational Model (Ch. 17)
11 Oracle SQL
12 Oracle SQL
13 PL/SQL
14 PL/SQL
15 Web Programming with PL/SQL
16 Web Programming with PL/SQL
(Last Day of Classes: Dec. 6, 2010)
Labor Day Holiday (Sept. 6,
2010)
Fall Break (Oct. 11-12, 2010)
Thanksgiving Holidays (Nov.
24-26, 2010)
OCTOBER 14, 2010 IS THE LAST DAY TO WITHDRAW A COURSE WITHOUT ACADEMIC PENALTY.
In the event of a fire alarm signal students will exit the building in a quick and orderly manner through the nearest hallway exit. Learn the floor plan and exits of this building. Do not use elevators. Crawl on the floor if you encounter heavy smoke. Assist disabled persons and others if possible without endangering your own life. Assemble for a head count on front lawn of main campus.