EvilZone

Programming and Scripting => Beginner's Corner => : Cr1TH1T February 03, 2015, 09:02:52 PM

: Understanding Entity Relationship Diagraming
: Cr1TH1T February 03, 2015, 09:02:52 PM

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]

: Re: Understanding Entity Relationship Diagraming
: Syntax990 February 03, 2015, 10:31:50 PM

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

: Re: Understanding Entity Relationship Diagraming
: Syntax990 February 03, 2015, 10:50:27 PM

: 2460h1 February 03, 2015, 10:40:43 PM

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.

: Re: Understanding Entity Relationship Diagraming
: Syntax990 February 03, 2015, 11:25:22 PM

: 2460h1 February 03, 2015, 11:17:53 PM

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.

: Re: Understanding Entity Relationship Diagraming
: Sparky712 May 03, 2015, 03:17:24 AM

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