The objective of the assignment is to analyze, design and implement database.
The students are also expected to further enhance their skills and executing SQL commands.
PMC Clinic uses a file system to manage appointment scheduling, doctor details, patient details, treatment records and payments. An excel spreadsheet program is utilized for this purpose. You are required to design a basic backend support that would meet the business needs of PMC clinic.
• Workflow of current business activities
• Data Modeling
• Data Dictionary
• SQL commands to create database, tables and insert data with primary key and foreign key
• Extract data into PHP webpage display
Tables after Normalization
Code listing (SQL commands) executed with PHP webpage