Charles asks you, “What is an entity, a table, a field, and a record?” He also wants to know the different between primary key, candidate keys, foreign keys, secondary keys, and combination keys.
What will be an ideal response?
You might explain to Charles that an entity is a person, place, thing, or event for which data is collected and maintained. A table contains a set of related records that store data about a specific entity. A field is a single characteristic or fact about an entity. A record is a set of related fields that describes one instance, or occurrence of an entity, such as one customer, one order, or one product. A primary key is a field or combination of fields that uniquely and minimally identifies a particular member of an entity. A candidate key is any field that could serve as a primary key because sometimes you have a choice of fields or field combinations to use as the primary key. A foreign key is a field in one table that must match a primary key value in another table in order to establish the relationship between the two tables. A secondary key is a field or combination of fields that can be used to access or retrieve records.
You might also like to view...
A document in the OpenOffice Writer application opens in the main ________
A) status bar B) sidebar C) work area D) toolbar
Critical Thinking Question Case Study 8-1? ? Lexi was cleaning out her attic and came across several boxes of old photos. She does not want to lose them so she loads them onto her computer. She knows you did that with some of your wedding photos recently. She decides to call you. Once Lexi has finished, she asks you how to share the photos with her family members. You tell her she can ______.? a. tell them she has loaded them on her computer b. view them and describe them to her family c. send them via email d. not share them once they are saved on her computer
What will be an ideal response?
The ____ takes instructions from the prefetch unit and translates them into a form that the control unit can understand.
A. register B. decode unit C. ALU D. internal cache
Which of the following is true about intangible benefits?
a. They can be measured directly. b. They cannot be measured directly. c. They are assigned a monetary value. d. They can be quantified in monetary terms.