Step 1: Setting up your DBMS

MS Access

Although MS Access may not be classed as "industry standard", it is an effective tool to use in order to help you deploy your database design. For this lesson you may want to firstly create an Access database in order to practice setting up your tables, fields and relationships before moving onto MySQL.

Below is an example Entity Relationship Diagram for enrolling a student. Notice that the relationship doesn't link STUDENT to COURSE. This is because the relationship is a many-to-many which needed to be resolved. We will look at this later when we begin to model the ERD.

ERD for enrolling a student
ERD example modelled in MS Access

Comment Stream