.
Attachments:
Answers
Answered by
1
Medium:
Will be using SQL (cuz it's easy).
Answer:
26.
CREATING TABLE
Create table student_list(roll_no int, name varchar (20), class int, section char (1), marks int;
ADDING TUPLES TO THE TABLE
insert into student_list values( 101, Geeta, 8, A , 73);
insert into student_list values( 103, Meet, 8, B , 75);
insert into student_list values( 102, Rita, 8, C , 74);
a)
Tuple refers to the data records. We have 3 of them here therefore 3 tuples in total.
b)
Attributes refer to the number of columns you have which here is 5.
c)
Primary key is added to the column which is unique in the table therefore primary key can be added to roll no.
d) Use command:
Alter table student_list add column Remarks varchar (20);
e)
select * from name order by asc;
Similar questions
Social Sciences,
29 days ago
Math,
29 days ago
English,
1 month ago
Hindi,
8 months ago
Physics,
8 months ago