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

    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
    Toronto, Canada
    the foreign keys that relate the tables to each other are missing | @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