Kanban Board Project 2 Logical Data Modeling

Learning and practicing logical data modeling

Conceptual Data Modeling ERD

First, we go through the conceptual data modeling process, and then proceed with logical data modeling using this ERD.

Logical Data Modeling ERD

What was a bit challenging was having to consider the relationship between both tables based on the mapping table.

After converting the Conceptual Data Modeling ERD into a table format, we proceed with normalization.

Normalization

The normalization steps must be carried out sequentially. Looking at the ERD above, it satisfies the 1st Normal Form.

To satisfy the 2nd Normal Form, we create a table for the Tag in the Ticket table and use the primary key of that tag as a foreign key.

Now, we need to check if it satisfies the 3rd Normal Form, but I find it difficult because I haven't fully grasped the concept yet.
I'm wondering if I should separate the author_id and responsibility_id in the Ticket table into other tables. However, it's not an N:M relationship, and it's a foreign key, so I decided to move on.