Computer Concept week4_2

19/02/2010

Exam 2nd week of March (close book)

Building Database

• Data Base: an organized collection of data
  
• Field: the smallest information in a database
  
• Record: a number of fields
  
• DBMS(Data Base Management System): the software, which can allow you to organize and control data in a database
  
• Query: getting select information
  

 
Database Structure

• File: a collection of data or information that has a filename and that can be stored permanently on a drive
  
• Table: a table is a collection of data about a specific topic
  
• Record: a number of fields make up a record
  
• Fields: the smallest information in database
  
• 
  
  Key Field: a special type of field, which uniquely identifies a record in a table, or to link relating table in a database
  
  
  

Data Type

• Digit: a single numeric character 0 to 9
  
• Character: a single item, either alphabetic(A-Z, a-z), numeric(0-9), or special symbol
  
• Alphabetic: upper case and lower case letters
  
• Alphanumeric: upper case and lower case letters(A-Z, a-z) as well as numbers(0-9) and special characters
  
• Integer: any positive or negative whole number
  
• Floating point: to represent result of large calculation without loss of precision
  
• Binary: a numbering system consisting of 0's and 1's
  
• 
  
  Real Number: positive or negative, large or small, whole numbers or decimal numbers
  
  
  

Data Objects

• Tables
  
• Queries
  
• Reports
  
• Forms