Your marketing research firm has been engaged by a major food supplier to aid them in analyzing cereal breakfast food sales.

Certain attributes of the cereals and the stores in which they are sold are of special interest to the client.

Cereals

Size $($grams$)$

Cost $($per $100$ grams$)$

Sweetness $($sugar per $100$ grams$)$

Stores

Socio$-$economic scale

Geographical code

Store size $($square meters$)$

Having concluded the system analysis phase, your firm is ready to begin gathering data. You have been asked to come up with a preliminary design for a relational database design.

$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.