Create a data model for on adult baseball league

Assignment Help Database Management System
Reference no: EM131123571

Sample Databases

Part 1

Come up with an original example of a one to many unary relationship. Create an example model of this relationship using the MySQL Workbench data modeler.

Part 2

Come up with an original example of a ternary relationship. Create an example model of this relationship using the MySQL Workbench data modeler.

Part 3

Using MySQL Workbench - Create a data model for on Adult Baseball league which supports all of the following data requirements:

Teams

• A team has a unique number associated with it
• Team Name
• Team City
• Each team has more than one player associated with it

Players

• Each Player has a unique number
• A player may play or have played for more than one team
• The number of years and batting average is tracked for each team the player played for.

Coaches

• In this league, all coaches are also players.
• A Team can have more than one coach.

Bats

• A team can have multiple bats
• Each bat is identified by a unique serial number.

For each of the three models above, you should export your model as a single page PDF and submit the resulting files.

Reference no: EM131123571

Explain role of a database administrator

Explain the role of a database administrator,the tasks performed by this role and why this role is important in Database Management.

Explore ways of converting depositors to borrowers

Universal Bank is a young bank growing rapidly in overall customer acquisition. The majority of these customers are depositors with varying sizes of relationship with the ba

List the details of parts supplied by quality

Attribute dob is the customer's date of birth, stops is the number of stops (0-??) a flight requires, and onTime is a percentage (0-100) indicating how often a flight is on

How many green books it has

Webster Library wants to know how many green books it has. Out of the 500 shelves of books, 3 shelves were selected. These shelves hold 150 books each. 54 of the books sampled

Develop view for sum of number ordered multiplied by price

Develop a view named OrdTot. It comprises the order number and order total for each order presently on file. (Order total is sum of the number ordered multiplied by quoted p

Creates a user-defined database role named paymententry

Write a script that creates a user-defined database role named PaymentEntry in the AP database. Give UPDATE permission to the new role for the Invoices table, UPDATE and INS

Demonstrate practical skills in using sql

ICT285 Databases Demonstrate practical skills in using SQL - Demonstrate practical skills in normalisation and convert a conceptual database design to a logical design in 3NF

Calculate the total adults and children visitors

YOF EWS07 H1- In cells B11:E11, Create formulas in the cell range D6:E10. Calculate the total adults and children visitors as well as the adult and child admission collected.

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd