Question

a) Create the following table items.

Column name Datatype Size Constrain

Roll No Integer Primary key

Studentname Varchar 15

Total Numeric 10, 2

Average Integer 3

a) Consider the following table Item and write the queries (i) and (ii).

Table: STUDENT

Roll No Studentname Total Average

101 Ravi 456

223 Pavithra 387

133 Karthik 420

104 Shyamala 344

215 Shivani 402

i. Write a command to find the average (5 subjects)of the student whose Roll No is

133.

ii. Write a query to display the list in ascending order.

or

Write a query to delete the student of Roll No 215​

Answer 1

Answer:

Here is required answer .

Explanation:

As per question

we have to

a) Create the following table items.

Column name Datatype Size Constrain

Roll No Integer Primary key

Studentname Varchar 15

Total Numeric 10, 2

Average Integer 3

i. Write a command to find the average (5 subjects)of the student whose Roll No is 133.

ii. Write a query to display the list in ascending order.

or

Write a query to delete the student of Roll No 215​

ANSWER OF THE FOLLOWING QUESTIONS :

CREATE TABLE STUDENTS (

   roll_no INT NOT NULL PRIMARY KEY AUTO_INCREMENT,

  name VARCHAR (15) NOT NULL

To display all records from table STUDENTS ;

Select * from STUDENTS ;

To list name and roll_no from STUDENTS;

students from table STUDENTS

To delete roll_no of 215 from STUDENTS

delete from STUDENTS where roll_no='215'

FOR MORE SUCH QUESTIONS:

brainly.in/question/29476414

#SPJ1