Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Term Project Part I. ERD Instruction: Create an ERD for the business case scenario below in Draw.io . The goal of this database is to

Term Project
Part I. ERD
Instruction: Create an ERD for the business case scenario below in Draw.io.
The goal of this database is to see data about baseball players who have been recently drafted to Major League Baseball Teams. In the MLB there are 30 teams, however, we are not
including all of them because this database is mainly for demonstrative purposes. Each player
received a player rating on a scale from 0 to 100 based on their skill level. This score was
given by scouts that are hired by each MLB team. The purpose of this rating system is to help MLB teams pick the best players for their program. The database also shows whether the
players are represented by agents who let the MLB teams know if they will have to negotiate
signing bonus with the agent or the player himself. Phone numbers are also given for each
player, agent, and scout to make communication between the parties easy. Players can have only one agent and agents are allowed to represent more than one player but must represent at lease one. Teams can draft more than one player and a player may only belong to one team. Teams may also have more than scout and those scouts belong to that team only who can create more than one scouting report.
Note: As you can see the narrative above is fairly flexible in that you have a lot of room to make assumptions and be creative, and that is the idea to start with a baseline that you can adapt to another
product. Make your own attributes, cardinalities, relationships, or even new tables. However, Id
recommend you start it off by working on these entities: Team, Agent, Player, and Scout.
Part II. DDL
Instruction: Write DDL codes to implement the ERD you have designed by creating the tables
with data in SQL Plus. Submit the DDL in a Notepad file (.txt). You can come up with your own data.
Part III. SQL Queries
Instruction: Based on your tables in SQL Plus, create 10 queries of your choice and provide SQL solutions. You may find it helpful to consult the examples in the SQL exercises. Submit the
queries and their results in a SPOOL file
Note: Do not include any select * from Table; in your queries.
1. Query1
2. Query 2
3. Query 3
4. Query 4
5. Query 5
6. Query 6
7. Query 7
8. Query 8
9. Query 9
10. Query 10

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 12c SQL

Authors: Joan Casteel

3rd edition

1305251032, 978-1305251038

More Books

Students also viewed these Databases questions

Question

2. To compare the costs of alternative training programs.

Answered: 1 week ago