Please build a relational database to store the following information about the sales at a departmental store.

billing address: address for customer billing

cost: inventory cost

credit limit: max credit for a specific customer

customer name: customer name

customer number: customer ID

description: inventory description

invoice number: invoice ID

item number: item ID

price: item price sold

quantity on hand: Inventory quantity on hand

quantity sold: total amount of inventory sold so far

quantity: quantity sold

shipping address: address for customer shipment

terms: discount terms offered to each sale

Use the normalization method and create the conceptual schema table for the relational database? Specify the primary key$($s$),$ foreign key$($s$),$ and other data for each table. $(10$ Points$)$