Help to normalize the following tables

1

I am new to sql server. please help me if you can.
I have three tables: sales, cash sales and credit sales.

the sales table has the column salesid(PK), salestype, amount and date

cash sales table has cashsalesid(PK), salesid(FK), clientname,numberofitems,priceperitem,amountreceived and date

credit sales table has creditsalesid(PK), salesid(FK), clientname,numberofitems,priceperitem,amountreceived and date

i want to normalize these tables to the 3NF

2

I think you should give this a go on your own first. Since you're new, this is a vital skill to learn

1 Like
3

ok. Thank you gbritton