Question: Creating an appointment system at a beauty salon using Object Modeling Analysis. This system will work on developing a customer appointment system. Using theses Attributes.
Creating an appointment system at a beauty salon using Object Modeling Analysis. This system will work on developing a customer appointment system. Using theses Attributes. Create 3 tables: customer info,Treatments (treatment ID, Name, Cost), Sales (TreatmentID & CustomerID & Cost)
Customer id
Name
Address
Ciy
State
Zipcode
Gender
Phone number
Date of birth
List treatments
Customer id for each treatment
Men's haircut
Women's haircut
Child's cut and style
Shampoo
Style
Bang trim
Beard trim
neck trim
Perm/waving
relaxer
Relaxer Retouch
Permanent Thermal Straightening
Brazilian blowout
Brazilian Blowout Express
Extension
Consultations Hair Extensions
Updo
Single process color (with cut)
single process color (with blowout)
Full foil (with blowout)
partial Foil (with cut)
partial foil (with blowout)
accent color panel (with cut)
accent color panel (with blowout)
dimensional color (with cut)
dimensional color (with blowout)
ombre/balayage (with cut)
ombre/balayage (with blowout)
conditional treatments
color correction
brow wax
brow tweezing
upper lip, cheek, chin
wax full face wax
a. State the rule that is applied to place an entity in first normal form. Describe how the data would change when in first normal form. b. State the rule that is applied to place an entity into second normal form. Describe how the data would change when in second normal form. c. State the rule that is applied to place an entity into third normal form. Describe how the data would change when in third normal form. d. What other guidelines and rules can you follow to validate that your data model is in good form?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help