NPTEL Introduction to Database Systems Assignment 2 Answers 2023

Hello Learners, In this Post, you will find NPTEL Introduction to Database Systems Assignment 2 Week 2 Answers 2023. All the Answers are provided below to help the students as a reference don’t straight away look for the solutions.

NPTEL Introduction to Database Systems Assignment 3 Answers Join Group👇

CLICK HERE

Note: First try to solve the questions by yourself. If you find any difficulty, then look for the solutions.

NPTEL Introduction to Database Systems Assignment 2 Answers 2023:

We are updating answers soon Join Group for update: CLICK HERE

Q.1. The ER model is a

• Record-based data model
• Representational data model
• Conceptual data model
• All of the above

State TRUE or FALSE:

Q.2. Entities in an entity set can have different properties.

• True
• False

Q.3. Entity sets need to be disjoint.

• True
• False

NPTEL Introduction to Database Systems Assignment 3 Answers Join Group👇

Q.4. Values of some attributes of an entity type need not uniquely identify a specific entity of that type.

• True
• False

Q.5. Relationships describe associations among entities.

• True
• False

Q.6. Only entity types can have attributes.

• True
• False

Q.7. The Salary attribute of an Employee entity can be a derived attribute.

• True
• False

NPTEL Introduction to Database Systems Week 2 Answers Join Group👇

CLICK HERE

Q.8. A Relationship type can not have an attribute.

• True
• False

Q.9. A Relationship type can not have more than one attribute.

• True
• False

Q.10. Consider the following statements:

S1: The key of an entity type always consists of more than one attribute.
S2: An entity type has exactly one key.
S3: An entity type may have more than one key.
Choose the correct option:

• S1: TRUE; S2: TRUE; S3: TRUE
• S1: FALSE; S2: TRUE; S3: FALSE
• S1: TRUE; S2: FALSE; S3: TRUE
• S1: FALSE; S2: FALSE; S3: TRUE

NPTEL Introduction to Database Systems Assignment 2 Answers Join Group👇

Q.11. Consider the following sets:

S1: {p: entity; q: weak entity; r: relationship; s: derived attribute; t: multi-valued attribute}
S2: {v: double-line rectangle; w: rectangle; x: double-line ellipse; y: diamond;z: dash-line ellipse}
Choose the correct mapping between S1 and S2:

• p: v; q: w; r: x; s: y; t:z
• p: w; q: v; r: y; s: x; t:z
• p: w; q: v; r: y; s: z; t:x
• p: v; q: w; r: y; s: z; t:x

Q.12. Consider the statements given below:

S1: The participation of an entity set S in a relationship set R is said to be total if every entity in S participates in at least one relationship in R.
S2: The participation of an entity set S in a relationship set R is said to be partial if some entities in S participate in R.
Choose the correct option:

• S1: TRUE; S2: TRUE
• S1: FALSE; S2: TRUE
• S1: FALSE; S2: FALSE
• S1: TRUE; S2: FALSE

Q.13. Choose the FALSE statement:

• A weak entity set may not have appropriate attributes to form a primary key.
• Every weak entity must be associated with an identifying entity.
• The identifying relationship from the weak entity set to the owner entity set is always one-to-many.
• The participation of the weak entity set in the identifying relationship is always total.

NPTEL Introduction to Database Systems Week 2 Answers Join Group👇

CLICK HERE

Q.14. Suppose hasPresident is a relationship type with two participating entity types Country and Person. What is the appropriate cardinality ratio for Country:Person?

• 1:1
• 1:M
• M:1
• M:N

Q.15. Consider the binary relationship type ​hasBranch​ between entity types ​Bank ​and Branch. Suppose the cardinality ratio (Bank: Branch) constraint of the relationship is expressed using (min, max) notation as (u, v) on the line connecting Bank to hasBranch and (x, y) on the line connecting Branch to hasBranch, which one of the following is correct:

• (u,v) = (1,1) and (x, y) = (1, N)
• (u,v) = (1,N) and (x, y) = (1, 1)
• (u,v) = (1,1) and (x, y) = (M, N)
• (u,v) = (M,N) and (x, y) = (1, 1)

Q.16. Consider two entity sets A = {a, b, c, d, e} and B = {p, q, r, s, t}, and they participate in a relationship R. The instances of R are given as: { (a, p), (b, q), (b, r), (c, r), (d, t), (e, t)}. Which one of the following is correct:

• Cardinality ratio of A:B is one-to-many; A participates partially; B participates completely
• Cardinality ratio of A:B is one-to-many; A participates partially; B participates partially
• Cardinality ratio of A:B is many-to-many; A participates completely; B participates completely
• Cardinality ratio of A:B is many-to-many; A participates completely; B participates partially

NPTEL Introduction to Database Systems Assignment 2 Answers Join Group👇

Disclaimer: This answer is provided by us only for discussion purpose if any answer will be getting wrong don’t blame us. If any doubt or suggestions regarding any question kindly comment. The solution is provided by Brokenprogrammers. This tutorial is only for Discussion and Learning purpose.

About NPTEL Introduction to Database Systems 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

Course Layout:

• Week 1   : Introduction and part of E/R Model Module
• Week 2   : ER Model Module
• Week 3   : Relational Model Module
• Week 4   : Relational Model Module
• Week 5   : TRC Module and part of SQL Module
• Week 6   : SQL Module
• Week 7   : Indexes Module
• Week 8   : Indexes Module + Query Processing Module
• Week 9   : Normal Forms Module
• Week 10 : Normal Forms Module
• Week 11 : Transaction Processing Module
• Week 12 : Transaction Processing Module

CRITERIA TO GET A CERTIFICATE:

Average assignment score = 25% of average of best 8 assignments out of the total 12 assignments given in the course.
Exam score = 75% of the proctored certification exam score out of 100

Final score = Average assignment score + Exam score

YOU WILL BE ELIGIBLE FOR A CERTIFICATE ONLY IF AVERAGE ASSIGNMENT SCORE >=10/25 AND EXAM SCORE >= 30/75. If one of the 2 criteria is not met, you will not get the certificate even if the Final score >= 40/100.

If you have not registered for exam kindly register Through https://examform.nptel.ac.in/