Introduction to Database Systems Week 2 Quiz Answers Nptel
Are you looking for NPTEL Introduction to Database Systems Week 2 Quiz Answers? 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 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
