FIFA-World-Cup-2022

This is an Oracle Apex based application for storing the FIFA world cup match data or any other tournament.

Features

• Anyone can create a user account by registration and will get automatic activated reader access.
• Most of the data of the match will be pass through the trigger or dynamic action to another table. So, user don’t need to update every other table with similar type data.
• Another interesting thing is page linking by that user can go through from a page to another like a website.
• Added update and delete trigger, some process by Pl/SQL code and dynamic action with Pl/SQL code execution.
• Also, added calendar report, Card with BLOB image, page linking, custom list view.

Tools Used :

• Oracle Apex
• SQL Developer

Setup :

• Download :

  • Oracle SQL Developer

Database Scheme :

• E-R Model :

  
  

• Relational Data Model :

  

Screenshot of Functionalities :

• Homepage :

• Form Page :

• Master Details Page :

• Multi-Table and Aggregate Queries Page :

• Parameterized Reports Page :

• Charts and Other Page :