Assignment-1-Solution

.pdf

School

Pennsylvania State University *

*We aren’t endorsed by this school

Course

220

Subject

Industrial Engineering

Date

Dec 6, 2023

Type

pdf

Pages

Uploaded by LieutenantMetalPorpoise26

 GARDEN GLORY PROJECT QUESTIONS (Chapter One) Submission: A single .doc or .pdf file to Canvas Garden Glory is a company that provides gardening and yard maintenance services to individuals and organizations. Garden Glory employs a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. The two tables below are a sample list of properties and their owners ( PROPERTY Table ) and a sample list of services provided by the company ( SERVICE Table). ServiceDescri ption ServiceDate ServiceFee PropertyName PropertyAddress EmployeeName EmployeePhone Mow Lawn 2014-05-05 $42.50 Jones House 1456 48th St, Bellevue, WA 98007 Sam Smith 206-254-1234 Plant Annuals 2014-05-08 $300.00 Eastlake Building 123 Eastlake, Seattle, WA 98119 John Evanston 206-316-5555 Garden Weed Control 2014-05-08 $75.00 Lake View Apts 1265 32nd Ave, Redmond, WA 98052 Dale Murray 206-298-5452 Trim Hedge 2014-05-10 $150.00 Elm St Apts 4 East Elm St, Lynwood, WA 98223 Sam Smith 206-254-1234 Mow Lawn 2014-05-12 $120.00 Eastlake Building 123 Eastlake, Seattle, WA 98119 John Evanston 206-316-5555 Trim Tree 2014-05-12 $200.00 Elm St Apts 4 East Elm St, Lynwood, WA 98223 John Evanston 206-316-5555 PropertyName PropertyAddress OwnerName OwnerEmail OwnerType Eastlake Building 123 Eastlake, Seattle, WA 98119 DT Enterprises dte@dte.com Corporation Jeferson Hill 42 West 7th St, Bellevue, WA 98007 DT Enterprises dte@dte.com Corporation Elm St Apts 4 East Elm St, Lynwood, WA 98223 Sam Douglas Doug.Samuels@somewh ere.com Individual Lake View Apts 1265 32nd Ave, Redmond, WA 98052 Sam Douglas Doug.Samuels@somewh ere.com Individual Jones House 1456 48th St, Bellevue, WA 98007 Mary Jones Mary.Jones@somewher e.com Individual

A. Describe problems that are likely to occur when inserting, updating, and deleting data in these spreadsheets. (20 points) Note: Don’t use general terms “redundancy” or “loss of information” to describe the problems. Describe at least one specific problem for EACH case (insert, update, delete). For instance, you should write “if I update column X in list Y, the problem is….” 1. For the ( PROPERTY Table ), if we were to insert a new Owner ( OwnerName , OwnerEmail , OwnerType ) that has not enlist a property yet, then we would have empty cells with regards to the PropertyName, PropertyAddress . The same can be said for the ( SERVICE Table ), in which if were to just insert a new employee, then we might have empty cells on services and properties. For the ( PROPERTY Table ), if we were to update the Owner email of DT enterprises, then we would be required to update at least two rows, in which it’s possible to lose information because you’re typing an email id having multiple characters. There is a similar problem in the ( SERVICE Table ), if we were to update the PhoneNumber for John Evanston, we would need to update at least three rows. For the ( PROPERTY Table ), if DT Enterprises does not own any property now, then we would be deleting all information about them, such as OwnerName , OwnerEmail, etc . In the ( SERVICE Table ), if we were to delete the “Garden Weed Control” service from the list, then we would lose all information about Dale Murray. B. Split both PROPERTY table and SERVICE table into multiple tables such that each has only one theme. (30 points) Note: Don’t lose information when you split the tables! 1 st table into two tables: PROPERTY_OWNER PropertyName PropertyAddress OwnerName Eastlake Building 123 Eastlake, Seattle, WA 98119 DT Enterprises Jeferson Hill 42 West 7th St, Bellevue, WA 98007 DT Enterprises Elm St Apts 4 East Elm St, Lynwood, WA 98223 Sam Douglas Lake View Apts 1265 32nd Ave, Redmond, WA 98052 Sam Douglas Jones House 1456 48th St, Bellevue, WA 98007 Mary Jones

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help