Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Help on layout please

Discussion in 'Information Technology' started by Charles, Jul 28, 2006.

  1. Charles

    Expand Collapse


    I am looking for the best table layout to keep track of a person that
    is a transporter for my organization. With that I will also need to
    keep track of the vehicle(s) they will be using, the LicensePlate
    number(s) of the vehicle(s), Insurance Policy covering that vehicle,
    transporters drivers license number.

    Right now I have the following:


    TBL-Insurer(this is the company info on the insurance co.)

    TBL-InsurerEvent(transporterID, InsurerID, DateBegan, DateExpire,
    Policy#, CopyOnFile)

    TBL-LicensePlate(LicensePlateID, LicensePlateNumber)

    TBL-LicensePlateEvent(LicensePlateEventID, LicensePlateID,
    TransporterID, StateOfIssue, DateOfIssue, DateExpire)
    **Note: I broke the License Plate into two tables, for in some states,
    you get a different plate number yearly or every 5 years, and I would
    like to retain the tag history of each transporter**

    TBL-DriverLicense(DriverLicenseID, DriverLicenseNumber, TransporterID,
    StateOfIssue, DateOfIssue, DateExpire, CopyOnFile)
    **Question: Since a person's DL number may also change, should I break
    this table down... not sure on best way**

    TBL-Vehicle(VehicleID, TransporterID, VINNumber, Make, Model, Year,

    Many, Many thanks in advance,
  2. Loading...

    Similar Threads Forum Date
    Interfaith So Help Me O’ God, Yahweh, Allah, Vaheguru, Et. Al…… Interfaith Dialogues Wednesday at 2:03 AM
    Interracial And Interfaith Marriage, Help Needed To Confront/convince My Parents Love & Marriage Aug 16, 2016
    Khalsa Aid Sikh Charity Praised For Helping Stranded UK Travellers Sikh Organisations Jul 26, 2016
    Sikh News Sikh Charity Praised For Helping Stranded UK Travellers - NDTV Breaking News Jul 26, 2016
    HELP ME! Sikh Sikhi Sikhism Mar 19, 2016

Share This Page