Answered step by step
Verified Expert Solution
Link Copied!

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 ?

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 10g SQL

Authors: Joan Casteel, Lannes Morris Murphy

1st Edition

141883629X, 9781418836290

More Books

Students also viewed these Databases questions