≡ Menu

SQL ERD Diagram online AJAX tool

Hi guys i found this online demo tool to sketch your SQL ERD diagrams.
Although supporting only the great MySQL and SQLite and not Oracle or SQL Server, the tool is amazing from the UI design and usability.

{ 10 comments… add one }

  • Lawrence Maina 15/12/2009, 6:00 pm

    Oh my God, I managed to develop a powerful database within just few minutes

  • Furqnaz 28/04/2010, 4:10 am

    Q.Draw the ER diagram of the following schema.

    1.EMP(SSN,Name,Birthdate,Street,City ,DNO,SuperSSN,Salary)-stores information about emloyees,with SSN as key.
    The DNO denotes the department to which they are assignes and the SuperSSN is the SSN of their supervisor.Every employees has a supervisor(assume the CEO has a supervisor with a fictious SSN).

    2.DEPT(DNUM,Dname,MGRSSN)-Stores information about the departments such as the unique departments number,a unique department name(Dname),and the SSN of the department manager(every department must have a manager).

    3.PROJECTS(PNum,Panme,PLocation,DNO)-information about Projects at the Company,with unique Project number(PNO).
    The project has a name and a location and is controlled/managed by a department.

    4.WORKS(ESSN,PNO,Hours)information about the projects that each employees works on the number of hours they works on each project.

    plz solve there queries….

  • yuval 28/04/2010, 9:47 am

    Hi Furqnaz,
    What is the query that you have?
    Are you wishing me just to draw the ERD?
    Is there a logical issue with the structure?

  • wida 30/04/2010, 6:55 pm

    furqnaz question sounds like a typical problem given for homework in database class. i remember [almost] the same design in a database text book by elmasri and navathe

  • yuval 30/04/2010, 8:53 pm

    True, if he only asked for something else then me doing his homework.
    Logic problems are much more satisfying then copying.

  • Aisha 30/12/2010, 7:00 am

    Yuval please please help me in drawing ER diagram of Dell Website please :( ASAP I shall be very thankful to you. .

  • Aisha 30/12/2010, 7:08 am

    Can anyone please help?

  • Aisha 30/12/2010, 7:09 am

    I need to draw an ER diagram for Dell.com online shopping like if a customer purchase any product how do they buy n make payment . . a possible model behind that . . please help me . .

  • ness 11/10/2011, 11:38 pm

    kindly help me in drawing ERD for online ordering system…..please100x asap

  • ness 14/10/2011, 10:47 pm

    kfliefksjfrh38

Leave a Comment