Hey! Sign in to get help with your study questionsNew here? Join for free to post

BTEC ICT help required

Announcements Posted on
Why bother with a post grad? Are they even worth it? Have your say! 26-10-2016
    • Thread Starter

    Hi all,

    I am doing ICT BTEC level 3 sub-diploma course . I'm on unit 18 P2 which says
    "“design a relational database for a specified user need” – You can EITHER take the flat-file for IT4U and normalise into 5 tables, using the 3 steps from First to Third Normal Form (3NF);
    OR create a database model to replicate a scenario such as a booking/ordering system. Using normalization break it down into 5 tables in Third Normal Form (3NF).
    You should refer to the design brief for the IT4U system or if creating your own model also create a design brief at this stage to summarize the user requirements of what the proposed system will do.
    Explain in a word-processing document the process of normalization and how it applies to your database model to get from zero to third normalized form. You should include evidence of steps of design (e.g. entity relationship diagram)."

    I'm really stuck with what to put in the tables. I have customer, product, order, supplier and order details tables but don't really know what to put in them.
    Teacher isn't being very helpful.

    Thanks in advance!

    Sorry you've not had any responses about this. Are you sure you've posted in the right place? Here's a link to our subject forum which should help get you more responses if you post there.

    Just quoting in Fox Corner so she can move the thread if needed :wizard:
    (Original post by Fox Corner)
Write a reply…


Submit reply


Thanks for posting! You just need to create an account in order to submit the post
  1. this can't be left blank
    that username has been taken, please choose another Forgotten your password?
  2. this can't be left blank
    this email is already registered. Forgotten your password?
  3. this can't be left blank

    6 characters or longer with both numbers and letters is safer

  4. this can't be left empty
    your full birthday is required
  1. Oops, you need to agree to our Ts&Cs to register
  2. Slide to join now Processing…

Updated: September 18, 2016
TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

Cats: Yay or nay?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.