Question: 2) (80p) Games Tech is a games developing company. They organize events to show their products to potential clients during the event. They want to

2) (80p) Games Tech is a games developing company. They organize events to show their products to potential clients during the event. They want to build a database that track the following: For each game developer: unique d unique soy, and the name (composed of first name and last name) For each potential client:( (unique), name and multiple phone numbers Each project manager. Unique SSN as well as name (composed of first and last) For each game: game id(unique), date of the release, price For each event, the id(unique), location and the date One developer can develop many games, and one game can be developed by many developers Clients can buy one or many games and one game can be bought by many clients. The company only tracks the clients who decide to buy its products. Each project manager supervises the creation of many games but one game can only be managed by one (min) or two (max) project managers. The company would keep track of the date when a project manager supervises the creation of the game. Each developer can attend to many events and they have to attend to some. Each event must host 1 or 2 developers. The system will not keep track of those shows that do not host any developer. Draw the E/R diagram (40 points) and the Database diagram (40 points) 2) (80p) Games Tech is a games developing company. They organize events to show their products to potential clients during the event. They want to build a database that track the following: For each game developer: unique d unique soy, and the name (composed of first name and last name) For each potential client:( (unique), name and multiple phone numbers Each project manager. Unique SSN as well as name (composed of first and last) For each game: game id(unique), date of the release, price For each event, the id(unique), location and the date One developer can develop many games, and one game can be developed by many developers Clients can buy one or many games and one game can be bought by many clients. The company only tracks the clients who decide to buy its products. Each project manager supervises the creation of many games but one game can only be managed by one (min) or two (max) project managers. The company would keep track of the date when a project manager supervises the creation of the game. Each developer can attend to many events and they have to attend to some. Each event must host 1 or 2 developers. The system will not keep track of those shows that do not host any developer. Draw the E/R diagram (40 points) and the Database diagram (40 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
