Introduction to Web Databases in Cloud Instances: A Case Study with Oracle Database Cloud Service

Introduction to Web Database in a cloud instance:
A web database provides a service to the data in the cloud. That is, a web database is a database
which is created and managed on the cloud. It is like an API which is in the form of the web page
and is used to store the data in the database. A web database in a cloud instance is defined when
the database is created on a web page and in the form of an API, it is used by the users anywhere
and anytime with the help of the cloud instances.
Implementation of the web database in the cloud instance (Oracle Database
cloud service):
Oracle database cloud service is a database as a service which is same as Oracle database but it is
on cloud and is created with the instances.
To create a database on Oracle cloud instance, the procedure of creating a database on the Oracle
cloud is followed.
1. Click on “create instance”.
2. After clicking the page will show the subscription type panel, fill out those details.
3. And by clicking on the next button follow up pages will be shown hence; those should be
filled.
4. Fill the Service details page in which create instances and configuration of backup and
recovery.
5. At last by clicking on “create”, the database is created in the cloud.
In the given case study we are required to create a database for football training sessions along
with the players’ records. A football coach named Bruce announces training sessions for the
players and gives some condition for the players to attend the training sessions which in the
creation of the database are considered to be business rules. The schemas for the case study
which is to be created and implemented are as follows:-
Player (Player_ID, player_name, player_dob, player_position, training_sessions_attended)
Performance (Player_ID, Training_Session_ID, rating)
Training_Session (Training_Session_ID, training_date, training_time, training_venue,
number_of_players)
There are three entities created from the case study and their attributes are given in the schema
accordingly.