Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2009
    Posts
    4

    Normalised database?

    hi guys, im new to this and was just wondering if someone would be so kind as to help me out and tell me if my database is fully normalised? I have also attached an ER diagram which i feel is completely wrong but i just cant think of any other way to do it. Any suggestions or constructive criticism would be much appreciated.

    Thanks in advance.
    Attached Thumbnails Attached Thumbnails RelationalSchema.jpg   erdiagram.jpg  

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    if this is for a homework assignment, you've got a couple of small issues

    the relationship between cars and sold cars is weird -- the PK of cars is not being used as the FK of sold cars

    it's not just a 1-to-1 relationship, either, as a car can usually (in real life) be sold more than once

    also, the column "Sold" at the bottom of the cars table seems out of place in light of the sold table

    the doors table seems pretty useless, unless you were planning to use it to restrict cars from the database which did not have an approved number of doors

    finally, please don't embed "tbl" into your table names -- that's just silly

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2009
    Posts
    4

    Thanks

    Thanks for the reply, it is very much appreciated. One final question. Which of the two diagrams, er diagram or relational schema diagram would come first in the design stage of a database?

    P.S. its actually for a small project which i have to create.

    Thanks again.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    It is your project. Don't you get to decide which diagram comes first? Think about the order that you want to present the information to your audience, that is the order that I'd include the diagrams in the project presentation.

    -PatP

Posting Permissions

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