
ANNOUCEMENTS
FOR DATABASE DESIGN CLASS
Please send your
comments to: Raghavan

- Question 3 in Assignment-1
is a test to see whether your check constraint is
working. If it is, you won't be able to insert the row
values as shown. Make the price lower, so that it does
not violate the constraint.
- Question 11 in Assignment-1
refers to the average value of a transaction. This means
that you find the value of each transaction (quantity *
price) and then divide the TOTAL value of all
transactions by the number of transactions. Of course,
you have to write the SQL query to do it!
- Normalization and E-R
modeling are fundamental concepts that you must
understand clearly before you can learn database design.
To supplement the lectures in the first two classes,
visit the Normalization site.

Please send your comments
to: Raghavan
© Dr. Vijay V. Raghavan
BACK TO Table of contents
BACK TO DATABASE Main Page
