DATA MODELS TUTORIALS
By Ncham Joseph Muam.
1. a) What is a data model?
b) Explain what you understand by denormalization and give its purpose.
1. Explain the key differences between entities, attributes, and relationships in a conceptual data
model. Provide examples.
2. Identify at least three advantages of starting database design with a conceptual model.
3. Create a conceptual data model for a hospital management system. Include entities such as
Patients, Doctors, Appointments, and Medications.
4. Discuss the role of cardinality and participation in relationship modeling. Provide examples
for one-to-one, one-to-many, and many-to-many relationships.
5. Consider a car rental system. Identify entities and relationships, and draw an ER diagram for
the system.
6. Why is abstraction important in the conceptual modeling phase? Provide an example of
generalization and specialization.
7. List and explain the meaning and use of the different kinds of keys in relational database
systems
8. a) Define data modelling and explain its significance in database management systems.
b) Discuss the differences between conceptual, logical, and physical data models. Provide an
example for each type.
9. a) Explain the components of an Entity-Relationship (E-R) model, including entities,
relationships, attributes, primary keys, foreign keys, and cardinality.
b) Given the following business scenario, create an E-R diagram: "A university has
departments, and each department offers multiple courses. Each course is taught by a
lecturer, and students can enroll in multiple courses."
10. a) Explain the principles of a relational database management system (RDBMS). How do these
principles ensure data integrity and consistency?
b) Convert the following E-R model into a set of relational tables. Identify the primary and
foreign keys for each table:
Entities: Employee, Department
Relationships: Employees work in departments (one-to-many).
11. a) Describe the process of converting a conceptual model into a logical model.
b) The following table contains redundancy issues:
StudentID StudentName Course Instructor Department
Normalize the table into 3NF, explaining each step of the process.
12. a) Discuss the role of SQL in physical modelling. Why is it essential for database management?
b) Write SQL queries for the following scenarios:
i. Create a table Student with fields StudentID, Name, Course, and EnrollmentDate.
ii. Insert a new student into the table.
iii. Retrieve all students enrolled in the course "Database Management".
13. a) Define integrity constraints in the context of databases. Discuss the different types of
integrity constraints with examples.
b) Create an SQL script that enforces the following constraints on a Books table:
BookID must be unique.
Title cannot be null.
Price must be greater than zero.
AuthorID must reference the Author table.
14. a) Explain the role of physical modelling in database design. Discuss factors such as indexing,
storage considerations, and SQL practices.
b) Define the ACID properties of transactions and explain how they ensure consistency in database
management. Provide an example of a transaction demonstrating these properties.
15. a) Define data warehousing and explain its importance in decision support systems.
b) Describe the main components of a data warehouse architecture, including ETL (Extract,
Transform, Load) processes, and explain their roles. Use diagrams to support your answer.