Foundations review solutions

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

  • 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.

  • The wrong encoding was used to open the file

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 AND 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

  • 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

  • 29.0

  • Yes/No

  • 6 rabbits were observed

Which of these terms describes a "field/column name"?

  • Assigned

  • Identifying

  • Unique

Which of these terms describes a "field label"?

  • Descriptive

  • Readable

  • User-interface

For each statement, input the correct structure (row, column, table)

  • All data refers to a SINGLE concept.

  • An attribute has the SAME field/data type for every record.

  • Attributes of a record ALWAYS stay together.

Who determines the fitness for use of your data?

  • The users of the data for research or education

For the given statements, input the matching image. (A, B, C, D) accuracyandprecision

  • High accuracy, low precision

  • Low accuracy, high precision

  • High accuracy, high precision

  • Low accuracy, low precision

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 used.

  • Collector field exists in both dataset A and B

  • Country field only exists in dataset B

  • Name field exists in dataset A, but dataset B contains First Name and Last Name fields

  • ID field exists in both dataset A and B

  • Elevation exists in dataset A, but not in dataset B

  • Date exists in dataset A, but Day, Month, and Year are separate fields in dataset B

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 know under which legal terms the reuse of data is permitted.