PSBTE PAPER

PSBTEPAPER.COM

Question Papers & Solutions

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

Relational Database Management System RDBMS Dec 2018 CSE/IT Diploma Paper


Get Started

https://www.youtube.com/watch?v=y_wJffQkeWo&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=6&t=0shttps://www.youtube.com/watch?v=mV41CMWonN4&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=7&t=0shttps://www.youtube.com/watch?v=M_RR6LVICp0&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=20&t=0shttps://www.youtube.com/watch?v=3BNQLUnbNpYhttps://www.youtube.com/watch?v=ZDkyNOzoG8A&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=8&t=0shttps://www.youtube.com/watch?v=s0LVPE0Q3LE&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=14&t=0s

Section aRelational Database Management System RDBMS MAY 2017 CSE/IT Diploma Paper

Full form of BCNF is _______________________

Full form of BCNF is Boyce–Codd Normal Form .

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

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

Draw the symbol for entity and derived attribute.
An ______________ diagram represents the overall logical structure of a database in a graphical form.

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

Define cardinality?

Cardinality.

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

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

Name any one DBMS.

Sol. 1.Oracle  2.MySQL. 

Write the syntax of UPDATE command with example.

Syntax of UPDATE command with example.

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

SQL is a non-procedural language. (T/F)

FALSE

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

TRUE

RDBMS May 2017 CSE/IT Diploma Solved Paper Click Here

Section B :Relational Database Management System RDBMS may 2017 CSE/IT Diploma Paper

What is data independence? Differentiate between logical and physical data independence?

Data independence.

Differentiate between logical and physical data independence.

Explain various types of relationships among entities?

Types of relationships among entities.

What are various integrity constraints? Explain.

Various integrity constraints.

Define transaction? List the various properties of a transaction?

Transaction and various properties of a transaction.

Define the following terms a) Primary key b) Entity c) Schema

a) Primary key
b) Entity
c) Schema

Briefly describe the different kinds of users of DBMS?

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


Get Started

https://www.youtube.com/watch?v=UHX6f8TIvX8https://www.youtube.com/watch?v=M_RR6LVICp0https://www.youtube.com/watch?v=mV41CMWonN4https://www.youtube.com/watch?v=s0LVPE0Q3LE&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=14&t=0s

Section c :-RDBMS 3RD Sem CSE MAY 2017 Diploma Solved Paper

Discuss the various advantages and disadvantages of DBMS ?

Advantages and disadvantages of DBMS.

What is normalization? Explain the 1st and 2nd normal forms with example?

Normalization

Explain the 1st and 2nd normal forms 

Explain the architecture of DBMS.

Architecture of DBMS.

Explain the various data types used in SQL?

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
JK SMART CLASSES
ER.JASWINDER KUMAR
\"JK
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
ENGINEERING CLASSES
ER.JASWINDER KUMAR
\"JK
er.jaswinder kumar
Senior Lecturer

Leave a Comment

Your email address will not be published.