IV/BCA/402 Student's Copy
2 0 1 8
CBCS
4th Semester
BACHELOR OF COMPUTER APPLICATIONS
Paper BCA-402
Database Management Systems
Full Marks 75
Time 3 hours
PART A—OBJECTIVE
Marks 25
The figures in the margin indicate full marks for the questions
SECTION—A
Marks 15
1. Tick the correct answer in the brackets provided 1×10=10
Data are
raw facts and figures
information
electronic representation of facts
All of the above
The data model which describes how the data is actually stored is
internal model logical model
external model All of the above
One limitation of E-R model is that, it cannot
use generalization
express relationship among relationship
use single primary key
All of the above
/545 1 Contd.
Complex entities can be constructed using which of the following
operations?
Sum Union
Aggregation Collection
Which normal form is most desirable?
Domain key normal form (DKNF)
Boyce-Codd normal form (BCNF)
Third normal form NF)
Fourth normal form NF)
The operation of a relation produces such that Y contains only
selected attributes of X. Such an operation is
projection intersection
union difference
GRANT is a command from the SQL type
DDL DML
DCL All of the above
Universal quantifier of relational calculus can be implemented in SQL
using the keyword
NOT EXISTS EXISTS
FOR ALL All of the above
Rollback of transaction is normally used to
recover from transaction failure
update the transaction
retrieve old records
repeat a transaction
Primary key of a table enforces which of the following entity
constraints?
Domain
Referential
Both and
Entity
IV/BCA/402/545 2 Contd.
2. Tick whether the following statements are True or False 1×5=5
Referential integrity constraint is enforced with the help of foreign keys.
T F
Aggregate functions are also known as column function.
T F
Tuple relational calculus is declarative and procedure oriented
language.
T F
Every weak entity set can be converted into a strong entity set by
adding appropriate attributes.
T F
The number of rows associated with the relations is called as the
degree.
T F
SECTION—B
Marks 10
Answer the following questions 2×5=10
1. What is data dictionary?
2. What is denormalization?
3. What is a role? What are its properties?
4. Differentiate between immediate update and deferred update.
5. What are the types of integrity constraints?
PART B—DESCRIPTIVE
Marks 50
The figures in the margin indicate full marks for the questions
1. What is functional dependency? Explain with example. 5
What are the types of DBMS? 5
OR
What are the characteristics of data in database? 5
IV/BCA/402/545 3 Contd.
What are the different types of design constraints? 5
2. What is an attribute? Explain the different types of attributes. 6
What are the degree and cardinality of a relationship? 4
OR
Explain, in detail, superclasses, subclasses and inheritance. 9
Define specialization in DBMS. 1
3. Consider the relation
Teach (Name, Address, Course)
Use standard query commands to do the following 6
Print all the informations about teachers who are teaching the
DBMS course.
Print the names and addresses of those teachers who teach
Select the teacher with name teaching course.
Explain natural join with example. 4
OR
What are the different types of relationships? 3
Explain in detail the two operations of relational algebra—union and
intersection. 7
4. What is cursor in SQL? What are its types? 4
Explain with example the statements used to handle cursors. 6
OR
Explain with diagram the three-schema architecture. 7
What is data independence? 3
5. What are the ACID properties in a transaction? 4
Explain the different data security risks. 6
OR
What is a database privilege? What are its two categories? 4
What are the different types of database users? 6