Task $1$: Database Design $(10$ points$)$

Create a design.pdf file which includes the following information:

Provide your relational schema definitions in text form, including the attributes for each relation and the types of all the attributes. Make sure to clearly indicate your chosen keys $($including

primary and foreign$).$ You are allowed flexibility on the exact attribute types you use for your schema, as long as they reasonably match the specification above $($e$.$g$.,$ in terms of number types,

string types$).$

Your schema should at least include:

Student table with student information

Course table with course details

Prerequisites table to track course prerequisites

Schedule table to track course meeting times and locations

Professor table with professor information

Teaching table to track which professor teaches which courses

Enrollment table to track student course enrollment

Provide an Entity$-$Relation $($ER$)$ diagram that describes your schemas.

I need the ER diagram