Normalisation

T

th0r0n

Hi,

Basically I have a Database that keeps a log of all call monitoring
sessions (where you listen to someones phone calls and give them marks
if they fulfil certain criteria) this is my structure:

Calls(CallID[PK],CallTime,CallDate,CustomerID) (The phonecall Monitored)
Campaigns(CampaignID[PK],CampaignName) (The department worked on)
Contracts(ContractID[PK],ContractName) (Name of employment agency of staff)
Customers(CustomerID[PK],CustomerName,CustomerNumber) (People phoned)
Logons(LogonID[PK],LogonUserName,LogonPassword) (Database logons)
Managers(ManagerID[PK],ManagerName,LogonID,CampaignID) (Managers)
Questions(QuestionID[PK],Title,SectionID,CampaignID) (List of criteria)
Responses(PassedID[PK],PassedResponse) (Yes, No or N/a)
Sections(SectionID[PK],SectionName) (Catergory of criteria)
Sessions(AnswerID[PK],StaffID,QuestionID,CallID,PassedID) (Test results)
Staff(StaffID[PK],StaffName,CampaignID,ManagerID,ContractID) (List of staff)

Is there any other way I should be doing it? What level of normalisation am
I on?
(Is there a tool I can download to tell me how nomalised my database is?)

Thanks very much,

Toby
 
T

th0r0n

Hi,

Basically I have a Database that keeps a log of all call monitoring
sessions (where you listen to someones phone calls and give them marks
if they fulfil certain criteria) this is my structure:

Calls(CallID[PK],CallTime,CallDate,CustomerID) (The phonecall Monitored)
Campaigns(CampaignID[PK],CampaignName) (The department worked on)
Contracts(ContractID[PK],ContractName) (Name of employment agency of staff)
Customers(CustomerID[PK],CustomerName,CustomerNumber) (People phoned)
Logons(LogonID[PK],LogonUserName,LogonPassword) (Database logons)
Managers(ManagerID[PK],ManagerName,LogonID,CampaignID) (Managers)
Questions(QuestionID[PK],Title,SectionID,CampaignID) (List of criteria)
Responses(PassedID[PK],PassedResponse) (Yes, No or N/a)
Sections(SectionID[PK],SectionName) (Catergory of criteria)
Sessions(AnswerID[PK],StaffID,QuestionID,CallID,PassedID) (Test results)
Staff(StaffID[PK],StaffName,CampaignID,ManagerID,ContractID) (List of staff)

Is there any other way I should be doing it? What level of normalisation am
I on?

The questions differ depending on what campaign the agent is working on, but
I am a bit confused, how am I supposed to answer all of these unique
questions on a form? I can't hard code them, as they have to change, and I
can't theoretically see how I can use a form to answer all of the unique
questions! (Theres's about 30 per session, and they have to be easily
accessible, so no selecting from listboxes or lengthy comboboxes.

Regards,

Toby

Thanks very much,

Toby
 
K

Klatuu

Build a Questions table. If it it tied to a campaign, have a campaign name
field you can filter on. Buidl a form that shows the questions. Of course
you will need another form that allows you to maintain your questions library.
 
T

th0r0n

Already have:-

Questions(QuestionID[PK],Title,SectionID,CampaignID) (List of criteria)

Klatuu said:
Build a Questions table. If it it tied to a campaign, have a campaign name
field you can filter on. Buidl a form that shows the questions. Of course
you will need another form that allows you to maintain your questions library.

th0r0n said:
Hi,

Basically I have a Database that keeps a log of all call monitoring
sessions (where you listen to someones phone calls and give them marks
if they fulfil certain criteria) this is my structure:

Calls(CallID[PK],CallTime,CallDate,CustomerID) (The phonecall Monitored)
Campaigns(CampaignID[PK],CampaignName) (The department worked on)
Contracts(ContractID[PK],ContractName) (Name of employment agency of staff)
Customers(CustomerID[PK],CustomerName,CustomerNumber) (People phoned)
Logons(LogonID[PK],LogonUserName,LogonPassword) (Database logons)
Managers(ManagerID[PK],ManagerName,LogonID,CampaignID) (Managers)
Questions(QuestionID[PK],Title,SectionID,CampaignID) (List of criteria)
Responses(PassedID[PK],PassedResponse) (Yes, No or N/a)
Sections(SectionID[PK],SectionName) (Catergory of criteria)
Sessions(AnswerID[PK],StaffID,QuestionID,CallID,PassedID) (Test results)
Staff(StaffID[PK],StaffName,CampaignID,ManagerID,ContractID) (List of staff)

Is there any other way I should be doing it? What level of normalisation am
I on?

The questions differ depending on what campaign the agent is working on, but
I am a bit confused, how am I supposed to answer all of these unique
questions on a form? I can't hard code them, as they have to change, and I
can't theoretically see how I can use a form to answer all of the unique
questions! (Theres's about 30 per session, and they have to be easily
accessible, so no selecting from listboxes or lengthy comboboxes.

Regards,

Toby

Thanks very much,

Toby
Click to expand...
Click to expand...
 
Top