Creating an appointment system at a beauty salon using Object Modeling Analysis.

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. 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?

Explanation / Answer

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

First Normal Form – If a relation contain composite or multi-valued attribute, it violates first normal form or a relation is in first normal form if it does not contain any composite or multi-valued attribute. A relation is in first normal form if every attribute in that relation is singled valued attribute.

Before Applying 1NF:-

8050823219,

8100428836,

9835933249

After Applying 1NF:-

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.

Second Normal Form – To be in second normal form, a relation must be in first normal form and relation must not contain any partial dependency. A relation is in 2NF iff it has No Partial Dependency, i.e., no non-prime attribute (attributes which are not part of any candidate key) is dependent on any proper subset of any candidate key of the table.

Partial Dependency – If proper subset of candidate key determines non-prime attribute, it is called partial dependency.

Before applying 2NF:-

After Applying 2NF:-

CUSTOMERS

TREATMENT

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.

Third Normal Form – A relation is in third normal form, if there is no transitive dependency for non-prime attributes is it is in second normal form.

A relation is in 3NF iff at least one of the following condition holds in every non-trivial function dependency X –> Y

Transitive dependency – If A->B and B->C are two FDs then A->C is called transitive dependency.

Before Applying 3NF:-

After Applying 3NF:-

CUSTOMERS

ADDRESS

d. What other guidelines and rules can you follow to validate that your data model is in good form?

Please let me know in case of any clarifications required. Thanks!

CUST_ID NAME GENDER ADDRESS PHONE# 12345 GOPAL MALAKER M ADDRESS1

8050823219,

8100428836,

9835933249

54321 JACK SPARROW M ADDRESS2 1234567890

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.