Theme you are registered - Create an application containing a mysql created database and an interface for it. The Java Server Faces technology will be used when creating the interface.
The database will consist of the following tables:
Clients (ClientID, Name, First Name, Address);
Additional Product (Product ID, Name, DateProduction, DataExpirare);
Manufacturers (ManufacturerID, Name, TaraOrigine, Address);
Relationships between tables are as follows:
between the Customers table and the Product tableFurther - M: N multiplication relation.
between the Product table and the Producers table - multiplicity relation M: N.
The interface should allow the user to perform the following operations on all tables: view, add, modify, delete. Viewing link tables will require viewing the data from the other tables.
All projects will contain, in addition to the requirements in the statements, a module that will implement two-level security access to the application: client and administrator. Customers will be able to view, add, and modify data. Only the administrator can perform the delete operation from the database. User passwords will be stored in the table in the form of "hash," not "plain text".
The project will contain:
1 - Description of the application, in which the main portions of code that give the functionality of the application (explanation of how the database connection is made and how viewing, adding, editing and deleting operations are performed) will be presented. Also, there must be a logical diagram of the database in the project.
2 - Bibliography: references must