Let$$s correct our refined data model that you developed in Part $2.$ Review this week's material, and revise $($if necessary$)$ the structure of your database so that it is using DBDL $3$NF$.$ Normalization is important and almost never ending in some cases. This means no repeating fields, no redundant fields and composite fields for many$-$to$-$many bridge tables. Watch the chapter normalization videos, read chapter $5$ definition, and review the articles on the web for normalization. Determine and document the relationships between the tables $($usually one link$/$connection between tables$).$ Finalize your tables to at least three tables and $7-10$ fields per each table. Using different types of fields is helpful if they apply$--$date$/$boolean$/$string and number, etc.$--$data variety helps confirm that you understand the principles. All tables need to be connected with primary keys to foreign keys.

Update your ER Diagram to add Cardinality and incorporate changes that you made since the refined submission. I$\text{'}$m also including my currently compleated portion of the assignment as a pitcure, also for the chart I used lucid charts to create the table. For my idea I$\text{'}$m planning on creating a database that manages the numerous winners of the Game

Awards over the past $4$ years and I chose this idea because of my passion for gaming. I want my project

to be able to be sorted by the game's manufacturer's $($e$.$g$.$ Microsoft, Sony, Nintendo$),$ what category

they received the award in $($Best Gameplay, Best Soundtrack$),$ the game genera $($RPG$,$ fighting game$),$ and

obviously the game's name.

Here is the resulting potential database.

Game Information $($GamelD$,$ GameName, ReleaseDate, ManufacturelD, DeveloperID, GenrelD,

Platform$($D$)$

FK $1$ ManufacturelD $($references Manufacture Table$),$FK $2$ GenrelD $($references Genre Table$),$ FK $3$

PlatformID $($References Platform Table$)$

Award Table $($AwardID$,$ BestGameYear, BestRPG, BestAction, BestFighting, BestStratagy, BestRacing,

BestMultiplayer$)$

Nominee Table $($NomineelD$,$ GamelD, AwardID, Year, ManufacturelD, CategoryID, GenrelD, Winner$)$

FK $1$ GamelD $($references Game Information$)$ FK $2$ AwardID $($references Award Table$)$ FK$3$ ManufactureID

$($references manufacture table$)$ FK$4$ CategoryID $($ References Category Table$)$ FK$5$ GenreID $($references

Genre Table$)$

Manufacture Table $($ManufacturerID$,$ ManufactureName$)$

Category Table $($CategorylD$,$ CatagoryName$)$

Genre Table $($GenrelD$,$ GenreName$)$

Platform Table $($PlatformID$,$ PlatformName$)$