Create table EMP with columns emp_num, ename, sal and enter 10 records. Add columns dname, dept_num, location for emp table.
Understand the Problem
The question is asking to create a database table named EMP with specific columns and to insert records into it as well as to add new columns later, which relates to SQL operations.
Answer
Create 'EMP' table, insert records, add columns, update records.
To accomplish the task, first create the table with given columns and types, insert 10 records, add the new columns, then update those records with additional data.
Answer for screen readers
To accomplish the task, first create the table with given columns and types, insert 10 records, add the new columns, then update those records with additional data.
More Information
This exercise demonstrates basic SQL database manipulation tasks such as table creation, data insertion, and schema modification using 'ALTER TABLE'.
Tips
Ensure data types match when inserting and updating records. Verify column additions and updates for accuracy.
Sources
- Exercise – 1 - gdctg.cgg.gov.in
