.
We have made the relational tables to make the database system and their information. We have the descriptions of the query that is required to create the tables and insert the values in the tables. We had to go through the normalization process to overcome data insertion, deletion and update anomalies to decide the tables to be created.
We do believe that this project will be beneficial to a lot of new or updatable parlor management system.
The scenario is of a beauty parlor management system.
- The parlor will be owned by 1 owner. The owner will have the properties like owner country, owner city and owner name. The parlor may have the attributes like men's section and women's arena. The parlor will have the unique attribute named branch code.
- The parlor will hire many employees. Each employee may have properties as employee name, employee id, employee mobile number, the salary of the employee and the skill which is a multivalued attribute.
- The parlor will offer many packages and each of the package may have the properties as follows:
=>Package type (multivalued attribute)
=>package code (unique key)
=>package name
=>discount percentage
- The parlor will provide many services and each of the
Service may have attributes as service name, service type
(Multivalued attribute) and a primary key named service
Code.
- The services will be booked by many clients as a many to
Many relationship and the clients will have these attributes
As follows:
=>gender
=>client name
=>client mobile number (multivalued)
=>client id (unique identity)
- In the end, the clients will be served by many employees.
This is a many to many relationship.