hi

as part of my revision i have been revising normalisation

attached is a document which i have normalised to BCNF. can n e 1 tell me whether i have done it correctly or not?

if not can you tell me where i am going wrong and how to correct it.

please help me my exams are 2morrow and i really don't want to fail please please please please

and here is the document

Looks to me like Client No functionally determines Client Name and perhaps Tel No, but it does not determine anything else. The same client could use your taxi service for 2 different journeys.

What has happened to Job Id in the final version?

thanks for that i must have missed that off. is this corrected verion better?

Yes, but now you no longer have the FD Staff No -> Veh Reg No which I think you had before.

your right - i have now corrected that- is this correct now

here's the doc

I still can't see where that FD is separated out into its own table in the 2NF version?

can u explain a little more in depth or show me what u mean- i'm still not sure?

In a normalised set of relations, all non-key attributes must be dependent directly on the relation key.

Your first relation has the key {JobID, StaffNo}. Is that right? Can there be 2 records with the same JobID but a different StaffNo?

Does the Veh Reg No depend on the JobID AND the StaffNo as you have it, or does it depend just on the StaffNo? (It could be either, depending on whether cars "belong" to the Staff or are shared between them).

there can't be two relations with the same jobid but different staff no's. and the viechel reg only depends on the staff no's.

i am rea;;y confused now as of where to go from here? what steps should i take next

Create a relation with jobid as the key, and put in it what depends on jobid, like Staff No, start time, drop off point, whatever.

Create another relation with Staff No as the key, and put in it what depends on Staff No, which is just Veh Reg No.

thanks for that- i was feaking out a bit there-

is this now correct. does this apply for £NF and BCNF?

i keep forgetting the attachment... Doooooh!!!!

and here is is