Thread: Database Design

Hi,
i am bit stuck for database design, basically i have 3 entity,

Manager
Level
Form


There are three levels of managers
There are three types of forms for each levels of manager
Each level manager fills one type of form only.

for instance

All senior managers fill form 1 only

All line manager fill form 2 only

All middle manager fill form 3 only

The three forms have different questions

I am havin trouble to normalised it.

I was thinking of manager table which is linked to the form table but it does not look like it is normalised

Originally Posted by jmurrayhead

Show us what you have so far. I think I understand what you mean, but not completely.

Hi,
at the moment i have 2 tables and it is in access,
my member table has:
Memberid PK;
Password;


This is linked to the three types of form

Form table

Formid PK:
Memberid FK;
Form Type;(This will be form Type1, form Type 2,form Type 3)
Level of management;
Q1;
Q2;
Q3;
Q4;
Q5;
Q6:
Q7;
.
.
.
But it does not look like it is normalise:
as form Type 1 has 5 questions for senior level
form Type 2 has 10 questions for middle level
form Type 3 has 20 questions for line managers

it is repeating in the table that i have

Hi,
i am having bit of a problem with an sql query, based on the above db design how do i identify a member who have filled in a specific form? I have tried this query:

Code:

 SELECT Member.MemberID, ManagementLevels.Description, Form.FormType
FROM (ManagementLevels INNER JOIN Member ON ManagementLevels.LevelID = Member.LevelID) INNER JOIN Form ON ManagementLevels.LevelID = Form.LevelID
WHERE (((Member.MemberID)=1));

But the problem is, that it relates every single member to a management level, and according to the query it says that member 1 has filled in a form. And this is not true.

Hi,
yes thats what i mean because i need to find out which member has filled in a form.

Hi,
i have created the table but when i run the sql i get this error message: