Database Design Project

This assignment presents a solution to a database design problem. It starts with an Entity-Relationship Diagram (ERD) representing the relationships between entities like patients, general practitioners, specialists, appointments, tests, and payments. The solution then outlines several business rules governing these relationships, clarifying constraints and dependencies. Finally, it details a 3rd Normal Form (3NF) logical design, specifying tables (Patient, GeneralPractitioner, Specialist, HistoryCases, Appointment, Test, Payment, Refferance) and their attributes, along with foreign key relationships to ensure data integrity and efficiency. The provided solution demonstrates a practical application of database design principles, illustrating how to translate business requirements into a well-structured relational database.