Networking and Operating Systems

IT Fundamentals, Section 7.3: Relational Databases – TestOut

Objective: 

This section introduces the purposes, properties and operation of relational databases. After finishing this section, you should be able to:

  • Describe the purposes of a relational database.
  • Define basic relational database terminology, including fields, records, primary keys, foreign keys, and one-to-many relationships.
  • Define the term normalization as it relates to storing and retrieving data.
  • Answer basic questions about Microsoft Access table relationships.
  • Perform the following database design tasks in Microsoft Access:
    • Create a table.
    • Add fields to a table.
    • Change the data type and size of a field.
    • Set default field values.
    • Create table relationships.

Links:

Key Terms:

  • Relational Database
  • Table
  • Field
  • Record
  • Primary Key
  • Foreign Key
  • Query
  • Form
  • Report
  • Normalization

Topics Discussed:

  • What are some primary keys that databases use to identify me?
  • What one-to-one, one-to-many, and many-to-many relationships do I encounter in a typical day?
  • How does normalization improve a database?

Assignment:

  1. Access the TestOut Courseware through the provided link.
  2. Study 7.3: Relational Databases and complete the 7.3.9 and 7.3.11 Labs/Activities and the 11 question Exam to complete the Section.

Assigned: April 23rd, 2024
Teacher Pacing Due Date: April 24th, 2024
AZ CS Standard: Computing Systems – HS.CS.T.1