Computer Science, asked by proooooo34, 1 month ago

.
pls \:  \:  \: help \: me \: pls

Attachments:

Answers

Answered by allysia
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