Scribd
Upload
2 views2 pages

Important Questions

The document contains a list of questions related to Database Management Systems (DBMS), covering topics such as definitions, Codd's rules, data models, normalization, SQL queries, and entity-relationship diagrams. It includes both 2-mark and 4-mark questions, requiring explanations, definitions, and examples. The questions aim to assess understanding of DBMS concepts, architectures, and practical SQL applications.

Uploaded by

bhushanp141
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
2 views2 pages

Important Questions

The document contains a list of questions related to Database Management Systems (DBMS), covering topics such as definitions, Codd's rules, data models, normalization, SQL queries, and entity-relationship diagrams. It includes both 2-mark and 4-mark questions, requiring explanations, definitions, and examples. The questions aim to assess understanding of DBMS concepts, architectures, and practical SQL applications.

Uploaded by

bhushanp141
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

-: 2 Marks Questions :-

1. Define Data / DBMS (and related basic terms) (Sum-25, Win-25)


2. State any two Codd's rules (Win-25)
3. Distinguish/Differentiate between Network and Hierarchical data model (Sum-25, Win-24,
Win-25)
4. List and explain any four advantages of DBMS over file/traditional processing system
(Sum-25, Win-24)
5. Enlist/State any four symbols used in ER diagram (Sum-25, Win-24)
6. Define normalization. List levels of normalization (Win-25)
7. Define tuple and Data Warehouse (Win-25)
8. What is Data Abstraction?
9. What is Data Independence?
10. Explain Primary Key with Example.
11. Draw and explain three level architecture of data abstraction (Win-24).
12. Write a SQL query to Create a table of below schema.
Table Student (Roll_No INT PRIMARY KEY, name VARCHAR(20) NOT NULL,
class VARCHAR(10) NOT NULL, division VARCHAR(1), dob DATE)
13. Write a SQL to Add a column Mobile_no inside a table Employee which is already created.
14. Write a SQL Query to Insert 2 values in below given Table student. You can Data of your
own choice.
Emp_id Emp_name Salary Date of Joining

-: 4 Marks Questions :-
1. Explain any four rules of E.F. Codd in detail (Sum-25, Win-24)
2. Explain two tier and three tier client server architecture (Sum-25)
3. Explain Two Tier Architecture with diagram.
4. Explain Three Tier Architecture with diagram.
5. What is Data Models. List and Explain any 2.
6. Explain Relational Model in detail.
7. Explain
6. What is ER Diagram. Explain in Detail.
7. Explain the super key, candidate key, primary key and foreign key with example (Win-24)
8. With neat ER diagram explain strong and weak entity set / Compare strong entity set and weak
entity set with example (Sum-25, Win-24)
9. Draw an ER diagram for a given system (college management / library management / hospital
management, with entities, relationships and attribute types) (Sum-25, Win-24, Win-25)

10. Consider given schemas


i) Dept(Dept_no, DName, LOC)
ii) Emp(Emp_no, Ename, Job, sal, Dept_no). Draw and explain parent-child relationship
and apply referential integrity constraints (Win-25)

11. Define Normalization and explain 2NF with example (Sum-25)


12. Draw the overall structure of DBMS. Explain storage manager and query processor
components (Win-25)
13. Normalize the following database up to 3NF (Win-24)
Studinfo (roll no, name, mobile, subID, sub marks, deptno., dept name, dept head) Here
(roll no, subID) is a primary key

You might also like