Write a task that will perform some of the functions performed by a simple emplo

Question

Write a task that will perform some of the functions performed by a simple employee database.

Each record will consist of six attributes, one if with is the primary key. The primary key will be automatically assigned to a record when the record is created. The fields for the record are as follows:

ID: integer (automatically generated by program)

Last name: 20 character max

First Name: 20 character max

Social Security Number: 11 character max (include “-“) Salary: float

Age: integer

The data should be stored in a randomly accessible file. There should be at least 20 records stored in the file.

Explanation / Answer

CREATE TABLE employee (ID varchar (12), last name char(20), firstname char(20),socsecnum numeric(11),salary float, age numeric(2),PRIMARY KEY (ID));

Insert into employee 3312,MANO,BALA,12345678901,3000,20);

We can arrange the values in ascending or descending orderv.we can display the particular valuevwitha NY column value.

Insertion of new value can be done .

Updation of existing value can also be done

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.