Data Base Management System Week 1 NPTEL Assignment Answers 2026

Need help with this week’s assignment? Get detailed and trusted solutions for Data Base Management System Week 1 NPTEL Assignment Answers. Our expert-curated answers help you solve your assignments faster while deepening your conceptual clarity.

✅ Subject: Data Base Management System (nptel dbms answers)
📅 Week: 1
🎯 Session: NPTEL 2026 January-April
🔗 Course Link: Click Here
🔍 Reliability: Verified and expert-reviewed answers
📌 Trusted By: 5000+ Students

For complete and in-depth solutions to all weekly assignments, check out 👉 NPTEL Data Base Management System Week 1 Assignment Answers

🚀 Stay ahead in your NPTEL journey with fresh, updated solutions every week!

Data Base Management System Week 1 NPTEL Assignment Answers 2026

1. Which of the following statements is (are) incorrect?

a) The physical level specifies how data is actually stored on disk.
b) The logical level focuses on user-specific views of the data.
c) The view level conceals details of data representation from applications.
d) The logical level defines relationships among stored data.

Answer : See Answer

2. Consider the following relations:
Course (cid, cname, duration)
Enrollment (eid, cid)

Consider the following relational algebra expressions:
RA₁: II_{course.cid, cname} (Course X Enrollment)
RA₂: II_{course.cid, cname} (Course x Enrollment)

Which of the following is correct?

a) RA₁ C RA₂
b) RA₂ C RA₁
c) RA₁ C RA₂
d) RA₁ = RA₂

Answer :

Answer :

4. Consider the relation ConferenceAttendee(AttendeeID, Email, Name, SessionID, where the
following two sets of attributes are candidate keys: {AttendeeID} and {Email, SessionID}.
Which of the following sets of attributes cannot be a super key for this relation?

a) {AttendeeID}
b) (Email, SessionID}
c) {AttendeeID, Name}
d) {Email, Name}

Answer :

Answer : See Answer

Answer :

Answer :

Answer :

Answer :

10. Identify the correct statements) about database schemas and instances.

a) Employee(emp-id, emp name, salary) represents a database instance.
b) (E101, ‘Amit’, 45000) is an example of a relation schema.
c) Department (dept_id, dept _name) defines a logical schema.
d) (‘D10’, ‘Accounts’) represents a physical schema.