Answer to Question #49845 in Databases | SQL | Oracle | MS Access for Abhishek Mukherjee

Question

ShopMart is a leading chain of departmental stores in America. It has many stores in the United
States, Bahamas, Canada, Cuba, Costa Rica, and Mexico, with its head office in California. The
chain is known for quality products, affordable prices, timely service, and a free home-delivery
facility. To ensure customer satisfaction and trust, the store procures the best quality goods from
different countries. In addition, to ensure prompt service, the store maintains an optimum level of
inventory all the time.
ShopMart deals in various categories of products, such as Household, Sports, Accessories, and
Clothing. Currently, the details of all these categories are stored in the ProductCategory file. The
details stored in the file consist of ID, name, and description of the categories. In addition, the
details of all the products are stored in the ItemDetails file. The details stored in this file consist of
ID, name, description, category ID, and unit price of the products. In addition, the ItemDetails file
stores i