How could I design this database?

[jennyek2000]

How could I design this database?

In the system you have a number of projects, each with there own attributes, which are stored in a table. Each project consists of a number of documents, which must also be stored in a table. So for every record in the projects table there is a table of documents. The system must allow you to create a job, which in turn creates a new document table with new data. How could I do this?

 

[lespaul]

You really haven't provided much information (and this also sounds like a home work assignment); but generally you would need two tables (you really don't want a new table for each projects documents):

Project: ProjectID (PK), ProjectName, ProjectStartDate, etc.

Documents: DocumentID(PK), ProjectID(FK), DocumentName, DocumentCreateDate, etc.

Then on a form, you would have a button, create new project which would insert a new record in the project table and if you want a new record in the document table and populate the fields with the information.