You have been asked to model the data requirements for football teams based on the following...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have been asked to model the data requirements for football teams based on the following description: Each football team has several players signed to it and competes in a football league. Each team is sponsored by one company although each company can sponsor more than one team. A player can be signed to only one team but it is also possible for a player not to be signed to any team (free agent). The details that are to be stored for each player are squad number, name, date of birth, nationality and player valuation. Each team has a team name, stadium name and established date. The details of the sponsor name and annual sponsorship also need to be recorded as well as the league number and league name that the team competes in. a) Represent the system description above as an Entity-Relationship Diagram. Ensure you have the correct cardinality and participation for each relationship. Include suitable attributes in your diagram. Indicate any assumptions you have made. b) Convert the ERD from part a) above to a relational model. A garage maintains a stock of parts for Renault cars. Each part has a part number, a description, and a price. The garage also records the quantity in stock for each part. The garage keeps a record of all cars they have worked on. Cars are identified by their registration number. The garage also records the car model and the owner's name, address and phone number. Cars can be booked in for a service or to mend a fault. The cost of the service will include the cost of labour as well as the cost of spare parts used. a) Represent the system description above as an Entity-Relationship Diagram. Ensure you have the correct cardinality and participation for each relationship. Include attributes in your diagram. b) Convert the ERD from part a) above to a relational model. You have been asked to model the data requirements for football teams based on the following description: Each football team has several players signed to it and competes in a football league. Each team is sponsored by one company although each company can sponsor more than one team. A player can be signed to only one team but it is also possible for a player not to be signed to any team (free agent). The details that are to be stored for each player are squad number, name, date of birth, nationality and player valuation. Each team has a team name, stadium name and established date. The details of the sponsor name and annual sponsorship also need to be recorded as well as the league number and league name that the team competes in. a) Represent the system description above as an Entity-Relationship Diagram. Ensure you have the correct cardinality and participation for each relationship. Include suitable attributes in your diagram. Indicate any assumptions you have made. b) Convert the ERD from part a) above to a relational model. A garage maintains a stock of parts for Renault cars. Each part has a part number, a description, and a price. The garage also records the quantity in stock for each part. The garage keeps a record of all cars they have worked on. Cars are identified by their registration number. The garage also records the car model and the owner's name, address and phone number. Cars can be booked in for a service or to mend a fault. The cost of the service will include the cost of labour as well as the cost of spare parts used. a) Represent the system description above as an Entity-Relationship Diagram. Ensure you have the correct cardinality and participation for each relationship. Include attributes in your diagram. b) Convert the ERD from part a) above to a relational model.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
Develop a client-server application in C++ using sockets to implement a simple chat system. Ensure that multiple clients can connect concurrently, and messages are transmitted securely .
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Under the fair labor standards act - are covered and must be paid at least the minimum wage
-
Certain environmental laws prohibit EPA from considering the costs of meeting various standards when the levels of the standards are set. Is this a good example of putting first things first or...
-
Given below is a bivariate distribution for the random variables x and y. a. Compute the expected value and the variance for x and y. b. Develop a probability distribution for x + y. c. Using the...
-
What is the fair value of a centrally cleared $500 million, 1.75%, three years remaining, annual pay swap given the Libor rates as shown below? Assume the Libor- OIS spread is constant at 18.125...
-
What is a debenture?
-
Provide an example of an organism within each of the four main nutritional categories of microbes and describe how each obtains its essential nutrients.
-
Lizzo is a well - known musician signed with Atlantic Records. She entered into a contract and agreed to play Mark's private Halloween party for $ 1 0 , 0 0 0 . One week before Halloween, the Outside...
-
Jon conveys Pinkacre to Matt, who does not record. Jon subsequently conveys to Anthony, who purchases in good faith for a valuable consideration, but does not record. Matt then records the deed from...
-
Indirect business taxes and capital consumption allowance are not income, yet they are included in the calculation of GDP as income received. Why do we add these two nonincome components to the other...
-
Consider the welding situation of the previous problem. This time let's consider the case where we have convective heat transfer from the rod's surface. For a rod of radius, \(r_{o}\), and a heat...
-
Why dont we measure national output by simply counting the total number of goods and services produced each year?
-
As a biochemical engineer you are evaluating a drug delivery system for an artificial protein to combat Alzheimer's. The protein is very large (200,000 molecular weight) and bulky and is sensitive to...
-
If the ellipse: \[a\left(x^{2}-y^{2} ight)+2 b x y-\frac{1}{2} \omega_{o}\left(x^{2}+y^{2} ight)+c=0\] is full of liquid and is rotated about the origin with an angular velocity, \(\omega_{o}\), the...
-
Your answers should be descriptive enough to explain the economic terms where applicable. 3. The table shows the demand and supply schedules for CDs. Price Quantity Demanded Quantity Supplied (Rs....
-
Differentiate the following terms/concepts: a. Personality types and money attitudes b. Planners and avoiders c. Moderating and adapting to biases d. "Perfectible judges" and "incorrigible judges"
-
The statement of nancial position of Columba Ltd. at December 31, 2011, was as follows: The recorded amounts of Columbas identiable assets and liabilities at this date were equal to their fair values...
-
How is an acquirer identied?
-
On January 1, 2013, Serpens Ltd. acquired the issued shares (cum div.) of Vela Ltd. for $120,000. At that date, the nancial statements of Vela included the following items: Share capital...
-
Which of the following statements is true? a. Encrypting data is sufficient to protect confidentiality and privacy. b. Cookies are text files that only store information and cannot do anything. c. A...
-
Which of the following is designed to identify entry of a nonexistent customer account number? a. sequence check c. completeness check b. field check d. validity check
-
A batch total that is calculated by summing the part numbers sold in a batch of 50 sales invoices is called a a. financial total c. record count b. hash total d. part count
Study smarter with the SolutionInn App