Introduction to Database Systems Week 2 Quiz Answers Nptel 2026
Are you looking for NPTEL Introduction to Database Systems Week 2 Quiz Answers 2026? You’ve come to the right place! Access the most accurate answers at Progiez.
Table of Contents
Introduction to Database Systems Week 2 Quiz Answers (Jan-Apr 2026)
Que.1
An entity type may have more than one attribute.
a) True
b) False
Que.2
A relationship type may have more than one attribute.
a) True
b) False
Que.3
A strong entity type always has a key.
a) True
b) False
Que.4
A weak entity type always has a key.
a) True
b) False
Que.5
Suppose Total-Salary attribute of employee entity type is computed using attributes Base-Salary, HRA, and Other-Allowances. Choose the most appropriate type for attribute Total-Salary:
a) Single valued
b) Multi valued
c) Composite
d) Single-valued and derived
Que.6
Suppose WorksFor is a relationship type with two participating entity types Employee and Company. Say, it represents the full-time job of the employees. What is the appropriate cardinality ratio for “Employee : Company”?
a) 1:1
b) N:1
c) 1:N
d) M:N
Que.7
Suppose BankAccount is a relationship type with two participating entity types Person and Account in a bank. What is/are the possible cardinality ratio(s) for “Person : Account”?
a) Only P
b) Only P & Q
c) Only P, Q & R
d) All cardinality ratios are possible
Que.8
Suppose Assigned is a many-to-one relationship type with two participating entity types Employee and Department. A maximum of seven employees are assigned to a department. If in the ER diagram, the line that connects Employee to the relationship type Assigned is to be labeled with (x, y) using min–max notation, choose the correct option:
a) x = 1, y = 7
b) x = 1, y = 1
c) x = 7, y = 1
d) x = 7, y = 7
Que.9
Consider the statements given below:
S1: The owner of a weak entity is always a strong entity.
S2: Entity sets must be disjoint.
Choose the correct option:
a) S1: True ; S2: True
b) S1: True ; S2: False
c) S1: False ; S2: True
d) S1: False ; S2: False
Que.10
Consider the following sets:
S1: {p: strong entity; q: weak entity; r: relationship; s: multi-valued attributes}
S2: {w: double-lined rectangles; x: diamond; y: rectangle; z: double-lined ellipses}
Choose the correct matching between S1 and S2:
a) p: w; q: x; r: y; s: z
b) p: w; q: x; r: z; s: y
c) p: y; q: w; r: x; s: z
d) p: y; q: w; r: x; s: x
Que.11
Consider the following attributes of the various entity types:
A1: Customer-Mobile-Number (Domain: Banking)
A2: Customer-City-Name (Domain: Banking)
A3: Airport-Code (Domain: Airline)
A4: Student-Email-Id (Domain: University)
Consider the typical modeling situations about the given domains and choose the FALSE statement:
a) Attribute A1 may be a key attribute of customer entity
b) Attribute A2 may be a key attribute of customer entity
c) Attribute A3 may be a key attribute of airport entity
d) Attribute A4 may be a key attribute of student entity
Que.12
Consider two entity sets A = {a, b, c, d} and B = {w, x, y, z} and they participate in a relationship R. The instances of R are:
{(a, w), (a, x), (c, y), (d, z), (c, z)}.
Which one of the following is correct?
a) Cardinality ratio of A:B is one-to-many; A participates partially; B participates completely
b) Cardinality ratio of A:B is many-to-one; A participates completely; B participates completely
c) Cardinality ratio of A:B is one-to-many; A participates completely; B participates partially
d) Cardinality ratio of A:B is many-to-many; A participates partially; B participates partially
Que.13
Consider two entity sets A = {a, b, c, d, e} and B = {w, x, y, z} and consider a relation R as a many-to-one relationship from entity set A to entity set B. Assume that A and B participate totally in R. Which one of the following is TRUE about R?
a) Every entity in A is associated with exactly one entity in B
b) Some entity in A is associated with more than one entity in B
c) Every entity in B is associated with exactly one entity in A
d) Every entity in B is associated with at most one entity in A
(Jan-Apr 2025)
Course Link: Click Here
1. While creating an ER diagram, Arjun is confused as to what shape he must choose to represent the attribute “Hobby” of the Person entity type. Arjun understands that a person may have many hobbies. Which of the shapes should he choose?
- Ellipse
- Double Ellipse
- Ellipse connected to an Ellipse
- Dotted-line Ellipse
2. Suppose R is a relationship type with two participating entity types E1 and E2. The number of entities in E1 and E2 are 2 and 4, respectively. How many different non-empty relationship sets are possible in this case?
- 255
- 8
- 2256
- 256
3. Suppose X is a composite attribute of an entity type and has three components – C1, C2 and C3, where C1 and C2 are multi-valued. If domain sets of C1, C2 and C3 have 2, 3, and 5 elements respectively, what is the size of the domain of X?
- 30
- 160
- 32
- 128
4. Suppose worksAt is a relationship type with two participating entity types Person and Organisation. What is the appropriate cardinality ratio for Person:Organization?
- 1:N
- N:1
- M:N
- 1:1
5. In the company XYZ, employees are given freedom to choose upto 3 projects to work on. Usually, a team of 4-5 people work on a given project. Suppose worksOn is a relationship type with two participating entity types Employee and Project. What is the appropriate cardinality ratio for Employee:Project
- 1:N
- N:1
- M:N
- 1:1
6. Consider a binary relationship ExistsIn between entity types City and State. It records as to which city is located in what state. Suppose the cardinality ratio constraint of the this relationship is expressed using (min,max) notation as (u,v) on the line connecting City to ExistsIn and (x,y) on the line connecting State to ExistsIn, which one of the following is correct: (Assume that the capital of any state is a city).
- u,v) = (1,1); (x,y) = (0,N)
- (u,v) = (1,N); (x,y) = (1,1)
- (u,v) = (1,1); (x,y) = (1,N)
- (u,v) = (1,N); (x,y) = (0,N)
7. The value of a composite attribute depends on the value of some other attribute.
- True
- False
8. The domain of a multi-valued attribute is the set of subsets of the set consisting of basic values.
- True
- False
9. In many to one binary relationships between two entities E1 and E2, an E2 entity may be associated with many E1 entities whereas an E1 entity may be associated with at most one E2 entity.
- True
- False
10. An entity set relating to itself gives rise to a recursive relationship
- True
- False
11. Suppose entity set A = {a,b,c,d,e} and entity set B = {w,x,y,z}. They participate in a binary relationship R and the instances in R are: { (a,w), (a,z), (b,w), (c,x), (d,x), (e,y) }. Which one of the following is correct?
- Cardinality ratio A:B is many-to-one; A participates partially; B participates completely.
- Cardinality ratio A:B is one-to-many; A participates completely; B participates completely.
- Cardinality ratio A:B is many-to-one; A participates completely; B participates partially.
- Cardinality ratio A:B is many-to-many; A participates completely; B participates completely.
12. Choose the correct statement
- A weak entity can exist even if it is not related to any other entity.
- Relationship types can have attributes.
- A weak entity type can not be the owner of another weak entity type.
- Weak entity set has to have a key attribute.
13. Which of the following is true with respect to ER model design choices:
- Weak entities are preferred over composite multi-valued attributes in every single case
- Composite multi-valued attributes are preferred over weak entities in every single case
- If a thing, not of independent existence, participates in a relationship, it is better to model it as a weak entity
- If a thing, not of independent existence, participates in a relationship, it is better to model it as a composite multi-valued attribute
Introduction to Database Systems Week 2 Quiz Answers
For answers to others Nptel courses, please refer to this link: NPTEL Assignment