MySQL:Hire Co:DDL:Hire

Entity Relationship diagrams


Which as a fully attributed ERD (this is drawn in MS-Access) becomes:




 * Notes
 * Client to Hire is an Access LEFT JOIN "Include ALL records from tblClient ..."
 * Equipment to Hire is an INNER JOIN join "Only include rows where the joined fields from both tables are equal"
 * When included in the overall Database for the Hire Center, a staff member will be responsible for the Hire, so StfID has been added to tblHire. Later this will be linked to the staff table. But for now, to keep things from getting too complicated this relationship will be added later.