Hrm 531 Week 3 Individual Assignment
Example for Individual Assignments
Week 3 Individual Assignment
Explanation:
This sample database is for a company that performs contract work for other companies. The contract work is software development. The contracting company is hired by another organization to perform specific software development. The contracting company does not consider the software developers as employees; rather they are contractors working on contracts. The contractors do receive a check for their work from the contracting company; however, because they are not employees, they check does not include normal employees’ deductions. The check contains the amount for the work performed. The tables needed for this simple database are listed below.
The Daily
Log table records the work a contractor performs on a specific contract on a given day. As a contractor performs their work they record the time that they started working on a contract and then what time they stopped working on that contract to either go to lunch or to go home at the end of the day. The daily log has entries for a contractor to work on up to four different contracts on a day. If a contractor goes to lunch and works on the same contract all day, then they would include the start and stop times before lunch and the start and stop times after lunch, and include the contract number for both entries. Thus if a contractor worked on the same project throughout a single day, there would be two entries in the daily log. When setting up the table for the log data, the date is one of the fields in the table so when you look at the time fields, the date is not part of the time field.
The Contractor table contains the names and personal information for each contractor that the contracting company has hired.
The Contracts table contains the information about a contract. This includes the company name, address and contact person.
Contractor
Name
Contractor ID Number
Home Address
Home Telephone Number
Mobile Telephone Number
Emergency Contact Name
Emergency Contact Telephone Number 1
Emergency Contact Telephone Number 2
Contractor Rate
Skills
Daily Log
Name
Contractor ID Number
Contractor Rate
Work Date
Contract Number 1
Start Time 1
Stop Time 1
Hours Worked 1
Contract Number 2
Start Time 2
Stop Time 2
Hours Worked 2
Contract Number 3
Start Time 3
Stop Time 3
Hours Worked 3
Contract Number 4
Start Time 4
Stop Time 4
Hours Worked 4
Comments
Contracts
Company Name
Company Address
Company Telephone Number
Contact Name
Contract Description
Contact Telephone Number
Contract ID Number
Contract Start Date
Expected Contract Finish Date
Contract Status
Comments
The above chart is the starting point for the assignment. Below are the steps needed to complete the assignment.
* Create the database in Access
* Create the tables one by one. As a table is created the appropriate fields are added as is outlined in the chart above.
* The fields in the tables above are assigned the appropriate data type
* (This step is optional.) Once the tables and fields are set up, the primary key is assigned to each table. If a field does not exist that will have a unique value for every record in the table, create a new ID field that can be used as the primary key field for the table.
* Go to the relationship tool and put all three tables in the diagram
The Access database for the example above is called Week3Database.
Week 3 Individual Assignment
Explanation:
This sample database is for a company that performs contract work for other companies. The contract work is software development. The contracting company is hired by another organization to perform specific software development. The contracting company does not consider the software developers as employees; rather they are contractors working on contracts. The contractors do receive a check for their work from the contracting company; however, because they are not employees, they check does not include normal employees’ deductions. The check contains the amount for the work performed. The tables needed for this simple database are listed below.
The Daily
Log table records the work a contractor performs on a specific contract on a given day. As a contractor performs their work they record the time that they started working on a contract and then what time they stopped working on that contract to either go to lunch or to go home at the end of the day. The daily log has entries for a contractor to work on up to four different contracts on a day. If a contractor goes to lunch and works on the same contract all day, then they would include the start and stop times before lunch and the start and stop times after lunch, and include the contract number for both entries. Thus if a contractor worked on the same project throughout a single day, there would be two entries in the daily log. When setting up the table for the log data, the date is one of the fields in the table so when you look at the time fields, the date is not part of the time field.
The Contractor table contains the names and personal information for each contractor that the contracting company has hired.
The Contracts table contains the information about a contract. This includes the company name, address and contact person.
Contractor
Name
Contractor ID Number
Home Address
Home Telephone Number
Mobile Telephone Number
Emergency Contact Name
Emergency Contact Telephone Number 1
Emergency Contact Telephone Number 2
Contractor Rate
Skills
Daily Log
Name
Contractor ID Number
Contractor Rate
Work Date
Contract Number 1
Start Time 1
Stop Time 1
Hours Worked 1
Contract Number 2
Start Time 2
Stop Time 2
Hours Worked 2
Contract Number 3
Start Time 3
Stop Time 3
Hours Worked 3
Contract Number 4
Start Time 4
Stop Time 4
Hours Worked 4
Comments
Contracts
Company Name
Company Address
Company Telephone Number
Contact Name
Contract Description
Contact Telephone Number
Contract ID Number
Contract Start Date
Expected Contract Finish Date
Contract Status
Comments
The above chart is the starting point for the assignment. Below are the steps needed to complete the assignment.
* Create the database in Access
* Create the tables one by one. As a table is created the appropriate fields are added as is outlined in the chart above.
* The fields in the tables above are assigned the appropriate data type
* (This step is optional.) Once the tables and fields are set up, the primary key is assigned to each table. If a field does not exist that will have a unique value for every record in the table, create a new ID field that can be used as the primary key field for the table.
* Go to the relationship tool and put all three tables in the diagram
The Access database for the example above is called Week3Database.