ISDD Notes lol N5 Flashcards
descending
largest-smallest/last-first; Z-A; 9-0
example of a web browser
internet explorer, Mozilla Firefox and google chrome
example of a compound primary key
Firstname Lastname
ways a virus can affect your computer (3)
deleting and altering files displaying unwanted messages and websites using up storage in your computer system
what do GUIs use? (4)
Windows Icons Menus Pointers
example of a search engine
google, yahoo!, Bing and ask.
Define: standalone
a computer that is not connected to any other computer system
Define: Online fraud/ identity theft
the act of deceiving someone to take advantage of them. catfishing as the person to buy goods
Define: solid state storage
devices that have no moving parts that are more robust
Define: linear navigation
screens are shown in a sequence, one after the other like a PowerPoint
name 4 validation checks
presence, restricted choice, length and range
Define: hierarchical navigation
there is a main page and all the topics are grouped
larger files take
longer time to download and display
example of restricted choice
U, PG, 12, 12A, 15, 18 only
pro and con of wireless
pro- no trailing wires con- less secure and more subject to interference
which storage device has the slowest read/write speed?
CD 7.2MB/s
[use, compressibility, lossy/lossless & size] .bmp
[use, compressibility, lossy/lossless & size] images, no, lossless, very large
Define: database
a structured set of data held in tables
2 5 8 19 34 is in what order
asc
examples of magnetic storage (2)
magnetic tape hard disc drive
what 2 things are illegal because of the computer misuse act
Unauthorised access like hacking. Unauthorised modification, changing data without permission or infecting a computer with a virus deliberately.
Define: client side scripting
processing is done on the user’s computer adding interactivity
Define: compound primary key
a primary key that may have 2 or more parts
databaSeS are good at?
Searching - for a particular record (maybe using AND, OR, NOT operators) Sorting - on a field (ascending or descending)
Define: virus
programs that have been written to copy their code into other programs, meaning they ‘spread’ by themselves
ROM stands for
read only memory
Define: data controller
the person or organisation that stores the data
what does the OS do (5)
provides the HCI to the user provides security keeps track of memory and filing reports errors controls input and output devices
.jpeg meaning
joint photographic experts group
Define: relational database
a database that has more than one table that are linked
the copyright - designs and patents act makes it illegal to (3)
make/run unauthorised copies of software use software without a licence when it requires one plagiarise peoples work
the communications act makes it illegal to: (2)
use other neighbour’s/company’s internet access without permission send offensive electronic messages
.png meaning
portable network graphic
Define: PDF
allows documents to be shared across different computer systems
ascending
smallest-largest/first-last; A-Z; 0-9
Define: search engine
websites that have indexed billions of pages to make it easier to find a specific website in an instant
Define: phishing
an attempt by someone to get you to enter personal information such as usernames, passwords, emails and bank account details
to reduce file size (audio/video)
lower number of samples/frames but quality will decrease too
Define: hacking
a person who gains unauthorised entry to computer systems
Example of ISDD: time field
03:45
pro and con of wired
pro- fast connection speeds con- wires must be installed
Define: Website
a collection of pages with hyperlinks connecting them
[use, compressibility, lossy/lossless & size] .gif
[use, compressibility, lossy/lossless & size] cartoons, logos, buttons; yes; lossless; small
exceptions to rights of data
police and other agencies can refuse access to data if there is a threat to national security
name the 3 types of connections:
wired optical wireless
What does it do: presence check
check data exists in a field - fields may not be left blank
What are the 3 kinds of storage device types?
built in external portable
built in -
internal hard drives
Define: information system
a computerised system which allows users to input and store data, then allows the data to be processed into useful information.
pros of relational(2)
no duplication or inconsistency
Expert User
Can type quickly and are familiar with keyboard commands and shortcuts.
HCI
Human Computer Interface
upload/download speed of cloud and local
cloud depends on internet connection and file sizes local should be instantaneous but may take longer from backing storage
utility programs or security suites features: (3/4/5)
anti-virus software backup storage disk defragmentation software updates data deletion encryption/decryption system clean-up security formatting
a field is a row or column?
column
z u t s q k is in what order
desc
Define: foreign key
a field, usually a primary key in another table used to form a link
price of using cloud and local
cloud can be expensive to store data on local has no cost
example of range check
drivers must be >25 and <70 to hire a car
Define: network
two or more computer systems connected to allow them to communicate and share information
Novice User
requires a HCI which allow less confident users to use the system. Usually uses a GUI.
what does R data mean?
data can be written once and only once
Define: record
a record contains all the data held for a particular subject (e.g. person).
graphic formats (4)
jpeg, bmp, gif, png
Define: external link
will link you to another website
audio formats (2)
wav, mp3
what does html do
processes and present text and graphics on a web page
[use, compressibility, lossy/lossless & size] .jpeg
[use, compressibility, lossy/lossless & size] images, yes, lossy, large