Use Any Compailer Java Not Netbeans 1 (75.63 KiB) Viewed 27 times
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: Your tables must be relationally complete. Make three Sequences (One for each table). Make any Materialized view. Insert some records to your tables.(use the created sequences to generate numbers to be inserted into a fields of your tables). 1- 2- 3- 4- 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 argi 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(argl) 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!