Consider a video game store. For each game, the database contains information about title, producing company name, designer(s) name(s), version of the game, type of the game and characters in the game. For each character in the game, it contains the character's name. The video games may be available at the store in different formats. Different formats may have different prices. Each game and format has a status indicating whether it is discontinued or not.
1. Draw the ER diagram for the database described above.
2. Create a relational database schema for this model assuming
a) Each video game in the database is available at the store in exactly one format.
b) Some video games in the database may not be available at the store and others may be present in more than one format.
Provide the name of the table, primary key, and other attributes for each table in your solution. Think intelligently between various choices available to map the E/R diagram to relations, to get best design for the problem in hand. Minimize the use of NULLs. Your representation will be evaluated based on correctness and succinctness.