CSCI 3720 Database Systems

 

Instructor:

Y. D. Liang, PhD
liang@armstrong.edu

Computer Science Dept

Lecture Sessions: MWF 8:00-8:50 SC 1503B
Textbook: Y. Daniel Liang
Database Application Development with Java and Oracle
Prentice Hall, 2006
 

Course Description 

This course is primarily concerned with developing database applications. This includes issues in representing data, collecting and representing information about data, E-R diagrams, functional dependencies, normal forms, SQL, and JDBC. Database projects will make extensive use of MySQL, Oracle, and Microsoft.

Goals 

The goals of the Database Systems are that students, by mastering the topics presented in this course, gain valuable skills in developing  Internet-based information systems using database systems and Java. 

Course Objectives 

Upon successful completion of Database Systems, students will be able to understand fundamentals of database systems, accessing and processing database using SQL, and developing database projects using MS Access database, Oracle database and Java. 

Prerequisites 

Java and Data Structures 

Tentative Schedules 

Session

Lecture topic

Reading Exercise

Slide

Week 1

Introducing database systems and getting started on using database systems

Chapter 1 Exercises ?

Chapter 1

Week 2 Relational data structures, and  integrity constraints Chapter 2 Exercises ? Chapter 2
Week 3  Relational algebra and relational calculus Chapter 2 Exercise ? Chapter 2
Week 4 ER modeling and translating ER diagrams to tables Chapter 3 Exercises ? Chapter 3

Week 5

Normalization theory

Chapter 3 Exercises ?

Chapter 3

Week 6

Review and exam 1

Part I Exercises ?

 

Week 7 JDBC Chapter 8  
Week 8 Advanced JDBC Chapter 9
Week 9 Servlets Chapter 10
Week 10 JSP Chapter 11

Week 11

Exams in the lab (servlets and JSP)

Part I Exercises ?

 

Week 12 SQL Chapter 4 Chapter 4

Week 13

Advanced SQL Chapter 5 Chapter 5

Week 14

Review and exam 3

Part I Exercises ?

 

Week 16

Review and Final Exam

 

 

 

Evaluation Scheme  

Evaluation is based on attendance, programming exercises, midterm exams, and final exam. Evaluation scheme is subject to change with a prior notice.

Programming assignments must be done individually.  Source file along with a disk must be submitted in the class on the due day regardless its status (complete or incomplete). No makeups will be offered except under extraordinary situations.

Exercises

25% (Due dates will be announced in the class. Must be submitted before the class, complete or incomplete. You may receive partial credits for incomplete projects.  No later submission can be accepted.)

Exams

40% (Exam 1: 15%, Exams on Servlets and JSP: 10%, and Exam 3 on SQL 15%)

Final Exam 35% (Comprehensive)

 

Grade

Points

A

>= 90.0

B >=80.0
C >=70.0
D >=60.0
F <60.0


Academic Honor Code

Programming assignments must be done individually. Failure to do so will result in a violation of the AASU Academic Honor Code. The following cases will be considered as violations: identical code, and extremely similar code. Violations will be reported to the Office of Vice President of Student Services.

Attendance Policy

Attendance is mandatory. Send me (liang@armstrong.edu) an email in advance if you have to miss a class. Please arrive at least 2 minutes before the class.

Class Picture

Craig Craven, Patrick Morgan, Chizoba Okeke, Justin Groseclose, Brad Bragg, Mark Stahl, Corey Ellis, Bryan Traywick, Sung Park, Jeff Costello, Scott White, Timmons Tunishe

Not Shown: Adam Hungerford