Question Solved1 Answer Practice Exercises P02-01- Hillside Landscaping • 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 Hillside Landscaping has several landscapers. Each landscaper is assigned a unique ID and first name, last name, mobile number, email (if available), and hourly rate are

NVZMSR The Asker · Computer Science

Practice Exercises
P02-01- Hillside Landscaping
• 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
Hillside Landscaping has several landscapers. Each landscaper is assigned a unique ID and first name, last name, mobile number, email (if available), and hourly rate are recorded.
Hillside has been in business for a long time and has many clients. Each client is assigned a unique id for recording purposes. For clients, first name, last name, mobile number, email (if available), and preferred day are recorded. However, some clients do not have a preferred day.
• Name the first tab P03-06a
• Draw the entities
• Include attributes for each entity and identify them as mandatory or optional
• Identify the UID/PK for each entity
• Specify all other candidate keys as unique keys (UKs)
P02-016
Each landscaper is assigned clients. However, when they first start, a landscaper is not assigned any clients while they are training. Each client is asked if they have a preferred landscaper. If they have no preference, a landscaper is assigned to them that becomes their preferred land-scaper. Of course, they can switch their preferred landscaper at any time.
• Name the tab P02-016
• Include relationships and ER language
P02-01c
It has been determined that some clients do not want a preferred landscaper and are willing to have whoever is available during for their appointment. As a result, if a client prefers a specific landscaper, it is recorded. Otherwise, a client is not assigned to a landscaper.
• Name the tab P02-01c
Modify the previous data model
P02-02 - Lakeside Assembly Inc.
• Create a file called P02-02
• Design the ER diagrams described below
• Export the file containing both data models as a PDF file and submit
P02-02a
Lakeside Assembly Inc. sells products assembled from parts purchased from various vendors.
For each vendor, vendor id, company name, and contact person are stored. Some vendors do not assign a contact person. For parts, part id, part description, and part cost are stored. For products, product id, product name, and selling price are stored.
• Name the first tab P02-02a
• Identify and draw the entities
• Include attributes for each entity and identify them as mandatory or optional
• Specify the UID/PK for each entity
• Specify all other candidate keys as unique keys (UKs)
P02-02b
Each part is purchased from one specific vendor. Of course, each vendor may supply several parts. Usually, but not always, a vendor relationship is established before any parts are pur-chased. Each product is assembled from one or more parts. Each part is unique and is used in the assembly of one specific product. Modify the ERD and include the ERD language.
• Name the second tab P02-026
• Enhance the ER diagram
• Include relationships and ER language
P02-02c
Sometimes, a product is discontinued. In this case, any parts used in the assembly of the discontinued product are keep in inventory for future use. As such, they are not used in the assembly of any current products.
• Name the third tab P02-02c
• Enhance the ER diagram
• Include relationships and ER language

Transcribed Image Text: Practice Exercises P02-01- Hillside Landscaping • 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 Hillside Landscaping has several landscapers. Each landscaper is assigned a unique ID and first name, last name, mobile number, email (if available), and hourly rate are
More
Transcribed Image Text: Practice Exercises P02-01- Hillside Landscaping • 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 Hillside Landscaping has several landscapers. Each landscaper is assigned a unique ID and first name, last name, mobile number, email (if available), and hourly rate are
See Answer
Add Answer +20 Points
Community Answer
GPVU4R
See all the answers with 1 Unlock
Get 4 Free Unlocks by registration

ANSWER:-- Salon Management System DFD (Level 1) 5.0 Official Receipt Process Official Receipt 2 Official Receipt Files Service Details Official Customer Invoice Details Receptionist Customer Registration Receipt Details Payment Payment Payment Process Details Details Custom 1 Appointment File Employee Details Appointment Details Date 2.0 - Time Appointment Process 3.0 ... See the full answer