Relating Fields and Records Assignment
An author keeps track of income and expenses in a table: ✔ flat file A college admissions department stores detailed information about each applicant, including his or her full name, address, high school, GPA, standardized test scores, intended major, and entrance exam scores: ✔ relational database A social media website has many users who are allowed to upload photos, videos, and information about themselves: ✔ relational database A library stores information about patron names, account numbers, books out on loan, the date books are due, the date books are returned, the number of days a book is overdue, and overdue book fines; this information allows the system to e-mail or call patrons to remind them to return books on time: ✔ relational database
<---
What is a disadvantage of using a relational database instead of a flat file to store, organize, and analyze data?
It is difficult to use a relational database without prior knowledge.
What is an advantage of using a relational database instead of a flat file to store, organize, and analyze data?
It is easier to minimize duplicate data in a relational database.
Refer to the table below to answer the questions to the right. Use the drop-down menus to answer the following questions
What does each row represent? ✔ a record What distinguishes one record from another? ✔ ID Number What should you choose as the primary key for this table? ✔ ID Number
Refer to the illustration below to answer the questions to the right.
What is the foreign key in the Players Table? ✔ Team What is the primary key in the Football Teams Table? ✔ Team
The illustration below shows a database containing store and product data. Use this information to answer the following questions. Use the drop-down menus to answer the following questions.
What is the primary key in Table 1? ✔ Store ID Number What is the primary key in Table 2? ✔ Product ID Number Which table is the cross-referencing table? ✔ Table 3: Search Engine
Refer to the illustration below to answer the following questions. Use the drop-down menus to make your selections.
What is the primary key in Table 1? ✔ Student ID Number What is the primary key in Table 2? ✔ Course ID Number What does Student ID Number refer to in Table 2? ✔ the foreign key What forms the link between Table 1 and Table 2? ✔ Student ID Number
Refer to the illustration below to answer the questions to the right.
What links the Football Teams table to the Players table? ✔ Team What type of relationship is represented by these tables? ✔ one-to-many
The illustration below shows a database containing store and product data. Use this information to answer the following questions. Use the drop-down menus to answer the following questions.
Which table contains foreign keys? ✔ Table 3 Which type of relationship is represented by the letter A? ✔ one-to-many Which type of relationship is represented by the letter B? ✔ one-to-many Which type of relationship is represented by the letter C? ✔ many-to-many
