Hello learners In this article we are going to discuss NPTEL Introduction to Database Systems Assignment 2 Answers. All the Answers provided below to help the students as a reference, You must submit your assignment with your own knowledge and use this article as reference only.
About the course:-
Databases are the backbone of almost all the digital services and e-governance solutions. Modern businesses and financial systems heavily depend on databases systems and transaction processing for their successful operation. This course introduces the students to the various theoretical and practical principles involved in the design and use of databases systems with the help of database management systems (DBMS) and the SQL Standard
NPTEL Introduction to Database Systems Assignment 2 Answers 2024:
1. An attribute of an entity can be both simple as well as multi-valued
Answer :- a
2. Only entity sets/types can have attributes associated with them.
Answer :- b
3. An attribute of an entity can be both composite as well as single-valued.
Answer :- a
4. An attribute of an entity can be both composite as well as simple.
Answer :- b
5. Consider the statements:
S1: The key of an entity type always consists of a single attribute.
S2: The key of an entity type may have more than one attribute.
S3: An entity type has exactly one key.
S4: An entity type may have more than one key.
Which of the following is correct?
Answer :- d
6. Suppose X is a composite attribute of an entity type and has three components – C1, C2 and C3, where only C2 is multi-valued. If domain
sets of C1, C2 and C3 have 5, 3, and 4 elements respectively, what is the size of the domain of X?
Answer :- d
7. Suppose R is a relationship type with three participating entity types E1, E2, E3. If the number of entities in E1, E2 and E3 are 5, 10,
and 4, respectively, the cardinality of the set of all possible instances of R is:
Answer :- c
8. Suppose isPartOf is a relationship type with two participating entity types District and State. What is the appropriate cardinality ratio
for District:State?
Answer :- b
9. Suppose Author is a relationship type with two participating entity types Person and Book. What is the appropriate cardinality ratio for Person:Book?
Answer :- c
10. Consider the binary relationship type BiologicalMother between entity types Person and Woman . Suppose the cardinality ratio
(Person: Woman) constraint of the relationship is expressed using (min,max) notation as (u,v) on the line connecting Person
to BiologicalMother and (x,y) on the line connecting Woman to BiologicalMother, which one of the following is correct:
Answer :- c
11. Suppose entity set A = {a,b,c,d,e} and entity set B = {w,x,y,z} and they participate in a relationship R and the instances in R
are: { (a,w), (b,w), (c,x), (d,x), (e,y) }. Which one of the following is correct?
Answer :- c
12. A weak entity can exist even if it is not related to any other entity.
Answer :- b
13. Key of an entity set can be determined by examining current entities in the set.
Answer :- b
14. A weak entity type can not be the owner of another weak entity type.
Answer :- b
15. Weak entity type participates partially in the relationship that connects it to its owner.
Answer :- b
16. Consider the following sets:
C = { p: weak entity type; q: multi-valued attribute; r: derived attribute: s: relationship type}
D = { w: dashed-line ellipse; x: diamond box; y: double-line rectangle; z: double-line ellipse}
The correct match between elements of C and D is
Answer :- c
