Fall 2006
CINS 5143.001
Advanced
Database Management Systems
Instructor
Name: Dr. Y. Alp Aslandogan
Email: aslandogan@sbcglobal.net
Web: http://www.lifeglass.org/PVAMU/CINS5143
Office:
Phone: (936) 857-2715
Mobile: (682) 365-2279
Office Hours:
Tuesdays
Thursdays
Class Meetings:
Wednesdays, 2:00-4:50 pm in room 226 SR Collins.
Textbook
Connolly, T. and Begg, C., Database Systems: A Practical Approach to Design, Implementation, and Management, 4th Edition, Addison Wesley, ISBN 0321210255.
Course Objective
This is an advanced course of database management systems emphasizing on both theoretical knowledge and practical skills of database design, database languages and database implementation.
Prerequisite
COMP 4953: Database Management or CINS 5033: Database Management Systems, and consent of the instructor.
Attendance
Attendance is expected and required. Students are responsible for materials missed during an absence, whether excused or not. Without regular attendance, students may not be able to complete the assignments and pass the exams. Classes will start and end at the prescribed time. Excessive absences or tardiness will result in lowered grades. The class roll will be called at the beginning of class after that no late additions will be made.
Course Outline
Chapter 1 Introduction to Databases
Chapter 3 The Relational Model
Chapter 4 Relational Algebra and Relational Calculus
Chapter 5 SQL: Data Manipulation
Chapter 6 SQL: Data Definition
Chapter 11 Entity-Relationship Modeling
Chapter 12 Enhanced Entity-Relationship Modeling
Chapter 13 Normalization
Chapter 14 Advanced Normalization
Chapter 26 Object-Oriented DBMSs - Concepts
Chapter 27 Object-Oriented DBMSs – Standards and Systems
Programming Environment
A relational database management system (such as MS Access, Oracle, SQL Server or MySql) is required to implement the term project and other in-class exercises.
Examinations
The midterm is scheduled on Wednesday, October 4th and the final exam during the final week. All examinations are in-class and closed-book. It’s the student’s responsibility to solve any schedule conflict. No makeup exam will be given, unless the instructor is informed in advance of a university-approved absence.
Group Project
Students are required to form a group of two to build a real or hypothetical database management system and present the system in the last two weeks of the semester.
Grading
The breakdowns of overall grade are:
Attendance (10%)
Project (20%)
Midterm Examination (35%)
Final Examination (35%)
The overall grading scales as described in the university catalog are:
90 – 100 A
80 – 89 B
70 – 79 C
60 – 69 D
0 – 59 F
Student Academic Appeal Process
Authority and responsibility for assigning grades to students rests with the faculty. However, in those instances where students believe that miscommunication, error, or unfairness of any kind may have adversely affected the instructor’s assessment of their academic performance, the student has a right to appeal by the procedure listed in the Undergraduate Catalog and by doing so within thirty days of receiving the grade or experiencing any other problematic academic event that prompted the complaint.
Americans with Disability Act (
Students with disabilities, who believe they may need an academic adjustment in this class, are encouraged to contact the Office for Students with Disabilities at (936-857-2693) as soon as possible to better ensure receipt of timely adjustments. Once you receive a letter from the office for Disability Service, kindly make an appointment to discuss appropriate academic adjustments for this class.
Definition of Cheating and Plagiarism
Prairie view