Chapter 3: Databases Flashcards
1
Q
Database
A
- A central repository of information, stored more-or-less permanently on a computer system, that is of interest to some enterprise.
- The heart of an information system, is a collection of all relevant facts organized in a series of integrated files (tables)
2
Q
Database Management System (DBMS)
A
- A generalized software tool for manipulating large databases; it provides minimally the capabilities of interrogation and maintenance of the stored data, via a set of languages or user interfaces.
- Is software for creating, storing, maintaining, and accessing database files
- A software program that lets the user create databases and then manipulate the data in the databases
3
Q
5 Purposes of Database Systems
A
- Record and organize data
- Maintain (create, delete, modify/update) data
- Interrogation (Questioning/retrieving data)
- Interconnect data
- Security, control, data sharing
4
Q
Table =
A
Relation/Record (Multiple records)
Records make up Fields which makes up a File
5
Q
Row of a table =
A
Record/Tuple
- Multiple records create a table
- Record = Makes up a field
6
Q
Column of a table =
A
Field/attributes
- Made up of records
- Group of fields make up a file
7
Q
Files
A
Database file with multiple tabes (all in the same database) interrelated
8
Q
Primary Key
A
- Uniquely identifies every record in a database
- Cannot repeat
- Can be foreign key if same field is in another table
9
Q
Foreign Key
A
Field in a table that matches the primary key column of another table
10
Q
Sequential access file structure
A
Records in files are organized and processed in numerical or sequential order (usually order in which they were entered)
11
Q
Random access file structure
A
Records can be accessed in any order
12
Q
Indexed sequential access method (ISAM)
A
- Records can be accessed sequentially or randomly depending on number being accessed
- Small company: Random
- Large company: Sequential
13
Q
Physical View
A
- One way that information is viewed in a database
- Involves how data is stored and how its retrieved
- Ex: Hard disks, magnetic tapes, or CDs
14
Q
Logical View
A
- One way that information is viewed in a database
- Involves how information appears to users and how it can be organized and retrieved
- Usually doesn’t display data (database view)
15
Q
Data Model
A
- Determines how data is created, represented, organized, and maintained.
- Usually contains data structure, operations, and integrity (quality/accuracy) rules