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

    Can anyone help me with my ER Diagram

    I made an ER diagram, but I'm not sure if it's correct. Please analyze and see if I have any errors.

    Here's the code:

    drop table apps;
    create table apps (
    name varchar(30) not null primary key,
    desc varchar(120) not null,
    price float not null,
    seller varchar(30) not null,
    size float not null,
    release date not null,
    category varchar(15) not null
    );

    drop table reviews;
    create table reviews (
    name varchar(30) not null,
    review varchar(120) not null
    );

    drop table ratings;
    create table ratings (
    name varchar(30) not null,
    rating float not null
    );
    Attached Thumbnails Attached Thumbnails er diagram.PNG  
    Last edited by samisawesome; 11-28-12 at 03:36.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    the foreign keys that relate the tables to each other are missing
    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
  •