Course Description
This course serves as an introduction to databases by presenting their fundamental principles in a simple and clear manner. It aims to provide an overview of what a database is, along with the essential elements of its management. The course covers foundational concepts such as files, various data models—with a particular focus on the relational model—relational algebra, database management systems, and SQL for querying databases. Additionally, students will learn how to develop a web application that interacts with database management systems (DBMS) through practical examples. Consequently, students will understand the importance of structuring and manipulating data in tabular form. All concepts and operations on data are illustrated through examples.
Course Objectives :
The main objectives for the course are:
-
Understand Database Fundamentals: Introduce students to the basic principles of databases, providing clarity on their structure and management.
-
Master SQL and Relational Models: Enable students to effectively use SQL and understand relational database concepts, including relational algebra.
-
Develop Web Applications: Teach students how to create web applications that interact with database management systems through practical examples.
-
Apply Knowledge Practically: Reinforce learning through real-world examples to emphasize the importance of structuring and manipulating data in tabular formats.
Overall Course Plan and Audience
The content of this course is structured into three chapters, where we have synthesized the most relevant information by drawing from various sources (books, lecture notes, websites, etc.) while adhering to the official framework adopted by the Ministry of Higher Education and Scientific Research for the students .This course is designed for second-year computer science engineering students
- Enseignant: tayeb benzenati