COMP 5120/6120: Database Systems I
|
|
|
Instructor: |
Dr. Wei-Shinn Ku |
|
|
|
|
Office Hours: |
Mon 4pm - 5pm, others by appointment. |
|
|
|
|
Place and Time: |
Shelby Center 1122, 3:30 pm – 4:45 pm, Tue, Thu. |
|
|
|
|
Description: |
As the first introductory course for databases, this course studies theoretical and applied issues related to the analysis, design, and implementation of relational database systems. |
|
|
|
|
Prerequisite: |
Comp 3270 or department approval. |
|
|
|
|
Text: |
Ramakrishnan and Johannes Gehrke, Database Management Systems,
Third Edition, McGraw Hill (main textbook) |
|
|
|
|
TA: |
Mr. Guangyu Zou, Shelby Center 3133, Office hours: Tue, Thu 2 pm – 3pm |
|
|
|
|
Grading: |
Assignments: 10% (3 assignments) Policies: When grades are emailed to you for assignments, you have 7 days to meet with the TA for grade changes. After 7 days, the grades are written in stone and can't be changed after that point. Due date/time will be strictly enforced. The TA will collect the submissions after the due day class. No work will be accepted after this collection. |
|
|
|
|
Participation: |
It is required that you attend class on a regular basis. Class participation is very important to the organization of the course. Exams will be based upon assignments and class discussions. |
|
|
|
|
Disabilities: |
Students who need accommodations are asked to arrange a
meeting during office hours the first week of classes, or as soon as possible
if accommodations are needed immediately. If you have a conflict with my
office hours, an alternate time can be arranged. To set up this meeting,
please contact me by E-mail. Bring a copy of your Accommodation Memo
and an Instructor Verification Form to the meeting. If you do not have an
Accommodation Memo but need accommodations, make an appointment with The
Program for Students with Disabilities, 1244 |
|
Week |
Topics |
|
1. |
Course Introduction |
|
2. |
Database System Overview and Database Design |
|
3. |
ER Model |
|
4. |
Relational
Model |
|
5. |
Relational Algebra |
|
6. |
SQL: Queries, Constraints, Triggers |
|
7. |
Project Introduction |
|
8. |
SQL: Queries, Constraints, Triggers |
|
9. |
Exam 1 (Oct 13) |
|
10. |
|
|
11. |
Disks and Files |
|
12. |
No Class (attending ACM GIS 2011) |
|
13. |
Tree-Structured Indexing |
|
14. |
Hash-Based Indexing |
|
15. |
Thanksgiving Break |
|
16. |
Exam 2 (Dec 1) |