help my normilisation

[brothertse2008]

hi guys im realy having trouble woth this normalisation. Now I dont expect the answers but could someone cast their eye over what ive got so far and tell me if im right.

UNF
Fault ref
Date submitted
First name
Surname
Telephone
Email
Fault details
Floor number
Room number
Priority
Fault type
Fault type detail 1
Pc name
Pc serial number
Warranty?
Details of fault
Fault type detail 2
Asset tag number

Resolved Y/N
Resolved by
Resolution details


1NF
Fault ref
Date submitted
First name
Surname
Telephone
Email
Priority

Fault ref
Asset tag number
Pc name
Pc serial number
Warranty?
Fault details
Floor number
Room number
Fault type
Fault type detail 1
Details of fault
Fault type detail 2
Resolved Y/N
Resolved by
Resolution details


2NF
Fault ref
Date submitted
First name
Surname
Telephone
Email
Priority

Fault ref
Asset tag number
Pc name
Pc serial number
Warranty?
Floor number
Room number

Fault details
Fault details
Fault type
Fault type detail 1
Details of fault
Fault type detail 2



3NF
Fault ref
Date submitted
First name
Surname
Telephone
Email
Priority

Fault ref
Asset tag number
Pc name
Pc serial number
Warranty?
Floor number
Room number

Fault details
Fault details
Fault type
Fault type detail 1
Details of fault
Fault type detail 2

 

[ColinEssex]

Phew! It's difficult to know where to start.

Firstly you need to make a table of demographic data about the person headed by an AutoNumber you should only have this data once in the database or it becomes difficult when things change - do it like this -

PersonID (AutoNumber)
Surname
FirstName
FloorNumber
Email
PCNumber

Etc

Then you need a table of faults logged headed by a number linked to the first table like this

Numb (Number)
FaultNo
FaultDate
Resolved (Y/N)

etc

Then you need a look-up table of possible faults headed by an AutoNumber

FaultID
FaultDesc

Then link them together on the number fields. Do that for now, then come back if you still have problems.

Col

 

[brothertse2008]

ok so whwn linking the tables (im using access) i would have the relationships set as one to many. when linking them id link the auto number in table one to the auto number in the other table because i want to enforce data integraty

 

[ColinEssex]

You only need the autonumber in the first table, the second table is just a number. The fault masterfile will need an autonumber then use that as the link to the FaultNo in the 2nd table.

Yes it's one-to-many. One person can have many PC faults logged over time.

Col

 

[gemma-the-husky]

mind you, is the person significant?

does it matter WHO reports the fault on a given machine

if this is all intra-company stuff, you are probably more concerned about the machines themsleves than the person reporting the fault. (maybe also if its a retail shop?)

in which case you may want to start with the machines table, as the employees table is not so important

machines tables

faults table, linked to the machine
(containing details of the person reporting the fault
(either maybe just as text - or keyed to an employees table)

ie different people can report faults on the same machine - just depends who has it any given time - even in a repair shop this would apply - as it may not be the same person who brings it each time

i know when you book a car in for repair, it starts with the car (reg no), not the owner - its a similar thing, i think
--------

 

[brothertse2008]

this is for a college assignement im doing.im settting it up as if i was doing a fault system for a college helpdesk. So im assuming its more relevant to know wat department reported teh falut.

i also checked so see if its ok to get answers from forums like this and it is as long as i reference it

 

[ColinEssex]

this is for a college assignement im doing.im settting it up as if i was doing a fault system for a college helpdesk. So im assuming its more relevant to know wat department reported teh falut.

i also checked so see if its ok to get answers from forums like this and it is as long as i reference it

I hope you improve your spelling when you write it up.

"It's ok to get answers from forums like this?" - What happened to attending the lectures and learning from them?

Col

 

[brothertse2008]

I do attend class. It has been explained in class but we encourage self help and various alternative learning and research methods.

Ive managed to normalise my date which I will post up after class (Where Iam now)