deeedev/lab-ddl-command-prograd-kabbadi-league

ProGrad Lab | ProGrad Pro Kabbadi League

ProGrad Pro Kabbadi League is gonna begin in a month from now. Our ProGrad organizers are pretty excited to see the champions. We have nearly 20 teams participating in the league. So, there's a lot of data like players, scores etc that need to be collected and stored to decide the winners at each level.

One of our Database specialist has done half the job by creating an ER diagram to visualise the database structure. That's when we thought we could take your help to take this project to completion as you have just started working with databases.

Can you give it a try?

What Should You Do

Go to Oracle SQL Developer and connect to SYSTEM schema or hr schema.
Start writing your queries in the query builder.
Save the .sql file and upload it in github.
Practice Oracle SQL - DDL Statements.

How To Submit

Upon completion, run the following commands:

git add .
git commit -m "ProGrad ID"
git push origin master

And finally, create a pull request so your ProGrad Mentor (PM) can review your work.

Instructions

1. Do not erase the existing queries.
2. Use the same file to write all your queries.
3. Select the entire query and run it to see the output.
4. Save the file as your_file_name.sql and upload it to github.
5. You can use ddl-pkl.sql as a reference.

Requirements

Oracle 11g Express edition and Oracle SQL Developer

ER Diagram

PROGRESSION 1: Create All

1. Create table city
2. Create table referee
3. Create table innings
4. Create table extra_type
5. Create table skill
6. Create table team
7. Create table player
8. Create table venue
9. Create table event
10. Create table extra_event
11. Create table outcome
12. Create table game

PROGRESSION 2: Drop A few

There is a slight change in plan and we might have to drop a few tables. Here goes the list.

1. Drop table city
2. Drop table innings
3. Drop table skill
4. Drop table extra_type

Happy Coding ❤️