Consider the relationship between the two entities CUSTOMER and ITEM:

CUSTOMER (Cus_number, Cus_name, Cus_Address)

ITEM (Item_number, Item_name, Item_price, Item_weight)

Redesign the above database tables to connect the two entities above in such a way to avoid duplication of the data. The new design enables you to issue bills for each customer renting items from the company. Note that a customer can rent many items and an item can be rented by several customers. (e.g Renting from Home Depot)

If Customers are buying items then one item can only be bought by one customer but one customer can buy several items.

Answer the following 2 questions:

1. Design the new relational database:

2. Write an SQL command to find the names of the items ordered by customer whose cus_number is 123