You are now going to prepare some reports for the company. Measurements are in metres and volume
n cubic metres. Prices are per cubic metre. Mako sure al currency values are displayed with 2 decimal
places
20 -
Using a suitable database package, import the file M2017BOARDS.CSV
Use these field names and data types:
Field Name Data Type Description/Specification
Board ID
Text
This is a unique identification for each board
Tree_ID
Text
This code identifies the type of tree
Thickness
Numeric
Width
Numeric
Numeric
Length
Drying
Text
Ready
Sold
Boolean/Logical Display as Yes/No or checkbox
Boolean/Logical Display as Yes/No or checkbox
Numeric/Currency Currency of your choice
Price
.
Set the Board_ID field as the primary key.
[3]
Import the file M2017TREES.CSV into your database as a new table with appropriate data
types. Set the Tree_ID field as the primary key.
121
21.
12.
Examine the file M2017LOCATIONS.CSV and decide on appropriate data types for each field
Import the file M2017LOCATIONS.CSV into your database as a new table with appropriate
data types. Set the Location_code field as the primary key.
121
EVIDENCE 4
Place in your Evidence document screenshot(s) showing the field names and data
types used in each of the three tables.
23
Create one-to-many relationships as links between the three tables.
Use the Tree_ID field in the Trees table to link to the Tree_ID field in the Boards table, and
the Location_code field in the Locations table to link to the Location_code field in the Trees
table.
EVIDENCE 5
Place in your Evidence document screenshot(s) showing the relationships between
the three tables.