Data Base Management System Week 1 NPTEL Assignment Answers 2025

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 2025 July-October
🔗 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 2025

1. Which level of abstraction describes how data is physically stored in the database?

a) Physical level
b) Logical level
c) View level
d) Abstraction level

Answer : See Answer

2. Consider the following SQL statements):
S1:
CREATE TABLE orders (
order _id
NUMBER PRIMARY KEY,
product_id NUMBER,
quantity NUMBER,
order_date DATE
S2:
INSERT INTO ordersorder_id, product_id, quantity, order_date)
VALUES (1001, 45, 3, ’15-JUN-2024′) ;
Identify the correct statement.

a) S1 is a Data Definition (DDL) Query, and S2 is a Data Manipulation (DML) Query.
b) Both S1 and S2 are Data Definition (DDL) Queries.
c) S1 is a Data Control Query (DCL), and S2 is a Data Definition (DDL) Query.
d) Both S1 and S2 are Data Manipulation (DML) Queries.

Answer :

3. Identify the correct statement/s about database schemas and instances.

a) Student (roll no, name, dept) represents a database instance.
b) (101, ‘John’, ‘CS’) is an example of a relation schema.
c) Course(course_id, title) defines a logical schema.
d) (‘CS101’, ‘Databases’) is an instance of a physical schema.

Answer :

Looking for DBMS previous year answers? Explore year-wise assignment answers in one place!

Answer :

5. Consider the following relations:
Employee (eid, ename, salary); Department (did, eid)
Consider the following relational algebra expressions:
RA₁ : ll_{Employee. eid, ename} Employee X Department)
RA₂ : ll_{Employee. eid, ename} Employee x Department)
Which of the following is correct?

a RA1 C RAg
b) RA2 § RA1
c) RAI S RA2
d) RA1 = RA2