Database Software Basics Answers

An author keeps track of income and expenses in a table: ✔ flat filerelational database

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: flat file✔ relational database

A social media website has many users who are allowed to upload photos, videos, and information about themselves: flat file✔ 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: flat file✔ relational database

What is an advantage of using a relational database instead of a flat file to store, organize, and analyze data?

What does each row represent? ✔ a recorda fielda foreign keya primary key

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 NumberNameGrade

What is the foreign key in the Players Table? ✔ TeamRankingPositionName

What links the Football Teams table to the Players table?

Use the drop-down menus to answer the following questions. What is the primary key in Table 1? What is the primary key in Table 2? Which table is the cross-referencing table?

Use the drop-down menus to answer the following questions.Which table contains foreign keys? Which type of relationship is represented by the letter A? Which type of relationship is represented by the letter B? Which type of relationship is represented by the letter C?

What is a disadvantage of using a relational database instead of a flat file to store, organize, and analyze data?

What distinguishes one record from another? First NameLast Name✔ ID NumberGrade

What is the primary key in Table 2? ✔ Course ID NumberCourse NameStudent ID Number

What is the primary key in the Football Teams Table? Ranking✔ TeamDivision

What type of relationship is represented by these tables?

What is the primary key in Table 2?

What should you choose as the primary key for this table? First NameLast Name✔ ID NumberGrade

What does Student ID Number refer to in Table 2? the primary key✔ the foreign key

Which table is the cross-referencing table?