ISDD Notes lol N5 Flashcards
1
Q
descending
A
largest-smallest/last-first; Z-A; 9-0
2
Q
example of a web browser
A
internet explorer, Mozilla Firefox and google chrome
3
Q
example of a compound primary key
A
Firstname Lastname
4
Q
ways a virus can affect your computer (3)
A
deleting and altering files displaying unwanted messages and websites using up storage in your computer system
5
Q
what do GUIs use? (4)
A
Windows Icons Menus Pointers
6
Q
example of a search engine
A
google, yahoo!, Bing and ask.
7
Q
Define: standalone
A
a computer that is not connected to any other computer system
8
Q
Define: Online fraud/ identity theft
A
the act of deceiving someone to take advantage of them. catfishing as the person to buy goods
9
Q
Define: solid state storage
A
devices that have no moving parts that are more robust
10
Q
Define: linear navigation
A
screens are shown in a sequence, one after the other like a PowerPoint
11
Q
name 4 validation checks
A
presence, restricted choice, length and range
12
Q
Define: hierarchical navigation
A
there is a main page and all the topics are grouped
13
Q
larger files take
A
longer time to download and display
14
Q
example of restricted choice
A
U, PG, 12, 12A, 15, 18 only
15
Q
pro and con of wireless
A
pro- no trailing wires con- less secure and more subject to interference
16
Q
which storage device has the slowest read/write speed?
A
CD 7.2MB/s
17
Q
[use, compressibility, lossy/lossless & size] .bmp
A
[use, compressibility, lossy/lossless & size] images, no, lossless, very large
18
Q
Define: database
A
a structured set of data held in tables
19
Q
2 5 8 19 34 is in what order
A
asc
20
Q
examples of magnetic storage (2)
A
magnetic tape hard disc drive
21
Q
what 2 things are illegal because of the computer misuse act
A
Unauthorised access like hacking. Unauthorised modification, changing data without permission or infecting a computer with a virus deliberately.
22
Q
Define: client side scripting
A
processing is done on the user’s computer adding interactivity
23
Q
Define: compound primary key
A
a primary key that may have 2 or more parts
24
Q
databaSeS are good at?
A
Searching - for a particular record (maybe using AND, OR, NOT operators) Sorting - on a field (ascending or descending)
25
Define: virus
programs that have been written to copy their code into other programs, meaning they 'spread' by themselves
26
ROM stands for
read only memory
27
Define: data controller
the person or organisation that stores the data
28
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
29
.jpeg meaning
joint photographic experts group
30
Define: relational database
a database that has more than one table that are linked
31
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
32
the communications act makes it illegal to: (2)
use other neighbour's/company's internet access without permission send offensive electronic messages
33
.png meaning
portable network graphic
34
Define: PDF
allows documents to be shared across different computer systems
35
ascending
smallest-largest/first-last; A-Z; 0-9
36
Define: search engine
websites that have indexed billions of pages to make it easier to find a specific website in an instant
37
Define: phishing
an attempt by someone to get you to enter personal information such as usernames, passwords, emails and bank account details
38
to reduce file size (audio/video)
lower number of samples/frames but quality will decrease too
39
Define: hacking
a person who gains unauthorised entry to computer systems
40
Example of ISDD: time field
03:45
41
pro and con of wired
pro- fast connection speeds con- wires must be installed
42
Define: Website
a collection of pages with hyperlinks connecting them
43
[use, compressibility, lossy/lossless & size] .gif
[use, compressibility, lossy/lossless & size] cartoons, logos, buttons; yes; lossless; small
44
exceptions to rights of data
police and other agencies can refuse access to data if there is a threat to national security
45
name the 3 types of connections:
wired optical wireless
46
What does it do: presence check
check data exists in a field - fields may not be left blank
47
What are the 3 kinds of storage device types?
built in external portable
48
built in -
internal hard drives
49
Define: information system
a computerised system which allows users to input and store data, then allows the data to be processed into useful information.
50
pros of relational(2)
no duplication or inconsistency
51
Expert User
Can type quickly and are familiar with keyboard commands and shortcuts.
52
HCI
Human Computer Interface
53
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
54
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
55
a field is a row or column?
column
56
z u t s q k is in what order
desc
57
Define: foreign key
a field, usually a primary key in another table used to form a link
58
price of using cloud and local
cloud can be expensive to store data on local has no cost
59
example of range check
drivers must be \>25 and \<70 to hire a car
60
Define: network
two or more computer systems connected to allow them to communicate and share information
61
Novice User
requires a HCI which allow less confident users to use the system. Usually uses a GUI.
62
what does R data mean?
data can be written once and only once
63
Define: record
a record contains all the data held for a particular subject (e.g. person).
64
graphic formats (4)
jpeg, bmp, gif, png
65
Define: external link
will link you to another website
66
audio formats (2)
wav, mp3
67
what does html do
processes and present text and graphics on a web page
68
[use, compressibility, lossy/lossless & size] .jpeg
[use, compressibility, lossy/lossless & size] images, yes, lossy, large
69
Pros of information systems (3)
saves using paper - saves money and space quicker and easier to search and sort data than going through paper sheets. reports are easy and quick to prepare and can be easily tailored to the users needs
70
www
world wide web
71
Define: surrogate primary key
a key that has been made up for each record
72
example of presence check
primary key
73
portable -
flash drives and CDs
74
which storage device stores the most?
solid state hard disc 512 GB / (magnetic hard disc 4TB)
75
storage devices each have different (4)
Capacity Accessibility Portability Speed of access
76
pro and con of optical
pro- high speed connection con- expensive
77
Health and Safety at Work Act means employers must: (6)
provide regular eye tests for staff who work on systems provide suitable lighting provide adjustable seating with posture support provide equipment like adjustable screens and ergonomic devices to reduce the chance of repetitive strain injury provide regular breaks tidy wires away to prevent injury
78
examples of optical storage (3)
CDs, DVDs, Blu-ray
79
Define: optical storage
makes use of a laser to shine and reflect light to read data stored
80
how do you test the user interface design? (web, 4)
if it matches specifications check for spelling errors scroll, audio/video, buttons work consistency
81
html means
hyper text mark-up language
82
Define: data subject
the person who the data is stored about
83
Define: field
an item of data for a record (e.g. name, address).
84
.pdf meaning
portable document format
85
Define: cloud storage + its accessibility
storage that can be uploaded to a web server. can be accessed as long as you have internet. PORTABLE
86
What does it do: restricted choice
choose from a list
87
to reduce carbon footprint (3)
use energy saving equipment put documents online rather than printing and email instead of letters recycling old unwanted computers
88
Define: lossless compression
no data is lost and original can be restored
89
each page on a website has its own
URL
90
security risk! data can be: (5)
corrupted, lost, deleted, hacked, damaged
91
name 5 tags from html
![]() there are more
92
Define: server side scripting
processing is done on the web server and sends page to user
93
Define: web browser
a software application used to navigate the www letting you retrieve and view information
94
Define: DOS attacks
Denial of Service attacks are where the attacker creates a program to flood the server with many requests for data from websites. this means genuine visitors cannot access it and as a consequence, companies can lose a lot of money.
95
a d g j p t y is in what order
asc
96
the more processors on the chip (core) the -
more powerful the computer and the more tasks it can complete at once
97
Define: file
a collection of related records
98
external -
large capacity network drives
99
[use, compressibility, lossy/lossless & size] .png
[use, compressibility, lossy/lossless & size] web images, yes, lossless, medium
100
link field can link to? (3)
to another file, email or web address
101
name 2/3 output devices
monitor speaker printer projector plotter
102
.RTF
rich text format - supports some formatting such as bold and underline; can also include images
103
Define: trojan
pretends to be a useful program but is secretly performing another function like monitoring your activity
104
Define: hyperlinks
allow you to link to other pages
105
Example of ISDD: calculated field
total = cost1 + cost2
106
Define: spyware
programs that secretly record what you do on your computer. usually used to get passwords and bank details
107
resolution =
spacing of pixels, measured in dpi
108
name 3/4 input devices
keyboard mouse track pad graphics tablet webcam microphone scanner
109
frequency of backups cloud and local
cloud will regularly back up meaning you dont have to save it yourself local means you are responsible for backup copies required
110
Define: P2P
a peer to peer network is where all the connected computers are of equal status and connect with all the other computers in a ring
111
Define: Update error
if there is more than one record with the same address and it needs updated - therefore all records (with the same address) need updated
112
example of a surrogate primary key
SQA number
113
Define: Deletion error
deleting a record may remove more data than expected
114
Example of ISDD: date field
6/03/2018
115
energy use measures to use less energy for companies: (3)
computer systems should be turned off when not in use low energy 'green machines' should be used when possible power saving modes should be used to cut down on electricity
116
disposal measures of IT equipment (3)
old electronic equipment should be disposed of properly companies need to erase sensitive information on equipment before disposal companies who make or sell equipment must provide ways for their customers to dispose of the equipment
117
Example of ISDD: boolean field
true/false yes/no
118
a firewall controls -
incoming and outgoing traffic and checks if it should be allowed through or not.
119
name 2 devices that are both input and output
touchscreen interactive white board games controller haptic glove
120
how do you test linking and navigation? (web, 3)
making sure there aren't broken links transitions are smooth hyperlinks work correctly
121
sharing resources in p2p and client server
client: all clients access the same p2p: each workstation has its own resources
122
What does it do: length check
checks how many characters are needed or are allowed in a field
123
data users must (5)
have the subjects agree to the data used it must be for the stated purpose Secure the data from being hacked Accurate - check it is and up to date Delete the data when it is no longer needed
124
Define: LAN
Local Area Network where the network exists in a single building or organisation
125
video formats (2)
mp4, avi
126
as # of samples/frames increase
quality increases; file size increases
127
name all 6 storage devices
magnetic hard disc USB DVD CD solid state hard disc memory card
128
RW stands for
rewritable
129
GUIs
graphical user interfaces
130
name 5 ISDD field types
any 5 from: text number(real or integer) date/time graphic object (OLE) calculated link boolean
131
Example of ISDD: number field
INTEGER(WHOLE): 1,67,4324 REAL(DECIMAL): 1.23, 658.232
132
cons of flat file(2)
when data is changed it may become inconsistent and duplicated in some cases.
133
doubling resolution
makes the file size quadruple
134
.bmp meaning
bitmap
135
Define: GUIs
make it easier for users to see software and access information
136
Define: lossy compression
data is lost and cannot be restored
137
the data subject has the right to (3)
see the data held on them have it correct if incorrect be awarded compensation if they have suffered as a result of wrong data
138
a relational database uses what to link tables
foreign keys
139
Define: local storage + its accessibility
storage that is used on the computer system you are using. the files are stored on the hard drive of that computer system and can only be accessed on it. MAY BE PORTABLE DEPENDING ON STORAGE DEVICE
140
Define: internal link
will link you to a page on the same website
141
good ISDD design avoids (3)
modification errors (insertion errors, update errors deletion errors)
142
What does it do: range check
checks data is within limits
143
what do scripting languages do (when implemented)
they tailor the system to the specific need of users and add functionality
144
which storage device has the fastest read/write speed?
magnetic hard disc 140MB/s
145
Define: Insertion error
when there is more than one copy of a record due to error
146
a good user interface considers these: (6)
Selection Consistency Readability Interactivity Navigation Visual layout
147
Define: flat file database
a database with a single table
148
networks allow us to (3)
communicate share hardware and software
149
why do we compress files?
less backing storage is needed it is faster to download from the internet
150
file size can be reduced by (3)
decreasing resolution (dpi) decreasing colour depth using compression
151
what is stored in ROM
programs like the operating system
152
Pro of biometrics (2)
avoids having to remember passwords hard to forge
153
examples of solid state storage (3)
USBs, memory cards, solid state hard drives
154
Example of ISDD: text field
text, symbols, numbers (anything you can type)
155
Define: URL
the uniform resource locator is the location of the page
156
Define: magnetic storage
uses magnetisable coating with dots on the surface is readable by small electromagnets.
157
Define: worms
copy themselves over and over again using all the storage space available
158
900 87 76 25 23 12 is in what order
desc
159
Define: client server
the server provides data and files for all the computers
160
Define: data users
the people who use the data
161
R stands for
recordable
162
sound/video is stored as
a number of samples/frames played one after the other
163
a record is a row or column?
row
164
.gif meaning
graphic interchange format
165
security in p2p and client server
client: usernames and passwords required to login p2p: difficult to manage and individual usernames and passwords for each system.
166
Define: SSL protocol
Secure sockets layer protocol is a method of creating encrypted connections for sending personal data.
167
the data controller must (3)
register with the data protection commissioner apply for permission to store the data state what they want to keep, the purpose of it and who is accessing it.
168
.txt
unformatted text - transferable and many devices recognise it
169
Define: keylogging
all the keys you press are recorded and sent back to the programmer
170
which storage device stores the least?
CD 700MB / (magnetic hard disc 500 MB)
171
Define: primary key
identifies one unique record
