Question

Create a database of students. Make a table in design view with the following fields:Roll number , student name, age, total marks. A)students who have
passed(marks>250) B) students with roll number 2,6 and 9 C) failed students with marks less than 250

Answer 1

Answer:

create table "tablename"  

("column1" "data type",  

"column2" "data type",  

"column3" "data type",  

...  

"columnN" "data type");  

The data type of the columns may vary from one database to another. For example, NUMBER is supported in Oracle database for integer value whereas INT is supported in MySQL.

Let us take an example to create a STUDENTS table with ID as primary key and NOT NULL are the constraint showing that these fields cannot be NULL while creating records in the table.

SQL> CREATE TABLE STUDENTS (  

ID INT                           NOT NULL,  

NAME VARCHAR (20) NOT NULL,  

AGE INT                         NOT NULL,  

ADDRESS CHAR (25),  

PRIMARY KEY (ID)  

);  

Explanation:

Use Above format and create your own