I have been working at my current job since January and on my resume i decided to write that i have SQL experience. While this is true, it has been at least a year since I have finished uni and I am very rusty with it. Basically I work at a building company in a certification department (helping with IT). My boss approached me months ago about building a database for him with his clients in it to which i agreed.
I am in no way wanting anyone to make a database for me I am more than capable of this myself however I am confused as to how to setup this one and its relations and am willing to offer a reward to someone willing to help.
Basically it is a client database. The thing is we have levels of membership for our annual fee agreements (Platinum, Gold, Silver and Bronze) and based on the membership level purchased it determines the price of our services we offer. Plus extra can be added onto these costs based on the location of the client companies.
So far I have a client table with the following fields:
Services (services cost is reliant on client type)
Inspection C ETC
Extra Council Fees (These costs are mandatory depending on council involved - not sure if i need a council table with every council and their respective prices listed)
Anyone that can help, would be very appreciated, i know it sounds confusing and im happy to clear anything up.