Case Study: National Football League (NFL) 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 2. Create a Data Model to reflect the entities and relationship determined (you can use Draw.10) 3. Create a database called dbNFL 4. Create the tables in your database 5. Add at least two records for each table created 6. Transaction Log :Write a SQL script/statement to check the log file for the newly created database to check what processes and steps SQL Server took to create the database and table.

Case Study: National Football League (NFL) 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 2. Create a Data Model to reflect the entities and relationship determined (you can use Draw.10) 3. Create a database called dbNFL 4. Create the tables in your database 5. Add at least two records for each table created 6. Transaction Log :Write a SQL script/statement to check the log file for the newly created database to check what processes and steps SQL Server took to create the database and table.

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

ER Modeling 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, 1999) and a score (such as 4 to 2). Draw the ER diagram to represent the above scenario
A record company wishes to use a computer database to help with its operations regarding its performers, recordings and song catalogue.• Songs have a unique song number, a non-unique title and a composition date. A song can be written by a number of composers; the composer’s full name is required. Songs are recorded by recording artists (bands or solo performers). A song is recorded as a track of a CD. A CD has many songs on it, called tracks. CDs have a unique record catalogue number, a title and must have a producer(the full name of the producer is required). Each track must have the recording date and the track number of the CD.• A song can appear on many (or no) CDs, and be recorded by many different recording artists. The same recording artist might re-record the same song on different CDs. A CD must have only 1 recording artist appearing on it. CDs can be released a number of times, and each time the release date and associated number of sales is required?
Use the following instructions below to construct a crows foot erd please 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
Project Synopsis: DATABASE MANAGEMENT:ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system. Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic…
in pharmacies in Turkey, it was decided to use a shared database. You have been assigned to design a database. You are given the following information:Patients are identified by their personal number and you need a record of their first name, last name, address and age. Each patient is assigned a primary doctor (family doctor).Doctors check the patients. They are identified by their registry numbers. You also need their first name, surname, specialty and years of experience. Every doctor has at least one patient. Doctors prescribe medication for patients. A doctor may prescribe one or more medications for several patients, and a patient may receive prescriptions from several doctors. Each prescription has a date and an amount associated with it. If a doctor prescribes a medicine more than once for a patient, all prescriptions must be kept.Each pharmaceutical company is identified by name and has a telephone number. Trade name and formula should be recorded for each drug. Each drug is…
in pharmacies in Turkey, it was decided to use a shared database. You have been assigned to design a database. You are given the following information:Patients are identified by their personal number and you need a record of their first name, last name, address and age. Each patient is assigned a primary doctor (family doctor).Doctors check the patients. They are identified by their registry numbers. You also need their first name, surname, specialty and years of experience. Every doctor has at least one patient. Doctors prescribe medication for patients. A doctor may prescribe one or more medications for several patients, and a patient may receive prescriptions from several doctors. Each prescription has a date and an amount associated with it. If a doctor prescribes a medicine more than once for a patient, all prescriptions must be kept.Each pharmaceutical company is identified by name and has a telephone number. Trade name and formula should be recorded for each drug. Each drug is…
in pharmacies in Turkey, it was decided to use a shared database. You have been assigned to design a database. You are given the following information:Patients are identified by their personal number and you need a record of their first name, last name, address and age. Each patient is assigned a primary doctor (family doctor).Doctors check the patients. They are identified by their registry numbers. You also need their first name, surname, specialty and years of experience. Every doctor has at least one patient. Doctors prescribe medication for patients. A doctor may prescribe one or more medications for several patients, and a patient may receive prescriptions from several doctors. Each prescription has a date and an amount associated with it. If a doctor prescribes a medicine more than once for a patient, all prescriptions must be kept.Each pharmaceutical company is identified by name and has a telephone number. Trade name and formula should be recorded for each drug. Each drug is…
in pharmacies in Turkey, it was decided to use a shared database. You have been assigned to design a database. You are given the following information:Patients are identified by their personal number and you need a record of their first name, last name, address and age. Each patient is assigned a primary doctor (family doctor).Doctors check the patients. They are identified by their registry numbers. You also need their first name, surname, specialty and years of experience. Every doctor has at least one patient. Doctors prescribe medication for patients. A doctor may prescribe one or more medications for several patients, and a patient may receive prescriptions from several doctors. Each prescription has a date and an amount associated with it. If a doctor prescribes a medicine more than once for a patient, all prescriptions must be kept.Each pharmaceutical company is identified by name and has a telephone number. Trade name and formula should be recorded for each drug. Each drug is…
Airline Management There is a report on poor management of an airline company in South Africa. As a results, the stakeholders decided that all information concerning the assets, operations, and the employees of the company should be organised with the use of a database management system. The database needs to store information about the Airplane (identified by planeid, name as planename, and cruise_range), Flights (identified by ftnum, place of departure as departfrom, destination as arriveto, total milage as tmilage, departure time as departtime, arrival time as arrivetime, and price). Pilots (identified by empid and planeid), and Staff (identified by empid, name as empname, and salary). The Staff relation consist of all the employees of the company including the pilots, and you have been hired to design and manage the database. Source: Okonkwo, C. (2021) Write an SQL query on the following: Determine the identity (planeids) of all airplanes that can fly from Johannesburg to Cape…
In the case of a physical database, where do you begin?
DATABASE MANAGEMENT Design an EER diagram for a database used to manage a racket sport association (for example, US Tennis Association). The following is a list of simplified requirements. Each member of the sport association has an id, a name, sex, age, an address, a phone number. A member can be a player, an umpire (i.e., referee), a coach, or an officer (i.e. a member can belong to one or more of the above categories). An umpire has a type (i.e., national, international, etc.). A coach has a certificate (i.e., level I, II, etc.). An officer has an office (i.e., a room number such as 101 or 212 in the main building). Each club has a name, an address, an owner, and a phone number. Except for some officers, every member belongs to one or more clubs (Hint: Make relationships between the subclasses of “member” and club). A player can be a professional or an amateur (but not both). A professional player has a rank (such as 1, 2, etc. within the association), and a coach (Note: Every…
University of Basrah College of CSIT Database Management System ( IS 304) Pharmacy Prescriptions Case Study 1. Problem: The goal is to design a database of a pharmacy system. 2. Description: Patients, or customers, in a pharmacy system, have prescriptions, written by a doctor, and are served accordingly by the pharmacist. Every patient in this system has a unique ID in addition to non-unique personal data such as phone number, address, first and last name, and ID. Using their IDs, the patient and the doctor are identified specifically for each prescription. In the exact same way, doctors have a dataset table with their own personal data and IDs. Prescription medication information is kept in a separate table. In addition to non-unique data like name, code, etc., each prescription has a unique ID. Also, there are two categories of medication, the ones that are written in the Prescription, and the ones that are in the stock. medication in the prescription itself may include several data…