Question

Create a database with the name ‘Student’. Create a table in the Design view with the following structure:
SId (primary key), SName, Math_marks, Sci_Marks, Eng_marks and enter the data for five students. Create a Query which gives the output for all records of Sci_Marks less than 40 and save the Query in the name of “Sci_Query”.

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

Answer 2

and" (and any subsequent words) was ignored because we limit queries to 32 words.

mark me brainlist