Q3\\ Assume we have the following application that models soccer teams, the games they play, and the players in each team. In the design, we want to capture the following: We have a set of teams, each team has an (ID, name, main stadium, and to which city this team belongs). Each team has many players, and each player belongs to one team. Each player has (a number, name, start year, and shirt number that he uses). Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium of the host team. For each match we need to keep track of the following: • The date on which the game is played • The final result of the match 1.Design an ER diagram to capture the above requirements? 2. Mention to primary key and candidate key if it is find? 3. Show the Relationships among entities?

Q3\\ Assume we have the following application that models soccer teams, the games they play, and the players in each team. In the design, we want to capture the following: We have a set of teams, each team has an (ID, name, main stadium, and to which city this team belongs). Each team has many players, and each player belongs to one team. Each player has (a number, name, start year, and shirt number that he uses). Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium of the host team. For each match we need to keep track of the following: • The date on which the game is played • The final result of the match 1.Design an ER diagram to capture the above requirements? 2. Mention to primary key and candidate key if it is find? 3. Show the Relationships among entities?

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

Assume we have the following application that models soccer teams, the games they play, and the players in each team. In the design, we want to capture the following: • We have a set of teams, each team has an ID (unique identifier), name, main stadium, and to which city this team belongs. • Each team has many players, and each player belongs to one team. Each player has a number (unique identifier), name, DoB, start year, and shirt number that he uses. • Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium of the host team. • For each match we need to keep track of the following: • The date on which the game is played • The final result of the match • The players participated in the match. For each player, how many goals he scored, whether or not he took yellow card, and whether or not he took red card. • During the match, one player may substitute another player. We want to capture this substitution and the time at which it…
Assume we have the following application that models soccer teams, the games they play, and the players in each team. In the design, we want to capture the following: • We have a set of teams, each team has an ID (unique identifier), name, main stadium, and to which city this team belongs. • Each team has many players, and each player belongs to one team. Each player has a number (unique identifier), name, DoB, start year, and shirt number that he uses. • Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium of the host team. • For each match we need to keep track of the following: • The date on which the game is played • The final result of the match • The players participated in the match. For each player, how many goals he scored, whether or not he took yellow card, and whether or not he took red card (Represent this as Match-Player Entity Type) • During the match, one player may substitute another player. We want to capture…
IN JAVA Cartesian Item Programming Depiction of the test: The Cartesian result of two arrangements of numbers An and B is characterized as the arrangement, all things considered (a,b) where an is an individual from An and b is an individual from B. It is frequently addressed by the image A x B and is alluded to as the Cartesian item since it starts in Descartes' meaning of logical calculation. The Cartesian result of two arrangements of genuine numbers is as requested sets. for example An equivalents [1, 2, 3]. B approaches [4, 5]. C = [(1, 4), (1, 5), (2,4), (2.5), (3,4), (3,5)] is the Cartesian item. Presently, given a facilitate tuple (i,j), where I signifies A[i] and j indicates B[j], and knowing A, B, develop a capacity that profits the file of a part in Cartesian item C as per (i,j) Introduction code: Primary public class /** * Repeat over the information lines individually. */ IOException is tossed by open static void main(String[] args). new…
Data Generator Most application depends on data. In IoT data is collected/generate by sensors. Since, we do not have access to sensors, we will have to generate data via code. The plotting a sufficient number of these data points (500 in this case) should get the following diagram or something very similar: You will pick a quantity that you would like to simulate (such as temperature, humidity, barometric pressure, customers arriving at a mall, or just with an alternate descriptor) and decide what shape you will emulate. This will guide you in selecting sensible value base lines for your data values. e.g., If you pick inside temperature then normal range will be 18-21oC. Design and build a class that will model your sensor reasonably well. Notice how the peaks do not occur at regular interval, nor are they the same height. Even the squiggles are the same shapes. You will create a class with a single public member (property) that give you a “random” value in your intended range and…
Age calculation. You must use the object oriented programming for this problem. USE JAVA LANGUAGE (1) Create a class called Date that Includes three pieces of information as data members—a month (type int), a day (type int) and a year (type int). Have a constructor with three parameters to initialize the three data members. Call setters inside to initialize each attribute. Provide a set and a get method for each data member. Assume that the values provided for the year and day are correct, but ensure that the month value is in the range 1–12; if it isn’t, set the month to 1. Provide a member function displayDate that displays the month, day and year separated by forward slashes (/). Provide a member function called calculateAge with three parameters that indicate a future date (represented as month, date, and year). Calculate one’s age based on one’s birth date and this future date. Inside the method simply print out one’s age in the format of how many years and how many days. Note…
Apply the Object Oriented concepts that you've learned (Abstraction, polymorphism, interfaces, packaging, ...) utilizing Boundary, control and entity concepts as well as SOLID Principles to design a Mountain camping application. This application manages a tent camping space for a configurable maximum number of tents. Each camping space (slot) is defined with a dimension (width and depth). The designed application must handle the following functions: • Each tourist shall be identified by a name, unique passport number, and his own tent dimensions (width and depth). • Each camping slot has a width and depth that describes the slot dimensions as well as slot hourly rent rate. • . Check-in function that marks the arrival time of a tourist to the camping site if there is an available slot. The application shall capture such time automatically from the system. During the check-in function, the application shall pick a free slot based on the active slot configuration. There are two…
Tyger Valley Pet Shelter (TVPS) receives food donations from a group of pet food manufacturers. TPS relies on each manufacturing company for a particular need. For example, Veggie Land supplies all the vegetables and Premier Seed Suppliers supplies all the seeds. The different food types are allocated to the animals according to their category. For example, food type 'seeds' is allocated to category 'Birds', while food type 'vegetables' is allocated to the categories 'Mammals' and 'Birds'. Each animal category is subdivided into different pet types. For example, the mammal record could relate to pet types 'Dog' and 'Cat'. TPS has recruited you to be their database designer. The database will store information on their suppliers, food types, animal categories and pet types: Record a unique ID, company name, contact number and possibly an e-mail address for each manufacturer. When recording information about the different food types, ensure that the expiry date is also stored. When…
Apply the Object Oriented concepts that you've learned (Abstraction, polymorphism, interfaces, packaging, ...) utilizing Boundary, control and entity concepts as well as SOLID Principles to design a Mountain camping application. This application manages a tent camping space for a configurable maximum number of tents. Each camping space (slot) is defined with a dimension (width and depth). The designed application must handle the following functions: • Each tourist shall be identified by a name, unique passport number, and his own tent dimensions (width and depth). • Each camping slot has a width and depth that describes the slot dimensions as well as slot hourly rent rate. • . Check-in function that marks the arrival time of a tourist to the camping site if there is an available slot. The application shall capture such time automatically from the system. During the check-in function, the application shall pick a free slot based on the active slot configuration. There are two…
Apply the Java concepts that you learned (OOP, polymorphism, interfaces, packaging, …), SOLID design principles as well as Design Patterns to design/extend a Parking Garage applicationand implement it using the java programming language. This application manages a parking spacefor a configurable maximum number of vehicles. The designed application must handle the following functions: ● Each garage slot has a width and depth that describes the slot dimensions as well as slot hourly cost.● The garage consists of a configurable maximum number of slots as well as a global slot selection algorithm i.e. First Fit or Best Fit where○ First Fit selection where the first slot with big enough dimension to host the vehicle will be selected○ Best Fit selection where the slot with the best dimension match should be used where the wasting area of the slot is minimized. ● Each vehicle shall be identified by a model name, unique identification number, owner mobile number, Model year and vehicle…
Create a class Student that contains three members: roll no, name and mark, and threefunctions. Write a first inputStudent() function to get data of student class. Write a secondgetMark() function that returns a student’s mark. Write a third display() function thatdisplays a student’s data. In a main() function, you need to declare 40 students and get dataof all students by using inputStudent() function. And also use a pointer array to keep allstudents by mark greater than 50 and display the searching data of each student in thatpointer array (Use the access operator -> to access a pointer points to member functions ofthe Student class)
Software Engineering: Project Description: Sentiment Analysis System for Images, In this project, we will be creating an Sentiment Analysis system that utilizes machine learning to efficiently analyze people's feelings using their images. Then we will build a web application that is allowing users to upload an image and make a decision about whether it is positive, negative, or neutral. I need the following (please in details and clearly): A) Context models (The whole System)B) Use case modeling (At least four of your system features or activities )C) Class diagrams 1. Classes and associations (The whole System) 2. Class diagram (At least four of your system activities)D) Sequence diagram (At least four of your system activities) Thank you!
The following is a sample report from a child clinic. It shows the days and treatments for visits to doctors at the clinic. A mother takes her child, sees a doctor and the doctor administers some treatment. There are couple of things you should assume: The mother’s name is unique. a mother won't have more than one child with the same name the doctor's surname is unique a treatment code is unique treatments are specific to doctors, eg 101 is only ever given by Johnson Surname First Name Town Age Child Doctor Date Treatment Smith Jane Coventry 30 Rebecca Johnson 27.3.04 101 Brian Clarence 30.5.04 209 Robert Johnson 10.1.88 101 Brown Beryl Rugby 28 Alan Clarence 30.4.04 214 Sarah Johnson 29.5.04 101 Sarah Clarence 12.1.04 321 Jones Fiona Kenilworth 34 James Clarence 30.4.04 322 Jenny…