## Question $1$

Draw an ERD $($table style$)$ for a library$$s study room booking database.

In brief, library patrons can book study rooms for non$-$commercial use.

The library holds records of patrons by their pid, first name, last name, and email address.

Study rooms are managed by their room number, number of seats, and multimedia devices.

A typical study room would have a $42-$inch flatscreen, while some rooms are equipped with a projector.

Study room book record includes record id$,$ pid, room number, date, and time.

Please clearly mark each entity's attributes, primary key $($PK$),$ and foreign key $($FK$),$ and cardinalities between entities.

## Question $2$

Normalize the database schema into the third normal form. You may skip the second normal form and get to the third normal form directly. Briefly reason why your normalized schema is in $3$rd normal form. You may add primary keys in decomposed schemas.

The original schema:

Student$\_$id $|$ Date$\_$of$\_$birth $|$ Address $|$ Course$\_1|$ Course$\_2|$ Course$\_3|$ Course$\_1\_$instructor $|$ Course$\_2\_$instructor $|$ Course$\_3\_$instructor $|$ Course$\_1\_$grade $|$ Course$\_2\_$grade $|$ Course$\_3\_$grade $|$ Course$\_1\_$semester $|$ Course$\_2\_$semester $|$ Course$\_3\_$semester