Scribd
Upload
15 views2 pages

20,21 DMS

The document outlines the creation and insertion of data into four tables: MARKSHEET_, MARKSDETAILS, BTS, and BTS2. Each table contains various fields such as roll number, name, marks, age, and date of birth, with sample data provided for each. The document includes SQL commands for creating the tables and inserting records into them.

Uploaded by

swaralibarve831
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
15 views2 pages

20,21 DMS

The document outlines the creation and insertion of data into four tables: MARKSHEET_, MARKSDETAILS, BTS, and BTS2. Each table contains various fields such as roll number, name, marks, age, and date of birth, with sample data provided for each. The document includes SQL commands for creating the tables and inserting records into them.

Uploaded by

swaralibarve831
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

DATE: 15/7/2024

1. TABLE
CREATE TABLE MARKSHEET_
(
ROLLNO NUMBER (2),
NAME VARCHAR (10),
MARKS NUMBER (2)
);

INSERT INTO MARKSHEET_ VALUES (21,'SWARALI','29')


INSERT INTO MARKSHEET_ VALUES (20,'MANTRA','29')
INSERT INTO MARKSHEET_ VALUES (22,'SWANANDI','29')

SELECT * FROM MARKSHEET_

2.TABLE
CREATE TABLE MARKSDETAILS
(
ROLLNO NUMBER (2),
NAME VARCHAR (10),
MARKS NUMBER (2),
DATEOFBIRTH DATE
);

INSERT INTO MARKSDETAILS VALUES (1,'MANTRA','29','02/21/2008')


INSERT INTO MARKSDETAILS VALUES (2,'SWARALI','29','08/31/2007')
INSERT INTO MARKSDETAILS VALUES (2,'SWANANDI','29','03/19/2007')

SELECT * FROM MARKSDETAILS;

3. TABLE

CREATE TABLE BTS


(
SRNO NUMBER (1),
NAME VARCHAR (10),
AGE NUMBER (2),
DATEOFBIRTH DATE
);

INSERT INTO BTS VALUES (1,'RM',30,'09/12/1994')


INSERT INTO BTS VALUES (1,'JIN',31,'09/12/1993')
INSERT INTO BTS VALUES (3,'SUGA',31,'03/09/1993')
INSERT INTO BTS VALUES (4,'JHOPE',30,'02/18/1994')
INSERT INTO BTS VALUES (5,'JIMIN',29,'10/13/1995')
INSERT INTO BTS VALUES (6,'V',29,'12/31/1995')
INSERT INTO BTS VALUES (7,'JUNGKOOK',27,'09/01/1997')

SELECT *FROM BTS;

4. TABLE

CREATE TABLE BTS2


(
SRNO NUMBER (1) PRIMARY KEY,
NAME VARCHAR (10),
AGE NUMBER (2),
DATEOFBIRTH DATE
);

INSERT INTO BTS2 VALUES (1,'RM',26,'09/12/1994')


INSERT INTO BTS2 VALUES (2,'JIN',28,'12/04/1992')

You might also like