Mechanic
Attribute Name Attribute Type Field Length Key Description Sample
Mechanic_Id Number 5 PK Identifies each Mechanic individually 27384
Mechanic_FName Character 20   The First name of the Mechanic Rob
Mechanic_LName Character 20   The last name of the mechanic Roy
Mechanic_Address Character 50   The address of the mechanic 121,Riverside,Syr
Mechanic_PhoneNo. Number 10   Phone Number of the mechanic 3154432530
Mechanic_Email Character 30   Email address of the mechanic robroy@madison.org
Mechanic_HDate Character 10   The date of hire of the mechanic 21-Dec-88
Mechanic_Salary Number 10   The salary of the mechanic 55000