Answer to Question #199467 in Management for HAMZA

Question

Extensively about what he wants and offers a concise summary:

 

I would like that my customers are able to browse my catalog of clothes and place orders over the Internet. Currently, I take orders over the phone. I have mostly corporate customers who call me and give me the unique Id number of a cloth and a quantity; they often pay by credit card. I then prepare a shipment

That contains the clothes they ordered. If I don't have enough in stock, I order additional, my catalog includes all the clothes I sell. For each cloth, the catalog contains its id number, brand, designer,

Purchase price, sales price, and the year the cloth brand was published. Most of my customers are regulars, and I have records with their names and addresses.

a) From the following data rectify basic relation and entities

b) Rectify the attributes for each entity and relation

c) Write SQL query to create table for each entity with two constraints at least

Answer 1

a) From the following data rectify basic relation and entities.

They are the customers and clothes

b) Rectify the attributes for each entity and relation.

customers depend on buying clothes from the dealer through catalogue

c) Write SQL query to create table for each entity with two constraints at least

Can regular customers purchase clothes without catalogue? Catalogue doesn't work well when all details of clothes aren't available.