CS 364  Introduction  to  Database  Systems

  Introducing  ORACLE (Backend and Client) - Industry Standard

Database  Supplements

MS SQL Server,   MySQL

Syllabus

 

 
Course Links 

Students    Notes   Homework     Project   CASE Tool   KDnuggets  VisioLike

Course Description

The course provides the basic concepts of database systems, with a practical focus for undergraduate students.  It familiarizes students with relational database and SQL. At the conclusion of CS364,  students will be able to

  • organize, maintain and retrieve information from a relational database 
  • design a relational database (client-server app) observing system life cycle
  • integrate emerging Internet technologies in databases
  • apply  ORACLE software

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

Textbooks

Database  Systems by P. Rob and C. Carlos, 7th ed.,  Course Technology  2007

 

Acquire Oracle Certification !   OCP Oracle DBA certification boxed set by Couchman Jason  

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 %
  • Midterm Exam                                                 20 %  
  • Project / Presentation                                       30 %
  • Final Exam                                                       30 %

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.
  • 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.
  • The instructor may revise this syllabus as deemed necessary.
  • All misconducts will be forwarded to the Chair after the first warning.

 

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.)
Chapters   Lecture Topics  
Chapter   1   Introduction to Database Systems  
Chapter   2   Relational Database Model
Chapter   3   Entity-Relationship Model  
Chapter   4   Schema Refinement & Normalization  
Chapter   5   SQL: Queries, Programming, Triggers  
Chapter   6 Database Design
Chapter  7 Relational Algebra and Calculus
Chapter  8* File Organizations and Indexing - Tree  & Hash
Chapter Data Mining
Other Info

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

 Lecture Time: Tuesday & Thursday 3 - 4:15 PM  /  4:30 - 5:45 PM

Office Hours:  Tuesday  10:15 - 11:15 AM  & 2 - 3 PM

 

(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!