I am in the progress of designing a database (or databases) for somebody and since I am a beginner I would love some advice.
The data is described as:
Customer1 (c1.type1, c1.type2, c1.type3) Customer2 Customer3 Customer4 (c4.type1, c4.type2) Customer5 Customer6 ... Customer10
There will be around 10 types of customers, perhaps less.
Not all the customers have different sub-types. The
type for customer1 for example, would be different than for other customers.
All of them would have general info included, for instance
phone number, along with other info.
Every customer generates an invoice. They pay different amounts since they buy different things.
We are predicting the tables may contain many millions of records.
Should I have multiple databases for each customer type?
Should I have one database with multiple tables for each customer type?
Should I have one database with one table for all customer types?
What about invoices? Separate database? Separate table? One invoices table for all invoices?
As of this moment I am inclined to go with one database with multiple tables for each customer type. The invoices would be in a separate table.
What do you think?