Assignment1_ERDSolution_NehaPatidar

Track Database ER diagram (crow's foot) Neha Patidar | September 19, 2022 OWNER PK Own_id Own_Fname Own_Lname Own_contractStartdate Own_Phone Own_Email PROPERTY PK Own_id FK Property_id Property_name Prop_address Prop_state Prop_city Prop_zip EMPLOYEE PK Emp_id Emp_fname Emp_lname Emp_startdate Emp_jobrole Emp_phone Emp_email EQUIPMENT PK Equi_ID Equi_name Equi_type Equi_dateacquired Equi_condition Automatic PK Auto_equipmentID Auto_motor Auto_fuelType Auto_dateofOilChange Manual PK Manual_ID Manual_motor Manual_fuelType Manual_dateofOilChange SUBPROPERTY PK Subprop_id FK Property_id Subprop_type Subprop_desc TRAINING_CERTIFICATES PK Training_CertificateID FK Training_Emp_id FK1Training_Equi_ID Training_DateOfCompletion SERVICES PK Service_ID FK Service_Subprop_id FK1 Service_Equi_ID Service_Description Service_Startdate Service_Enddate Service_Type Service_Cost Service_EstimatedHours Owns is having to use SECONDARY_OWNER FK Own_id SecOwn_Fname SecOwn_Lname SecOwn_Phone SecOwn_Email has requires uses Is either Required to do