The purpose of this assignment is to expose you to the idea of Entity Relationship Diagrams and how to use Visio. You will be using this tool heavily in the coming semesters.
This diagram is called an Entity Relationship Diagram (ERD) and shows how different tables and data are related to one another. You will learn about how to create these diagrams yourself in Data Concepts but for now we want to be familiar with the different parts of the diagram and how to use Lucidchart.

We would like a way to represent different Terms in this diagram so let's add an entity (table) for that.

"shell" should appear.
"Show attribute types". A new column in the entity will appear.
Name and rename it to Term. This would be the name of our table as well.
name and rename it to TermId.




Nvarchar is the type and the (20) shows the limit of the length. Not all data types will have a limit.

When you click on the Entity, you can drag the yellow circle that lines up with the vertical blue line to change the size of the columns to make text fit in one line.

EnrollmentDetail entity and name it TermId.
TermId attribute a foreign key by right clicking on the name of the attribute and clicking on "Set Foreign Key"
You can also use 'Ctrl + 3' and click and drag the relationship line from TermId in the Term entity to TermId in the EnrollmentDetail entity.

TermId in the Term entity and the other point to TermId in the EnrollmentDetail entity.TermId in Term should be "One and only one" (two vertical lines), and the symbol pointing to TermId in EnrollmentDetail should be "Zero or more" (a crow's foot with a circle).The two vertical lines stand for "one and only one" so we can read the relationship as "An enrollment detail can have one and only one term ID". The crow's stand for "many" so we can read the relationship as "term identities can be used by many enrollment details".
"1 to M" on the label.
"Ctrl + s"
© 2026 Northcentral Technical College