PRACTICAL 4 TABLE DATA

 CREATE TABLE STUDENTS ( StuID INT, FirstName VARCHAR(25), LastName VARCHAR(25),    Website VARCHAR(50), City VARCHAR(25), Division VARCHAR(20), SPI DECIMAL(4,2) );

INSERT INTO STUDENTS VALUES (1011, 'Keyur', 'Patel', 'techonthenet.com', 'Rajkot', '3-ITX', 8.5);

INSERT INTO STUDENTS VALUES (1022, 'Hardik', 'Shah', 'digminecraft.com', 'Ahmedabad', '5-ITY', 7);

INSERT INTO STUDENTS VALUES (1033,'Kajal', 'Trivedi', 'bigactivities.com', 'Baroda', '3-CEX', 9.8);

INSERT INTO STUDENTS VALUES (1044, 'Bhoomi', 'Gajera', 'checkyourmath.com', 'Ahmedabad', '5-CEZ', 8.2);

INSERT INTO STUDENTS VALUES (1055, 'Harmit', 'Mitel', NULL, 'Rajkot', '7-ITY', 5.9);

INSERT INTO STUDENTS VALUES (1066, 'Ashok', 'Jani', NULL, 'Baroda', '3-ECX', 6.2);

DBMS LAB EXAM 1

DBMS LAB EXAM 1 QUESTIONS : (Exam will taken in next DBMS lab as per timetable)

1 List the relational algebra operators. List the type of joins in relational algebra. Explain all joins with example.

2 Explain set operation with example.

3 Explain the term ‘Generalization’, ‘Specialization’ and ‘Aggregation’ with example.

4 Define with examples. A. Weak Entity Set B. Strong Entity Set C. Total Participation D. Partial Participation E. Single Valued Attribute F. Multivalued Attribute G. Derived Attribute I. Composite Attribute.

DBMS PRACTICAL 1 TABLES

CREATE TABLE DEPOSIT (ACTNO INT, CNAME VARCHAR(50), BNAME VARCHAR(50), AMOUNT DECIMAL(8,2), ADATE DATE);

CREATE TABLE BORROW (LOANNO INT, CNAME VARCHAR(50), BNAME VARCHAR(50), AMOUNT DECIMAL(8,2));

INSERT INTO DEPOSIT VALUES(101, 'ANIL', 'VRCE', 1000, '01/03/1995');

INSERT INTO DEPOSIT (ACTNO, CNAME, BNAME, AMOUNT, ADATE) VALUES(102, 'SUNIL', 'AJNI', 5000, '04/01/1996');

INSERT INTO DEPOSIT VALUES(103,'MEHUL', 'KAROLBAGH', 3500, '11/11/1995');

INSERT INTO DEPOSIT VALUES(104,'MADHURI', 'CHANDI', 1200, '12/07/1995');

INSERT INTO DEPOSIT VALUES(105,'PRAMOD', 'M.G.ROAD', 3000, '03/27/1995');

INSERT INTO DEPOSIT VALUES(106,'SANDEEP', 'ANDHERI', 2000, '03/31/1996');

INSERT INTO DEPOSIT VALUES(107,'SHIVANI', 'VIRAR', 1000, '09/05/1995');

INSERT INTO DEPOSIT VALUES(108,'KRANTI', 'NEHRU PLACE', 5000, '07/02/1995');

INSERT INTO DEPOSIT VALUES(109,'MINU', 'POWAI', 7000, '08/10/1995');

INSERT INTO BORROW VALUES(201, 'ANIL', 'VRCE', 1000);

INSERT INTO BORROW VALUES(206, 'MEHUL', 'AJNI', 5000);

INSERT INTO BORROW VALUES(311, 'SUNIL', 'DHARAMPETH', 3000);

INSERT INTO BORROW VALUES(321, 'MADHURI', 'ANDHERI', 2000);

INSERT INTO BORROW VALUES(375, 'PRAMOD', 'VIRAR', 8000);

INSERT INTO BORROW VALUES(481, 'KRANTI', 'NEHRU PLACE', 3000);

SE UNIT 9 MATERIAL FOR MID SEM EXAM

 3 UNIT 9 MATERIAL (FOR MID SEM EXAM ONLY) : DOWNLOAD

CNS UNIT 9 MATERIAL FOR MID SEM EXAM

CNS UNIT 9 MATERIAL (FOR MID SEM EXAM): DOWNLOAD

DBMS PRACTICE QUESTIONS 1

DBMS PRACTICE QUESTIONS 1

1. What is indexing? Explain different types of indexing with example. (UNIT 6)

2. What is hashing?  Explain types of hashing. Explain open hashing and closed hashing. (UNIT 6)

3. Explain query processing steps with diagram. (UNIT 5)

4. Create a b tree for following key values. 2,3,5,7,11,17,19,23,29,31) Assume that the tree is initially empty and values are added in ascending order. Consider the number of pointers in each node as four. (UNIT 5)

DBMS PRACTICE QUESTIONS 2

DBMS PRACTICE QUESTIONS 2

1. Explain all types of JOINS in relational algebra with example. (UNIT 3)

2. Explain SET OEPRATIONS in relational algebra with example. (UNIT 3)

3. How can we measure cost of Join query? Explain using example. (UNIT 5)

4. Explain query optimization process. (UNIT 5)