Trident University International Relational Database Project Paper

In this assignment, you are to write Oracle SQL statements to:

• Create a table.
• Accept user input to populate the table.
• Check if the data has been added to the table properly.

Use this reference for your Case Assignment.

• Spool File and Accept User Input (with answers)

This assignment consists of three parts:

• Write Oracle SQL statements to create a table called Employee with the following attributes and associated data types.

Employee

• Write Oracle SQL statements to insert new records to the Employee table. The program should do the following:

— Trident Bookstore —
Please enter the Employee ID: Jimmy2345
Please enter employee First Name: Jimmy
Please enter employee Last Name: William
Please enter the phone number of the employee: 714-456-3456
Note: Add at least 2 records of the data

• Check whether data has been loaded to the table properly.

Oracle live SQL does not support some of the commands such as ACCEPT. It is helpful to learn these commands though.