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