Analysis and Design of Database
Dr. Victoria Yoon
Office Location: Snead Hall B4113
4:30pm – 6:30pm
Other times by appointment
The course is designed to prepare students for the development of information systems using databases and database management techniques.
Upon successful completion of the course the student will:
• Be able to write advanced SQL statements
• Be able to write sophisticated PL/SQL programs with loops, cursors, procedures, etc.
• Know how to define triggers.
• Learn how to use grant and revoke statements.
• Understand basic concepts of XML and know how to develop XML database using
• Understand physical storage levels.
• Understand basic concepts of indexes and how to select and create indexes.
• Understand concepts of transactions and concurrency control
A. Silberschatz, H. Korth, S. Sudarsan, Database System Concepts, 6th Edition, McGraw
Hill, 2011. ISBN 978-0-07-352332-3.
Page 1 of 6
Tentative Course Schedule
Course Introduction; EER Diagram
Slides, Ch 7
SQL part 1
SQL part 2
PL/SQL part 1
Ch 3, slides
PL/SQL part 2
Authorization & Triggers
Ch 4.6, Ch 5.3
Ch 23, slides
Ch 23, slides
Ch 23, slides
XML Database Storage;
Project Presentation Slides Due at
Project Report Due at 7:00pm
Ch 10.1 to 10.
Ch 11.1 to 11.3
Ch 15.1, 15.2
Note: The course schedule is designed as a guide only. If changes to the schedule occur, they will be announced in class.
Final grades will be based upon your performance evaluation in class participation, assignment, project, and two exams. Weights will be applied as follows:
Students are expected to actively participate in the class discussion. The performance of a student’s class participation will be evaluated and incorporated into the student’s final grade.
Homework must be done individually unless otherwise specified. It will consist primarily of written and design problems. Homework is designed to simulate a real-world environment.
Homework will normally be due in the beginning of the class on the due date. You must submit your code and its answers. You are encouraged to use a text editor (e.g., notepad++ or
TextPad) to write your code. Otherwise your handwriting must be clear and clean. Late homework will not be accepted unless the instructor grants prior permission. It is advisable to put a significant amount of effort into homework because it will help you in your project and exams as well.
There will be two exams. Both exams will be in-class, closed book. Exams may include short answer questions and working with the database concepts. Any missed exams will result in a grade of 0. Makeup exams will not be administered except in the case of extreme emergency.
If you miss an exam because of an extreme emergency, notify me in advance. If I agree that your emergency was, indeed, extreme, and it can be documented, a make-up exam will be given. Project
There will a project giving you the opportunity to apply your new knowledge to a real problem. The detailed description of the project will be distributed in class.