مساعدة مستعجلة

السلام عليكم يا أعضاااااء الفريق المحترمين,,, أريد منكم شرح لهذي المعطيات لأن لازم أطبقهم كلهم في الاوركل ضرررررررررررررررررررررررررررررررررررررررروري :

• Fill in a new form for a customer who wants to insure a car. Provided, the customer and/or the car might already be in the database from previous transactions.

• View the details of an existing transaction.

• Modify any of the details of an existing transaction.

• The owner can be able to restrict the results to the transactions of a over the period of time.

• View a list of all the transactions for a specific insurance company.

• View the total earnings (insurance charge) for a specific year or month within that year.

• Delete an existing transaction.

• The number of available drivers for each transaction.

For the above operations you have to do a PL/SQL program with choices. Every choice should ask proper inputs from the users and results should be printed on the screen. In the program try to use clusters, functions, procedures and triggers.