Chapter 1 Flashcards
Which of the following best describes why databases are referred to as client/server database systems?
a. A system that divides processing between client computers and a database server.
b. Processing is divided between two clients.
c. The client is a multiple-user computer that provides shared-database services with the single-user server.
d. The server is a single-user computer that interfaces with the single-user client.
a. A system that divides processing between client computers and a database server.
In client/server computing, the database-system software and interfaces are spread across a network of single-user clients and multiple-user servers that communicate and cooperate to carry out system objectives.
What is the most widely used type of database called?
a. Table
b. Relational database
c. Structured Query Language (SQL)
d. Database management system
b. Relational database
The relational database is the most popular choice.
What links the tables in a relational database?
a. Keys
b. Rows
c. Tables
d. Columns
a. Keys
Tables in a relational database are linked together through the use of keys
(Primary keys and foreign keys).
What technique is used to organize data attributes into a more efficient, reliable, and maintainable structure, and ensures that all tables are linked together?
a. Sybase
b. Keys
c. Normalization
d. Structured Query Language (SQL)
c. Normalization
This is a three-step technique that places tables in first, second, and third normal form.
What are the rules called that govern how SQL is written?
a. Primary Keys
b. Query rules
c. Syntax rules
d. Keywords
c. Syntax rules
Syntax rules govern how SQL is written
Client
A single user computer that interfaces with multiple user server.
Client/Server data base system.
A system that divides client computer and a data base server.
Database
A collection of electronically stored organized files.
Server
a multiple shared database connection, interfacing and processing services.
Field
Column that runs vertically within a table.
Foreign Key
Link records of one type with those of another type.
Keys
Uniquely identify a row or record in a table.
Normalization
A three step technique used to organize data attribute in a more efficient, reliable, flexible, and maintainable structure.
Primary Key
a field whose value uniquely identifies every row.
Row
A record that represents a collection of information relating to an item in a table.