Home
Subjects
Solutions
Create
Log in
Sign up
Upgrade to remove ads
Only ₩37,125/year
- Science
- Computer Science
-
Flashcards
-
Learn
-
Test
-
Match
-
Flashcards
-
Learn
-
Test
-
Match
Terms in this set (20)
What is a primary key?
a field (or group of fields) that uniquely identifies a given entity in a table
Which of the following illustrates the primary concepts of the relational database model?
entities, attributes, keys, and relationships
Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?
entity
What is the role of a foreign key?
It is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
What is the primary problem with redundant information?
It is difficult to determine which values are the most current., It is often inconsistent, It is difficult to determine which values are the most accurate.
What are rules that enforce basic and fundamental information-based constraints?
relational integrity constraint
What is one of the biggest pitfalls associated with real-time information?
It continually changes
Which of the following lists include all of the five characteristics common to high-quality information?
accuracy, completeness, consistency, timeliness, and uniqueness
What compiles all of the metadata about the data elements in the data model?
data dictionary
Which of the following is true in regard to the elimination of redundant information?
improves information quality
What is a technique for documenting the entities and relationships in a database environment?
entity-relationship diagram
What is a collection of related data elements?
record
What expresses the specific number of instances in an entity?
cardinality
What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?
one-to-many relationship
What is a characteristic of a table?
field
What is composed of rows and columns that represent an entity?
Table
What is a primary key?
a field that uniquely identifies a given record in a table
What is a foreign key?
a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity?
one-to-one relationship
What occurs when two entities can be related to each other in many instances?
many-to-many relationship
Recommended textbook solutionsComputer Organization and Design MIPS Edition: The Hardware/Software Interface
5th EditionDavid A. Patterson, John L. Hennessy
220 solutions
Engineering Electromagnetics
8th EditionJohn Buck, William Hayt
483 solutions
Introduction to the Theory of Computation
3rd EditionMichael Sipser
389 solutions
Starting Out with C++ from Control Structures to Objects
8th EditionGodfrey Muganda, Judy Walters, Tony Gaddis
1,294 solutions
Sets with similar termsISYS 210 Appendix C
21 terms
shelby_elkins
INFORMATION SYSTEMS
45 terms
pipervwright
MIS Final Exam - APPENDIX C (Databases)
12 terms
josie_dexter
Chapter 6 Designing Database
10 terms
quizzyquizface
Sets found in the same folderMIS quiz 5
10 terms
trisharam96
IS Exam 3
128 terms
augcollier
MSIS 5.2
33 terms
RachelEBellah
MIS Chapter 6
68 terms
vickycasado
Other sets by this creatorQuiz 4 study guide
29 terms
MerlottiLorenzo
Quiz 1 study guide
10 terms
MerlottiLorenzo
Other Quizlet setsCSIT 120 Study Guide Exam 1 Chapters 1-3
22 terms
ichefdan
Test 1
34 terms
mgorovoy
COB 204 1st exam
36 terms
austint0012
APRD Exam 3 Study Guide
31 terms
lindseyhallen
Related questionsQUESTION
Information about a particular SmartData data value is stored in which chronicles master file?
2 answers
QUESTION
Which two configurations can an admin use to help users manage search results?
2 answers
QUESTION
The difference between FAT12/16 and FAT32 boot sector is that the FAT32 sector includes data to make the file system more scalable and flexible.
5 answers
QUESTION
Which statement about spreadsheets is true?
4 answers