Question

Equipement Repair Oaner Service Ownerame Owno Progerty PropetyNome rziningourzelD
D3: DB Specification & Implementation: After you have developed the conceptual E-R model for GG, convert that data model into a relational database design for Garden Glory. Then develop the specifications for database implementation, indicating data types, PKs, and FKs. Implement the design and create the GG Database and execute a variety of queries to test the functionality of your DB. Document your database design and the processing results accordingly. You can also refer to the GG project questions in §5. Question: Implement your DB design in MS Access. Create tables, create relationships, enter sample data ( see the sample data in previous deliverables and/or feel free to make up some sample data as appropriate), create data entry forms and reports as necessary, and use SQL or QBE to query the DB and test its operational performance.

Answer 1

Relationship Tools Databasez2: Database (Access 2007) Microsoft Access Home Create External Data Database Tools Design New Totals Copy Format Painter [Biul Ad Replace Go To Select 图画 V ViewPaste Filter Find X Delete ore Y Toggle Filter Mews Clipboard Font Rich Text Records Sort & Filter Find EmployeeRelationshipsSenvice Service Employee PropertylD PropertyiD PropertyD EmployeelD Street City State Žip OwnerlD ServiceDate FirstName EmployeelD Tra TrainingCourseID EmployeelD Equipment Repair Equipment OWNER EquipmentlD EquipementRepairtd EquipmentType EquipmentID 으 ? OwnerlD Email Ready PM 05:40 23-05-2018

SELECT Employee.EmployeelD, Service.HoursWorked FROM Equipment INNER JOIN [Equipment Repair) ON Equipment.EquipmentID = [Equipment Repair]-EquipmentID) INNER JOIN (((Service INNER JOIN Employee ON Service. PropertyID = Employee-EmployeeID) INNER JOIN ((Owner INNER JOIN Property ON Owner.OwnerD-property.OwnerlD) INNER JOIN Subproperty ON Property. PropertyID = Subproperty. PropertyID) Service.PropertylD Subproperty.PropertyID) INNER JOIN TrainingCourse ON Employee.EmployeelD- TrainingCourse-Employee ID) ON Equipment. Equipment! D = TrainingCourse. EquipmentD ORDER BY Employee.EmployeelD; Database2: Database (Access 2007) - Microsoft Access Home Create External Data Database Tools Selection AdvancedFind New Σ Totals Replace Calibri Spelling 집 匀 Copy Save Go To View Paste Refresh Billa-lla- 囲, ;-仨|lab). All''' >< Delete , H. More, Records Format Painter Y Toggle Filter Select Views Clipboard Font Rich Text Sort & Filter Find RelationshipsQueryl EmployeelC HoursWorke All Tables owner: Table 4.5 2.75 Property: Table Subproperty: Table TrainingCourse : Table Equipment: Table Equipment Repair Equipment Repair : Tabile Employee Table Service Service : Table

| Databasez2: Database (Access 2007) - Microsoft Access Home Create External Data Database Tools らNew ΣTotals 21 Selection Replace Copy ViewPaste Find Format Painter Y Toggle Filter Select Clipboard Rich Text Records Sort & Filter Find All Tables RelationshipsQuerylEmployee Owner: Table Employee Owner subform Property: Table EmployeelD LastName Kumar subproperty : Table TrainingCourse FirstName TrainingCourse : Table PhoneNumber 767567 Equipment : Table Experiencelevel Equipment Repair Equipment Repair : Table Employee : Table Employee Service : Table Record: 1イ 4 ot 4 ト刺ト13 | 承No Filter Search Form View PM 06:068 !.. lg ..il..:) 23.05.2018-

Databasež2: Database (Access 2007) - Microsoft Access Home Create External Data Database Tools New Selection Replace Totals 21 Copy Format Painter Spelling [Blu ViewPaste Find Y Toggle Filter Select Find Clipboard Rich Text Records Sort & Filter All Tables Relationship,'-1 Query'내 Employee _ Equipment Repair -Property! ▼ << Property1 Owner: Table Owner subform Property : Table Property Propertyl PropertyllD PropertyName Elm St Apts Street 4 East Elmm Subproperty: Table Property City Lynwood TrainingCourse: Table State Equipment: Table zip Equipment OwnerlD Equipment Repair Equipment Repair: Table Equipment Repair Equipment Repair Subform Employee Employee : Table Employee Service : Table ▼ | | Record. Iイイ 2 ot 8 トト1 ト13 |承NO Filter | Search Form View PM 06:12 23-05-2018

Report Layout Tool:s Database2: Database (Access 2007) Microsoft Access Home Create External DataDatabase Tools Format Arrange Page Setup New ΣTotals 112 d Save咢Spelling ac Replace ViewPaste Format Painter Y Toggle Filter Mews Font Rich Text Records Sort & Filter Relationship,' p Query Property|剻Report x Field List All Tables << Employee 과 Equipment Repair Fields available in other tables: Edit Table Edit Table Edit Table Edit Table Edit Table Edit Table Edit Table Edit Table Owner : Table I PropertyID PropertyNai-| Street , City State Zip OwnerlD Owner subform 1 Eastlake Buildi 123 Eastlake Seattle 2 Elm St Apts 4 East Elm Lynwood W 3 Jefferson Hill 42 West 7th St Bellevue 4 Lake View Apt 1265 32nd Ave Redmond WA S Kodak Heights 65 32nd Avenu RochesterNY 6 Private Reside 1456 48th St Bellevue 7 Private Reside 1567 51st St BellevueWA 8 Private Reside 567 151st St Rochester NY N. 1承No Filter | Search 98119 Equipment Repair E Property Property: Table subproperty Property Subproperty WA Subproperty: Table Record: H PropertylD SubpropertylD SubpropertyValue ntID EquipmentName TrainingCourse : Table Equipment Equipment: Table Equipment Equipment Repair Record: 1 of 4 ト Equipment Repair: Table Equipment Repair Equipment Repair Subform Employee : Table Record: H No Filter Search Service Service : Table Show only fields in the aurrent record source Layout View PM 06:14 !.. lg ..il..:) 23.05.2018- 12345678

Database2: Database (Access 2007) Microsoft Access Home Create External Data Database Tools New Totals Selection Advanced Y Toggle Filter aa Replace Copy Spelling Paste-, Format Painter コ ( ㄧ匿 a, Retresh ×Delete. Moreng A] Filter View B 1 Find Select Font Views All Tables Owner Clipboard Rich Text Records Sort & Filter Find Y< Owner Owner: Table Query! Owner subform Owner Owner Property: Table Query! Property Propertyl Property Propertyl 1 Mary Jones 2 DT Enterprises 3 Sam Douglas 4 UNY Enterprises 5 Doug Samuels [email protected] [email protected] [email protected] UNYEunye.om [email protected] Individual Corporation Individual Corporation Individual 24 May 2018 Page 1 of1 EE Subproperty: Table Quenyl Property Property Propertyl TrainingCourse Table Report View

Database2: Database (Access 2007) Microsoft Access Print Preview Word Show Margins Print Data Only Columns Text File Print Size rait Landscape Margins Page Zoom One Two More Refresh Excel SharePoint PDF Setup Close Print Prenew Close Prevlew Page Pages Pages Page Layout Zoom Data All Tables RelationshipsQueryl Employee Equipment RepairEProperylReportiTrainingCourse Property1 Owner: Table Owner subform Property1 Property Property: Table Property Property Property propertyMD SubpropertyVal 1 E lake Building 2 Em St Apts 3 Jefferson Hill 4 Lake View Apts 5 Kodek Heights Apts 6 Private Residence 7 ■ Property Subproperty: Table Property Property Property! Private Residency 3 Private Residence TrainingCourse: Table TrainingCourse Equipment Equipment : Table Equipment Equipment Repair 幽Equipment Repair: Table E Equipment Repair Eo ipment Repair SubformPage: No Filiter Ready !.. lg ..il..:) 23.05.2018- 17

Database?: Database (Access 2007) - Microsoft Access Print Preview Show Margins Word Print Data Only Text File Print Size rait Landscape Margins Page Zoom One Two More Refresh Excel SharePoint PDF Close Print Prenew Close Prevlew EE Columns Page Pages Pages orXPS丐> More ▼ List Page Layout Zoom Data All Tables RelationshipsQueryl Employee Equipment RepairProperylReporti TrainingCourse Propertyl Equipment Owner: Table Owner subform Equipment Property Property: Table Property Propertyl Property Propertyl 1 ABC 1 A 2 CDE 2 G Subproperty: Table Property Property Property 3 FGH 3 H 4 GHI TrainingCourse: Table TrainingCourse Equipment Equipment: Table Equipment Equipment Equipment Repair Equipment Repair: Table Page: 1 No Filter Ready !.. lg ..il..:) 23.05.2018- l PM 06:18

Database2: Database (Access 2007) - Microsoft Access Home Create External Data Database Tools Copy JFormat Painter (B i ulA127 New Σ Totals Save Spelling × Delete" d More Selection Advanced Y Toggle Filter c Replace Go To Select --| View Paste ツー Refresh Filter Find All Views Clipboard Font Rich Text Records Sort & Filter Find QueryService Query Service Service EmployeelD LastName FirstName Akshay PhoneNumber ExperienceLevel PropertylD Servicel HoursWorked 9876543210 으 6 4.5 Record. I 1 of 4 k: | No Filter | raj Form View 画憂ピ

Report Layout Tools Database2: Database (Access 2007) Microsoft Access Home Create External Data Database Tools Format Arrange Page Setup 2 Totals Formatting Hide Details View Blu ΕΞΕ Conditional Gridlines Logo gFields Add Existing oox & Sort Views Font Formatting Grouping& Totals Gridlines Controls AutoFormat Service 24 May 2018 07:55:42 PM EmployeelD LastName FirstName PhoneNumber ExperienceLeve PropertylD ServicelD HoursWorked 4.5 2.75 4.5 1 Raj 2 Khanna 3 Margaratte Sophia 4 Kumar Akshay 9876543210 9087654321 9879065432 9089767567 Rameshh 10 2 Selva 4 4 4 Page 1 of1 Layout View

SELECT Employee.EmployeelD, Employee.LastName, Employee.FirstName, Employee.PhoneNumber, Employee.ExperienceLevel, Service.PropertylD, Service.ServicelD, Service.HoursWorked FROM Service INNER JOIN Employee ON Service.[PropertyID] Employee.[EmployeelD]: Database2: Database (Access 2007) - Microsoft Access Home Create External Data Database Tools Y: Selection ac Replace Calibri save spelling 집 Delete- More- Records Copy 피 a-a-EB- 되 ツ ] Refresh View Paste JFormat Painter B 1 Filter Find Y Toggle Filter Select Views Clipboard Rich Text Sort & Filter Find Query Service Query All Tables Equipment EmployeeID ▼ LastName FirstName ▼| PhoneNumber ExperienceLevel ▼| PropertyID, ServiceID 、Hoursworked Akshay Ramesh 3 Margaratte Sophia Ra 2 Khanna 9876543210 9087654321 9879065432 9089767567 Equipment 10 2.75 Equipment Repair Equipment Repair Table 4 Kumar Selva 4 4 アQuery! (New) (New) Equipment Repair Equipment Repair Subform Equipment Employee : Table Query! Service Query Employee Service Service TrainingCourse Service: Table アQuery! Service Query Record: 1 of4 | No Filter | Search Datasheet View