COSC 3P32 Midterm Practice Questions
Midterm Practice Questions
COSC 3P32 Midterm Practice Questions
Q1
Given the portion of an ER diagram displayed below, write the SQL statements to create the
resulting SQL table schema.
Q2.
Design the ER diagram which most accurately represents the following scenario:
• We are going to start up an online book store. For each of our customers we want to record
their name, address and phone number.
• For each book we want to record the ISBN, title, author, price and the number of copies
which we have in stock.
• Each order which we receive will be given an order number and we will record the customer,
the order date and the credit card for payment.
• An order will consist of one or more books, so we will have to keep track of which books are
associated with an order and how many copies of each book are ordered. Our policy will be to
ship each book title when we have a sufficient number of copies in stock, so different books on
the same order may have different ship dates.