example of dbms

8/11/2019 Example of DBMS

1/4

Examples

Search for the string 'SYSTEMS' appearing anywhere within thePROJNAME column in the PROJECT table.

SELECTPROJNAME FROMPROJECT

WHEREPROJECT.PROJNAME LIKE'%SYSTEMS%'

Search for a string with a first character of 'J' that is exactly two characters

long in the FIRSTNME column of the EMPLOYEE table. SELECTFIRSTNME FROMEMPLOYEE

WHEREEMPLOYEE.FIRSTNME LIKE'J_'

Search for a string of any length, with a first character of 'J', in theFIRSTNME column of the EMPLOYEE table.

SELECTFIRSTNME FROMEMPLOYEE

WHEREEMPLOYEE.FIRSTNME LIKE'J%'

In the CORP_SERVERS table, search for a string in the LA_SERVERS

column that matches the value in the CURRENT SERVER special register.

SELECTLA_SERVERS FROMCORP_SERVERS

WHERECORP_SERVERS.LA_SERVERS LIKECURRENT SERVER

Retrieve all strings that begin with the sequence of characters '%_\' in

column A of the table T. SELECTA FROMT WHERET.A LIKE

'\%\_\\%' ESCAPE'\'

Use the BLOB scalar function, to obtain a one byte escape character which

is compatible with the match and pattern data types (both BLOBs). SELECTCOLBLOB FROMTABLET

WHERECOLBLOB LIKE:pattern_var ESCAPEBLOB(X'OE')


2/4

Computer Motherboard InformationBy Mike Marcoe, eHow Contributor

The primary hardware component of any computer system is the motherboard. Every

other piece of computer hardware, from the keyboard, mouse, CPU and RAM toexpansion cards, all connect into the motherboard. Motherboards are also known bydifferent names, such as main board, printed circuit board (PCS) or systems board.Without the primary circuit system of the motherboard, one would have nocomputer.Have a question? Get an answer from online tech support now!

Read more :http://www.ehow.com/about_5202406_computer-motherboard-information.html

Basics

Motherboards are printed with circuits that are multiple layers thick, and are, therefore,

often difficult to see. Every motherboard is at least two or more layers thick. The printedwires are called traces, and they carry and transmit the data and commands between theCPU, Northbridge, RAM and other hardware devices. The motherboard also needs toconnect to the power supply in order to provide the proper power for the computer.Therefore, the motherboard and power supply must have matching connector slots.

Characteristics

There are three common related characteristics that help to define modernmotherboards. The first is form factor. Form factor is what designates the actual physicalsize of the motherboard, as well as the location of the ports on it, airflow and othercomponents. The second characteristic is the chipset, which defines the type of RAM andhow much RAM the computer will support, as well as the processor that is required forthe motherboard. The third characteristic includes the built-in components, whichdefine the basic function capabilities of the entire computer system.

Types

There are numerous types of motherboard form factors, according tohttp://www.computerhope.com/jargon/m/mothboar.htm. Each one comes withdifferent features and components. There are many popular motherboardmanufacturers, and depending on your computing needs, you can have a custommotherboard designed for you.

Chipsets

Chipsets on the motherboard determine the types of hardware, memory capacity andother external devices that the computer can support without adding expansion cards tothe computer. In general, modern computers are composed of two main chips, called theNorthbridge and the Southbridge.Northbridge chips do a lot of work on the motherboard; they require their own heat sinkand fan. The Northbridge assists the CPU in working with the RAM. On somemotherboards, the Northbridge actually provides communication with the video cardinstead of the memory, as the memory controller on those types of motherboards is builtdirectly into the CPU. The Northbridge is generally located under the fan on the

motherboard.The Southbridge handles expansion and mass-storage devices. Its main job is as a
https://now.ehow.com/tech?utm_source=eHow&utm_medium=intext&utm_term=Other+Computer+Networking&utm_content=intext1&utm_campaign=none&article_title=Computer+Motherboard+Informationhttps://now.ehow.com/tech?utm_source=eHow&utm_medium=intext&utm_term=Other+Computer+Networking&utm_content=intext1&utm_campaign=none&article_title=Computer+Motherboard+Informationhttps://now.ehow.com/tech?utm_source=eHow&utm_medium=intext&utm_term=Other+Computer+Networking&utm_content=intext1&utm_campaign=none&article_title=Computer+Motherboard+Informationhttp://www.ehow.com/about_5202406_computer-motherboard-information.htmlhttp://www.ehow.com/about_5202406_computer-motherboard-information.htmlhttp://www.ehow.com/about_5202406_computer-motherboard-information.htmlhttp://www.ehow.com/about_5202406_computer-motherboard-information.htmlhttps://now.ehow.com/tech?utm_source=eHow&utm_medium=intext&utm_term=Other+Computer+Networking&utm_content=intext1&utm_campaign=none&article_title=Computer+Motherboard+Information


3/4

controller hub on the hard drive.Modern motherboard manufacturers usually add a third primary chip called the SuperI/O chip, or system ROM chip. This chip provides part of the support for the systemBIOS at a basic level.

Additional Components

Other basic motherboard components include USB/FireWire ports, onboard soundchips, RAID (redundant array of independent devices) and audio, modem, andcommunications and networking riser slots.Some motherboards are designed to offer support for older technologies, such as floppydrives, modems, infrared connections and parallel ports; yet most modern chipsets onnewer motherboards do not support those older devices.

Read more :http://www.ehow.com/about_5202406_computer-motherboard-information.html

Different Types of Computer Monitors

Read more :http://www.ehow.com/facts_4969872_different-types-computer-monitors.html

CRT

CRT (Cathode Ray Tube) computer monitors were the most common computer monitors

until flat panel screens became affordable. Similar to older TVs, CRT monitors stilltypically have much better contrast ratios and viewing angles than other computermonitor alternatives.

LCD

LCD (Liquid Crystal Display) computer monitors save a lot of space and can even bemounted on walls. They provide a wide viewing angle and come in sizes typically rangingfrom 17-inches to 60-inches.

Plasma

Plasma computer monitors are less commonly used with computers due to their highoperating temperatures, high power consumption, and fixed resolution.

Touchscreen

Touchscreen computer monitors provide a new way of interacting with your computerwith a touch-sensitive screen. This allows users to interact directly with the applicationon screen without need for a mouse or keyboard.

OLED

OLED (Organic Light Emitting Display) computer monitors are much thinner and

brighter than LCD or Plasma screens. OLED monitors can also be placed on transparentsurfaces, such as glass, allowing the user to see through them when not active.
http://www.ehow.com/about_5202406_computer-motherboard-information.htmlhttp://www.ehow.com/about_5202406_computer-motherboard-information.htmlhttp://www.ehow.com/facts_4969872_different-types-computer-monitors.htmlhttp://www.ehow.com/facts_4969872_different-types-computer-monitors.htmlhttp://www.ehow.com/facts_4969872_different-types-computer-monitors.htmlhttp://www.ehow.com/facts_4969872_different-types-computer-monitors.htmlhttp://www.ehow.com/about_5202406_computer-motherboard-information.html


4/4

example of dbms

Documents