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

    Unanswered: Normalizing from an ERD

    I need to create a relational schema and normalize the ERD that is posted below. However, I'm not really sure where to even start. Could anyone point me in the right directly?


    ERD:
    http://i.imgur.com/2eaJ6.jpg

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by New2IST View Post
    Could anyone point me in the right directly?
    it's really easy

    each of those gray boxes becomes a table

    each of the purple PK columns becomes a PRIMARY KEY

    each of the red FK columns becomes a FOREIGN KEY

    example --
    Code:
    CREATE TABLE video_stores
    ( store_id INTEGER NOT NULL PRIMARY KEY 
    , store_name    VARCHAR(37)
    , store_address VARCHAR(37)
    , store_phone   VARCHAR(37)
    , store_email   VARCHAR(37)
    , other_store_details VARCHAR(37)
    );
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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