Designing a new Database - Garden Glory

Using Pages 253 and 254, please construct 5 Table Definitions using either MS-Word (Table), MS-Excel, MS-Visio (Software and Database/Database Model Diagram) One for each corresponding Category below.

• Owner
• Owned_Property
• Employee
• GG_Service
• Property_Service

Include Schema design as illustrated in the attached files

Refer to pages 129 thru 133 for your attribute definition types. Please use what you think best would correspond to Character, Numeric or DateTime data. Don't be concerned about an incorrect data type at this point.

254 Part 1 Database Fundamentals FIGURE 3-40 Sample Data for Garden Glory OWNED PROPERTY Table Street 123 Eastlake 4 East Elm 42 West 7th St Bellevue WA 98007 2 Name PropertyType Seattle WA 981192 Lynwood WA 98223 1 Eastlake Building Office Elm St Apts Jefferson Hill Lake View Apts Apartments 1265 32nd Avenue Redmond WA 98052 3 Kodak Heights Apts Apartments Jones House Douglas House Private Residence 1567 51st St Bellevue WA 980073 Samuels House Apartments Office WA 98052 65 32nd Avenue 1456 48th St Redmond Bellevue WA 98007 1 Private Residence Private Residence 567 151st St Redmond WA 98052 5 FIGURE 3-41 Sample Data for Garden Glory EMPLOYEE Table EmployeelD LastName Smith Evanston Murray Murphy Fontaine FirstName John Dale Jerry Joan CellPhone 206-254-1234 206-254-2345 206-254-3456 585-545-8765 206-254-4567 Senior Master FIGURE 3-42 Sample Data for Garden Glory GG SERVICE Table ServicelD ServiceDescription Mow Lawn Plant Annuals Weed Garden Trim Hedge Prune Small Tree Trim Medium Tree Trim Large Tree CostPerHour 25.00 25.00 30.00 45.00 60.00 100.00 125.00