I am new into programming world, I am working on some project where I have to create a database of some Projects. Below are details.
There are 3 tables Project Details, Consultant and Invoices Trackers.
Project table has information about all projects. Like ProID, ProDescription,ActivityID,Total Capital, Amount spent per Activity, Owner and Expect completion Date.
Consultant table has FirstName,LastName,ConsultingCmpny,
Invoice tracker table will contain all the invoices that are realted to projects, The table must contain following data. Cmpny, Desc, Billing Period, Consultant Fname, Consultant Lname, ID, Invoice number, Amount, ProjectID, Invoice Approver.
Consultant and Project are related with Project Desc.
Project & Invoice are related with Project Activity ID.
Consultant and Invoice are related with Some ID (I have to create.)