[go: up one dir, main page]
Scribd
Upload
11 views2 pages

DBMS - Assignment

The document outlines a comprehensive assignment on Database Management Systems (DBMS), covering definitions, advantages over file systems, data views, system architecture, schemas, keys, relational models, and various database concepts. It includes practical tasks such as SQL queries, ER diagram design, and PL/SQL coding, along with theoretical questions on normalization, transactions, and concurrency control. Additionally, it addresses the differences between SQL and NoSQL databases, the importance of indexing, and the CAP theorem.

Uploaded by

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

DBMS - Assignment

The document outlines a comprehensive assignment on Database Management Systems (DBMS), covering definitions, advantages over file systems, data views, system architecture, schemas, keys, relational models, and various database concepts. It includes practical tasks such as SQL queries, ER diagram design, and PL/SQL coding, along with theoretical questions on normalization, transactions, and concurrency control. Additionally, it addresses the differences between SQL and NoSQL databases, the importance of indexing, and the CAP theorem.

Uploaded by

kiyeve2214
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Assignment

Database Management System


Q.1. Define DBMS. List the advantages of DBMS over the file system.
Q.2. Explain different types of Views of data (Data abstraction) in database.
Q.3. Explain System Structure with neat and clean diagram.
Q.4. Briefly describe various architectures of database system.
Q.5. Describe different types of schemas and database users.
Q.6. Define the followings with example of each:
1. Super key
2. Candidate key
3. Primary key
4. Foreign key
Q.7. Explain relational database model in detail.

Q 8. Write short note on the following


1. Data dictionary 2. Operators used in relational algebra
Q.9. Consider the following tables:
Students (SID, SName, Age, DepartmentID)
Courses (CID, CName, Credits, DepartmentID)
Enrollment (SID, CID, Grade)
Department (DepartmentID, DeptName)
1. Find the names of students along with the courses they are enrolled in.
2. Find students who are enrolled in at least one course.
3. Find students who are enrolled in the "Computer Science" department.
4. Retrieve the names of students who have enrolled in at least two different courses.

5. Find departments that have no students enrolled.


Q.10. Design an ER diagram for a university system with entities: Student, Course, Instructor, and
Department. Show relationships like "Enroll", "Teaches", and "Belongs To".
Q.11. How is PL/SQL different from SQL? Also, write a PL/SQL block to print "Hello, World!" using
DBMS_OUTPUT.PUT_LINE.
Q.12. What do you mean by DML, DDL and TCL? And write a short note on
1. Mapping cardinality.
2. Weak & strong entity set.
3. Derived attribute.
Q.13 Describe Specialization, Generalization, Aggregation and Inheritance.
Q.14. Define functional dependency (FD) explain with example.
Q.15. Define the first, second, and third normal forms (1NF, 2NF, and 3NF) with examples.
Q.16. Explain partial dependency and transitive dependency.
Q.17. Explain BCNF with example.
Q.18. Define Multivalued and Join dependency.
Q.19. Consider relation R={ A,B,C,D,E,F,G,H} and set of FDs={A->DE, B->F, AB->C, C->GH, G->H}
(a) Find the candidate key of R.
(b) Find attribute closure of AB, C, BD and AG
(c) Identify the highest Normal form of given relations.
Q.20. What is a transaction in a database management system? Explain with example.
Q.21. Explain the ACID properties of a transaction.
Q.22 What is the difference between immediate database modification and deferred database modification?
Q.23 Describe RAID in detail.
Q.24 What is the importance of indexing used in database? List the different techniques used for indexing.
Q.25 Draw and explain Transaction state diagram.
Q.26 What do you mean by concurrency control. What are the different methods for concurrency control?
Q.27 Explain different methods used for database recovery.
Q.28 Write the difference between SQL and NoSQL.
Q.29 What are the advantages of NoSQL databases.
Q.30 Explain CAP theorem.

You might also like