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.
Various integrity constraints.
Transaction and various properties of a transaction.
a) Primary key
b) Entity
c) Schema
Different kinds of users of DBMS.
RDBMS 3rd Semester CSE May 2017 Diploma Solved Paper Click Here
Advantages and disadvantages of DBMS.
Normalization
Explain the 1st and 2nd normal formsÂ
Architecture of DBMS.
Various data types used in SQL.