Improve this document
Create an issue
Edit on GitHubFoundations review
| Quiz yourself on the concepts learned in this section. |
-
For the given statement, input the correct term (database, database language, database program)
-
combines and presents functions and features for manipulating data, together in a unified interface
database program -
structured and organized collection of data and/or information held on a computer
database -
the way by which a human communicates with a computer
database language
-
-
If you open a data file and see the following, what would you suspect is the issue?
�tre, ou ne pas �tre, c�est l� la question.-
Nothing
-
It is corrupt
-
The wrong encoding was used to open the file
-
The sender used a weird font
-
-
For the given software, input the type of software (data capture, data management, data cleaning, data publishing).
-
Integrated Publishing Toolkit (IPT)
data publishing -
Specify
data capture data management -
iNaturalist
data capture -
OpenRefine
data cleaning
-
-
For the given example, input the correct data type (binary, boolean, float, integer, long integer, text, unstructured text)
-
1236975
long integer -
01101111
binary -
We walked 5 miles down the road west from the post office in the center of town. We then went 2 miles north on a dirt path to the river. Then we continued west along the river for another 5 miles.
unstructured text -
1024
integer -
29.0
float -
Yes/No
boolean -
6 rabbits were observed
text
-
-
Which of these terms describes a "field/column name"?
-
Assigned
-
Descriptive
-
Identifying
-
Readable
-
Unique
-
User-interface
-
-
Which of these terms describes a "field label"?
-
Assigned
-
Descriptive
-
Identifying
-
Readable
-
Unique
-
User-interface
-
-
For each statement, input the correct structure (row, column, table)
-
All data refers to a SINGLE concept.
table -
An attribute has the SAME field/data type for every record.
column -
Attributes of a record ALWAYS stay together.
row
-
-
Who determines the fitness for use of your data?
-
The museum or department director
-
The users of the data for research or education
-
The collector of the data in the field
-
The person entering the data into the database
-
-
For the given statements, input the matching image. (A, B, C, D)
-
High accuracy, low precision
C -
Low accuracy, high precision
B -
High accuracy, high precision
D -
Low accuracy, low precision
A
-
-
Identify the data relationships where Dataset B needs to be merged into Dataset A (0:1, 1:0, 1:1, 1:∞, ∞:1, ∞:∞). Not all the relationships are used.
-
Collector field exists in both dataset A and B
1:1 -
Country field only exists in dataset B
0:1 -
Name field exists in dataset A, but dataset B contains First Name and Last Name fields
1:∞ -
ID field exists in both dataset A and B
1:1 -
Elevation exists in dataset A, but not in dataset B
1:0 -
Date exists in dataset A, but Day, Month, and Year are separate fields in dataset B
1:∞
-
-
Metadata is important because (select the TRUE statements):
-
it allows users to determine if a dataset is fit for their use.
-
it allows you to share exact coordinates for each occurrence.
-
it allows you to know under which legal terms the reuse of data is permitted.
-
it also applies to all supplemental and associated materials, including images, video, and other media.
-
it allows you know about the institution’s next exhibition/opening hours.
-