Home
Main topics
Study help discussion
All study help
GCSEs
A-level
University discussion
Uni applications
University and HE colleges
University help and courses
University student life
Postgraduate
Medicine
Careers discussion
Careers and jobs
Teacher training
Finance and accountancy
Lifestyle discussion
Chat
Relationships
Fashion
Fitness
Sexual health
GCSE and A-level
Study level discussion
GCSE
A-level
Btec
T-level
Scottish qualifications
IB
EPQ
Study help discussion (by subject)
Maths
English
Geography
History
Biology
Chemistry
Physics
Foreign languages
All study help
GCSE and A-level articles
GCSE articles
A-level articles
Exam and revision articles
What to do after GCSEs
What to do after A-levels
When is A-level results day 2024?
When is GCSE results day 2024?
More study help
Studying, revision and exam support
Grow your Grades
Revision and exams
Revision and exam discussion
A-levels
GCSEs
Btecs
All A-level exams
All GCSE exams
Revision tips
Top vloggers for revision help
Best video resources for revising GCSE or A-level English
Best places online for maths revision
How to use past exam papers for revision
Preparing for an exam
How to study effectively for your exams
Handling revision and exam stress
What to expect from an exam
Seven things to do in the last week before an exam
How to handle exam nightmares
Finding motivation
Getting past procrastination
It's not too late: 10 ways to kick-start your revision
How to revise when you're feeling lazy
University
University discussion
All universities
Applying through Ucas
Student finance
Personal statement
Postgraduate study
Uni accommodation
University life
University course discussion
All uni courses
Apprenticeships
Medicine
Arts and humanities courses
Stem courses
Social science courses
Universities by region
North of England
Midlands
South of England
Greater London
Scotland
Wales
Northern Ireland
Distance learning
International study
University guides and articles
All university articles
Applying to uni articles
Personal statements
Personal statement examples
Freshers
University open days
Studying law at university
Student life at university
Careers and jobs
Careers discussion
Careers and jobs discussion
Apprenticeships discussion
Part-time and temp jobs
Industry forums
Career forums by sector
Armed forces careers
Consultancy careers
Finance careers
Legal careers
More industry forums
Marketing careers
Medicine and healthcare careers
Public sector careers
Stem careers
Teaching careers
Life and relationships
Life chat
General chat
Relationships
Friends, family and colleagues
Advice on everyday issues
Fashion
Health chat
Life and style
General health
Sexual health
Mental health
Fitness
News and entertainment chat
Debate and current affairs
Entertainment
UK politics
News
Educational debate
Football
Sport
Student finance
Undergraduate
Full time
Part time
Postgraduate
Postgraduate Master's Loan
Postgraduate Doctoral Loan
Disabled Students' Allowances
Taking a break or withdrawing from your course
Further information
Parents and partners
Repayment
Advanced Learner Loan

What would you like to say?

Your discussion will live here...

(Start typing, we will pick a forum for you)

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

Take our quiz to find out what your revision personality is! >>

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

Take our quiz to find out what your revision personality is! >>

Forums
the tables

the tables

htariq29

can someone please tell me how many tables there was cause i did 3 i dont get how there would be 4 2 tables are the id's and the 3rd was the ref numeber one

Reply 1

BailyEast1

There would be a forth table between staff and positions, as in the scenario it said that staff can have many positions during their tenure at the company and from the data given you can see that many positions can be held my many employees,(many employees had the same position) in the 4th table I think you’d have the Staff Ref, Position ID, position start and end date, hope that helps !

Quick Reply

Related discussions

hypothesis Testing with only > Mean side of z table
Complete University Guide Table 2024
How do I find the league tables for modern foreign language degrees?
Teak Root
Btec ict level 3 unit 2 may exams
The Sports Hurt/heal game
Dnd puzzle help.
a level chemistry
BTEC IT Unit 2 January 2024 exam discussion
Guardian/Daily Mail Uni/Times Rankings 2024
University Rankings Herriot Watt, Dundee or Strathclyde
Btec it level 3 unit 2
Disparity between national and international league tables?
Test statistics in SPSS Custom tables
London student accomodation - Studio available over the summer
BTEC IT LEVEL 3 unit 2 jan 2024
Biology OCR A level PAGS
Manufacturing account
Any HTML Experts Please Send Help
Tenancy Takeover in Loughborough

Latest

Articles for you

Calculating Ucas points based on predicted grades

What do university league tables really tell you?

Finding the one: how I picked the right uni

Is a postgrad course worth it? The pros and cons of postgraduate study

The Student Room and The Uni Guide are both part of The Student Room Group.

Get Started

Today's posts
Unanswered posts
Community guidelines

Using TSR

TSR help centre
Cookies & online safety
Terms & conditions
Privacy policy
Ad Privacy Settings

Info

About TSR
Advertise
Contact us

Connect with TSR

Twitter
Facebook
YouTube
Instagram
TikTok

The Student Room and The Uni Guide are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: Imperial House, 2nd Floor, 40-42 Queens Road, Brighton, East Sussex, BN1 3XB