In this project, you are asked to design and implement a database that will store all the necessary information for a Dentist Clinic. After designing the database you will implement a software which will insert, delete and update data. Your design should contain at least 10 tables. You are free to design the databaseanyway you like, but the following requirements should be considered: Your database should have a user table that will allow users to login the system. This table will be used for authentication purposes. The system should also support creating user groups such as admin, employees, nurses and dentists. Each group should have some specific role in the system. For example, employee prepare appointments and have full access to the database. Administrators manage systems, nurses may take place in patient visits or operations and dentists add inspections and treatments, attend operations etc. Doctors are examining many patients but a patient see only one doctor in the clinic. Patients may get medical or operational treatments. For those patients who need to be treated with medication the database should store data about the medicines as well. There also should be a REPORTS page which will show the report about SQL and PL/SQL results/outputs. The project will have 3 phases: DESIGN: The database should be designed and should be demonstrated with ERD. FKs and PKs should also be indicated with relational model. Use any database that you want (Oracle, MSSQL, MySQL etc.), to implement your design. DEVELOP: Write a software (with any language such as JAVA, C\#, PHP, ASP etc.) to insert/update/delete and show data from your database. You should develop at least 3 windows to manage 3 tables, for insert/update and delete record from the database. When the project is completed you should have at least 10 records inserted in those 3 selected tables. QUERY: Write 10 SQL retrieving statistical information to help management (use join, subquery, group by, to_char etc.) and 10PL/SQL (procedure, function or anonymous blocks) At the end of this project, you will submit a report that should contain the following items as well as present it in the class on a date do be announced later: 1. Introduction - An introduction giving brief information and assumptions about the system 2. Database - ER Diagram, - Relational Data Model, - Data Definition Language Details (DDL), including all necessary constraints, - Data Manipulation Language (DML), - 10SQL and 10PL/SQL questions and answers/outputs. 3. Software - Provide your DB connection code - Provide screenshots of all your pages as well as their codes and give some brief information about each page. These are the minimal requirements which means they have to be implemented, but implementing only the requirements that is mentioned above will not be enough to get full mark. You should extend this design and create a real-life database using MySQL or any other database program
