Create Entity-Relationship diagram for Assisted Living facilities.

College

CollegeID int No

CollegeName nvarchar(100) No

CollegeDescri... nvarchar(MAX) Yes

CollegeEstabli... datetime Yes

CollegeRegistr... datetime Yes

AddressID int Yes

CreatedDate datetime No

LastModifiedBy nvarchar(50) No

LastModifiedD... datetime No

Column Name Condensed Type Nullable

Departments

DepartmentId int No

DepartName nvarchar(50) No

DepartmentDe... nvarchar(MAX) Yes

CollegeID int Yes

CreatedDate datetime No

LastModifiedBy nvarchar(50) No

LastModifiedD... datetime No

Column Name Condensed Type Nullable

Roles

RoleID int No

RoleCode nvarchar(50) Yes

RoleDescription nvarchar(MAX) Yes

CreatedDate datetime No

LastModifiedBy nvarchar(50) No

LastModifiedD... datetime No

Column Name Condensed Type Nullable

Users

UserID nvarchar(50) No

HintQuestions nvarchar(50) Yes

HintAnswers nvarchar(50) Yes

UserPassword nvarchar(50) Yes

RoleID int Yes

EmailID nvarchar(MAX) Yes

CreatedDate datetime No

LastModifiedBy nvarchar(50) No

LastModifiedD... datetime No

Column Name Condensed Type Nullable

Instructors

InstructorId int No

FirstName nvarchar(50) No

MiddleName nvarchar(50) Yes

LastName nvarchar(50) No

DepartmentID int No

DOB datetime No

HireDate datetime No

AddressID int Yes

CreatedDate datetime No

LastModifiedBy nvarchar(50) No

LastModifiedD... datetime No

UserID nvarchar(50) Yes

Column Name Condensed Type Nullable

Address

AddressID int No

AddressLine1 nvarchar(50) Yes

AddressLine2 nvarchar(50) Yes

AddressLine3 nvarchar(50) Yes

City nvarchar(50) Yes

Strate nvarchar(50) Yes

ZipCode nvarchar(50) Yes

Country nvarchar(50) Yes

CreatedDate datetime No

LastModifiedBy nvarchar(50) No

LastModifiedD... datetime No

Column Name Condensed Type Nullable

1-1

Course

CourseID int No

CounseName nvarchar(50) Yes

ProgramID int Yes

CourseDescrip... nvarchar(MAX) Yes

CourseHours int Yes

CreatedDate datetime No

LastModifiedBy nvarchar(50) No

LastModifiedD... datetime No

Column Name Condensed Type Nullable

Programs

ProgramID int No

ProgramName nvarchar(50) No

ProgramDescr... nvarchar(MAX) Yes

ProgramHours int Yes

ProgramType nvarchar(50) Yes

CreatedDate datetime No

LastModifiedBy nvarchar(50) No

LastModifiedD... datetime No

Column Name Condensed Type Nullable

ProgramSchedules

ProgramSche... int No

ProgramID int Yes

ScheduleStart... datetime Yes

ScheduleEndD... datetime Yes

InstructorID int Yes

CreatedDate datetime No

LastModifiedBy nvarchar(50) No

LastModifiedD... datetime No

Column Name Condensed Type Nullable

StudentEnrollments

StudentEnroll... int No

StudentID int Yes

EntrollmentYear int Yes

Term nvarchar(10) Yes

FinalGrade nvarchar(10) Yes

MidTermGrade nvarchar(10) Yes

CourseID int Yes

CreatedDate datetime No

LastModifiedBy nvarchar(50) No

LastModifiedD... datetime No

Column Name Condensed Type Nullable Students

StudentId int No

FirstName nvarchar(50) No

LastName nvarchar(50) Yes

MiddleName nvarchar(50) No

Gender nvarchar(1) Yes

DOB datetime No

UserID nvarchar(50) Yes

AddressID int Yes

CreatedDate datetime No

LastModifiedBy nvarchar(50) No

LastModifiedD... datetime No

Column Name Condensed Type Nullable

StudentProgramRegistration

StudentProgra... int No

ProgramSche... int Yes

StudentEnroll... int Yes

MidtermGrade nvarchar(10) Yes

FinalGrade nvarchar(10) Yes

CreditHours int Yes

TotalAttendan... int Yes

CreatedDate datetime No

LastModifiedBy nvarchar(50) No

LastModifiedD... datetime No

Column Name Condensed Type Nullable

2-1