Question: Hello guys, someone could help me with my database assigment ? Exercises A hairdresser needs a database with information about customers, services, reservations, employees and
Hello guys, someone could help me with my database assigment ?

Exercises A hairdresser needs a database with information about customers, services, reservations, employees and their shifts. Based on this information we are supposed be able to: 1.(10p) Design database schema in the third normal form. 2. Program PL/SQL procedure for the following task: 2.1.(5p) insert a new customer; 2.2.(10p) make a customer reservation to order a service to a particular hairdresser; 2.3.(10p) check how many times a given person has been a customer during the last two years; 2.4.(5p) give a given customer a discount; 2.5.(10p) prepare a receipt for the service; 2.6.(10p) calculate salary for all employees (based on the fulfilled services); 2.7.(20p) One of the hairdressers is sick. For each of the services assigned to him or her find a replacement - first we should look for those hairdressers that have a shift scheduled for that day. 3.(20p) Tasks related to triggers In the hairdresser database replace declarative referential integrity constraints by constraints defined by triggers
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
