Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Oct 2013
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Making a database for work - reward offered.

    Hi guys,
    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:

    Clients Table
    ClientID
    Clientname
    Clientaddress
    Clientphone
    Clientemail
    Clientscope
    Clientlocation

    Client Type
    Platinum
    Gold
    Silver
    Bronze

    Location
    City
    Out-of-city
    Out-of-state

    Services (services cost is reliant on client type)
    Inspection A
    Inspection B
    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)
    Archiving
    Searches ETC

    Anyone that can help, would be very appreciated, i know it sounds confusing and im happy to clear anything up.

  • #2
    Super Moderator
    Join Date
    May 2005
    Location
    Southern tip of Silicon Valley
    Posts
    2,877
    Thanks
    2
    Thanked 164 Times in 159 Posts
    Sounds like all you're needing is to refresh your memory on database normalization.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •