Subscribe for notification

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 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 …]

TRUE

Related Post
RDBMS May 2017 CSE/IT Diploma Solved Paper Click Here

Data independence.

Differentiate between logical and physical data independence.

Types of relationships among entities.

Various integrity constraints.

Transaction and various properties of a transaction.

Different kinds of users of DBMS.

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

RDBMS 3rd Semester CSE MAY 2017 Diploma Solved Paper

Advantages and disadvantages of DBMS.

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
ER.JASWINDER KUMAR
JK SMART LECTURE
ER.JASWINDER KUMAR
Engineering Classes Upload Lecture for Polytechnic Diploma classes in any stream like ECE,EE,ME and Civil Engineering
ENGINEERING CLASSES
ER.JASWINDER KUMAR
er.jaswinder kumar
Senior Lecturer
admin: Hello Friends, I am Jaswinder Kumar Working as HOD (Senior Lecturer) at Polytechnic Engineering College. I Have Three Youtube Channel names as 1.JK Smart Classes 2.JK Smart Lecture 3.Engineering Classes for Helps the Class 12, Diploma, and B.tech Student To achieve the desired goal in an easy way.

This website uses cookies.

Read More