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 ?

Hello guys, someone could help me with my database assigment ? Exercises

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!