Question

I. Create a table with the given fields. Enter 5 records in it . Save
the database with the name ‘Student’s Details ‘ and enter records
in it .
Admin_no Roll_no First_name Address Fathers
name
Phone_no DOb
 Modify table and insert the field name “Age’ after the field ‘Father’s Name’.
 Set roll_ no as primary key
 Insert a new filed ‘Date of joining ‘ at the end.
 Edit the record number 5 and change the information

Answer 1

Answer:

I. Create a table with the given fields. Enter 5 records in it . Save

the database with the name ‘Student’s Details ‘ and enter records

in it .

Admin_no Roll_no First_name Address Fathers

name

Phone_no DOb

 Modify table and insert the field name “Age’ after the field ‘Father’s Name’.

 Set roll_ no as primary key

 Insert a new filed ‘Date of joining ‘ at the end.

 Edit the record number 5 and change the information