Project for CIS50:

Your assignment is to create a realistic project that uses several Oracle tables and where the work with the tables is done mainly with PL/SQL. Tables can be created using SQL.

The project should involve at least two tables where there is a link from one table into the other. Each table should have a primary key. There link between the two tables should be established as a foreign key. Constraints should be used when creating the tables. There should be additional tables that are used to hold the results of querying or taking things out of one or more tables.

The PL/SQL blocks should query the table for situations that need to be dealt with, create tables of extracted information, updating, inserting, deleting etc.

You should include the following in one or more of your PL/SQL blocks/programs:

• If statements - use two different ways
• Loops - use two different types
• Tables
• Cursors - use several and try at least one regular cursor, one For cursor, and one block with multiple cursors
• Exceptions
• Accepting criteria for a query as user input
• Procedure - named
• Procedure - internal/local
• Function
• Trigger

If you have already created a database that you use for examples you can adapt it to meet these criteria and proceed from there.

Feel free to e-mail me your plan if you want feedback.