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

Email

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?