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?
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.
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.
- Do not erase the existing queries.
- Use the same file to write all your queries.
- Select the entire query and run it to see the output.
- Save the file as your_file_name.sql and upload it to github.
- You can use dml-pkl.sql as a reference.
Oracle 11g Express edition and Oracle SQL Developer
- Insert into city
- Insert into referee
- Insert into innings
- Insert into extra_type
- Insert into skill
- Insert into team
- Insert into player
- Insert into venue
- Insert into event
- Insert into extra_event
- Insert into outcome
- Insert into game
- Update player table
- Update player table
- Update player table
- Update player table
- Delete from extra_type
- Delete from referee
- Delete from player
- Delete from outcome
Happy Coding ❤️