ACS 565  Database Design

 

Introducing  ORACLE (Backend, Application Server and Client)  - Industry Standard

Database   Supplements

MS SQL Server,   MySQL

Syllabus

 
Course Links 

Students     Notes      Homework     Publication    Project    CASE Tool   KDnuggets

Course Description

ACS575 is a graduate-level course in database systems that builds upon CS364. It emphasizes implementation issues and DBMS architecture with  focus on advanced topics such as transactions and concurrency, object-oriented databases, security, data warehousing and mining, query optimization, distributed, deductive, client/server and knowledge databases. It also surveys emerging database technologies.  At the conclusion of ACS575,  students will be able to

  • create a simplified single-user relational database system with layers.
  • create integrated database application in a three-tier architecture (industry standard).
  • use emerging Internet and object-oriented technologies in databases.
  • apply  ORACLE software effectively.

Students are allowed to use any client software to interface Oracle database (web-/ non-enabled ).

Textbooks

Database Management Systems by R. Ramakrishnan and J. Gehrke, 3rd ed., McGraw-Hill 

 
Grading

The grading scale for all assignments and examinations is as follows:

  • A          90 - 100 %
  • B          80 -  89 %
  • C          70 - 79 %
  • D          60 - 69 %
  • F           0  - 59 %

Final grades will be based on 5 components as weighted below:

  • Attendance/Homework                                     20 %
  • Paper                                                               15 %   
  • Project / Presentation                                        25 %
  • Midterm                                                           15 %
  • Final Exam                                                       25 %

Any component submitted after the due date earns automatic 30 % deduction. To get a passing grade all components must be done or an incomplete grade will be awarded.

Miscellaneous Policies / Responsibilities
  • Students are expected to come to class prepared (have textbook and have read required assignments), and submit homework on time avoid penalty. If a student is not able to attend class, student should contact the instructor prior to class (Only 3 excused absences allowed).
  • Projects will be executed in groups or teams. Other activities must be done individually to avoid penalty. Make-ups and incompletes are not encouraged and can only be granted for rare cases. Avoid submitting virus-infested disks or a score of zero will be awarded.
  • All misconducts will be forwarded to the Chair after the first warning.
  • The instructor may revise this syllabus as deemed necessary.

 

American With Disabilities Act

Any student whose disability falls within ADA guidelines and who is registered with the Adaptive Needs Program should inform the instructor during the first week of class of any special needs or equipment necessary to fulfill the requirements of this course. Students who have or may be dealing with a disability should speak with the disability office (260-481-6657).

 

 
Course Content:   (Warm and interactive lecture with demonstration.)
  Lecture Topics  
1 Query Processing and Optimization
2 Transaction Processing Concepts
3 Concurrency Control Techniques
4 Database Recovery Techniques
5 Database Security and Authorization
6 Distributed Databases and Client-Server Architecture
7 Deductive Databases
8 Data Warehousing and Data Mining
9 Object-Oriented Databases
10 Emerging Database Technologies and Applications
Other Info

 Instructor Dr. E. Udoh,  Phone 260-481-6946,   Room  ET 125P,   Email udohe@ipfw.edu,   

 Lecture Time  

Office Hours:   

(Students are required to adhere to these times or send me an email). 

* This course is designed with the interest of the student at heart. Get involved, no student can afford to be a spectator in computer science!