I hope someone can help. I confused with one part of my coursework.
"For each booking there are a number of payments. There are three types of payment: the deposit (usually made when the holiday is booked), the balance (the rest of the cost, which is usually paid up about one month before the trip starts), and an optional insurance payment. The database should record the type, date and amount of each payment. There is only one payment of each type per booking."
How many tables should i create here? 4? like Paymnet, Deposite, Balance and insurance or
should i make only one table Payments? Payment has type,date and amout as its attribute but i am not sure with others.