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

Your job as a database designer is to design a database with a schema that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, photograph, sculpture), and its price must be stored. Pieces of artwork also classified into groups of various kinds, for example, portraits, still lives, works by Picasso, or works of the 19th century; a given piece may belong to more than one group. Each group is identified by a name (like those just given) that describes the group and property. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique ID, name, address, total amount of dollars spent in the gallery, and the artists and groups of art that the customer tends to like. Draw the ER diagram for the database.
Suppose you are given the following requirements for a simple database for the National Hockey League (NHL): • There exists many teams in the NHL • Each team has a teamID, name, a city, a coach, and one or more players • Each player belongs to only one team • Each player has a playerID, name, a position (such as left wing or goalie), a skill level, and a set of zero or more injury records . An injury record has an injuryRecordID, a game, a player, and a description. • A game is played between two teams and has a gameID, a homeTeamID, an away TeamID, a date (such asMay 11th, 2017), a home team score, and an away team score. Construct a schema for this database and ensure all relationships cardinalities (1:1, 1:M, M:M) match the requirements above. Then, using this schema, write your Data Definition Language queries in SQL to be able to create these tables in SQLite. Ensure all relevant constraints (Primary Keys, Foreign Keys, NOT NULL, data types) are included. Submit both the schema…
A database has been designed to display a list of popular movies and also a list of actors acting in these movies. The relationship that would exist between the related tables would be: O many to many one to many O many to one O one to one
Although you always wanted to be a dog trainer, you ended up being an expert on databases because you love to work with data and logic. Your old love is still there, however, so you set up a database company, DogTraining, that builds a product for dog kennels. The core of this product is a database with a schema that captures all the information that kennels need to maintain. Kennels keep information about dog trainers, the First and Last names of the dog trainers (which are unique), birthplace, color of the dog trainers hair, and style of training. For each dog, the trainer, the date the dog was born, a name (not unique), the type of dog (e.g., Brittany, German Shepard, Collie, etc.), color of the dog’s hair, and how much weighs must be stored. Dogs are also classified into groups of various kinds, for example, hunting, guard, working; a given dog may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, kennels…
All I need is an ER diagram that takes into account everything described. Thank You.
1. Connect mySQL database by using Python. 2. Create database and tables as given below by using Python. (a) BANK database (b) CUSTOMER: customer_id integer, name varchar, lastname varchar, registration_date date, score integer (c) BRANCH: branch_id integer, branch name varchar, cash_hold float, foundation date date, liability float (d) LOAN: loan_id integer, customer_id integer, branch_id integer, amount float Choose primary and foreign keys depending on the base design. 3. Create arrays of at least 5 different records. Use these arrays to populate each table in the database.
Following on your BIG break to make a database for an… organization that organizes table tennis tournaments (also known as “Tourney”s) at their premises on behalf of clubs, you’ve written down the business rules as follows: One Match belongs to One Tourney, and not none. One Tourney has Many Matches, at least one and a maximum of 128. One Match takes place on One Table, and not none. One Table is used in Many Matches, and possibly none. One Match belongs to one Category, and not none. One Category appears in Many Matches, and possibly none and a max of 32. One Match involves Many Players, minimum 2 and maximum 4. One Player plays Many Matches, and possibly none. You have also been given a small sample of their records (which is not in the least in relational format), which may prove useful. It is below. Match Number Tourney Tourney Start Date Day Time Slot In Day Player Names(Team 1) Player Names(Team 2) Player IDs (Team 1) Player IDs(Team 2)…
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…
Produce the 3NF for the following: Scenario 1 This is a simple list table of a company trying to keep track of parts that they sell and orders that came in purchasing those parts (in other words, not a database but a flat one table file) You will design a database for this company so that they won't be relying on a simple 1 table list system to keep track of their data. Looking at the table below, produce the IN of the data OrderDate 10/20/2010 10/20/2010 10/20/2010 10/21/2010 10/21/2010 10/23/2010 10/21/2010 10/23/2010 10/23/2010 OrderNum 21608 PartNum AT94 DR93 NumOrdered 11 1 Description QuotedPrice $21.95 $495.00 $399.99 $329.95 S595 00 $794.95 $150.00 $495.00 00 0621S Iron 21610 Gas Range 21610 21613 DW11 Washer KL62 Dryer Dishwasher Home Gym Microwave Oven Gas Range Treadmill 21614 21617 ктоз 21617 CDS2 4. 21619 DR93 1. 21523 KV29
A member of The perspective of the head is thus: It's a database, and the fundamental design/structure we picked contains some sensitive driver information." How about putting it in a secure location where only those who need it may access it? Is there a tactic you'd prefer, or a position you'd take? Justification is required....
We would like to develop a database that captures the following requirements. A University student can enrol in a course and at least in one major. In fact, a student can enrol in many majors within that course. During the semesters, a student can enrol in units. We want to capture in which year and in which semester a student enrolled in each unit. We have two semesters: Semester 1 and Semester 2. A unit has a code, a title and the number of credit points. We would like also to record the student’s GPA. A course has a code and a name. A major has a code and a name. Also, a major belongs to a course. A unit can be part of either a course or a major. A unit can also be shared across different courses and different majors. Important to note: Provide your design in a textual form, i.e. Entity(Attribute1, Attribute2, Attribute3, …). Make sure that the primary keys of each entity are underlined (Attribute1 in the example above) and foreign keys are indictated in bold (Attribute3 in…
The ABC Engineering (ABCE) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The ABCE administrator gives you the description of the training group's operating environment. ABCE has 12 instructors and can handle up to 30 trainees per class ● It offers five Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes Each class is taught by one instructor Each instructor may teach up to two classes or may be assigned to do research only Each trainee may take up to two classes per year Complete the table to define all of the entities and relationships. First one is done for you. Consider one of the relations as a composite relationship. ENTITY INSTRUCTOR RELATIONSHIP Teaches CONNECTIVITY 1:M ENTITY CLASS