Analysis and Design of Database
Systems
Instructor
Instructors:
Dr. Victoria Yoon
Office Location: Snead Hall B4113
Phone:
804.828.0672
Email:
vyyoon@vcu.edu
Office Hours:
Tuesday
4:30pm – 6:30pm
Other times by appointment
Course Description:
The course is designed to prepare students for the development of information systems using databases and database management techniques.
Learning Outcomes:
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
Oracle.
• Understand physical storage levels.
• Understand basic concepts of indexes and how to select and create indexes.
• Understand concepts of transactions and concurrency control
Recommended Textbook:
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
Week
Dates
Topic
Reading
1
8/26
Course Introduction; EER Diagram
Slides, Ch 7
2
9/2
SQL part 1
Ch 3
3
9/9
SQL part 2
4
9/16
PL/SQL part 1
Ch 3, slides
Slides
5
9/23
PL/SQL part 2
Slides
6
9/30
Authorization & Triggers
Ch 4.6, Ch 5.3
7
10/7
XML
Ch 23, slides
8
10/14
Exam 1
9
10/21
XML Database
Ch 23, slides
10
10/28
Ch 23, slides
11
11/4
12
11/11
13
11/18
14
11/25
15
12/2
16
12/9
XML Database Storage;
Storage;
Indexing
Transactions
Concurrency Control;
Query Optimization
Project Discussion
Project Presentation
Project Presentation Slides Due at
7:00
Project Presentation
Project Report Due at 7:00pm
Exam 2
Ch 10.1 to 10.
Ch 11.1 to 11.3
Ch 14
Ch 15.1, 15.2
Ch 13.1
Note: The course schedule is designed as a guide only. If changes to the schedule occur, they will be announced in class.
Grading System:
Final grades will be based upon your performance evaluation in class participation, assignment, project, and two exams. Weights will be applied as follows:
Class Participation
Assignments
Project
Exam 1
Exam 2
10%
20%
20%
25%
25%
Class Participation
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
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.
Examinations
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.
Electronic Device(s)