Question

Create a sequential file and state the serial numbers, name, basic pay of five employees of a company.​

Answer 1

Answer:

1.Create the employee table with columns eno, ename, age, job, salary, and dept, with journaling enabled.

2.Create a table with some other data types

3.Create a table listing employee numbers for employees who make more than the average salary.

4.Create a table that spans two locations. Specify number of pages to be allocated for the table.

5.Create a table specifying defaults.

6.Create a table specifying check constraints. In the following example, department budgets default to $100,000, expenses to $0. The check constraint insures that expenses do not exceed the budget.

7.Create a table specifying unique constraints and keys.