What changes are you trying to make? (e.g. Adding or removing code, refactoring existing code, adding reports)

Added SQL queries, ERD diagrams, and Markdown documentation for Assignment 2.

What did you learn from the changes you have made?

I learned how to design logical data models, extend ERDs with new entities and relationships, and apply SQL commands such as JOINs, INSERT, UPDATE, DELETE, and window functions.

Was there another approach you were thinking about making? If so, what approach(es) were you thinking of?

I considered storing shift info directly in EMPLOYEE but created a separate EMPLOYEE_SHIFT_ASSIGNMENT table to maintain normalization and flexibility.

Were there any challenges? If so, what issue(s) did you face? How did you overcome it?

Yes, structuring the UPDATE query with a CTE and COALESCE required several iterations to fix syntax errors. Testing queries in DB Browser helped verify the logic.

How were these changes tested?

I executed all SQL queries in DB Browser and confirmed no errors. Both ERD diagrams were created and validated in draw.io.

A reference to a related issue in your repository (if applicable)

Checklist

• I can confirm that my changes are working as intended