In this project, you are asked to design and implement a database that will store

all the necessary information for a specific domain.

After designing the database, you will implement a software which will insert,

delete and update data.

Your database design should contain at least $6$ 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, employee, customers, technical

staff, etc. Each group should have some specific role in the system. For

example, employee prepare some items and have full acces to the database.

Administrators manage systems, and so on$.$

Design foreign keys to other tables, in order to$,$ visualize and relate information

from different tables.

Write queries to insert, delete or update data from tables.

Write PL$/$SQL blocks such as procedures, functions or triggers. Check the details

below.

The project will have $3$ phases:

DESIGN: The database should be designed and should be demonstrated with ER

Diagrams. Foreign keys, primary keys, constraints, default values should also be

indicated with relational model.

Use any database that you want $($MySQL$,$ Oracle, MSSQL$,$ etc.$),$ to implement

your design.