CH. 9 Databases
individual database
A combined set of data files intended to be used by one person.
A collection of related data that can be sorted, logically organized, searched, and stored is called a ___________.
Database
In the relationship shown on the left, the Owners table is linked to the Pets table by a 1-to-many relationship. This means that each entry in the OwnerID field can be linked to many _________.
Pets
What are primary keys and ordinary field:
Primary key - voter registration number - driver's license number - social security number Ordinary field: - street address - party affiliation - last name
To search a database for information, create a _________.
Query
In the datasheet view of relational database (such as Microsoft Acess) a row of information is called a _________.
Record
To display or distribute a summary of data and archive snapshots of the data, data administrators or programmers create:
Reports
Company database
users access the organizations database through a LAN
Where do you click to change the view from datasheet to design view?
you click on view under HOME
Three examples of DBMS software:
- Oracle Database - Microsoft SQLServer - Office Access
Your college has a database with a Students table. Which of the following could be a primary key in the table?
- Social Security Number - Student number
What's true about database fields:
- a group of related characters in a database table - represents a characteristic of someone or something
A database for a pet care buisness:
Owner Table: - Street address - last name - zip code - phone number Pet Table: - medicines - species - preferred food - pet name
Advantages of filing systems:
Traditional filing system: - requires no training to use Database: - allows greater data sharing - allows unlimited storage
In the ClassList table, the primary key is probably the ______ field.
classnumber
to view any relationships between the drivers table and the tickets below you have to __________.
click on the database tools tab or Design tab
Large databases often called data banks, that cover particular subjects are referred to as
commerical
distributed database
data is stored in different physical locations - accessed through a client/server network
Becky wants to organixe and sort her wedding invitation list according to groom's guests, bride's guests, out of town guests, and estimated wedding gift value. For this reason she is using a recreational ____________ instead of a list.
database
To create a relationship between 2 tables, it is necessary to create a ____________ key in one table that is the primary key of the other table.
foreign
In a relational database, a common field that links two tables in a relationship but is not a primary key is called a ____________.
foreign key
the order in which data is organized in a database is referred to the database_______________.
hierarchy
Adam was in the 5th grade when he was adopted by the Smith's. Because his school used a centralized database, all of his teachers had his correct name on their grade reports. This is an example of how a centralized database can help improve data __.
integrity
Forms structure data input ensure data ___, meaning the information entered is accurate, timely, and useful
intergrity
Katrina was a senior in college when she married her high school sweetheart. She changed her ladt name, and because the college use a centralized database, each of her instructors has her new name in their gradebooks. This is an example of how centralization can improve data ___________.
intergrity
Commercial database
often referred to as a data bank
In a relational database, an important field that contains a unique value that identifies each record as individual is the ___________ key
primary
So that users can find specific information quickly by using filters based on specific criteria, databases allow the creation of __________.
queries
this database uses common fields to create links between tables. This is called a _______ database.
relational