Understanding Entity Relationship Diagraming

[Cr1TH1T]

I just wanted to post what I have learned about ERD on here to see if I am correct so far.

Students Student ID First Name Last Name Address City State Zip Code E-Mail[/l][/l][/l][/l][/l][/l]

   
   

• • 
    

    Registration Student ID Course ID Registration Date

    
    
    

    Graduate Student ID Undergraduate Graduation Form Undergraduate Major Undergraduate GPA

    
    
    

    Undergraduate Student ID High-School Graduation Form High-School Grade Point Average

    Courses Course ID Course Name Course Designation Semester ID Location

    
    
    
    The glowing Attributes are the Primary Key's for the ERD. I am currently working on the diagram for this project so I will post it once it's finished. I will be using crow's feet notation.

EDIT:




I am going to post a diagram today. I use both Oracle Academy and Access as well as Visio. I use the 2013 edition.





Additional Edit:


The File Name is University and is posted.
[/list]

[Syntax990]

Rather than just talking about pure concept, why not upload the MircosoftAccess database file? That would be more credible than what is currently provided.

[Syntax990]

but why do you assume he's using Microsoft Access??

The content of his wording suggests he's studying this in college. I don't know any college doing database design that uses libreoffice base or some other database modeler.

[Syntax990]

Well, mine for starters did? We were taught using Oracle/MySQL in my database design course. Seems to me that would be the better way to learn. Who the hell still uses MS Access for any serious dbms?

I don't make the rules up, the educational institute people do.

[Sparky712]

My Uni defnitely introduced this with MySql. with the 'weak' people in the class using PHPMyAdmin to build the DB.