Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Unanswered: Database Organization

    First post here.

    I am fairly new to databases, I have written a few queries but nothing too fancy.

    I am looking to create a database of restaurants in my city and was wondering how to organize it. The fields I am thinking about are:
    Code:
    [Name]
    [Location] --> Should I have separate fields for [city, state, zip and street number]?
    [Neighborhood]
    [Avg Entree Price]
    [Reservations accepted]
    [Hours]
    [Delivery]
    [order online]
    [cuisine]
    [Features (kid friendly, wifi, etc)]
    So each restaurant in my database would have those fields. Is this the correct way to do this?

    I would envision a query like (pseudo code)

    Code:
    SELECT from restaurant where 'Avg entree price' = 10 & CUISINE=indial & DELIVERY=yes WHERE neighborhood = southside

  2. #2
    Join Date
    Jul 2011
    Location
    India
    Posts
    13
    Hi,

    let talk as per your table column wise.

    Location Column

    as per your location column in the table,i will suggest to take different field for city,state and street number.

    Avg Entree Price

    it will be better if you take this in different column .coz may be your entry fee will be different in future .so take this column in different table with effetive date.

    in this way you need to think about your database and analysis the database and use normilization concept in your database.

    Hope it help

    All the best

Tags for this Thread

Posting Permissions

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