Review for Midterm by juanagui

VIEWS: 33 PAGES: 7

									Review for Midterm




                     1
                 Administrivia
• 75 minutes, in class, on Thur March 11
• close book/note, only scratch paper allowed
• I will not be here
  – TAs will proctor the exam




                                                2
                  Administrivia
• If you think a question is ambiguous
  – state and argue for your assumptions
  – then work with the assumptions
• Make sure to write down your name and student
  ID number
• You should write your solutions directly into the
  midterm copy given to you



                                                      3
               Midterm Format
• One multiple-choice question
• Followed by several more questions
• The question formats are similar to the questions
  we covered in the lectures and homeworks
  – some questions may be slightly more complicated
• 100 points
• The few last questions may be slightly more
  difficult

                                                      4
             What Will Be Covered?
• The ER model (Chap 2)
• The relational model & translation from ER
    – Sections 3.1 – 3.3
•   Schema refinement (Sections 3.4 – 3.7)
•   Relational algebra (Sections 5.1 – 5.3)
•   SQL + Views (Chapter 6)
•   Constraints + Triggers (Chapter 7)


                                               5
Lets Go Over Each Part in More Detail




                                        6
        Suggested Method for Study
• Go over the lecture slides
• Try to work out solutions to problems on lecture
  slides before looking at the actual solution
• Read the textbook
• Talk with people in your project group
• Look at last-year homeworks and midterm




                                                     7

								
To top