Given the following database design (see pdf attached):

1. CREATE a Database called 'HighlineUniversity'. Assume appropriate data types for the attributes.
2. INSERT atleast THREE records/rows per table. More rows are okay if it helps to capture foreign key relationships better.
3. Execute ANY 'UPDATE' on the Department Table.
4. Execute ANY 'DELETE' on the Student Table.
5. Execute ANY 'MODIFICATION' on the Professor Table.
6. Identify any entity (that is, an individual/a department/a college etc) and create a personalized outlook of the database from their perspective strictly

Transcribed Image Text:

COLLEGE College D DeanLastName DeanFirstName Building PhoneNumber --ConsistsOf/Consistedin PK PK DEPARTMENT FK College D DepartmentName FK ProfLastName FK ProfFirstName Building PhoneNumber TotalStudentsEnrolled * * Enrolls/Enrolledin STUDENT StudentFirstName Student Number StudentLastName FK Enrollment Date Fx DepartmentName FK ProfLastName ProfFirstName Chairs/Chaired By PROFESSOR ProfLast Name ProfFirstName Building PhoneNumber -Advises/AdvisedBy COLLEGE College D DeanLastName DeanFirstName Building PhoneNumber --ConsistsOf/Consistedin PK PK DEPARTMENT FK College D DepartmentName FK ProfLastName FK ProfFirstName Building PhoneNumber TotalStudentsEnrolled * * Enrolls/Enrolledin STUDENT StudentFirstName Student Number StudentLastName FK Enrollment Date Fx DepartmentName FK ProfLastName ProfFirstName Chairs/Chaired By PROFESSOR ProfLast Name ProfFirstName Building PhoneNumber -Advises/AdvisedBy