Consider the following database tables and answer queries using SQL.

July 7, 2021 in C and CPP

What is identifying relationship? When is it used?

c) What is identifying relationship? When is it used?

July 7, 2021 in C and CPP

What is recursive relationship? Explain with example.

b) What is recursive relationship? Explain with example.

July 7, 2021 in C and CPP

What are views? How is it related to data Independence?

a) What are views? How is it related to data Independence?

July 7, 2021 in C and CPP

In the ________ normal form, a composite attribute is converted to individual attributes.

A. 2NF B. Alternate Keys C. Range
D. External hashing E. Ordered F. Internal hashing
G. Key H. Dependency preservation I. 1NF
J. Column K. Relation L. BCNF
M. Unordered

4.1 In the ________ normal form, a composite attribute is converted to individual attributes.
4.2 All Candidate Keys excluding the Primary Key are known as ________.
4.3 Target space is made of buckets in ________.
4.4 The term attribute refers to a ________ of a table.
4.5 Functional Dependencies are the types of constraints that are based on ________.
4.6 ________ is stricter than 3NF.
4.7 Primary index is created on a file when file is ________.
4.8 ________ is an association among two or more entities.
4.9 ________ is a property of lossless decomposition.
4.10 File of ________ records are called heap files.

July 7, 2021 in C and CPP

In an ER diagram single line represents partial participation of an entity in a relationship.

Each statement below is either TRUE or FALSE. Choose the most appropriate one and
ENTER in the “OMR” answer sheet supplied with the question paper, following
instructions therein.

2.1 In an ER diagram single line represents partial participation of an entity in a relationship.
2.2 Primary Key of a relation is minimum super key.
2.3 It is not allowed to insert duplicate records in database.
2.4 Placing Null values for an attribute is avoided as they do not have any specific meaning.
2.5 Group by is an example of aggregate function.
2.6 Modifying the database without ensuring that transaction will commit may leave database in a consistent state.
2.7 Tables in second normal form (2NF) eliminate all hidden dependencies.
2.8 A database is ordered collection of data.
2.9 A relation cannot have more than one key.
2.10 Union is a relational algebra operation.

July 7, 2021 in C and CPP

Values of Key attributes cannot be NULL is a requirement of

1.10 Values of Key attributes cannot be NULL is a requirement of
A) Key Constraint
B) Entity Integrity Constraint
C) Referential Integrity Constraint
D) None of the above

July 7, 2021 in C and CPP

Threats to the databases result in the loss or degradation of the following:

1.9 Threats to the databases result in the loss or degradation of the following:
A) Loss of integrity
B) Loss of availability
C) Loss of confidentiality
D) All of the above

July 7, 2021 in C and CPP

Maximum number of relationship instances that an entity can participate in a relationship is called

1.8 Maximum number of relationship instances that an entity can participate in a relationship is
called
A) Degree
B) Cardinality ratio
C) Min-max constraints
D) None of the above

July 7, 2021 in C and CPP

Single entity having more than one role in the same relationship is an example of

1.7 Single entity having more than one role in the same relationship is an example of
A) Binary relationship
B) Identifying relationship
C) Recursive relationship
D) Ternary relationship