Question: Identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided. OWNER Owner

Identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided.

Identify the primary key and the foreign key(s).Identify the primary key and the foreign key(s).Identify the primary key and the foreign key(s).

OWNER Owner Owner Name 1 Mary Jones 2 DT Enterprises 3 Sam Douglas 4 UNY Enterprises 5 Doug Samuels OwnerEmail - OwnerType. Mary Jones@somewhere.com Individual DTEdte.com Corporation Sam.Douglas somewhere.com Individual UNYE@unye.com Corporation Doug, Samuelssomewhere.com Individual EMPLOYEE Dale Employeeld. LastName . FirstName . Cellphone . ExperienceLevel. 1 Murray 206-254-3456 Junior 2 Murphy Jerry 585-545-8765 Master 3 Fontaine Joan 206-254-4567 Senior 4 Evanston John 206-254-2345 Senior 5 Smith Sam 206-254-1234 Master GG_SERVICE Service Service Description CostPerHour 1 Mow Lawn $25.00 2 Plane Annual $25.00 3 Weed Garden $10.00 Trim Hedge $45.00 5 Prune Small Tree $60.00 6 Trim Medium Tree $100.00 7 Trim Large Tree $120.00 OWNED_PROPERTY PropertyID - Property Name Property Typ Street City State - Zip - Owneri. 1 Eastlake Building Office 123 Eastlake Seattle WA 98119 2 2 Elm St Apts Apartments 4 East Elm Lynwood WA 98223 3 Jefferson Hill Office 42 West 7th St Bellevue WA 98007 2 4 Lake View Apts Apartments 1265 32nd Avenue Redmond WA 98052 5 Kodak Heights Apts Apartments 65 32nd Avenue Redmond 98052 Rendid WA OWNED_PROPERTY PropertyID. Property Name Property Typ Street City State - Zip - Owneri. 1 Eastlake Building Office 123 Eastlake Seattle WA 98119 2 Elm St Apts Apartments 4 East Elm Lynwood WA 98223 3 Jefferson Hill Office 42 West 7th St Bellevue WA 98007 2 4 Lake View Apts Apartments 1265 32nd Avenue Redmond WA 98052 3 5 Kodak Heights Apts Apartments 65 32nd Avenue Redmond WA 98052 6 Jones House Private Residei 1456 48th St Bellevue WA 98007 7 Douglas House Private Residei 1567 51st St Bellevue WA 98007 8 Samuels House Private Reside 567 151st St Redmond WA 98052 3 2 4 6 PROPERTY_SERVICE Property Servicel - PropertyID - Service ServiceDate - Employee - Hours Worked 1 2 5/5/2014 4.5 2 3 2 5/8/2014 3 4.5 2 1 5/8/2014 2.75 1 5/10/2014 5 2.5 5 5 4 5/12/2014 4 7.5 6 1 5/15/2014 2.75 7 4 5/19/2014 1 1 8 7 1 5/21/2014 2 2.75 3 6/3/2014 5 2.5 10 5 7 6/8/2014 4 10.5 11 8 3 6/12/2014 4 2.75 12 4 5 6/15/2014 1 5 13 7 3 6/19/2014 4 8 4 4 9 6 key and the foreign key(s). If a table does not have a foreign key, write None in Primary Key Foreign Key(S) the space provided. Table OWNER EMPLOYEE GG SERVICE OWEND PROPERTY PROPERTY SERVICE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!