Identify and draw the entities
Question # 1 : P02-01- Jenny's Salon & Spa
-
Create a file called P02-01
-
Design the data models below
-
Export the file containing the data models as a PDF file and submit
P02-01a
At Jenny's Salon & Spa, we have several hairstylists that are salaried employees. In addition
to their salary, we store their first name, last name, social security number, mobile number,
and email address. The salon has clients, which they record first name, last name, mobile
number, email address, and preferred day. Some clients do not have a preferred day.
-
Name the first tab P02-01a
-
Identify and draw the entities
-
Add the attributes associated with each entity and identify them as mandatory or optional
-
Identify candidate keys for each entity
-
Specify the UID/PK for each entity
-
Specify all other candidate keys as unique keys (UKs)
P02-01b
Each hairstylist is assigned clients. When a hairstylist is hired, the hairstylist is not assigned
any clients during orientation. Each client is asked if they have a preferred hairstylist. If they
have no preference, they are assigned a hairstylist that becomes their hairstylist. Of course,
they can switch to another hairstylist at any time.
-
Name the second tab P02-01b
-
Include relationships and ER language
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
