In this project, you are asked to design and implement a database that will store all the necessary information for a De

[answerhappygod]

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 acces 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: