Suppose you are given the following requirements for a simple database for the Oman National Hockey Team (ONHT): The ONHT has many teams, Each team has a name, a city, a coach, a captain, and a set of players, Each player belongs to only one team, Each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records, A team captain is also a player, A game is played between two teams (referred to as host_team and guest_team) and has a date (such as June, 12th, 2021) and a score (Such as 6 to 4). Construct a clean and concise ER diagram for the ONHT database.

Suppose you are given the following requirements for a simple database for the Oman National Hockey Team (ONHT): The ONHT has many teams, Each team has a name, a city, a coach, a captain, and a set of players, Each player belongs to only one team, Each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records, A team captain is also a player, A game is played between two teams (referred to as host_team and guest_team) and has a date (such as June, 12th, 2021) and a score (Such as 6 to 4). Construct a clean and concise ER diagram for the ONHT database.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

Suppose you are given the following requirements for a simple database for the Indian Premier League (IPL): a. the IPL has many teams, b. each team has a name, a city, a coach, a captain, and a set of players, c. each player belongs to only one team, d. each player has a name, a position (batting order), a skill level (such as batsman, bowler, AL rounder), and a set of injury records,e. a team captain is also a player, Construct a clean and concise ER diagram for the IPL database.
Suppose you are given the following requirements for a simple database for the football League (FL): the FL has many teams, each team has a name, a city, a coach, a captain, and a set of players; 24 players, each player belongs to only one team, each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records, • a team captain is also a player, • a game is played between two teams ( 2020) and a score (such as 4 to 2). host team and guest team) and has a date (such as May 11th, 1- Construct a Database Conceptual Model using UML ER diagram for the FL database. 2- Use mapping rules to convert the design to Logical database model using UML ER model. 3- Check the entities to be in the 3NF normal form. 4. Write the needed SQL Statements to create the database.
Suppose you are given the following requirements for a simple database for the football League (FL): the FL has many teams, each team has a name, a city, a coach, a captain, and a set of players; 24 players, each player belongs to only one team, each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records,  a team captain is also a player, a game is played between two teams (host team and guest team) and has a date (such as May 11th, 2020) and a score (such as 4 to 2). Construct a Database Conceptual Model using UML ER diagram for the FL database. Use mapping rules to convert the design to Logical database model using UML ER model. Check the entities to be in the 3NF normal form. Write the needed SQL Statements to create the database.
Suppose you are given the following requirements for a simple database for the football League (FL): the FL has many teams, each team has a name, a city, a coach, a captain, and a set of players; 24 players, each player belongs to only one team, each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records, · a team captain is also a player, a game is played between two teams (host team and guest team) and has a date (such as May 11th, 2020) and a score (such as 4 to 2). Construct a Database Conceptual Model using UML ER diagram for the FL database. Use mapping rules to convert the design to Logical database model using UML ER model. Check the entities to be in the 3NF normal form. Write the needed SQL Statements to create the database.
Suppose you are given the following requirements for a simple database for the National Hockey League (NHL): the NHL has many teams, each team has a name, a city, a coach, a captain, and a set of players, each player belongs to only one team, each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records, a team captain is also a player, a game is played between two teams (referred to as host team and guest team) and has a date (such as May 11th, 2019) and a score (such as 4 to 2). Construct a concise ER diagram for the NHL database.
Words:0 Path: p QUESTION 13 Suppose you are given the following requirements for a simple database for the Oman National Hockey Team (ONHT): . The ONHT has many teams, . Each team has a name, a city, a coach, a captain, and a set of players, Each player belongs to only one team, • Each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records, . A team captain is also a player, • A game is played between two teams (referred to as host team and guest team) and has a date (such as June, 12th, 2021) and a score (Such as 6 to 4).
Suppose you are given the following requirements for a simple database for the National Football League (NFL): the NFL has many teams, each team has a name, a city, a coach, a captain, and a set of players, each player belongs to only one team, each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records, · a team captain is also a player, a game is played between two teams (referred to as Home Team and Guest team) and has a date (such as May 11th, 1999) and a score (such as 4 to 2) Instructions: Use the Case Study above to complete the following tasks 1. Identify the objects (entities) and attributes based on the information provided in the case study
You are asked to design a database for an University. This particular university has multiple departments. Each department in that university offers one or more courses to the students. All the students are part of a certain department and they take courses in that department. A department has a name, unique number and chairman. The courses have a name, a course number such as ‘311’ , a credit point value, and the year it commenced. A course cannot be identified uniquely with the course number, but the course number is unique for each department. Students have given names, surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes a course the year and the semester he or she took that particular course is recorded. When he finishes the course , the grade and total marks are recorded. A student can take multiple courses but they are also allowed to drop a semester in that university by taking no courses. Construct an ER diagram using the requirements…
Your task is to develop a database, in order to keep information on all sales at a motorcycle dealership. The database will include information on motorcycles, salespeople, sales, and customers. We assume for simplicity that the dealership sells only new motorcycles and that all motorcycles are produced by the same manufacturer. Each kind of motorcycle is called a model, and it has a unique model number. For each model, you want to store also its name, engine size in cubic centimeters (cc) which is an integer number, and the date when this particular model was introduced. For each salesperson, you want to store their employee ID number, first name, middle initial, last name, and the date when the employee was hired. For each customer, you want to store a customer ID number, first name, middle initial, last name, address information (city, state, and zipcode), phone number (given in standard US format), and e‐mail address. Assume that you do not have a zip code table available. Each…
Consider the following information about a Pakistan Super League(PSL) database: The PSL has many teams Each team has a name, a city, a coach, a captain, and a set of players Each player belongs to only one team Each player has a name, a position (such as Bowler or Batsman), a skill level, and a setof injury records A team captain is also a player A game is played between two teams (referred to as host_team and guest_team) and has a date (such as May 11th, 1999) and an outcome (Winner Name or Draw). Draw an ER Diagram according to the above requirements.
You are to design a Hospital database. So before creating the database, your task is to draw the ER diagram based on the following data collected and analyzed: A hospital will have a name, unique id, multiple helpline numbers (one for doctor's appointment, one for ambulance, one for bill information and one for other services' info) and locations. A hospital may have more than one location as it may have different branches and each of the locations will have a building no., street address, road no. and city name. A patient will have a name, unique ID, may have more than one phone number, age, height, weight and symptoms. A patient takes an appointment in a hospital and the appointment date is recorded. A patient may have an attendant. An attendant will have his/her name, contact numbers and relationship with the patient as a record in the database. Due to the covid situation, the hospital authorities will only allow 1 attendant with 1 patient.
Bundoora College has a small book store that opens for students, staff and general public. Currently, they use a manual order system. The manager asked you to build a database for them. You had an interview session with him and you get a general overview about the database requirements. The database should store: Orders information made by students, staff or general public. The order should have order number, the date and the time it is made. Customers details, so that the manager can notify the customers with the order status as well as send promotional material. The detail includes customer code, the full name, home address, contact phone number, and email address. List of the items in each order. The items can be books and/or stationeries. For each book, you should be able to include the details such as the title, the authors, the ISBN, and the price. For stationery, you should have the code, description, and price. If a book is required for a particular subject offered in…