The following are the tables and data in the ITCO630_A database:

Using the sample database, write the scripts in a file called ITCO630_P3.SQL to create the following views. Remember to include a USES clause at the top of the script file to use the ITCO630_A database. Also include code that checks if the view already exists. If it does, it should be dropped and recreated.
Create a view named v_worker showing the student number, assignment number, and start date where the role is “worker.”
Create a view called v_no_points with all the columns of the assignment table except the points column.
Create a view called v_count that shows the number of students working on each assignment. The view should have columns for the assignment number and the count.

Design and implement a database to store personal trainer booking for a gym and client/server software system in Java to interact with the database. The client program should have an intuitive user interface to add, remove and manage bookings. The server program should allow multiple clients connect at the same time and interact with database (see the scenario below)

Design a deductive database system in Datalog for the database listed below. For this exercise, assume names uniquely identify one person; also assume that if two parents have children in common (one or more), then they are married. Additionally, if children have common parents then they are siblings. Define rules for grandparent, grandfather, sister and five additional rules on your own.

Attached file: LoadDB.sqlPreview the document

Download the script file, LoadDB.sql to C:CIS4210
Run sqlplus SYSTEM/Oracle11
Enter START C:CIS4210LoadDB.sql
Enter SPOOL C:CIS4210M1spool.txt
DESCRIBE iggy.part;
SELECT * FROM iggy.part;
DESCRIBE iggy.supplier;
SELECT * FROM iggy.supplier;
DESCRIBE iggy.quote;
SELECT * FROM iggy.quote;
SPOOL OFF;
QUIT;

Submit your text document with the file name c:cis4210M1spool.txt . You now can run sqlplus iggy/oracle in order to try the various examples in the book.