Upgrade to remove ads
Only A$47.99/year
- Science
- Computer Science
-
Flashcards
-
Learn
-
Test
-
Match
-
Flashcards
-
Learn
-
Test
-
Match
Terms in this set (39)
Record
A logically connected set of one or more fields that describes a person, place, or thing.
Data and information are essentially the same thing.
False
Data integrity
The condition in which all of the data in the database are consistent with the real-world events and conditions.
Field
A character or group of characters that has a specific meaning.
File
A collection of related records.
Data Redundancy
Situation where different versions of the same data are stored at different places because they werent updated considtently.
Metadata
Provide a description of the data characteristics and the set of relationships that link the data found within the database.
Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.
False
End-User Data
Raw facts of interest to the end user
Metadata describe the data characteristics and the set of relationships that links the data found within a database.
True
Entity
Represents a particular type of object in the real world.
Constraint
A restriction placed on the data.
Data Definition Language (DDL)
Enables a database administrator to describe schema components.
Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories. (True or False)
False
Which of the following is true of business rules?
A) they allow the designer to set company policies with regard to data.
B) they can serve as communication tool between the users and designers.
C) they provide a framework
for the company's self-actualization.
D) they allow the designer to develop business processes.
Answer: B
Entity (2)
Is anything about which data are to be collected and stored.
Model
Main function is to help one understand the complexities of the real-world environment.
In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored. (True or False)
True
Entity relationship
Model was developed to allow designers to use a graphical tool to examine structures rather than deacribing them with text.
Business Rule
A brief, precise, and unambiguos description of a policy, procedure, or principle within a specific organization.
If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A).
True
Foreign Key
Primary key of one table that has been placed into another table to create a common attribute.
Column
Represents an attribute in each table.
Entity Integrity
The Customer table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique.
SELECT
Also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.
PROJECT
Returns only the attributes requested, in the order in which they are requested.
NOT NULL
Constraint can be placed on a column to ensure that every row in the table has a value for that column.
Referential Integrity
Dictates that the foreign key must contain values that match the primary key in the related table, or must contain null.
True
Relational Algebra defines the theoretical way of manipulating table contents using relational operators.
Union-Compatible
When two or more tables share the same number of columns, and when their corresponding columns share the same or compatible domains, they are said to be...
Existence-Dependent
Entity that can exist in the database only when it is associated with another related entity occurrence.
Domain
The set of possible values for a given attribute.
In the entity relationship model, a table row corresponds to an entity instance.
True
Composite attribute
Can be further subdivided to yield additional attributes.
An entity in the entity relationship model corresponds to a table in the relationship environment.
True
Strong Entity
If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as?
Weak entity
Has a primary key that is partially or totally derived from the parent entity in the relationship.
False
Composite attributes make it easier to facilitate detailed queries.
Cardinality
Expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.
Recommended textbook solutionsEngineering Electromagnetics
8th EditionJohn Buck, William Hayt
483 solutions
Computer Organization and Design MIPS Edition: The Hardware/Software Interface
5th EditionDavid A. Patterson, John L. Hennessy
220 solutions
Introduction to the Theory of Computation
3rd EditionMichael Sipser
389 solutions
Introduction to Algorithms
3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen
720 solutions
Sets with similar termsCIS-324 Final
54 terms
southerngoddess1
214 practice exam
169 terms
khalsasant
Data Management Foundations - C175
102 terms
autumnoftheseraphs
database test 1
73 terms
adrianelemoine
Sets found in the same folderDatabase Chapter 2
66 terms
nbana93
Midterm Round 2
125 terms
Kereev
database design
20 terms
toya13
finals Ch 4
51 terms
rharperAP
Other sets by this creatorChapter 4 CISS201
11 terms
michael_goeins
Principles of Management CHP 1
21 terms
michael_goeins
EAWS-Airframe
15 terms
michael_goeins
EAWS-Powerplants
16 terms
michael_goeins
Verified questionsCOMPUTER SCIENCE
True/False: Loops are more general than recursion.
Verified answer
COMPUTER SCIENCE
Write a program that alters the behavior of a Parent class using the concept of overriding.
Verified answer
COMPUTER SCIENCE
Write a Python statement that subtracts the variable down_payment from the variable total and assigns the result to the variable due.
Verified answer
COMPUTER SCIENCE
T F The exit function can only be called from main.
Verified answer
Other Quizlet setsBronchodilators & Antiglaucoma Medications
14 terms
bkim01
Quiz 2
70 terms
p4_alliek
KIN- Foundations of Structural Kinesiology
40 terms
Jocelyn_Aguilar84
Generic's AND Trade's
84 terms
stephanie01132001
Related questionsQUESTION
When data is changed in a query datasheet, what happens to the associated data in the table? Do the tables need to have a relationship if you want to create a query that retrieves data from multiple tables?
3 answers
QUESTION
What can extensive locking in a relational database cause
2 answers
QUESTION
What program serves as the GUI front end for accessing Sleuth Kit's tools?
15 answers
QUESTION
Java programs tend to execute faster than programs compiled into machine-dependent code because the Java virtual machine only has to interpret the bytecode.
9 answers