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

ObjectiveTo develop a simple database application using modern programming tools.ToolsStudents should use python as their main development platform. They can also choose either one of the database management systems SQLite, MySQL, PostgreSQL, and Microsoft SQL Server.GuidelinesEach student should agree to work with one student from the class as a teammate. Otherwise, the student works alone and gets penalized by getting at most 75% of the project grade. Teams should work independently toward the same project goal. Each team has to prepare a report presenting all the details about the work done and the job division. The number of pages should not pass twenty.Description of the ProjectThe project is to develop a simple university management system. The application should let three different kinds of users to work, namely, the student, the instructor, and the faculty coordinator. Users should have the following functionalities in the system:Faculty coordinator Log in to the system Add…
Job portal system: This system allows the students to search and apply for jobs etc. online. The manager can use the system for posting and deleting job offers etc. Create your own case study (problem statement) for the above application and 1. Draw the use case diagram 2. Class diagram with at least 4 classes and explain all the relationships 3. Draw a DFD-0 for this application
Design the UML class diagram to support the system below and upload a picture of your diagram. Used Class Material Website: You are designing a website where students can resale their used material for a course. A course may have multiple sections. The course material is specific to each section of a class. Not all course may require class materials, but they may require many of them. A student can have many used materials for sale. The class material can be either: · Textbook: which has a price(mandatory), title(mandatory), authors(optional), edition(optional) · Software: which has a price(mandatory), title(mandatory), publisher(optional), and also its operating system (mandatory) · Equipment: which has a price(mandatory), title(mandatory), description(mandatory) All class material can be either available or sold. Do a class diagram with: 1. all the classes , 2. their associations 3. their multiplicity . 4. For each classes, where are the…
ObjectiveTo develop a simple database application using modern programming tools.ToolsStudents should use Visual studio for their codes and They can also choose either one of the database management systems SQLite, MySQL, PostgreSQL, and Microsoft SQL Server.GuidelinesEach student should agree to work with one student from the class as a teammate. Otherwise, the student works alone and gets penalized by getting at most 75% of the project grade. Teams should work independently toward the same project goal. Each team has to prepare a report presenting all the details about the work done and the job division. The number of pages should not pass twenty.Description of the ProjectThe project is to develop a simple university management system. The application should let three different kinds of users to work, namely, the student, the instructor, and the faculty coordinator. Users should have the following functionalities in the system:Faculty coordinator Log in to the system Add a new…
Job portal system: This system allows the students to search and apply for jobs etc. online. The manager can use the system for posting and deleting job offers etc. 1.Create your own case study (problem statement) for the above application 2.Draw the use case diagram 3.Class diagram with at least 4 classes and explain all the relationships
Rock Series: A site hosts many shows a year. Artists have a name and perform several times in a series (each is a show on a different date). Series have one or more artists and have a series name and a specified seating arrangement. A series is held in one (and only one) of several halls, each of which has a hall number. Represent this situation of shows and artists with an E-R diagram.
Make use-case diagram: The customer wants a system for bike racing registrations where Organizers of eventscan publish races, people who want to race can sign up and the system should also keeptrack of the old races to racers can "level up" and start in higher categories (cat).Racers who officially want to race need to sign up with the system with their name,credit card information. To be able to register for official races they need to buy alicence. The license is always valid for 1 year and has a specific ID and is for the racerscurrent level (cat). Racers are sorted into categories 5-1 where 5 is beginner and 1 isthe best category. Racers can only race in official events if they have the cat required,so they need to race against others their level.Organizers can create races. The interesting part is though that a race can consist ofdifferent stages. E.g. one stage is a road race, the other a criterium and the other atime trial (you can find what these are online). Each stage is on a…
For below given Scenario draw the following UML Diagrams CLASS DIAGRAM SEQUENCE DIAGRAM WEB BASED AUCTION SCENARIO The seller logins and create auction section online for the buyer and provide the following details The Seller is provided with a page where he provides details about product he wants to sell. He specifies a product, category, quantity, end time for the auction, type of auction (multiple items auction or First Price Sealed Bid). He saves the details. the details about the products which are auction. He selects the winner determination algorithm and price determination algorithm. He starts the auction. Again as the Auction first product and he continue the auction until he finish all items.
Hi i got this in my APS class, thanks You are playing a 2 person matchstick game. Players take turns to remove 1, 5 or 6 matches from the pile of matches. We want you to analyse this game, clearly explaining everything you are doing and develop a strategy to ensure that you would always win the game.
Create ERD an Entity and Relationship Diagram for the following application:The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of users Messager Personal information form: It contains a list of the user's personal data…
Create an ER Diagram that describes the following requirement: John is trying to help his price-conscious mother by creating an app that will save the prices of goods in their place. This app will have all the stores in their place that are categorized. Each store will have a name. A store can have multiple categories. There are some stores that have multiple branches. It is possible that other branches will have different prices for their goods or products. The addresses of the branches will also be saved. For every product that his mother wants to monitor, it will be saved in the app . She wants the product’s name to be saved including the product’s variants. She also wants the product to be categorized so that it will be easy to search for specific products. Every time her mother buys something from that store, they will save or update the prices of the items for that branch store. She also wanted to include the date when the prices were updated. With these features, his mother…
A student may register for classes during a specified registration period. To register, a student must see their advisor. The advisor must approve each course that the student has selected. The advisor will use the registration system to determine if the student has met the course prerequisites, is in good academic standings and is eligible to register. If the advisor approves the courses, the advisor enters the student's college id into the course registration system. The course registration number for each course is entered. The course description, course number and section for those courses will automatically display. The system will check for schedule conflicts before saving the registrations. A bill for the courses will print in the Bursar's office. The student should proceed to pick it up. b)Draw a class diagrams which represents the generic objects and relationships described above. Make c)sure to specify multiplicities for all associations shown in your diagrams.----