Enter sample data of your own choosing into QtyOnHand in the Product_T table. Test the modification you

Question:

Enter sample data of your own choosing into QtyOnHand in the Product_T table. Test the modification you made in Problem and Exercise 16 by attempting to update a product by changing the inventory to 10,000 units. Test it again by changing the inventory for the product to –10 units. If you do not receive error messages and are successful in making these changes, then you did not establish appropriate constraints in Problem and Exercise 16.


Data from Exercise 16.

Modify the Product_T table by adding an attribute QtyOnHand that can be used to track the finished goods inventory. The field should be an integer field of five characters and should accept only positive numbers.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Essentials of Database Management

ISBN: 978-0133405682

1st edition

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

Question Posted: