Image transcription text 5M521D Project 3 1514: Scope When you volunteered to worlc with a local Charity, you were assigned to maintain a database pertaining

Image transcription text 5M521D Project 3
1514: Scope When you volunteered to worlc with a local Charity, you were assigned to maintain a
database pertaining to current projects. The Charity re-ouilds houses for families who
cannot afford to buy a house for themselves. Each house is assigned a House ID which
is unique to that house. As people from the community volunteer, they are assigned to
one ofthe house projects. It is yourjdh to keep up with “II data pertaining to house
projects and their assigned volunteers. This is a new database that you must create
and then begin accumulating the data. 1} Start Access and open a new Blank desktop database named W1 3m
Project Saocdb, replacing XXIX)! with your last name1 and replacing am with yourfirst name. 2
2} Create a table, Houses, that contains the following fields: 5
Field Name Data Field Description
Type Size
House In Short Text 6 Uniquely identities the house project and is the primary trey.I Address Short Text 30 Address attire house Project Short Text 15
Manager Project M anager N ame Start Date Datel’TIme Default Short Date Date the project was started End Date DateJ’TIme Default Short Date Estimated completion date Budget Cunency Cunency Ddecimal
places Estimated Project budget Image transcription text reate a seoond table, VolunteersI that contains the tolowing fields. 4 Field Home Data Type Field Size Description
Volunteer ID Short Text 6 Uniquely identities the volunteer and
is the Primary Key
Last Name Short Text 20 Volunteer’s Last Name
First Name Short Text 20 Volunteer’s First Name
—_I 4} Each of the tables above has a primary key that will identityI each record in the
table. Now you need a field somewhere that will allow you to establish a
relationship between the two tables. Thl extra field will be added to one ofthe
tables so that there will be a common field on which the relationship will be
formed. As you look at your two tables to determine what you need to add, you think
about how it takes many workers to build a house. That lwould imply that each
House needs to be linked to the Volunteers using a One-To-lulany relationship. Add the field needed forthe relationship to the design of the Volunteers table.
Open the relationships window and establish a relationship between the two tables. Choose the option to Enforce Referential Integrity without Cascade
Updates or Cascade Deletes. 5 Image transcription text 5) Add the following records to the Houses table
House ID
Address
Project Manager
Start Date
End Date
Budget
H105
2897 Elm Street
Scott
05/18/16
09/01/16
50000
H106
5208 Franklin Ave.
Walton
04/01/16
08/01/16
35000
H107
5207 Franklin Ave.
Walton
04/01/16
08/15/16
42000
H108
5208 Franklin Ave.
Walton
04/30/16
09/15/16
33000
H109
5208 Franklin Ave.
Walton
04/30/16
09/30/16
27000
H104
1486 Elm Street
Scott
04/30/16
09/15/16
35000
H102
1588 Elm Street
Scott
04/15/16
09/30/16
25000
H101
1580 Elm Street
Scott
05/01/16
08/15/16
16000
H120
901 Chester Ave.
Henderson
05/01/16
08/15/16
45000
H121
902 Chester Ave.
Henderson
05/01/16
08/15/16
37000
6) Add the following records to the Volunteers table (it will be easy if you
completed instruction 4 correctly).
Volunteer ID
Last Name
First Name
Phone
House ID
VO197
Mitchell
Bill
416-890-7856
H107
VO198
Carpenter
Candy
805-907-8967
H120
VO190
Bell
Don
416-800-8744
H120
VO200
Reynolds
Sarah
418-890-5633
H101
VO201
Brooks
Hannah
418-890-7822
H121
VO202
Brooks
Austin
418-890-7822
H121
VO203
Miller
Philip
805-907-5645
H104
VO204
Lang
Tamara
805-907-3321
H107
VO205
Mulloy
Tim
905-907-0009
H109
VO208
Smith
Pam
418-807-1234
H101