Relational Database Management System RDBMS May 2017 CSE/IT Diploma Paper

Download Previous Year Diploma Solved Question Paper of Relational Database Management System RDBMS May 2017 CSE/IT Diploma Paper Relational Dat

Download Previous Year Diploma Solved Question Paper of Relational Database Management System RDBMS May 2017 CSE/IT Diploma Paper

Relational Database Management System RDBMS May 2017 CSE/IT Diploma Paper

                                   SECTION-A

Q1. Fill in the blanks.                                                      15×1=15

i. Full form of BCNF is ______________.
ii. The set of all possible values an attribute can have is called its __________ .
iii. Draw the symbol for entity and derived attribute.
iv. An __________ diagram represents the overall logical structure of a database in a graphical form.
v. Define cardinality?
vi. _____________ command is used to take back privileges from the user.
vii. Name any one DBMS.
viii. Write the syntax of UPDATE command with example.
ix. SQL is a non-procedural language. (T/F) 
x. Commit means save the work done. (T/F) 

                                      SECTION-B

Q2. Attempt any five questions.                                                                    5×6=30

i. What is data independence? Differentiate between logical and physical data independence?
ii. Explain various types of relationships among entities?
iii. What are various integrity constraints? Explain.
iv. Define transaction? List the various properties of a transaction?
v. Define the following terms
a) Primary key
b) Entity
c) Schema
vi. Briefly describe the different kinds of users of DBMS?

                                     SECTION-C

Q3. Attempt any three questions.                                                       3×10=30

i. Discuss the various advantages and disadvantages of DBMS.
ii. What is normalization? Explain the 1st and 2nd normal forms with example?
iii. Explain the architecture of DBMS.
iv. Explain the various data types used in SQL?

Relational Database Management System RDBMS May 2017 CSE/IT Diploma PSBTE Solved Paper

                                   SECTION-A

Q1. Fill in the blanks.                                                      15×1=15

i. Full form of BCNF is Boyce–Codd Normal Form .
ii. The set of all possible values an attribute can have is called its Domain .
iii. Draw the symbol for entity and derived attribute.
iv. An Entity Relationship diagram represents the overall logical structure of a database in a graphical form.
v. Define cardinality?
vi. REVOKE command is used to take back privileges from the user.
vii. Name any one DBMS.

Sol. 1.Oracle  2.MySQL. 

viii. Write the syntax of UPDATE command with example.

Sol. UPDATE table_name SET column_name = value [, column_name = value …]
ix. SQL is a non-procedural language. (T/F)

Sol. FALSE
x. Commit means save the work done. (T/F)

Sol.TRUE

Full form of BCNF is Boyce–Codd Normal Form .

The set of all possible values an attribute can have is called its Domain .

 An Entity Relationship diagram represents the overall logical structure of a database in a graphical form.

Cardinality.

REVOKE command is used to take back privileges from the user.

Sol. 1.Oracle  2.MySQL. 

 

Syntax of UPDATE command with example.

Sol. UPDATE table_name SET column_name = value [, column_name = value …]

RDBMS May 2017 CSE/IT Diploma Solved Paper Click Here

Data independence.

Differentiate between logical and physical data independence.

Types of relationships among entities.

Transaction and various properties of a transaction.

RDBMS 3rd Semester CSE May 2017 Diploma Solved Paper Click Here

RDBMS 3rd Semester CSE MAY 2017 Diploma Solved Paper

Normalization

Explain the 1st and 2nd normal forms 

Architecture of DBMS.

Various data types used in SQL.

RDBMS 3RD Sem CSE MAY 2017 Diploma Solved Paper Contact Us
MY YOUTUBE CHANNEL
JK Smart Classes Upload Lecture for Degree classes like B.TECH,M.TECH in any stream like ECE,EE,ME and Civil Engineering
JK SMART CLASSES
JK SMART CLASSES
ER.JASWINDER KUMAR
JK SMART CLASSES
JK SMART LECTURE
ER.JASWINDER KUMAR
Engineering Classes Upload Lecture for Polytechnic Diploma classes in any stream like ECE,EE,ME and Civil Engineering
JK SMART CLASSES
ENGINEERING CLASSES
ER.JASWINDER KUMAR
JK SMART CLASSES
er.jaswinder kumar
Senior Lecturer

COMMENTS

WORDPRESS: 0

Categories