Beginner - how to draw a relational database (plan)

Discussion in 'Database' started by Databasesfordummes, Nov 6, 2012.

  1. Databasesfordummes

    Databasesfordummes New Member

    Joined:
    Nov 6, 2012
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Hi,

    What do people mean when they say to "draw a database"?

    I need to draw a relational database and I'm a absolute beginner. I'm not sure what is meant by the word draw? I was going to either write/draw it out but I downloaded MySQL in case it would be useful.

    Where do I start with this? Do I need to just write out the titles of all the different areas of info that I need or do I draw almost a mindmap type of plan where I say that, for example, a name is connected another piece of info and so on. How do I differentiate between what goes under primary key, secondary key, entity(?) etc or do I even need to go in to that much detail if it's just an initial drawing of the database.

    Thank you for your suggestions and for your patience with my lack of skills!

    :worried:
     
  2. Databasesfordummes

    Databasesfordummes New Member

    Joined:
    Nov 6, 2012
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    84 views and no suggestions yet - uhoh! If anyone could give any suggestions, even a quick pointer as to what a plan entails or should look like. I have no idea where to start, so any suggestions at all, even for databases in general, would be great :)

    I also have no idea how to use "MySql", so the basic steps of setting up things and what the basic buttons mean would also be really helpful, as reading about it on the net is so confusing!

    Thanks again.
     
  3. state

    state New Member

    Joined:
    Sep 14, 2011
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    0
    Hello Databasesfordummies
    Drawing means drawing.You can draw an ER diagram depicting the relationship between the entities and also depict the attributes associated with them.There are tons of other things you can do.
    http://creately.com/blog/diagrams/er-diagrams-tutorial/
    All the Best
     
  4. Juliette

    Juliette New Member

    Joined:
    Jul 10, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    ER diagrams (entity-relationship diagrams) are a great why to draw a database. Being a beginner I would suggest using Lucid Chart to do this. They are so easy to use and very professional. Go look up Lucidchart ER diagrams, it's very helpful!
     
  5. sachin

    sachin New Member

    Joined:
    Sep 13, 2014
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    stilll student
    Location:
    andhra pradesh
    Dear experts i am getting very valuble suggestions from u all .now i got challenge infront of me. i got my college project for creating a windows application software of about student details i.e, it should be able to display his all details about from his residential address to college profile about NAME,R.NO:,HIS MARKS,ATTENDANCE etc.etc.what i need from u is we have an overview of about creating application but i don't know how to interface it with linking them from various departments of college for example to update marks list,mobile number to change the marks or number etc .how the database should be created.how to create link between them .we are total four members of team.is it possible to do our project complete in 50 days. plz anything i wrongly mentioned forgive me .give any information about this .i am expecting a lot from u.
    thank you friends.
     
  6. rutu12

    rutu12 New Member

    Joined:
    Feb 6, 2015
    Messages:
    19
    Likes Received:
    1
    Trophy Points:
    0
    Occupation:
    Self employee
    Location:
    India
    Home Page:
    http://getsarkarinaukri.co.in/
    Great suggestions .
    This forum is really helpful to learn new things about programming
     
  7. mialuzzatto

    mialuzzatto New Member

    Joined:
    Aug 5, 2015
    Messages:
    122
    Likes Received:
    5
    Trophy Points:
    0
    Occupation:
    Work at https://www.idevelopersquare.com
    Location:
    Waltham, MA, USA
    Home Page:
    https://www.idevelopersquare.com
    Hello,

    You can choose to use the Block Diagram and the Basic Drawing Shapes to draw your database model diagrams, but since there is a special template for Database Model diagram, we will look at that first. Open the Entity Relationship template and object relationship template from the ERD & Database category. For a quick start, on the Libraries menu, point to ERD & Database item, and then click Entity Relationship and Object Relationship item.
     
  8. vickya4n

    vickya4n New Member

    Joined:
    Aug 23, 2016
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Gender:
    Male
    Simple tutorial help you learn how to draw a database model diagram for your ... Open the EntityRelationship template and object relationship template from the ... floor plans, workflows, fashion designs, UML diagrams, electrical diagrams, ...
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice