Ok I've searched through and read about normalization can someone just have a quick once over my grasp of this concept.
I am designing a database for service recrods, the database will detail Customer contact details, service records, location and instruments.
so I have 4 tables:
1 listing locations and adress containing the postcode.I have set the postcode to the PK.(tblLocations)
tblCustomer listing customer details, contact number name including the postcode again as there may be 2 people working at one site but in different departments.
tblInstrument listing the instruments that need servicing this table has serial numbers for all the instruments and also contains postcodes. However the pk is the serial number.
The final table is the service history table tblService. This lists what services were carreid out at which site. It inculdes Location, Contact, Postcode, Instrument, work carried out and serial number and serviceID. Service ID is set to the primary key.
The tblService pulls info from the other tables so that all that is entered is the problem.
So I have the hospital table linked to the customers via Postcode. The instruments are linked to the hospital again via postcode. The service records are then linked to the location using the ServiceID field.
As one location can have many instruments, service calls, contacts I have made all links one to many from the hospital to all.
Have I got the correct idea?
many thanks.
I am designing a database for service recrods, the database will detail Customer contact details, service records, location and instruments.
so I have 4 tables:
1 listing locations and adress containing the postcode.I have set the postcode to the PK.(tblLocations)
tblCustomer listing customer details, contact number name including the postcode again as there may be 2 people working at one site but in different departments.
tblInstrument listing the instruments that need servicing this table has serial numbers for all the instruments and also contains postcodes. However the pk is the serial number.
The final table is the service history table tblService. This lists what services were carreid out at which site. It inculdes Location, Contact, Postcode, Instrument, work carried out and serial number and serviceID. Service ID is set to the primary key.
The tblService pulls info from the other tables so that all that is entered is the problem.
So I have the hospital table linked to the customers via Postcode. The instruments are linked to the hospital again via postcode. The service records are then linked to the location using the ServiceID field.
As one location can have many instruments, service calls, contacts I have made all links one to many from the hospital to all.
Have I got the correct idea?
many thanks.