View the step-by-step solution to:


This question was created from ict285m2015s2


Not very sure how to this please provide answer for me thank you


An agency supplies temporary staff to hotels Within the Perth region. The table shown
below lists the time spent by agency staff working at various hotels. The Tax File Number (TFN) is unique for every member of staff.
- ContractND mw— Hoteltocation Smith J. Fremantle Hocine, D. Northbridge
White, T. Midland
Smith, J. Midland (a) What is the candidate key of the relation? (b) What normal form is the relation in? Explain your reasoning. (0) Convert the relation to a set of relations each in Third Normal Form {SHIT}.
Indicate all primary keys and foreign keys. (6 marks)

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question