I am writing my first app in ASP.NET. I have customers and several services. I would like to know the best way to design the database tables.
Services include Alarm, CCTV, Access, and Fire and have their own unique fields. My confusion is that since a customer can only have one of each, should I include the service fields in the Customer database, or should I create separate tables for each service
and create relationships from the customer to the services? Would this separation reduce the size of the database since most customers do not have every service?
Go to the complete details ...