Chapter 10 Managing a Database

Database is a collection of data organized in a manner that allows access, retrieval, and use of that data.
Data is a collection of unprocessed item for example text , number , images , audio and video
Information is processed data

Database , Data and Information 

• Database software as we called a database management system (DBMS) it allow user to -create a computerized database                                                   -add,modify and delete data                                                         -sort and retrieve data                                                                   -create forms and reports from the                                                 data 
• Data integrity identifies the quality of the data 
• Garbage in ,garbage out(GIGO) points out the accuracy of a computer output depends on the accuracy of the input
• For information should have the following characteristic that is accurate , verifiable,timely,organized,accessible,useful andcost-effective

The Hierarchy of Data

• a character is one byte for the number , letters ,space punctuation marks or other symbols
• a field is a combination of one or more related characters for example field name , field size and data type
• common data types include text , numeric , AutoNumber , currency , date , memo , yes/no , hyperlink , object and attachment
• a record is a group of related fields-a primartkey uniquely identifies each record 
• a data file is a collection of related record

Maintaining Data

• File maintenance refers to the procedures that keep data current -adding records,modifying records and deleting records
• users add new records to a file when they obtain new data
• user modify a record to correct inaccurate data or update olad data
• Validation compares data with a set of rules or values to find out if the data is correct -alphabetic/numeric check ,range check , consistency check , completeness check , check digit and other checks

File processing Versus Databases 
File processing system

• each department has its own set of files 
• used for many years
• have data redundancy 
• isolate data

Database approach

• programs and users share data 
• reduce data redundancy
• improve data integrity 
• share data
• allows easier access
• reduces development time 
• can be more vulnerable

Database Management Systems

• a data dictionary contains data about each file in the database and each field in those files
• a DBMS provides several tools that allow user and programs to retrieve and maintain data in the database 
• a query language consists of simple , English -like statements that allow users to specify the data to display, print, or store
• query by example (QBE) provides a GUI to assist users with retrieving data
• A dorm is a window on the screen that provides areas for entering or modifying data in a database
• a report generator allows users to design a report on the screen , retrieve data into the report design , and then display or print the report
• A DMS provides means to ensure that only authorized users access data at permitted times - access privileges                                                                          -principle of least privilege
• A DMBS provides a variety of techniques to restore the database to a usable form in case it is damaged or destroyed         -backup          -log       -recovery utility     -continuous backup

Relational, object-Oriented, and multidimensional Databases

• a data model consists of rules and standards that define how the database organizes data
• A relational database stores data in tables that consist of row and columns .each row has a primary key and each column has a unique name
• 
  
• a relationship is a link within the data 
• structured query language (SQL) is a query language that allows users to manage, update,and retrieve data
• an object-oriented database (OODB) stores data in objects 
• examples of applications appropriate for an object-oriented database include multimedia database , groupware database , computer aided design database and hypertext database
• a multidimensional database can store data in more than two dimensions of data
• a data warehouse is a huge database that stores and manages the data required to analyze historical and current transactions

Wed Databases

• databases on the web allow you to

   -shop for products or                                                                              services

   -buy or sell stocks 

   -search for a job

   -make airline reservations

   -register for college classes

   -check semester grades

Database Administration 

• it is important have have a carefully designed database
• Database Analyst(DA)-decides on proper filed placement,defines data relationship ,and identifies users access privileges
• Database Administrator (DBA)-creates and maintains the data dictionary ,manages security , monitors performance and checks backup and recovery procedures
• Employees shold learn how to use the data in the database effectively-interact with database                                                                  -identify new data for the database                                              -maintain the database

Chapter 9 Network and Communications
Communications
Computer communications describes a process in whch two or more computers or devices transfer data, instructions,and information

(sending  device) - (communications channel)-( receiving device)

User of Computer Communications
user can send and receive wireless messages using wireless messaging services

1.Text messaging  (SMS) allows users to send and receive short text messages on a phone or other mobile device or computer

2.Picture messaging allows users to send pictures and sound files

3.Video messaging allows users to send short video clips

4.Wireless instant messaging allows wireless users to exchange real-time messages with one or more other users 

Wireless Internet access points allow people to connect wirelessly to the internet from home,work,school,and in many public locations

• 
  

A cybercafe is a location for people to use computer to access internet

A global positioning system (GPS) is a navigation system that consists of one or more earth-based receivers that accept and analyze signals sent by satellites in order tp determine the Gps receiver's geographic location

Groupware-helps groups of people work together on projects and                   share information over a network 
                  -Component of work group computing
                  -Major feature is a group scheduling
Voice mail-is allows someone to leave a voice message for one or                more people 
                  -computer in voice mail system converts an analog                       voice message into digital form
                  -a voice mailbox is a storage location on a hard disk int                he voice mail system
Many programs provide a means to collaborate, or work online ,with other users connected to a server
Collaboration software includes tools that enables users to share documents via online meeting and communicate with other connected users for example online meeting ,web conferences and document management systems
Web services enable programmers to create applications that communications with other remote computer over the Internal or on an internal business network 
A mashup is a web application that combines services from two or more sorces

Networks
A network is a collection of computers and devices connected together via communications devices and transmission media. Advantages of a network include: Facilitating communications, Sharing hardware and software, Transferring funds, Sharing data and information.
A local area network (LAN) is a network that connects computers and devices in a limited geographical area. A wireless LAN (WLAN) is a LAN that uses no physical wires. A metropolitan area network (MAN) connects LANs in a metropolitan area. A wide are network (WAN) is a network that covers a large geographical area.
The design of computers, devices, and media on a network is sometimes called the network architecture. P2P descirbes an Internet network on which users access each other's hard disks and exchange files directly over the Internet. A network topology refers to the layout of the computers and devices in a communications network. An intranet is an internal network that uses Internet technologies. An extranet allows customers or suppliers to access part of its intranet. 

Network Communications Standards
Ethernet is a network standard that specifies no computer controls when data can be transmitted. 
The token ring standard specifies that computers and  devices on the network share or pass a special (token). 
TCP/IP is a network standard that defines how messages are routed from one end of a network to another.
Wi-Fi identifies any network based on the 802.16 standard that facilitates wireless communication.
Sometimes referred to as wireless Ethernet.
Bluetooth defines how two Bluetooth devices use short-range radio waves to transmit data.
UWB (ultra-wideband) specifies how two UWB devices use short-range radio waves to communicate at high speeds.
IrDA transmits data wirelessly via infrared (IR) light waves.
RFID uses radio signals to communicate with a tag placed in or attached to an object, animal, or person.
Communications software consists of programs that: Helps users establish a connection to another computer or network. Manage the transmission of data, instructions, and information.

Communications Over the Telephone Network
The public switched telephone network (PSTN) is the worldwide telephone system.
A communicaation device is any type of hardware capable of transmitting data, instructionsm and information between a sending device and a receiving device.
A dial-up modem converts signals between analog and digital.
A digital modem sends and receives data and information to and from a digital line.
A wireless modem uses the cell phone network to connect to the Internet wirelessly from a notebook computer, a smart phone, or other mobile device.
A network card enables a computer or device to access a network.
Available in a variety of styles.
Wireless network cards often have an antenna.

Communications Devices
A wireless access point is a central communications device that allows computers and devices to transfer data wirelessly among themselves or to a wired network.
A router connects multiple computers or other routers together and transmits data to its correct destination on a network.
Many are protected by a hardware firewall.
A hub or switch connects several devices in a network together.

Home Networks
Home networks provide computers with the following capabilities: Connect to the Internet at the same times, Play multiplayer games, Connect game consoles to the Internet.

Communications Channel
the amount of data that can travel over a communications channel sometimes is called the bandwidth.
Latency is the time it takes a signal to travel from one location to another on a network.
Transmission media carries one or more signals.
Broadband media transmit multiple signals simultaneously.

Wireless Transmission Media
Cellular radio is a form of broadcast radio that is used widely for mobile communications.
Microwaves are radio waves that provide a high-speed signal transmission.
A communications satellite is a space station that receives microwave signals from an earth-based station, amplifies it, and broadcasts the signal over a wide area.

Chapter 8 Types of storage
Storage 
Storage its holds data,instructions and information for future use.
A storage medium is the physical material on which computer keeps data, instructions and information.

• Capacity is the number of bytes a storage medium can hold. For example kilobyte(KB) ,Megabyte (MB) ,Gigabyte (GB) ,Terabyte(TB) 
• a storage device is the computer hardware that records or retrieves items to and from storage media
• reading is the process of transferring items from a storage medium into memory
• writing is the process of transferring item from memory to a storage medium
• Access time measures the amount of time it takes a storage device to locate an item on a storage medium and the time required to deliver an item from memory to the processor

Hard disks

• a hard disk that contains one more inflexible , circular platters that use magnetic particles to store data , instructions , and information
• hard disk can store data by using longitudinal recording or perpendicular recording
• the characteristics of a hard disk include capacity ,platters,read/write heads ,cylinders , sectors and tracks ,revolutions per Minute ,transfer rate and access time
• Formatting is the process of diving the disk into tracks and sectors so that the operating system can store and locate data and information
• the hard disk arms move the read and write head which reads items and writes item in the drive
• A head crash occurs when a read and write head touches the surface of a platter 
• and always keep a backup of our hard disk
• RAIN is a group of two or more integrated hard disks
• A network attached storage (NAS) device is a server connected to a network with the sole purpose of providing storage 
• a disk controller consists of a special-purpose chip and electronic circuits that control the transfer of data,instructions,and information from a disk to and from the system bus and other components of the computer
• SATA , EIDE , SCSI , SAS

Flash Memory Storage

Flash memory chips are a type of solid state media and contain no moving parts

Solid state drives (SSDs)have several advantages over magnetic hard disk for example faster success time , faster transfer rates , generate less heat and consume less power and last longer 

• a memory card is a removable flash memory device that you insert and remove from a slot in a computer, mobile device , or card reader/writer for example compact flash (CF) ,secure digital (SD) , secure digital high capacity (SDHC) ,microSD , microSDHC ,picture card , memory stick and memory stick micri(M2)
• USB flash drives plug into a USB port on a computer or mobile device
• an Express Card module is a removable device that fits in an Express Card slot 
• Developed by the PCMCIA
• Commonly used in notebook computers

Cloud storage

cloud  storage is an Internet service that provides storage to computer users

Optical Discs

an optical disc consists of a flat,round,portable disc made of metal,plastic and lacquer that is written and read by a laser 

• it store software,data ,digital photos,movies and music
• it commonly store items in a single track that spirals from the center of the disc to the edge
• Track is divided into evenly sized sectors
• Archive disc-stores photo from online photo center                                         -resolution usually is 7200 pixels per photo                                 -cost is determined by the number of photos that                            being stored
• picture CD - single-session CD-ROM that stores digital                                   versions of film                                                                          -it uses a 1024 x 1536 resolution                                                  -many photo centers offer Picture CD dervices

Other types of storage 

• tape is a magnetically coated ribbon of pla stic capable of storing large amounts of data and information
• tape drive is reads and writes data and information on a tape
• a magnetic stripe card contains a magnetic sripe that stores information 
• a smart card stores data on a thin microprocessor embedded in the card
• Microfilm and microfiche store microscopic images of documents on a roll or sheet film

Chapter 7 Understanding Output

Output is a data that has been processed into a useful form. An output device is any type of hardware component that conveys information to one or more people. For example monitor , printers , speakers ,headphone ,earbuds ,data projectors , and etc.

Display Devices

• A display device is conveys text , graphics and video information
• for monitor is a packaged as separate peripheral
• Liquid crystal display (LCD) is a liquid compound to present information on a display device 
• the quality of an LCD depends primarily on resolution , response time ,brightness ,dot pitch and contrast ratio

Printers

• A printer is produces text and graphics on a physical medium 
• it printed information that we called a hard copy or printout
• A nonimpact printer forma characters and graphics on a piece of paper without actually striking the paper for example ink-jet printers , photo printers , laser printers , thermal printers , mobile printers , label and postage printers ,plotters and large-format printers.
• an ink-jet printer forms characters and graphics by spraying tiny drops of liquid ink onto a piece of paper 
• a photo printer produces color photo-lab-quality pictures
• laser is high-speed , high-quality , black and white and color
• a multifunction peripheral(MFP) is a single device that prints , scans , copies , and in some cases , faxes 
• a thermal printer generates images by pushing electrically heated pins against the heat-sensitive paper 
• a mobile printer is a small, lightweight , battery-powered printer that allows a  mobile user to print from a notebook computer , smart phone , or other mobile device
•  a label printer is a small printer that prints on adhesive-type material
• plotters are used to produce high-quality drawings
• large-format printers create photo-realistic quality color prints on a larger scale
• impact printers form characters and graphics on a piece of paper by striking a mechanism against an inked ribbon that physically contacts the paper 
• a dot-matrix printer produces printed images when tiny wire pins on a print head mechanism strike an inked ribbon 
• a line printer prints an entire line at a time

Speakers, headphones , and earbuds
An audio output device produces music , speech , or other sounds 
most of the computer users attach speakers to their computer to generate higher-quality sound for playing games,  listen to music and watching movie

• headphone are a type of speakers that cover or are placed outside of the ear
• earbuds that also called earphone rest inside the ear canal
• some of the speakers are specifically designed to play audio from a portable media player

voice output occurs when you hear a person's voice or when the computer talks to our through the speakers 

other output device are available for specific uses and applications.For example ,data projectors , interactive whiteboards , force-feedback game controllers and tactile output

• a data projector is a device that takes the text and images displaying on a computer screen and projects them on a larger screen 
• an interactive whiteboard is a touch-sensitive device, resembling a dry-erase board ,that displays the image on connected computer screen 
• force-feedback sends resistance to the device in response to actions of the user 
• tactile output provides the user with a physical response from the device

Chapter 6 Understanding lnput
Impute is any data and instructions entered into the memory of a computer

• the instructions that can be entered into the computer in the form of programs,commands and user responeses

An input device is any hardware component that allows users to enter data and instructions into a computer . For example, keyboard, mouse ,pen input and etc.

Keyboard

• keyboard is an input device that contains keys that uses press to enter data and instructions into a computer
• for the insertion point is a symbol on the screen that indicates where the next character you type will apper

Mouse

• A mouse is a pointing device that fits under the palm of our had comfortably
• some  of the mouse is wired or wireless

Other Pointing Devices

• for the other pointing devices trackball is a stationary pointing device with a ball on top or side
• beside that, a touchpad is a small , flat ,rectangular pointing device that is sensitive to pressure and motion
• a pointing stick is a pressure-sensitive pointing device shaped like a pencil eraser that is positioned between keys on a keyboard

 Pen Input

• with pen input that touch a stylus or digital pen on a slat surface to write , draw , or make selections

Game controllers

• video games and computer games use a game controller as the input device that directs movements and actions of on-screen objects
• for example gamepads , joysticks and wheels ,light guns , dance pads and motion-sensing controllers

Digital cameras

• a digital camera is a mobile device that allows users to take pictures and store them digitally into the memory card 

Voice Input 

• voice input is the process of entering input by speaking into a microphone
• voice recognition is the computer capability of distinguishing spoken words
• audio input is the process of entering any sound into the computer, for example  speech , music and sound effects
• music production software allows users to record compose, mix , and edit music and sound

Video input

• video input is the process of capturing full-motion images and storing them into a computer storage medium
• for example web cam is a typeof digital video camera that enables a use to capture video and  still images , send e-mail messages with video attachments , add live images to instant messages ,broadcast live images over the interm]net and make video telephone calls
• video conference is a meeting between two or more people by using internet

Scanners ad reading devices is also one of a input device

Chapter 5 
Types of Utility Programs and Operating Systems

System Software

• System software consists or the programs that control or maintain the operations of the computer and its device
• Operating systems and Utility Programs

Operating system 

• An operating system (OS) is a set of programs containing instructions that work together to coordinate all the activities among computer hardware resources

-start and shut sown a computer 
-provider a user interface 
-manage progams
-manage memory
-coordinate task
-establish an internet connection
-monitor performance
-provide utilities
-automatically update
-control a network 
-administer security

Operating system functions

• the process of starting or restarting a computer is called booting 

cold boot-is turning on a computer that has been powered off                            completely
Warm boot-is using the operating system to restart a computer

• it includes various shut down options

-sleep mode saves any open documents and programs to RAM, turn off all unneeded functions, and then places the computer in a low-power state
-hibernate saves any open documents and programs to a hard disk before removing power from the computer

• a user interface is to controls how to enter data and instructions and how information is displayed on the screen
• with a graphical user interface(GUI), you interact with menus and visual images
• with a command-line interface is a user uses the keyboard and to enter data and instructions to CPU

• How an operating system handles programs directly affects your productivity such as single user and multiuser ,single tasking and multitasking , Foreground and background,preemptive multitasking and multiprocessing
• Memory management optimizes the use of RAM 
• Virtual memory is a portion of a storage medium functioning as additional RAM
• A performance monitor is a program that assesses and reports information about various computer resources and devices
• 
• operating systems often provide users with the capability of 

-managing files 
-searching for files 
-viewing images 
-securing a computer
- uninstalling programs 
-cleaning up disks
-defragmenting disks
-diagnosing problems
-backing up files and disks 
-setting up screen savers

• Automatic update automatically provides updates to the program
• some of the operating systems are designed to work with a server on a network
• a network administrator uses the server operating system to add and remove users,computers and other devices or install software and administer network security
• a server operating system organizes and coordinates how multiple users access and share resources on a network
• a user name or user ID identifies a specific user
• a password is a private combination of characters associated with the user name

Stand-Alone Operating Systems 

• a stand-alone operating system is a complete operating system that work on a desktop computer or other computing device 
• for example window 7 , mac os x ,UNIX and Linux

Embedded Operating Systems

• An embedded operating system resides on a ROM chip on a mobile device or consumer electronic device
• for example window Embeddes CE, Windows phone 7,Palm OS,iPhone OS,BlackBerry,Google Android,Embedded Linux and Symbian OS

Utility Programs

• A utility program is a type of system software that allows a user to perform maintenance-type tasks
• A file manager is a utility that perform functions related to file ,it will displaying a list of files ,organizing files in folders,copying,renaming,deleting,moving,and sorting files and folders and creating shortcuts
• A search utility is a program that attempts to locate a file o your computer based on criteria our specify
• for an image viewer is to allow user to display,copy and print the contents of a graphics file
• uninstaller is to removes a program that associated entries in the system files
• A disk cleanup utility searches for and removes unnecessary files
• A disk defragmenter reorganizes the files and unused space on a computer'shard disk so that the operating system accesses data more quickly and programs run faster
• A backup untility is to copy files to another storage medium
• restore utility is to reverses the process and returns backed up files to their original form
• screem saver cause the display device's screen to show a moving image or blank screen if no activity occurs for a specified time 
• personal firewall is to detects and protects a computer form unauthorized intrusions
• media player is to view images and animation ,listen to audio, and watch video files on computer
• disc burning software is to copy the data recordable or rewritable optical disc
• personal computer maintenance utility identifies and fixes operating system problem, detects and repairs disk problem, and includes the capability ofimproving a computer performance 

Chapter 4

System Unit Components

System unit

• The system i\unit is a case that contains electronic computer used to process data
• The inside of the system unit on a desktop personal computer includes:

1. Drive bay(s)
2. power supply
3. Sound card
4. Video card
5. Processor
6. Memory

• The motherboard is the main circuit board of the system unit    -A computer chip contains integrated circuits 

Processor

• The processor,also called the central processing unit(CPU),interprets and carries out the basic instructions that operate a computer                                                                        -contain a control unit and an arithmetic logic unit (ALU)

1. Multi-core processor
2. Dual-core processor
3. Quad-coreprocessor

•  The control unit is the component of the processor that directs and coordinates most of the operations in the computer
• The arithmetic logic unit (ALU) performs arithmetic,comparison,and other operations
• For every instruction,a processor repeats a set of four basic operations,which comprise a machine cycle  
•  Most current personal computers support pipelining                   -Processor begins fetching a second instruction before it completes the machine cycle for the first instruction

The processor contains registers,that temporarily hold data and instructions
The system clock controls the timing of all computer operations

• The pace of the system clock is called the clock speed,and is measured in gigahertz(GHz)
• The leading manufacturers of personal computer processor chips are Intel and AMD
• Determine how you plan to use a new computer before slecting a aprocessor
• 
• A processor chip generates heat that could cause the chip to burn up
• Require additional cooling                                                              -Heat sinks                                                                                    -Liquid cooling technology
• Parallel processing uses multiple processors simultaneously to execute a single program or task                                                   -Massively parallel processing involves hundreds or thousands of processor                                      

Data representation

1.  Analog signals are continuous and vary in strength and quality
2. Digital signals are in one of two states:on or off

• Most computers are digital
• The binary system uses two unique digits(0 and 1)
• Bits and bytes

A computer circuit represents the 0 or the 1 electronically by the presence or absence of an electrical charge
             
Eight bits grouped together as a unit are called a byte.A byte represents a single character in the computer 

• ASCII (American Standard Code for Information Interchange) is the most widely used coding scheme to represent data

Memory

• Memory consists of electronic components that store instructions waiting to be executed by the processor,data needed by those instructions, and the result of processing the data 
• Stores three basic categories of item:

1. The operating system and other system software
2. Application programs
3. Data being processed and the resulting information

• Each location in memory has an address
• Memory size is measured in kilobytes (KB or K),megabytes (MB),gigabytes (GB),or terabytes (TB)
• The system unit contains two types of memory:

1. Volatile memory-Loses its contents when power is turned off                                -Example includes RAM
2. Nonvolatile memory-Does not lose contents when power is                                          removed                                                                                      -Examples include ROM,flash                                                        memory,and CMOS

• Three basic types of RAM chip exist:

1. Dynamic RAM (DRAM)
2. Static RAM (SRAM)
3. magnetoresistive RAM(MRAM)

• RAM chips usually reside on a memory module and are inserted into memory slots
• The amount of RAM necessary in a computer often depends on the types of software you plan to use
• Memory cache speeds the processes of the computer because it stores frequently used instructions and data
• Firmware-Read-only memory (ROM)refers to memory chips storing permanent data and instructions
• EEPROM can be erased- A PROM (programmable read-only memory)chip is a blank ROM chip that can written to permanently
• Flash memory can be erased electronically and rewritten           -CMOS technology provides high speeds and consumes little power
• Access time is the amount of time it takes the processor to read from the memory 

Expansion slots and Adapter Cards

•  An expansion slot is a socket on the motherboard that can hold an adapter card
• An adapter card enhances functions of a component of the system unit and/or provides connections to peripherals

• With Plug and Play, the computer automatically can configure adapter cards and other peripherals as you install them
• Removable flash memory -Memory cards,UUSB flash drives, and PCcards 

Ports and connectors

-A port is the point at which a peripheral attaches to or communicates with a system unit

-A connector joins a cable to aport

Buses

• Expansion slots connect to expansion buses
• Common types of expansion buses include

      -PCIbus

      -PCI Express bus 

      -Acclerated Graphics Port

      -USB and FireWirebus

      -PC Card bus

Bays

• A bay is an opening inside the system unit in which you can install additional equipment 

Power Supply

-the power supply conversts the wall outlet AC power into DC power 

-Some external peripherals have an Ac adapter, which is an external power supply