AnsweredAssumed Answered

More efficient database design

Question asked by rezap on Nov 10, 2010
Latest reply on Nov 11, 2010 by FentonJones

Title

More efficient database design

Post

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

Screen_shot_2010-11-10_at_11.55.44_AM.png

Outcomes