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.
Cardinality.
________ command is used to take back privileges from the user.
REVOKE command is used to take back privileges from the user.
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](\"https://www.psbtepaper.com/wp-content/uploads/2020/03/JK-SMART-CLASSES-removebg-preview-1.jpg\")
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