5.11. Knowledge Check

Knowledge Check 1

 

Text Description
This activity contains a set of dialog cards, which are described below.
Activity Description or Instruction:
  1. Dialog Text: Database; Image Alt Text: database
  2. Dialog Text: File; Image Alt Text: file
  3. Dialog Text: Fields; Image Alt Text: field
  4. Dialog Text: Record; Image Alt Text: record

Solution:

  1. A set of interrelated files forms a database (e.g., a customer sales database may include customer file, inventory file, and sales file).
  2. A set of related records, such as all customer records, forms a file (e.g., customer file).
  3. Fields contain data about one customer such as the customers address, customer name, and so on.
  4. All the fields for one customer form a record (e.g., customer record).

Knowledge Check 2

Text Description
  1. Customer ID could be categorized as a:
    1. file
    2. field
    3. record
    4. database
  2. Which of the following would be identified as a file?
    1. Data about one customer
    2. A customer’s name
    3. Data about one inventory item
    4. All inventory records
  3. Which of the following is not an advantage of database systems?
    1. Data sharing
    2. Data privacy
    3. Data independence
    4. Data integration
  4. In a Sales Table, the field most likely chosen as a primary key would be:
    1. customer number
    2. customer name
    3. inventory item number
    4. sales invoice number
  5. In an inventory table, the most likely nonkey would be
    1. item number
    2. colour and price

Solution:

  1. b. field
  2. d. All inventory records
  3. b. Data privacy
  4. d. sales invoice number
  5. b. colour and price

Knowledge Check 3

Is the primary Key in the Products Table.
Is the foreign Key in the Products Table.
Is the primary Key in the Category Table.

Possible Answers,

  • Category ID
  • Product ID

Solutions:

Is the primary Key in the Products Table – ProductID
Is the foreign Key in the Products Table – CategoryID
Is the primary Key in the Category Table – CategoryID

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Information Systems for Business and Beyond Copyright © 2022 by Shauna Roch; James Fowler; Barbara Smith; and David Bourgeois is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book