hi

i am new to Databases and Programming...I want to Design a project Auditing Tool..to be used by project Managers and Auditors

I have the following Tables:


Employee(Id,Fname,LName,etc)
Project(projectId,projName,description,CompanyID)
Company(id,Name,City,Project)
Questions

First User is the auditor who will asses the project using a set of Questions stored in Database and give a score based on the answers given

Manager will want to view Overall score for a particular Company that has multiple project and also view score for the individual projects


how do i link these tables



Can somebody help please