Question A2 Consider the following business rules: 1. Each game company creates several games for players. Each company has a company ID and company name. Each player has a player ID and player name. Each game has a game ID and game name. 2. Each game is created by one company. 3. All games can be played by multiple players at the same time. 4. Every player can play as many games as they like. 5. There is no collaboration among the game companies. (a) Draw a basic entity relationship diagram (without attributes) which reflects the above business rules using Crow's Foot notation. (b) Assume you are building the above data model in Microsoft Access, identify those attributes which are necessary with appropriate domain and write the SQL statements that create those tables in the database which implement the relationships in part (a) of this question

Question A2 Consider the following business rules: 1. Each game company creates several games for players. Each company has a company ID and company name. Each player has a player ID and player name. Each game has a game ID and game name. 2. Each game is created by one company. 3. All games can be played by multiple players at the same time. 4. Every player can play as many games as they like. 5. There is no collaboration among the game companies. (a) Draw a basic entity relationship diagram (without attributes) which reflects the above business rules using Crow's Foot notation. (b) Assume you are building the above data model in Microsoft Access, identify those attributes which are necessary with appropriate domain and write the SQL statements that create those tables in the database which implement the relationships in part (a) of this question

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Complete the statements below:
Complete the statements below:
Use Python to draw the pattern in the picture.
A computer loses the date when you shut it down at night, so you have to input it again in the morning. How do you fix the issue and what is it?
Example1: Find f(x) = x + ² + ³ + 4 + · 3 through input command. Use while loop. MATLAB ........ for 10 terms, inputs x
How can I get my Python files from Blackboard and save them to send to my professor?
84. What is the result of the expression:0x35 | 0x75 a. 115 b. 116 c. 117 d. 118
Computer Science Solve it as soon as possible only if know wrong answer dislike
It says that it does not work and I still get an error
DO NOT COPY FROM OTHER WEBSITES Correct and detailed answer will be Upvoted else downvoted. Thank you!
Write a program to create a countdown timer.
Asap!!