Defining Tables - ERDL Diagram Syntax

  • Simply type the table name followed by a hyphen and then type in your fields
  • Append any schema names. eg. ecommerce.Customer
  • If the table name has spaces, enclose it in double quotes. eg. "Customer Address"

Customer
-
CustomerID int
Name varchar(100)
Address1 string
Address2 string
City string



STUDENT

- Student ID (PK)
- First Name
- Last Name
- Email
- Program

COURSE
- Course ID (PK)
- Course Name
- Units

INSTRUCTOR
- Instructor ID (PK)
- Instructor Name
- Department

ENROLLMENT
- Student
- Course
- Semester
- Grade