Question Bank
2 marks
[Link] the term Database Management System? Why do we need a DBMS?
[Link] the term data abstraction.
[Link] the differences between file processing system and a DBMS
[Link] out three major disadvantages of keeping organizational information in a file
processing system.
[Link] to define data model? List out different types of data models?
[Link] the difference between primary key and foreign key?
[Link] between Dynamic SQL and Static SQL.
[Link] a short note on entity relationship model.
[Link] derived attributes with suitable example.
10..How does redundancy create challenges in different situations?
[Link] the different types of Data models?
[Link] the usage of the rename operation with an example.
[Link] the sql for commit and rollback.
[Link] can a data model be applied to organize and structure information effectively?
[Link] between Primary Key and Foreign Key?
[Link] basic structure of PL/SQL.
[Link] database design, how can a weak entity be recognized and used?
[Link] the components of E-R Diagram
[Link] relational algebraic projection.
20. How does redundancy create challenges in different situations?
Part B
[Link] you are tasked with designing the database
architecture for a rapidly growing online learning platform.
The platform needs to handle a large number of users, course
materials, video streaming, and real-time interactions like
quizzes and discussions. How would you structure the database
to ensure scalability, data integrity, and optimal performance
while accommodating future growth?
[Link] you are designing a database for a library
management system. The system needs to track books,
members, and borrowing transactions while ensuring data
integrity and efficient retrieval of information. How would you
use keys (primary, foreign, and candidate keys) and
relational algebra operations to structure the database and
optimize queries for book availability and member borrowing
history?
[Link] you are developing a database for a hospital
management system. The system needs to store information
about patients, doctors, appointments, treatments, and
[Link] would you use the Entity-Relationship (ER) model
to design the database structure, ensuring proper relationships
between entities and efficient data retrieval?
[Link] are designing a database for a multinational company
that manages employees across multiple departments and
locations. The company has different types of employees,
including full-time, part-time, and contract workers, each with
unique attributes and [Link] would you use the Enhanced
Entity-Relationship (EER) model to represent specialization,
generalization, and inheritance in the database design to ensure
flexibility and efficiency?
[Link] the following relations for a company database
Application.
Employee (Eno, Name, Gender, DOB, Doj, Designation,
Basic_Pay, Dept_No)
Department (DeptNo,Name)
Project (ProjNo, Name, Dept_No)
Works for (Eno,ProjNo,Date, Hours)
i)Develop DDL to implement the above schema.
(ii) Develop an SQL query to list the department number and
the number of Employee in each department.
(iii) Develop a View that will keep track of the department
number, the number of employees in the department, and the
total basic pay expenditure for each department.
(iv) Develop an SQL query to list the details of employees who
have worked in more than three projects on a day.
6. Consider a student registration database comprising of the
given below table schema.
Student file:
Studen Studen Addres Teleph
t t name s one
numbe
r
Course file
Course Descri Hours Profess
Numbe ption or
r Numbe
r
Professor file
Profess Name office
or
Numbe
r
Registration file
Studen Course date
t numbe
numbe r
r
Consider a suitable example of tuples/records for the above
mentioned tables and write DML statements (SQL) to answer
for the queries.
7. How can E-R diagram notation be applied to represent an E-
R model structure? Explain with an example.
8. Develop an Entity Relationship model for a student attends
classes. Each class divided into one or more sections and the
given entities are student, class, section, subject
