By using Oracle SQL-PLUS Make three tables with their own attributes: Al-Azhar university of Gaza Faculty of EIT Databas

[answerhappygod]

By using Oracle SQL-PLUS Make three tables with their own
attributes:
Al-Azhar university of Gaza Faculty of EIT Database Project
Second semester 2022
The main aim of your project is to create a database schema
consists of 3 tables suggested by yourself and simulate it through
a graphical application program:
Part 1 : SQL By using sql-plus environment create your database
tables:
1- Your tables must be relationally complete.
2- Make three Sequences (One for each table).
3- Make any Materialized view.
4- Insert some records to your tables.(use the created sequences
to generate numbers to be inserted into a fields of your
tables).
Part 2: PL/SQL By using PL/SQL create the following:
1- A procedure Proc_Insert(arg2,arg3..argn): When the procedure
is executed, the value of the passed arguments will be inserted
into a table of your database.Note(you have to use one of the
created Sequences to generate a value to be inserted into a field
of your table).
2- A Procedure Update_value(arg1,arg2): The procedure searches
about arg1 value in a specific column of your table and changes the
value of the searched item to be equals arg2.
3- A procedure called del_Record_from_Table(arg1) that deletes a
specific row from one of the tables you created.
4- A Function getAllData(arg): When Your call your function it
should search about an item in your table and returns all data
about it.
5- A row type trigger that’s fires to accept the deleted rows
from a table on your database and store them into another
table.
-You must create a new table to accept the deleted rows.
- The new table must contain two additional columns, the first
is to store the username and the second one is to store the time of
deletion.
6- A statement Trigger that disallows inserting or deleting or
updating a table in holidays.
Part 3 : -Using NetBeans create a graphical application program
to simulate the inserting, deleting, searching and updating of your
database tables using JDBC.
Notes : The deadline for submitting your project is Tuesday
20/05/2022