I am fresher in Database Design
I want to Design a Database for an online Auditing Tool...for Auditor and Project Managers..
so far I have the following tables...
Employee (EmpID , EmpName,EmpLname ,Phone)
Administrator( AdminID ,EmpID, AdminEmail)
Company(CompanyID, CompanyName,ProjectID)
Auditor( AuditorID, Name, LastName)
Questions(QuestionID, Question)
Results(QuestionID,Result,CompanyID,ProjectID)
User One Auditor:
will asses the project ussing the questions in the database and give a score for the project.
User Two Manager
Will view the Overall score for a particular Company and a Score a Single Project under that Company(From a list Box)
I'm having a hard time in creating the relationships between the(Company and Score..Project and Score..Score and Questions)
The Questions are under two sections and there should be score for that particular section and overall score for both sections.
Any Help will be much Appreciated..