Computers and Technology, 12.01.2021 14:00 jayjay3787

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.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 16:50

Consider a slotted aloha system, where the time slot equals the fixed duration of each packet. assume that there are 4 stations a,b,c,d sharing the medium. (a) stations a,b,c,d receive one packet each from higher layers at times 1.3, 1.5, 2.6,5.7 respectively. show which transmissions take place when, according to the slottedaloha protocol; describe all transmissions until all four packets have been successful.when needed, each station has access to the following sequence of random number, provided by a random number generator and drawn uniformly between 0 and 1: (1) station a draws numbers: 0.31, 0.27, 0.78, 0.9, 0.9, 0.11, 0. (2) station b draws numbers: 0.45, 0.28, 0.11, 0.83, 0.37, 0.22, 0. (3)station c draws numbers: 0.1, 0.2, 0.3, 0.4, 0. (4) station d draws numbers: 0.36, 0.77, 0.9, 0.1, 0.1, 0.1, 0.1, 0. (b) in slotted aloha, a station transmits in each time slot with a given probability. what probabilities would you assign to each of the four stations so as to: (i) maximize the efficiency of the protocol? (ii) maximize fairness among the four stations? (c) will the efficiency increase or decrease if we modify slotted aloha as follows: (i) get rid of slots and allow stations to transmit immediately? (ii) implement carrier sensing? (iii) implement collision detection? (iv) implement collision avoidance?

Answers: 3

Answer

Computers and Technology, 23.06.2019 07:30

What is the penalty for violating section 1201 of title 17 chapter 21 of the us code

Answers: 1

Answer

Computers and Technology, 23.06.2019 13:30

Select the correct answer from each drop-down menu. which types of computer networks are bigger as well as smaller than a man? a man is a network of computers that covers an area bigger than a , but smaller than a .

Answers: 1

Answer

Computers and Technology, 24.06.2019 03:30

Auniform resource locator (url) is a formatted string of text that web browsers, email applications, and other software programs use to identify a particular resource on the internet. true false

Answers: 2

Answer

You know the right answer?

You are now going to prepare some reports for the company. Measurements are in metres and volume n...

Questions