Foundations review

Quiz yourself on the concepts learned in this section.
  1. 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

    • structured and organized collection of data and/or information held on a computer

    • the way by which a human communicates with a computer

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

  3. For the given software, input the type of software (data capture, data management, data cleaning, data publishing).

    • Integrated Publishing Toolkit (IPT)

    • Specify

    • iNaturalist

    • OpenRefine

  4. For the given example, input the correct data type (binary, boolean, float, integer, long integer, text, unstructured text)

    • 1236975

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

    • 1024

    • 29.0

    • Yes/No

    • 6 rabbits were observed

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

    • Assigned

    • Descriptive

    • Identifying

    • Readable

    • Unique

    • User-interface

  6. Which of these terms describes a "field label"?

    • Assigned

    • Descriptive

    • Identifying

    • Readable

    • Unique

    • User-interface

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

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

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

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

    • 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

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