SQL Training¶
erDiagram
Employees {
int EmployeeID
string LastName
string FirstName
string Grade
}
EmployeeContacts {
string PhoneNumber
int EmployeeID
}
Projects {
string ProjectID
int CustomerID
string Manager
}
Customers {
int CustomerID
string Customer
}
Schedules {
int ProjectID
int EmployeeID
string Date
int Hour
}
Employees ||..|{ EmployeeContacts : has
Employees ||--|{ Schedules : has
Projects }|--|| Customers : ""
Projects ||--|{ Schedules : ""