Results 1 to 5 of 5

Thread: Normalization

  1. #1
    Join Date
    Jul 2012
    Posts
    4

    Normalization

    Hi guys

    I'm wondering if anybody could tell me please the 1NF, 2NF and 3NF for the below UNF data?

    UNF

    Categories ID
    categori description

    Restaurants id
    rest name
    rest address
    rest postcode
    rest description
    rest telephone number
    rest email
    rest image
    rest comment

    menu id
    menu type
    menu start date
    menu expiry date
    menu comment

    menu items id
    menu items name
    menu items description
    menu items image
    menu items price
    menu items preparation time
    menu items comment

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Andy Red View Post
    I'm wondering if anybody could tell me please
    well, at least you said please, which is a step up from many people asking us to do their homework for them

    but we still won't do it

    if you give it a try, post your best effort, indicate which parts you're having trouble with, then we'll offer suggestions

    but we won't do your assignment, sorry
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2012
    Posts
    4
    Ok Thank you for your reply r937, the following is my solution could any one tell is it
    a correct solution up to 3NF and if not why?

  4. #4
    Join Date
    Jul 2012
    Posts
    4
    unf

    Categories ID
    categori descriptio


    Restaurants id
    rest name
    rest address
    rest postcode
    rest description
    rest telephone number
    rest email
    rest image
    rest comment


    menu id
    menu type
    menu start date
    menu expiry date
    menu comment

    menu items id
    menu items name
    menu items description
    menu items image
    menu items price
    menu items preparation time
    menu items comment



    1nf

    menu id
    Categories ID
    categori descriptio
    Restaurants id
    rest name
    rest address
    rest postcode
    rest description
    rest telephone number
    rest email
    rest image
    rest comment
    menu type
    menu comment
    menu items name
    menu items description
    menu items image
    menu items comment



    menu id
    menu items id
    menu start date
    menu expiry date
    menu items price
    menu items preparation time

    2nf

    menu id
    Categories ID
    categori descriptio
    Restaurants id
    rest name
    rest address
    rest postcode
    rest description
    rest telephone number
    rest email
    rest image
    rest comment
    menu type
    menu comment
    menu items name
    menu items description
    menu items image
    menu items comment



    menu id
    menu items id
    menu start date
    menu expiry date





    menu items id
    menu items price
    menu items preparation time


    3nf

    Categories ID
    categori descriptio

    Restaurants id
    Categories ID*
    rest name
    rest address
    rest postcode
    rest description
    rest telephone number
    rest email
    rest image
    rest comment

    menu id
    Restaurants id*
    menu type
    menu comment
    menu items name
    menu items description
    menu items image
    menu items comment


    menu id
    menu items id
    menu start date
    menu expiry date


    menu items id
    menu items price
    menu items preparation time

  5. #5
    Join Date
    Jul 2012
    Posts
    4
    unf 1nf 2nf 3nf

    Categories ID menu id menu id Categories ID
    categori descriptio Categories ID Categories ID categori descriptio
    Restaurants id categori descriptio categori descriptio
    rest name Restaurants id Restaurants id Restaurants id
    rest address rest name rest name Categories ID*
    rest postcode rest address rest address rest name
    rest description rest postcode rest postcode rest address
    rest telephone number rest description rest description rest postcode
    rest email rest telephone number rest telephone number rest description
    rest image rest email rest email rest telephone number
    rest comment rest image rest image rest email
    menu id rest comment rest comment rest image
    menu type menu type menu type rest comment
    menu start date menu comment menu comment
    menu expiry date menu items name menu items name menu id
    menu comment menu items description menu items description Restaurants id*
    menu items id menu items image menu items image menu type
    menu items name menu items comment menu items comment menu comment
    menu items description menu items name
    menu items image menu items description
    menu items price menu items image
    menu items preparation time menu id menu id menu items comment
    menu items comment menu items id menu items id
    menu start date menu start date
    menu expiry date menu expiry date menu id
    menu items price menu items id
    menu items preparation time menu start date
    menu expiry date


    menu items id menu items id
    menu items price menu items price
    menu items preparation time menu items preparation time

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •