Transmission Control Protocol (TCP)
Database Management Systems Networks
Dat•baseIpomCpu/tPrn ewuite fa otllccltsno rom auti th at •MTPWeb server – a computer dedicated to responding
sevicoerlonnleee otthoa ceom anu ncatonu.nicate and to requests for Web pages. User Datagram Protocol (UDP)
Database management system – a combination of software • Selec operation – to identify records in a table.
and data made up of the physical database, the database • • Projec operation – to produce a subset of the ng
engTCP that achieves higher transmission speeds at the cost a small number of nodes in a close geographic area.
Query – a request to retrieve data from database. •colRing topology – a LAN configuration in which all
• Pinge (a sr)–rany sed ts estl heticeeatacrtietor • nodes are connected in a closed loop.oncatenate rows
Schnetwoork. computer is active and reachable. re of data in a from two tables.
database. • •Other operations include the set operations: union,
• Trata taunef– ate gamntwai sh) –s tet reut ai th central node controls all message traffic.
Relpacichttatei croset frInt ene . lace to another on a •difBus topology – a LAN configuration in which all
the•etwoPort a numeric designation corresponding to a nodes share a common line.nd division.
particular highlevel protocol.that defines how data is
Table – a collection of database records. Select attribute list from tablelist where condition.a
Record (or object, or entity) – a collection of related fields networks, based on a bus topology.
that make up a single database entry.ttachments or on in Sele•t cWidearea network (WAN) – a network e returned.
wehisita.lient makes requests of a server and the server Fromconnecting two or more localarea networks. the
Fie•espoFirewall – a gateway machine and its software that query.
• File server – a computer dedicated to storing and Where clause restricts the data that is returned.n
Key – one of more fields of a database record that uniquely (*) – can be used in the select clause to denote that all
ide•tifiAccess control policy – a set of rules established by
Structured Query Language (SOL) – a comprehensive work attributes in the selected records should be returned.
communication are permitted and denied. Like operator performs some simple pattern matching
rel•tionHostname – a name made up of words separated by . on strings.
Entinfrastructure developed for a large city.r technique Order clause determines how the results of the query
for•desiInternet backbone – a set of highspeed networks et;
each hostname corresponds to a particular IP address. should be sorted.
ER •iagrIP address – an address made up of numeric values (%) matches any string
separated by dots that uniquely identifies a computer on Ex: Select Title from Movie where Rating = ‘PG’
Carthe Internet.ess to the Internet.of relationships that Ex: Select * from Movie where Rating = ‘R’ order by
may•exisPhone modem – a device that converts computer Title
There are 3 possible general cardinality relationships:
specifies a specific organization or group.gain. Insert statement adds a new record to a table.
•• Onetoonedomain (TLD) – the last section of a Ex: insert into Customer values (9876, ‘John Smith’,
d•maiOnetomanycifying the type o