Also, you will add the additional relations and relationships to the relational

schema you created in Deliverable $1.$ You must maintain $1$st$,2$nd$,$ & $3$rd Normal

Form in this enhanced model. Be sure to list your relations in alphabetical order

and be sure to include the relationships between the relations $($all these lines may

look a little messy$).$ Also, keep in mind that all the relations must be shown flush

left against the left margin of the page and in alphabetical order. Be sure to use the

correct capitalization formatting with RELATION names being singular and, in

ALL CAPS, while attributes are presented using Proper Camel notation.

Remember that this logical schema is a listing of the relations and relationships,

and it is not in the same format as an ERD.

Begin with the initial entities for REGION, STORE, PRODUCT, CUSTOMER,

and VENDOR provided above, transform them into RELATIONS. Realize that

the five entities $($or the five converted relations$)$ are not in $3$rd Normal Form. This

is obvious by the many$-$to$-$many relationship that would need to exist between

STORE and CUSTOMER and the relationship between STORE and PROJECT.

Make sure to show the referential integrity constraints diagram $($see figures $4-3$ &

$4-5$ in your textbook$)$

You are to do the steps necessary to obtain $3$rd Normal Form. You do not have to

show how you got there, but you are to provide a document that shows the final

relations you come with $($and their relationships$)$ once you have achieved $3$rd

Normal Form. Hint: Your answer will be within the Word document you submit as

your Project $1$ Assignment response along with the other deliverables for this

assignment. Be sure to format this showing the logical schema $($Rectangle boxes

for relations in alphabetical order and lines between the relations to indicate the

relationships$).$ This format is NOT an ERD. Make sure it includes proper

formatting and capitalization, as well as the appropriate relationships.