You will:

$1.$ Create a well$-$prepared discussion post and,

$2.$ Respond to three other people's discussion posts in a way that continues the discussion on the design principles.

Criteria:

$1.$ Your initial discussion post should identify the case study you selected and give a summary of the overall database design.

$2.$ You should explain the relationships between the tables, the primary keys, the foreign keys, and any other notes of interest. What are the entity classes? How were attributes decided upon? What is the key idea for each use case?

$3.$ You should comment on how the designer used normalization to achieve a database that has referential integrity and non$-$redundancy.

$4.$ You should provide one method for joining the tables that are in the design $($some might not have this possible, so please select a case study where this is an option$).$ In other words, how would you start writing queries to these databases? Provide some thought and thinking about where you would get started.

You will also need to make sure that your post is grammatically correct and free of errors in English. Initial posts should be about $2-3$ paragraphs plus any supporting information that might happen in bullets.