In this project, you are asked to design and implementa atabase 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 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 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. Ps and PKs should also be indicated with relational model Use any database that you want (Orade, MSSQL, MySQL etc.), to implement your design DEVELOP: Write a software (with any language such as JAVA, CS, 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 PU/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 Dereiton Language Detais (DOL), nauding at necessary constraines Data Manipulation Language (DML). 5 SQL and S PUSQL questions and answersoutputs 3. Software Provide your DB connection code Provide screenshots of your pages as well as the codes and gre some brid 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-te database using MySQL or any other database program Individual or group work (max 2 people) accepted. 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 Details (DDL), 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. 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. Individual or group work (max 2 people) accepted. 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 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 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
