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 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).

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

TakeltAll Inc is a wholesaler company that has just opened up for business. They sell all kinds of technology devices at their store, ranging from graphics cards to fully kitted gaming motherboards. To help them develop the information system needed for their sales operations, they have hired you to design their database. They currently keep a wide variety of products at their warehouse. The usual information stored for each product includes name, manufacturer, and price, etc... Apart from keeping track of their products, they would like you also to keep track of the purchases made by their clients. Purchases made by clients are shown in invoices that list all the client's products and the quantities of each product. The price at which a product was bought should also be recorded at the purchase of the products. TakeltAll has two types of employees they would like to keep track of in their new information system. Namely sales agents and product managers. Each employee can either be a…
Cludadwy Chairs sells a patented seat that spectators can take to youth soccer games. The seat folds so it is small enough to fit in the glove box of most vehicles. The company operates a factory in Kansas and also contracts its manufacturing projects to small firms in Canada and Mexico. An unusual problem has occurred for this small multinational company: People are getting confused about dates in internal memos, purchase orders, and email. When the company’s database was originally designed, the designer was not aware that the format for dates in Canada and Mexico was different from the format used in the United States. For example, in Canada and Mexico, the notation 7/1/19 indicates January 7, 2019, whereas in the United States the same notation indicates July 1, 2019. Although it seems like a small point, the date confusion has resulted in several order cancellations. Cludadwy Chairs has asked for your advice. You could suggest writing a simple program to convert the dates…
Assume a database of Employees of a company have been given as shown below:Employee: < ID, Name, ProjCode, Salary>Projects: <projID, ProjName, Budget> For each project, count the number of employees who are paid less than the average salary of that project. Determine if there is any project with a budget less than the total salary paid to its employees. If yes, find the name of the project and its budget.
Scenario 1: A privately owned company that sells industrial kitchen equipment needs to set-up a database for their employees. The company has vastly expanded over the last couple of years and needs to keep track of its employees’ salaries. The salaries are worked out according to the position of the person in the department that they work in. Each department has certain facilities, for example the director’s department has a smoking balcony, the factory has a water cooler e.t.c. Each position has the same salary, regardless of the department. For example, a manager in the factory has the same salary as the manager of the IT department. Each employee is uniquely identified by their employee’s ID number. The CEO would also like to know how many positions in each department there are, as well as the name of the branch each employee works for. Each branch must have the information of the country it is situated in. Question 1: Draw a complete entity relationship diagram with all…
A student basketball club wants to keep track of their players, games, and teams for the season. The club currently has several teams, but players can only play on one team during the season. Multiple games will be played throughout the season, and each team will participate in multiple games, each against a different team. From this information, create an entity relationship diagram for a database that would help the basketball team tracks the season. I would prefer to have a handwritten picture or computer-generated picture. thank you!
Dr. Jones, knowing that you are an intuitive database design student, has come to you with a possible database solution for his medical practice. He is interested in storing data related to his patients and the medications that they take. He specifically would like to keep track of the drug names, the drug price, the dosage each patient takes, and the dates that the medications were prescribed. He needs to be able to pull patient data quickly to make sure that each patient is taking the least medication to help their illness. Create business rules that might go with this scenario. Keep in mind that nouns (subjects) will become entities and their characteristics attributes. Verbs will translate into the relationships between entities. Create the ER diagram using Visio that would go with this scenario. Be sure to include entities, attributes, keys, and relationships using the crow’s feet notation
A small Hotel owner wish to computerized the management of hotel operations. You are asked to assist in the development of a database for the hotel. The database keeps data about ROOM, EMPLOYEE and FACILITY. From the discussion session with the hotel manager, you have identified the following information: • Three types of ROOMS offered by the hotel are single, double and deluxe room. Each room is identiﬁed by its unique number. • In general, there are two main types of the hotel jobs, GUEST SERVICES and ADMINISTRATIVE & SUPPORT. • HOTEL MANAGER, EVENT PLANNER and ACCOUNTANT are the administrative and support job positions in the hotel. • Types of employee falls under the guest services are RECEPTIONIST, HOUSEKEEPER, or KITCHEN STAFF. • Each RECEPTIONIST is identiﬁed with her/his name, employee number and years of experience. • The receptionists need to assign a HOUSEKEEPER to each room every morning or whenever it required before the room can be assigned to a guest to ensure the…
FeastFam is a restaurant group which consists of multiple restaurants nationwide. Due to recent restrictions imposed by the government, the group has had to adapt to a new way of managing information in their daily operations. FeastFam has approached you to help them with the creation of a database which will keep track of the following information: • FeastFam franchise group has a main headquarter office. The address of this office should be stored in the database. • FeastFam has many restaurants across South Africa (indicated using a “has-a" relationship). • Each restaurant has a name, location and phone number. To handle reservations the following needs to be considered: • Each restaurant can have many customers make reservations. • Each customer can have many restaurants at which they make reservations. • Each customer has a name, surname and contact number. • For each reservation the following information is stored: Date, time, number of guests. When the customer arrives with…
We want to maintain a database for a Faculty within a multi-campus regional university. The facultyhas a number of schools and each school is characterized by its school-code which is unique, nameand campus location. Schools employ professors who are characterized by their unique staff-id, nameand the school they work for. A school offers courses that are characterized by their course-code whichis unique, course name and the school. There are subjects offered within the faculty and these arecharacterized by unique subject-code, title and the school that offers them. Students enroll intocourses that are characterized by student-id which is unique, name, address and phone. The following business rules apply• A course must belong to only one school, but a school may have many courses• A student must be enrolled in a course, but a course may have 0 or more students• A course must have one or more subjects, but a subject may be taught as part of many courses• A student may be enrolled in…
Think about a student database with the StudentID as the main key and the Major, Age, MaritalStatus, and HomeZipCode indexes (all secondary keys). If the institution requested a list of MIS or computer science majors who were over 25, married, and from the 45462 zip code OR computer engineering majors who were single and from the 45462 zip code, then let's pretend they were both over 25 and from the 45462 postcode. How can indexes be used to guarantee that only the data that satisfies this criteria is accessible to users?
StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.
The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits. Table: Camper CAMPER_NUMBER 1000 1001 1002 1003 CAMPER_LAST_NAME Jones Schmidt Williams Cooper CAMPER_FIRST_NAME Jamie Pat Clifford Amanda CAMPER_ADDRESS 1278 Essex Pl 4954 Spangled Way 956 Segull Lane P. O. Box 998877 CAMPER_CITY Birmingham El Paso Portland Portsmouth CAMPER_STATE AL TX ME OH CAMPER_ZIP_CODE 45251 79919 4108 45662 CAMPER_DRIVERS_LICENSE JJ998743-98 87632434 WIL885123 765A876B897 CAMPER_EMAIL jjones@somewhere.com patwonderfu34l@nowhere.net williams98342@foomail.com coopera@nowhere.net Table: Spot SPOT_NUMBER 101 102 103 104 SPOT_NAME The Pines The Glade Teardrop Spot Tent In Trees…