Year 12s: what will be the first way you research your future options? >>

Relational Database Help (lots Of Rep To Be Gained!)

Hey all!

Im happy to give rep to anyone who is generous enough to take time and advise me with this!

Ok... I'll get straight to the point! As part of a school project I am required to create an Access Database to store information on Work Experience Placements.

I need to begin planning and would appreciate some advise on how to link (relate) the tables together.

Currently I know that I require:

1) A "student table" (containing fields such as first name, surname, address and postcode).

2) An "employers table" (containing contact names, organisation names, email addresses e.t.c)

3) A "placement table" (to show which students are going on which placements).

I am currently slightly confused on how to link these tables together so that the database works efficiently, and would appreciate some advise on which fields & primary keys to link together.

Thankyou,
Davror

Reply 1

teachercol

You need to create key fields for your main tables : suggest student id and employer id.

The joining table (placement) will have fields like

student id
employer id
date started
date finished
...

The links will be student - placement (1 - many) (join on student id)
and placement - employer (many -1) (join on empployer id)

That should get you started.

Latest

Articles for you

Terms and conditions

What is an LLM and how could it benefit your career?

Powerful questions business students forget to ask their career advisers

Why I chose a law degree and what studying law was like

Relational Database Help (lots Of Rep To Be Gained!)

Related discussions

Latest

Trending

Trending

Articles for you