COMP 521 Fall 2011
Introduction to Databases

ANNOUNCEMENTS
  • December 5th: The final exam is moved to FB007.
  • October 25th: I will return your midterm tomorrow morning in class. If you wish to improve your score, please turn in a revised solution TOGETHER with your original midterm paper to my office AND email me the list of questions you want me to re-grade by 9AM Thursday Oct 27th. A correct answer will earn you up to 50% extra points. For example, if you got 20 points (out of a total of 30 points) for Q1 and turn in a correct ER diagram by the deadline, you'll get (30-20)*0.5 = 5 extra points.
  • October 16th: The midterm on Oct 17th will be open book/notes and close computer/PDA/phone. No material sharing between students is allowed.
  • October 5th: The final exam is scheduled to be at 4PM Friday December 9th in SN 011.
  • October 5th: The due time for Homework #2 is extended to Oct 10 5PM EDT in my office. There is a 10% bonus if you hand in by 9:30AM in class.
  • September 14th: Homework late policy: All homeworks are due at the begining of the lecture of the due day. Late submissions are accepted until the midnight of the due day subject to 50% panelty.
  • August 24th: The class will be held in SN 011.

    • Credit Hours: 3
    Location: SN 011
    Time: MW 9:30-10:45AM
    URL: http://www.cs.unc.edu/Courses/comp521-f11
    Instructor: Wei Wang
    Office: SN 316
    Email: weiwang@cs.unc.edu
    Voice: 1 (919) 962-1744
    Office Hour: Wednesday 10:45AM-noon
    TA: TBD
    Office:
    Email:
    Voice:
    Office Hour:
    Prerequisite: COMP 410 and 411 and MATH 381

    Textbook: Database Management Systems, by Ramakrishman and Gehrke, 3rd edition, McGraw Hill.

    Schedule

    DATE LECTURE NOTES READING HOMEWORK
    Aug. 24 Introduction [PDF] Chapter 1
    Aug. 29 The Entity-Relationship (ER) Model [PDF] Chapter 2
    Aug. 31 The Relational Model [PDF] Chapter 3 Homework #1
    Sept. 5 Labor Day!
    Sept. 7 The Relational Algebra [PDF] Chapter 4.1-4.2
    Sept. 12 The Relational Calculus [PDF] Chapter 4.3-4.5
    Sept. 14 SQL: Queries, Constraints, Triggers (Part 1) [PDF] Chapter 5.1-5.4
    Sept. 19 no class
    Sept. 21 no class
    Sept. 26 SQL: Queries, Constraints, Triggers (Part 2) [PDF] Chapter 5.5-5.10 Homework #1 due in class
    Sept. 28 Overview of Storage and Indexing [PDF] Chapter 8 Homework #2
    Oct. 3 Storing Data: Disks and Files [PDF] Chapter 9
    Oct. 5 Tree Structured Indexes [PDF] Chapter 10
    Oct. 10 Hash-based Indexes [PDF] Chapter 11 Homework #2 due in class
    Oct. 12 University Day!
    Oct. 17 Midterm 1 (Chapters 1-5, 8-11)
    Oct. 19 no class
    Oct. 24 Overview of Query Evaluation [PDF] Chapter 12
    Oct. 26 External Sorting [PDF] Chapter 13 Homework #3
    Oct. 31 Evaluation of Relational Operations [PDF] Chapter 14
    Nov. 2 Schema Refinement and Normal Forms [PDF] Chapter 19
    Nov. 7 Schema Refinement and Normal Forms Chapter 19 Homework #3 due in class
    Project proposal due in class
    Homework #4
    Nov. 9 Database Design and Tunning [PDF] Chapter 20
    Nov. 14 Database Application Development [PDF] Chapter 6
    Nov. 16 Databases and Internet Applications [PDF] Chapter 7 Homework #4 due in class
    Nov. 21 Midterm 2 (Chapters 12-14, 19-20)
    Nov. 23 Thanksgiving Holiday!
    Nov. 28 Overview of Transaction Management [PDF] Chapter 16
    Nov. 30 Concurrency Control [PDF] Chapter 17
    Dec. 5 Crash Recovery [PDF] Chapter 18
    Dec. 7 Project Presentation (5 min + 2 min Q&A):
    1. J Bancroft, J Dearmon, K Qi
    2. B Clark, S Vennam
    3. D Bencuya, W Gobel, R Miller
    4. D Gao, C Moore, C Sun
    5. Y Huang, A Mantovani, F Trevino villarreal
    6. A Lim, J Miklowcic, C Yi
    7. H Huang, A Mickey, A Vasilyev
    8. C Butler, R Rodriguez, L Wilkerson
    9. D Hood, A Lewis, F Meyer
    		Project report due in class
    Dec. 9 4-7PM FINAL EXAM (Chapters 1-5, 8-14, 16-20) in FB007
    Wei Wang