Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009
    Posts
    2

    Post Is My Database Design Well Structured? - Beginner RDBMS Question

    First of all, i'm glad to be part of your forum members! Hi to everybody...

    ****************************************

    * represents primary key

    As far as i see, this design is good. I need your confirmation I followed 1NF, 2NF, 3NF, and one to many relationships guidelines.

    -Seller Table {*SellerID, first name, last name, address, city, CountryID (foreign key), phone number, date hired}

    -Customer Table {*CustomerID, first name, last name, address, city, CountryID (foreign key), SellerID (foreign key) }

    -Car Table {*CarID, manufacturer, model, car year}

    -Purchased Car Table {*CarID (foreign key), *CustomerID (foreign key), date purchased }


    -----

    These tables have multivalued fields...

    Country Table {*CountryID, country name}

    A customer can store several phone number (home, cell, work):

    Phone Table {*PhoneID, CustomerID (foreign key), phone number}
    Last edited by peace2009; 08-02-09 at 14:21.

  2. #2
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Quote Originally Posted by peace2009
    These tables have multivalued fields...
    Relational databases are never multi-valued. Attributes are always single-valued attributes. Perhaps you meant something different though and if so then maybe you could clarify what you mean.

    I think your design is a reasonable first attempt. You might want to reconsider possible dependencies between the Address, City, Country attributes.

  3. #3
    Join Date
    Aug 2009
    Posts
    2
    Quote Originally Posted by dportas
    Relational databases are never multi-valued. Attributes are always single-valued attributes. Perhaps you meant something different though and if so then maybe you could clarify what you mean.

    I think your design is a reasonable first attempt. You might want to reconsider possible dependencies between the Address, City, Country attributes.
    maybe you could clarify what you mean:

    You are right. I meant country field will have a drop list that contains country names, so basically the field will end up having one value.

Posting Permissions

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