Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 triggersStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started