AnswersIntroduction to Information Technology - EL3701Create and Edit Images

Relating Fields and Records Answers

25 verified answers3 views
1
Free Preview

Use the drop-down menus to answer the following questions.

Answers:
Selection 1:Table 3
Selection 2:one-to-many
Selection 3:one-to-many
Selection 4:many-to-many
2
Free Preview

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

A social media website has many users who are allowed to upload photos, videos, and information about themselves: flat file✔ relational database

A
flat file
B
✔ relational database
4

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

A
flat file
B
✔ relational database
5

Read the following examples, and decide whether each example describes a relational database or a flat file. Use the drop-down menus to make your selection.

Answers:
Read the following examples, and decide whether each example describes a relational database or a flat file. Use the drop-down menus to make your selection.:flat file
Read the following examples, and decide whether each example describes a relational database or a flat file. Use the drop-down menus to make your selection.:relational database
Read the following examples, and decide whether each example describes a relational database or a flat file. Use the drop-down menus to make your selection.:relational database
Read the following examples, and decide whether each example describes a relational database or a flat file. Use the drop-down menus to make your selection.:relational database
6

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

A
It is easier to create duplicate data in a relational database.
B
It is easier to search for data in a regional database.
C
It is easier to minimize duplicate data in a relational database.
D
It is easier to use relational databases without prior knowledge.
7

Use the drop-down menus to answer the following questions.

Answers:
Use the drop-down menus to answer the following questions.:a record
Use the drop-down menus to answer the following questions.:ID Number
Use the drop-down menus to answer the following questions.:ID Number
8

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

Question illustration
Answers:
Selection 1:Student ID Number
Selection 2:Course ID Number
Selection 3:the foreign key
Selection 4:Student ID Number
9

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

A
✔ Team
B
Ranking
C
Position
D
Name
10

What links the Football Teams table to the Players table? Ranking✔ TeamName Position

A
Ranking
B
✔ Team
C
Name
D
Position
11

Use the drop-down menus to answer the following questions.

Answers:
Use the drop-down menus to answer the following questions.:Store ID Number
Use the drop-down menus to answer the following questions.:Product ID Number
Use the drop-down menus to answer the following questions.:Table 3: Search Engine
12

Use the drop-down menus to answer the following questions.Which table contains foreign keys? Table 1Table 2✔ Table 3

Answers:
Selection 1:Table 3
Selection 2:one-to-many
Selection 3:one-to-many
Selection 4:many-to-many
13

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

A
It is difficult to access information in a relational database.
B
It is difficult to avoid creating duplicate information in a relational database.
C
It is difficult to filter information in a relational database.
D
It is difficult to use a relational database without prior knowledge.
14

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

A
First Name
B
Last Name
C
✔ ID Number
D
Grade
15

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

A
✔ Course ID Number
B
Course Name
C
Student ID Number
16

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

A
Ranking
B
✔ Team
C
Division
17

What type of relationship is represented by these tables? ✔ one-to-manyone-to-onemany-to-many

A
✔ one-to-many
B
one-to-one
C
many-to-many
18

What is the primary key in Table 2? Product Name✔ Product ID NumberProduct DescriptionPrice

A
Product Name
B
✔ Product ID Number
C
Product Description
D
Price
19

Which type of relationship is represented by the letter A? one-to-one✔ one-to-manymany-to-many

A
one-to-one
B
✔ one-to-many
C
many-to-many
20

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

A
First Name
B
Last Name
C
✔ ID Number
D
Grade

Did you find these answers helpful?

More from this Course

Assignment
20 verified answers

Word Processing Software Basics

Assignment
21 verified answers

Databases

Assignment
25 verified answers

Database Software Basics