Each book has a book id, a title, an author, a price, and an amount (amount of
books in stock).
• For every student, we must capture her/hisstudent id, name, gender, major, and
discount level.
• When an order is successfully placed by a student, an order record should be
added to the database. Each order contains at least the following information: a
student, an order date, books ordered, a total price, a payment method, a card
no. (if the payment method is by credit card). Once the order is cancelled by the
student, the corresponding order record will be removed.
• The books in an order may be delivered on different dates. For each book of an
order, record its delivery date. After some book has been delivered to the
student, the order can no longer be cancelled.
• A student can enjoy 10% (20%) discount if her/his total order in the current
year has exceeded $1,000 ($2,000). Each book has a book id, a title, an author, a price, and an amount (amount of
books in stock).