Information Technology: Database concepts and applications The Everest Books dat
ID: 3790654 • Letter: I
Question
Information Technology: Database concepts and applications
The Everest Books database has four tables i e., books, customers, orderinfo, and orders everest Tables books customers orderinfo orders The columns of each table are shown below. Also there are some example recorders in each of these tables, which are displayed in MySQL Workbench (table boo 1 SELECT FROM everest.books 1 SELECT FROM everest. customers Result Grid t* Filter Rows: I Result Grid Filter Rows Edit: Export ISBN Title UnitPrice Id Name Company Street City State zip 0439357624 Born Confused 16.95 25 Scenic Road Hilltop NJ 18901 1 Jones, Tom Acrme 0670031844 White Mughal 34.95 NULL 2 Wise, Susan 32 New Road Union AZ 78901 0929306260 Java 49.95 3 Singh, Liza FastTrack 155 Route 133 Holmdel FL 48901 0929306279 Bell Labs 29.95 SELECT FROM everest orderinfo 1 SELECT FROM everest. orders; tA Filter Rows: Result Grid Order Id ISBN Qty UnitPrice Filter Rows 0929306279 29.95 Result Grid Edit: 0929306260 1 49.95 Id CustomerId Order Date shipDate shipping 0439357624 16.95 2004-03-31 2004-03-31 4.99 0670031844 1 34.95 2004-04-01 2004-04-02 5.99 0929306279 1 29.95 49.95 2004-04-01 2004-04-02 3.99 0929306260 1 0439357624 16.95 2004-04-02 2004-04-02 6.99 0670031844 1 34.95Explanation / Answer
When a customer's contact information changes, Customer contact information in the CUSTOMERS should be changed.
We donot need to add a new entry with the updated information.
But, we can update the CUSTOMERS table for that particular Customer:
UPDATE EVEREST.CUSTOMERS SET CITY = 'NEW_CITY_NAME' , ZIP = 'NEW_ZIP_CODE' WHERE ID = 'CUSTOMER_ID'
NEW_CITY_NAME : New city name to be updated.
NEW_ZIP_CODE : New zip code to be updated.
CUSTOMER_ID : Customer Id of the Customer whose contact information to be updated.
Above query can be used for updating the customer contact information.
Please comment for any queris/feedbacks.
Thanks,
Anita