CS3 - Kurtz  Santa Monica College 

DATABASE MANAGEMENT

 

Database Management System  DBMS 
A computer program that enables you to organize data so that they can be easily stored, accessed, modified and maintained.
Data  Facts
Database Collection of related data 
One or more tables
Field  Single piece of data (address, name, price, ID#)
Record Group of related fields with information about a single entity
Table  Collection of records
Single-table Database  Data is stored in only one table.
Relational Database  Data is stored in several logically related tables linked by key fields 
Minimizes data entry for multiple orders from same customer or if customer moves 
Eases difficulty of two customers with same name 
Maintains data on suppliers and products even if there are no orders or billings for same 
 
Object Oriented Database Based on Object Oriented Model
Stores more data type than a relational database
Can return results faster than a relational database
Design View  Shows field names, type of data each field will hold, and each field's properties. 
Used for defining the structure of a new table or modifying the structure of an existing table.
Datasheet View  A columnar presentation of a table that shows the contents of many records at once 
May be used to create or modify records
Form View  May display all of the fields from a single record onto one form 
May combine data from multiple tables onto one form 
May be used to create or modify records
Query A database search that lists records based on criteria that you specify 
Used to combine data from multiple tables 
Used to selectively modify data
Criteria  A particular condition or instruction entered by the user upon which a query may be based
Find Command  Used to search for the next record in a database table containing a user specified "search phrase"
Wildcard Character A symbol that takes the place of one or more characters in a search or query (e.g., 9040* will yield all numbers beginning with 9040, such as all of the zip codes in Santa Monica).
Default Value  Specified by user during design phase 
Appears in a particular field in every record unless explicitly changed
Wizards  On-screen help tools 
Step-by-step instructions for creating forms, table, queries, and reports 
Typically more powerful than templates or help screens
Reports  Provide an attractive, professional, and useful presentation of selected data from a database 
Always based on a table or query 
Laid out in bands which represent sections of the report