Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2008
    Posts
    117

    Unanswered: Database Design Help as per Excel

    Hello,
    How to design database fields as per excel Attachment?Classic Laundry.zip

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by bharanidharanit View Post
    Hello,
    How to design database fields as per excel Attachment?Classic Laundry.zip
    wow, does that ever look like a homework assignment

    here's how you design a database table --
    Code:
    CREATE TABLE tablename
    ( column1 DATATYPE [NOT] NULL
    , column2 DATATYPE [NOT] NULL
    , column3 DATATYPE [NOT] NULL
    , column4 DATATYPE [NOT] NULL
    , PRIMARY KEY ( column [,column]... )
    );
    what exactly are you having trouble with?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2008
    Posts
    117
    Hi,
    I know to create table, but i am not familiar in creating relationships? I want help in creating relationship.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by bharanidharanit View Post
    I want help in creating relationship.
    between which tables?

    please show the CREATE TABLE statements for the tables that you want to relate
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Nov 2008
    Posts
    117
    Actually i am having trouble in knowing the relationship, which fields to relate between the tables. And so i attached the excel sheet.

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by bharanidharanit View Post
    Actually i am having trouble in knowing the relationship, which fields to relate between the tables. And so i attached the excel sheet.
    yes but the excel sheet does not describe the tables, it's just a bunch of stuff laid out on a grid

    which tables do you want to have?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Dec 2009
    Location
    Antwerp (Belgium)
    Posts
    33
    Well ... if you create a table for "linen" and one for "staff", with quantities for each item and a date, it could make sense to make a relationship on the date field. In that way you could make a report by date.

Posting Permissions

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