Course Title

Database Fundamentals

Course Number

10671353

Instructor Name

MOAMIN BURHAM JAMIL ABUGHAZALA

Contact Information

[email protected]

Semester(s) and academic year(s)

First Semester 2024

Compulsory / Elective

Compulsory

The primary goal of this class is to learn the principles and practices of database management and database design. Over the course of the semester, we will discuss the database, relational database design, normalization, SQL queries, reports and other interfaces to database data, and documentation.

Course Objectives: Database Systems (Fundamentals)

By the end of this course, students will be able to:

1. Understand the Fundamentals of Databases

   • Define what a database is and explain its role in modern applications.
   • Identify different types of database users and their responsibilities.
   • Explain fundamental database system concepts and architecture.

2. Learn and Apply Data Modeling Techniques

   • Develop Entity-Relationship (ER) and Enhanced ER (EER) diagrams for real-world applications.
   • Understand the principles of data abstraction, schema levels, and data independence.
   • Convert ER/EER diagrams into relational database schemas.

3. Master Relational Database Concepts and Design

   • Understand relational data models, relational algebra, and database constraints.
   • Apply normalization techniques (Functional Dependencies, Normal Forms) to optimize database design.

4. Write and Execute SQL Queries

   • Utilize SQL for data definition, manipulation, and querying.
   • Implement relational database designs in SQL.
   • Apply SQL constraints, joins, aggregations, and subqueries.

5. Develop and Implement Database Applications

   • Design and implement a database system for a real-world project.
   • Integrate database concepts into software applications.
   • Test and optimize database queries and performance.

6. Work on Real-World Database Projects 

   • Form project teams and collaborate on database development.
   • Conduct user requirement collection and database design based on a case study.
   • Implement a working database system using SQL and document the development process.

7. Enhance Analytical and Problem-Solving Skills

   • Analyze business requirements and translate them into database solutions.
   • Apply normalization techniques to reduce redundancy and improve data integrity.
   • Solve database design and query optimization challenges.

8. Communicate and Document Database Design Effectively

   • Document database design and development phases.
   • Present database projects and findings effectively.
   • Demonstrate teamwork and collaboration in database development.

• Understand the fundamentals of how data is stored in computer systems.
• Know the fundamentals of Structured Query Language (SQL) and how it can be used to store
• and retrieve data from a relational database.
• Be able to apply the principles used in class to build a database application from the ground up.
• Identify the data requirements of contemporary organizations and how database management
• systems meet them,
• Develop conceptual data model specifications,
• Design and implement authentic database applications,
• Gain experience with the existing database management systems.
• Demonstrate ability to communicate effectively when collecting project data and when
• presenting project phases and product(s).

Fundamentals of Database Systems 6th edition by Elmasri & Navathe