CMPT 258 Database SystemsMidterm Review

Regarding the Exam• Oct 15 Thursday•Close book•Cheat sheet (1 side of an A4 paper)

Tutors Available!•Mondays 11 am - 12 pm•Tuesdays 1 pm - 2 pm•Wednesdays 2 pm to 3 pm•Thursdays 12 pm - 1 pm

•RLC 203

Problem 1•ER diagram

▫Chapter 2▫Examples in class▫Homework 1

•Clearly mark all key and participation constraints.

•1:N, M:N, etc. or an arrow •Double lines for total participation•Double lined boxes for weak entities

Problem 2•SQL statements

▫CREATE, DROP, ALTER▫INSERT, UPDATE, DELETE, SELECT▫CREATE VIEW▫Chapter 3▫Examples in class▫Homework 2

Problem 3•Two questions•Convert an ER diagram to SQL

statements▫CREATE TABLE …▫Primary key constraints▫Foreign key constraints▫Rules to translate ER to relational model

8