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

I added answers to the assignment "Design a Logical Model" in a Markdown file. This includes:

• An entity-relationship diagram (ERD) illustrating the logical model for a small bookstore with employee, order, sales, customer, book entities, and a date table.
• Another ERD that contains everything the first one does, plus a new entity for Employee Shifts (morning/evening) and its relationship to Employee.
• Two additional diagrams (embedded using Mermaid) showing two architectures for customer addresses (type 1 and type 2 slowly changing dimensions).
  I've also added two image files of the ERDs to the repository.

What did you learn from the changes you have made?

I learned how to design a logical model incorporating various entities and relationships that a bookstore would need. This involved exploring the difference between overwriting vs. retaining changes in customer addresses (type 1 vs type 2 slowly changing dimensions) and considering how employee shifts could be modeled.

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

I considered using more complex relationships and additional entities in the ERD, such as adding Payments, or making explicit the distinction between Title (the concept of a book) x Edition x Book (the physical thing). However, I decided to keep it simple and aligned with the assignment requirements.

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

The challenge was ensuring that the ERD remained reasonably sized while capturing all necessary relationships and ensuring normalization. Another challenge was deciding how to model customer addresses using type 1 vs. type 2 dimensions. I researched and tried a few approaches, ultimately opting for a simple but effective solution for each scenario.

How were these changes tested?

I reviewed the logical model to ensure consistency and checked the relationships between entities. I also compared my ERD with the AdventureWorks schema, highlighting differences as requested in the assignment.

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

N/A.

Checklist

• I can confirm that my changes are working as intended