Study sets, textbooks, questions
Upgrade to remove ads
ACIS Exam 3
Terms in this set (38)
Google is a what?
An application that feeds the database is called?
Web Crawler is a software that is programmed to do what?
Go out into the web to look for websites.
Tries to figure out how important that web page is for the words that appear?
Query Processor reads from what?
Query Processor has two parts:
User Interface & Results Formatter
What we see when we go to google
Shows us the highest rankings first and lists that first, and so on.
Just accepts requests and sends it to index servers.
All they do is store index, and sends 1,000 matches to document servers.
Retrieves stored documents and snippets are created to describe the search results, returned to user in seconds.
When trying to keep track of multiple things, use a ________.
When trying to keep track of multiple outputs, use a _________.
Data about data is _________.
What makes a database more powerful?
In a database, you need to define the ___________.
What does Ad-hoc mean?
In a database, only relevant data is ________.
Shared access cannot be done in spreadsheets, but can be done in _____________.
Keeping things synced up, or keeping tables synced up is known as what?
Data is stored separately from programs that use the data.
Meaning quality data
An error within the data
Why is copying data to another place a bad idea?
You have to keep the data updated manually.
Set of related tables is known as?
An object we're trying to keep track of is known as?
Another name for a row within a table, an instance or a specific example of an entity.
Column within a table, it is a characteristic of the object.
The actual data item for a given field, for a given record.
Uniquely identifies each row/record in a table
Connects a row in one table with one or more rows in another
How many primary keys can there be?
How many foreign keys can there be?
The structure and organization of a database is described by its what?
Is an occurrence of an entity class that can be uniquely described with a primary key.
Is a process of assuring that a relational database structure can be implemented as a series of two-dimensional relations (Files or tables).
Is a relation you create to eliminate a many-to-many relationship.
Consists of the primary key fields from the two intersecting relations.
Composite Primary Key
Recommended textbook explanations
John Buck, William Hayt
Introduction to Algorithms
Charles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen
Java How to Program (early objects)
Harvey M. Deitel, Paul J. Deitel
Computer Organization and Architecture
Sets with similar terms
Chapter 5 Databases: Tables and Entities
Other sets by this creator
PQL Exam 3
PQL Exam 2
PQL Exam 1
Organization Behavior Exam 2 Flashcards (Chapter 1…