Ms$.$ Johnson hired you as an IT consultant to help Garden Glory with their systems. Ms$.$ Johnson shows you the spreadsheet where the company's data is collected. The spreadsheet shows data that Garden Glory collects about properties and services. She asks you to design a new database for them.

Sample Data for Garden Glory

$\backslash$table$[[$PropertyName$,$Type,Street,City,ZIP,ServiceDate,Description,Amount$],[$Eastlake Buiding,Office,$123$ Eastlake,Seattle,$98119,\frac{5}{5}\frac{?}{2012},$Lawn Mow,S$,42\mathrm{.}50],[$Elm St Apts,Apartment,$4$ East Elm,Lynnwood,$98023,\frac{5}{8}\frac{?}{2012},$Lawn Mow,s$,12350],[$Jelerson HIll,Ofice,$42$ West $7$ th $St,$Belevue,$98040,\frac{5}{8}\frac{?}{2012},$Garden Service,$$,53\mathrm{.}00],[$Eastlake Buiding,Office,$123$ Eastlake,Seattle,$98119,\frac{5}{10}\frac{?}{2012},$Lawn Mow,$s,42\mathrm{.}50],[$Eastlake Buiding,Office,$123$ Eastlake,Seattle,$98119,\frac{5}{12}\frac{?}{2012},$Lawn Mow,s$,42\mathrm{.}50],[$Elm St Apts,Apartment,$4$ East Elm,Lynnwood,$98273,\frac{5}{15}\frac{?}{2012},$Lawn Mow,$s,123\mathrm{.}50],[$Easilake Buiding,Ofice,$123$ Easlake,Sealle,$98119,\frac{5}{19}\frac{?}{2012},$Lawn Mow,$$,42\mathrm{.}50]]$

Use

Draw.io $U$ to develop an ERD for the Garden Glory database.

Creating an ERD that:

Shows the entities $($tables$)$

Defines primary keys

Defines the foreign keys

Shows the relationships between entities using Crow's Foot notation.Ms$.$ Johnson hired you as an IT consultant to help Garden Glory with their systems. Ms$.$ Johnson shows you the spreadsheet where the company's data is collected. The spreadsheet shows data that Garden Glory collects about properties and services. She asks you to design a new database for them.

Sample Data for Garden Glory

$\backslash$table$[[$PropertyName$,$Type,Street,City,ZIP,ServiceDate,Description,Amount$],[$Eastlake Buiding,Office,$123$ Eastlake,Seattle,$98119,\frac{5}{5}\frac{?}{2012},$Lawn Mow,S$,42\mathrm{.}50],[$Elm St Apts,Apartment,$4$ East Elm,Lynnwood,$98223,\frac{5}{8}\frac{?}{2012},$Lawn Mow,S$,12350],[$Jelerson HIl,Office,$42$ West $7$ th St$,$Belevue,$98040,\frac{5}{8}\frac{?}{2012},$Garden Service,s$,53\mathrm{.}00],[$Eastlake Buiding,Office,$123$ Eastlake,Seattle,$98119,\frac{5}{10}\frac{?}{2012},$Lawn Mow,S$,42\mathrm{.}50],[$Eastlake Buiding,Office,$123$ Eastlake,Seattle,$98119,\frac{5}{12}\frac{?}{2012},$Lawn Mow,s$,42\mathrm{.}50],[$Elm St Apts,Apartment,$4$ East Elm,Lynnwood,$98273,\frac{5}{15}\frac{?}{2012},$Lawn Mow,$5,123\mathrm{.}50],[$Easildke Buiding,Ofice,$123$ Eastlake,Sealtle,$98119,\frac{5}{19}\frac{?}{2012},$Lawn Mow,$$,42\mathrm{.}50]]$

Use

Draw.io C to develop an ERD for the Garden Glory database.

Creating an ERD that:

Shows the entities $($tables$)$

Defines primary keys

Defines the foreign keys

Shows the relationships between entities using Crow's Foot notation.