Scribd
Upload
11 views1 page

DBMS Assignment on Generalization & SQL Queries

The document is an assignment for a Data Base Management System course at ABSS Institute of Technology, focusing on various topics such as generalization, specialization, aggregation, SQL queries, data abstraction, domains in relational models, and the three schema architecture. It includes specific questions requiring comparisons, SQL query writing, and explanations of concepts. The assignment is to be submitted by December 12, 2024.

Uploaded by

Pooja Goel
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
11 views1 page

DBMS Assignment on Generalization & SQL Queries

The document is an assignment for a Data Base Management System course at ABSS Institute of Technology, focusing on various topics such as generalization, specialization, aggregation, SQL queries, data abstraction, domains in relational models, and the three schema architecture. It includes specific questions requiring comparisons, SQL query writing, and explanations of concepts. The assignment is to be submitted by December 12, 2024.

Uploaded by

Pooja Goel
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

ABSS Institute of Technology, Meerut

Data Base Management System (BCS-501)

Assignment-1 (Unit-1)

Course/Branch:[Link]/CSE Submitted date: 12-12-2024

Note: Attempt all questions.

Q.1. Compare Generalization, Specialization and aggregation with suitable examples.

Q.2 (a). Student (Roll_No,Name,Father_Name,Branch)

Book(ISBN,Title,Author,Publisher)

Issue(Roll_No,ISBN,Date-of-Issue)

Write the following queries in SQL and relational algebra.

1) List roll number and name of all students of the branch ‘CSE’
2) Find the name of student who has issued a book published by ‘ABC’ publisher.
3) List title of all books and their authors issued to a student ‘RAM’
4) List title of all books issued on before December 1,2020
5) List all books published by publisher ‘ABC’

Q.3 What is Data Abstraction? How the Data Abstraction is achieved in DBMS?

Q.4 What are the different types of domains used in relational model? Discuss the
referential integrity constraint with suitable example.

Q.5 Explain the three schema architecture. Explain in detail with diagram.

You might also like