I need more details about the database which includes ER diagram etc.

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 8 tables. You are free to design the database anyway 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 systern. 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 ooperations 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 5 records inserted in those 3 selected tables. QUERY: Write 5 SQL retrieving statistical information to help management (use join, subquery, group by, to_char etc.) and 5 PL/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 Detais (DL), including all necessary constraints, Data Manipulation Language (DML) 5 SQL and 5 PL/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