Good evening dear readers
Could someone help me create an ERD based on this normalization?
I am a first-year IT student and I have some difficulty with this.
ONF
Order number Order date Customer number Customer name Customer address
1NF
Order Order number Order date Customer number Customer name Customer address
Order line Order number Item number Item description Quantity Price
2NF
Order Order number Order date Customer number Customer name Customer address
Order line Order number Item number Quantity
Item Item number Item description Price
3NF
Order Order number Order date Customer number
Order line Order number Item number Quantity
Item Item number Item description Price
Customer customer number customer name customer address
question from:
https://stackoverflow.com/questions/65875555/i-have-trouble-making-a-erd-restaurant 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…