More efficient database design
I think I may have bitten off more than I can chew for my first database project and I need some professional advice about the database I designed and created. I have come to this conclusion based on the fact that I am beginning to learn how to write scripts and it seems like all my hard work into the design may be flawed. Could someone here take a look at my file to see if there is something I could have done better in the design?
this database is for an oil service company.
There is one customer with multiple services on multiple dates for install and removal using multiple invoices. there is also a billing cycle associated with each piece of equipment that is billed out every month until the removal. Can someone here please advise? thanks