1.3: Exchanging data
0.0 / 5
- Created by: Daniel_Sanders
- Created on: 04-03-16 11:17
Flat-file Database
All the data is stored in a single, two dimensional file.
1 of 55
Flat-file Database Terms
Rows = records, Columns = fields.
2 of 55
Relational Database
A relational database uses a DBMS to provide structure, increases data integrity, reduce incompatibility, and remove data dependence.
3 of 55
Relational Database Terms
Columns = attributes, Rows = tuples, Tables = relations.
4 of 55
Database Management System (DBMS)
A program to manage databases which allows uses to create, update, read, and delete data.
5 of 55
Data Manipulation Language (DML)
A system of syntax elements similar to a programming language used for inserting, updating, and deleting data in a database.
6 of 55
Primary Key
A unique attribute used to identify a tuple (it is customary to underline a primary key).
7 of 55
Foreign Key
A non-primary attribute in one table which is a primary key in another table and so links the two together.
8 of 55
Secondary Key
A different attribute that allows the data to be accessed in a different way.
9 of 55
Entity-relationship Diagram (E-R Diagram)
This is a diagrammatic means of showing a data model/database and illustrates relationships between entities in the database and attributes of each entity.
10 of 55
Entity
An object, person, event or thing about which data can be recorded.
11 of 55
Attribute
A property of an entity.
12 of 55
Relationship
An association between two entities.
13 of 55
Database Normalisation
A technique for designing databases which aims to minimise data duplication and maximise data integrity.
14 of 55
Stand Alone
A single computer not connected to any other computers/devices.
15 of 55
Network
Two or more computers connected to each other.
16 of 55
Workstation
A computer on a network.
17 of 55
Server
A computer dedicated to providing a service on a network.
18 of 55
Node
Refers to any device on a network.
19 of 55
Local Area Network (LAN)
A network using short-range communications hardware and can be anything from small houses to large offices.
20 of 55
Wide Area Network (WAN)
A network connecting devices over a large geographical area, e.g. the Internet.
21 of 55
Metropolitan Area Network (MAN)
A network covering a town or city.
22 of 55
Personal Area Network (PAN)
A personal network created between two devices (e.g. Bluetooth speaker and mobile phone).
23 of 55
Transfer Control Protocol (TCP)
This protocol ensures packages are transferred without errors and are reassembled at the receiving end as a TCP header is added.
24 of 55
Internet Protocol (IP)
This protocol defines how data is transferred across the internet.
25 of 55
TCP/IP
This protocol provides a real world implementation of the OSI model.
26 of 55
File Transfer Protocol (FTP)
This protocol defines how files are uploaded and downloaded over the internet.
27 of 55
Hypertext Transfer Protocol (HTTP)
This protocol transfers webpages.
28 of 55
Simple Mail Transfer Protocol (SMTP)
This protocol is used for sending e-mail.
29 of 55
Handshaking
The process of negotiating and agreeing on a protocol.
30 of 55
Open Systems Interconnection (OSI)
The OSI model is a theoretical framework for defining protocols in 7 layers, where control is passed from one layer to the next.
31 of 55
User Datagram Protocol (UDP)
A connectionless protocol where one program can send lots of packets to another and that would be the end of the relationship; useful for VOIP and online gaming.
32 of 55
Domain Name System (DNS)
This is a system for converting domain names (easier to remember) into their equivalent IP address.
33 of 55
DNS Server
This stores domain names and their corresponding IP address, and if one domain name server does not recognise an IP, it passes the request to another one.
34 of 55
Packet Switching
Messages are split into equal sized packets with each packet being labelled signifying its destination and order. The packets are sent along communication lines, and each node decides where to send the packets.
35 of 55
Circuit Switching
Messages are split into packets but a route is reserved before they are sent.
36 of 55
Network Interface Card (NIC)
This is used on LANs and works at the network layer of the TCP/IP stack which converts data to signals for transfer via a communication medium.
37 of 55
Unshielded Twisted Pair (UTP)
A cable with a short range which is easy to install but is susceptible to interference.
38 of 55
Shielded Twisted Pair (STP)
A UTP cable with less interference due to a foil layer, but is more expensive and harder to install.
39 of 55
Coaxial
A cable with little interference and a large range.
40 of 55
Fibre Optic
An expensive cable with a large range which cannot be tapped but cannot be bent round corners due to the refraction required for data transmission.
41 of 55
Repeater
This amplifies the signal when transmitting data over distances further than the medium allows.
42 of 55
Hub
This takes data transmitted by one node and transmits it to all other channels and is thus considered unintelligent.
43 of 55
Switch
This takes data transmitted by one node and retransmits it to the channel linking to the receiving node and as such they are intelligent devices and packet sniffing cannot occur.
44 of 55
Bridge
This provides connections between different networks.
45 of 55
Router
A way of connecting together LANs and WANs.
46 of 55
Modem
Stand for modulate-demodulate and provides analogue to digital signal conversion.
47 of 55
Firewall
Hardware or software which provides internet security by preventing unauthorised access by blocking traffic not coming through open ports.
48 of 55
Proxy Server
Allow shard access to an internet connection and can also provide additional features such as website filtering and data caching for regularly downloaded content.
49 of 55
Internet
The world's largest WAN which is a global network connection computers and other devices.
50 of 55
Client-server Network
A network where one or more servers manage the network, and most nodes are clients which must log on using network credentials to be able to user the network.
51 of 55
Peer-to-peer Network
A network where no computer has overall control and some computers may provide basic services, e.g. printing, but this is on an ad hoc basis.
52 of 55
Hypertext Markup Language (HTML)
HTML is a markup language using tags to describe elements of web documents.
53 of 55
Cascading Style Sheets (CSS)
CSS is a style language that describes the visual presentation of web documents.
54 of 55
Javascript (JS)
An object orientated computer programming language used to create interactive effects within web browsers.
55 of 55
Other cards in this set
Card 2
Front
Rows = records, Columns = fields.
Back
Flat-file Database Terms
Card 3
Front
A relational database uses a DBMS to provide structure, increases data integrity, reduce incompatibility, and remove data dependence.
Back
Card 4
Front
Columns = attributes, Rows = tuples, Tables = relations.
Back
Card 5
Front
A program to manage databases which allows uses to create, update, read, and delete data.
Back
Similar Computing resources:
0.0 / 5
0.0 / 5
0.0 / 5
0.0 / 5
0.0 / 5
5.0 / 5 based on 2 ratings
0.0 / 5
5.0 / 5 based on 1 rating
3.0 / 5 based on 4 ratings
0.0 / 5
Comments
No comments have yet been made