NAAC

JG0)
ARKA JAIN
ANSWER SHEET GRADE A Booklet 281791
No
University
Jharkhand
ACCHE61TED UIVEN$rrY

Enrollment No ATU/230498
Date
442025
Academic
24-25 Exam No. of continuation
tolSemester 4 tA sheets used
Course
Section TechCse'E Year
Student's
HIM ANSHU PAUL Signature
Name
Roll No.
Subject Rlational aabau Homagenit BTCS-OS- o4
For Office Use Only

Invigilator Name
Signature (with date) Any Rernarks
S. No.

Q1oQ11/Q12/Q13/014o15
No. of Ques. Q1Q2 Q3 Q4 Qs Q6 Q7Q8Q9
Total Marks
Total Marks
Marks Obtained
Marks Obtained

Name of the Signature

Examiner

Rechecking Signature
Authority
Rules &Requlations
is strictly prohibited.
1. Use of any electronic devices like calculator, mobile phone etc.
appearing in the examination.
2. Any student caught using unfair means of cheating will be immediately disqualified from
inside the examination hall. For security
3. No unauthorized material such as book, paper, document or picture is allowed advised not to leave any valuable
candidates must leave their bags outside the examination
reasons, halls. You are
belongings in your bag. If it is possible, do not bring your bag at all.
the examination hall.
4. The university will not be responsible for the loss of candidate's belongings in or outside
5. No candidate is allowed to leave his/her seat without the permission of the invigilator.
blue/black pen. Answers written in
6. Allanswers, with the exception of graphs, sketches,diagrams etc. should be written in
pencil/red/green pen willnot be marked.
7. All materials/devices which are found to violate any examination rules and regulations will be confiscated.
8. Do not write in red pen or pencil unless specified on the examination paper
be used tor
9. Candidates should write on both sides of each page in the answer book. Any page in the answer book may page:
"rough work as long as a clear diagonal line is drawn across the page, and is specially mentioned to as rough
10. Candidates should begin the answer to each question on a new page. Number each question.
during the
11. Students are not allowed to leave the examination hall during the frst 3o minutes of theexamination and
last 15 minutes of the examination.

Thisanswer book contains 8 pages

dG ARKA JAIN NAAC
University (2) GRADE A
Jharkhand

AH- oindlntrt OoL ayd DML tommand

SOL

THEO2y:
Mata
DyL- ata
lampalala agng
SOURCE COO:
PART-A
CREAT DATAGASE
e db

CREAT E TAGLE stadbt(

Dtdt I) INT PRIMARY KEY,
Name VARCHAR so) NoT AluLL
IAT CHfk (Asez IB))
E'l VARCHAR1oo) NIQUE NDT NVLL
Rhocla ben CIAR (1o)CHECk(LENaTH!la
CREA TE TAGLf Enyoll neti
Snsallatt 10 INI PRIMAAY KEY
ptudat I0 INT
 NAAC
JG) ARKAJAIN (3) GRADE AA
University
Jharkhand

Jlnaten INI_CHECI(Dntin BETWELN I4HAJE

fORE TGN key(atadnt IO) RELERE NLES stlt

PARTB

IN SERT INTO stidot (utalatI0, Alaenay,h¡e, Email, Ahoaky

VALVE S
0'hdha laall 0, 'huiehe@gnilcan12 3456lB2d)s

6'Alie Lalie Qjmaik Co22 33565s al)

223344S564
(5, 0hyan 23 biska@ gmilton2a4455K677)

THSEAT TNTO Roeallst aoelbnatro, tudotze,

VALUES

22, Plyiu to2 2),

S, 5, BnglilK los' s),

 NAAC
JG) ARKA JAIN (4)
GRADE A
University
Jharkhand

UPDA TE ttadot
SET Rhore Nen ber 9714 /22801)
WHERE Nan /Aiec

DELETE FROM Enellme

 MysQL Workbench
Local instance MySQL80 x
File Edit View Query Database Server Tools Scripting Help
S

Navigator: SQL File 3* courselog account balances trarnsacfions atudents COurses

SCHEMAS Lirrit to 1000 rows

4 Flter objects 1 CREATE DATABASE db;
aditya 2 USE db
aju
awais
HTables 4 Create the tables
account_balances 53 CREATE TABLE Student (
courselog StudentID INT PRIMARY KEY,
Courses
students 7 Name VARCHAR(50) NOT NULL,
transactions Age INT CHECK (Age >= 18),
Views
EmailVARCHAR(100) UNIQUE NOTNULL,
Stored Pro cedures
Functions
10 PhoneNumber CHAR(10) CHECK (LENGTH(PhoneNumber) = 10)
ayush 11
lib rary 12
library
movie
13 CREATE TABLE Enrollments
pratima 14 EnrollmentID INT PRIMARY KEY,
rahul 15 StudentID INT

Ri xsi
rajiv 16 CourseName VARCHAR(100) NOT NULL,
sakila
str 17 Semester INT CHECK(Semesten BETWEEN 1 AND 8) I
sys 18 FOREIGN KEY (StudentID) REFERENCES Student (StudentID)
world
19
20
21 Insert students (with etors)
Administration Schemas 22 INSERT INTO Student (StudentID, Name, Age, Email, PhoneNumber)
23 VALUES
Information
24 (2, Himanshu Paul 20, Himanshu@[Link]'1234567890" )
Schema: library 25 (2, Dheeraj' 24, dheenaj@[Link]",987654321 )»
26 (8,Alice, 16,[email protected] ),
27 (4,Raj#' 21,naja@example,com 223B445566 ),
28 (5,Shyan 2,ishav@[Link] 334455667),
29 (6,Rishay20,[email protected] )
BO
B1

Object Info Session Output

Search
ce MySQL80 X
Query Database Server Tools Scripting Help

SQL File 3 courselog acCOun balances rarsoctions students Courses

Lirnit to 1000rows
21 -Insert students (with errors)
22 INSERT INTO Student (StudentID, Name, Age, Email, PhoneNumber)
23 VALUES
24 (1, Himanshu Paul 20, Himanshu@[Link],1234567890),
unt balances 25 (2, Dheeraj , 24,dheerai@gmail. com',0987654321),
se log
ses
26 (3, Alice l16,alice@example. com"1122335559'),
ents 27 (43 Raja, 21,[Link]"2233445566'),
sactions 28
(5, Shyam 23,nishav@gmail. com3344556677'),
ro cedures
29 (6, Rishav 20,[email protected]');
31

32
INSERT INTO Enrollments (EnrollmentID, StudentID, CourseName, Semester)
33 VALUES
34 (1, 1,Math 101,),
35 (2, 2,'Physics 102 2)
36 (9, 3, Chemistry 10BF):
37 (4, 43,Biology 104 4)
38 (5, 5, English 105" 5)
39 (5, 456,Histanys9);
40
41
Schemas 42 UPDATE Student
43 SET PhoneNumber =98765421
44 WHERE Name=ACe
orary 45
46 DELETE FROM Enrollments
4 WHERE StudentID
48

49
50
51

Session Output
earch
 SQL File 3* COUrse log aCCOUnt Dollaee

Limit to 1000 rows

21 -- Insert students (with errors)

22 INSERT INTO Student (StudenttID, Name, Age, Email, PhoneNumber)
23 VALUES

(1, 'Himanshu Paul'y 20, Himanshu@[Link]'1234567890)

CCount balances (2, "Dheeraj', 24, dheeraj@[Link]', 0987654321),
ourse log 26 (3, 'Alice ', 16,alice@[Link] , 1122335559)
ourses 'raja@[Link]',2233445566'),
tudents
27 (4, 'Raja', 21,
ransactions 28 (5, 'Shyam", 23, rishav@[Link],3344556677 )
S 29 (6, Rishav', 20, rishav@[Link]',4452345688 )5
ed Procedures
ions
31
Semester)
32 INSERT INTO Enrollments (EnrollmentID, StudentID, CourseName,
33 VALUES
34 (1, 1, "Math 101', 1),
35 (2, 2, 'Physics 102 , 2),
36 (3, 3, 'Chemistry 103, 3),
37 (4, 4, 'Biology 104', 4),
38 (5, 5, 'English 105', 5),
(6, 456, "History 106 9)

Schemas
Output
Action Output
Message
Time Action
1row(s) affected
orary 1 [Link] CREATE DATABASE db
2 [Link] USE db
O
row(s) affected
Age INT CHECK (Age. Orow(s) affected
3 [Link] CREATE TABLE Student( StudentID INT PRIMARY KEY, Name VARCHAR(50NOT NULL,
Enrollment|D INT PRIMARY KEY. StudentID INT, Course Name VARCHAR(100) NO. 0row(s) affected
4 [Link] CREATE TABLE Enrollments
(Student|D, Name, Age, Email, PhoneNumber) VALUES (1, Himanshu Paul', 20, Himanshu@gamil. Eror Code: 3819. Check constraint 'student chk 1' is violated
5 [Link] INSERT INTOStudent
2, Physics Eror Code: 1452. Cannot add or update a child row: a foreign key constrai
6 [Link] INSERT INTO Enrollments (Enrollment|D, Student|D, CourseName, Semester) VALUES (1, 1, Math 101, 1), (2.

ssion