Examine the following table and answer the following questions;
STUDENT
|
REGNO
|
NAMES
|
AGE
|
ADDRESS
|
|
SC02-0111/07
|
Hilda Omondi
|
18
|
Box 7 Kisumu
|
|
SC02-0112/07
|
Rachel Kamau
|
21
|
Box 34 Nairobi
|
|
SC02-0113/07
|
Barrack Papai
|
19
|
Box 5768 Kakamega
|
i). Write an SQL data definition statement which when executed would result in the relation shown above. Indicate any primary key(s), field types and sizes
ii) Write a DML statement to add the second tuple of the above relation
iii) Write a DML statement that lists all the names of students in an ascending order