Please enable JavaScript.
Coggle requires JavaScript to display documents.
Databases (Components of a DB (Primary key (Unique Identifier (PK),…
Databases
Components of a DB
Record
table
form
report charachters
field
file
Primary key
Unique Identifier (PK
secondary key
Primary key from another table
Field name
Name of collum
Foreign key
Query
Search in DB to find result
Relationships
1 to 1
1 student 1 time table
1 to many
1 student many subjects
many to many
many sports to many students
Types of databases
Flat file
1 table
Relational
2 or more table
Query
Structured query language
FROM
Table name
WHERE
Criteria
ORDER BY
Order
SELECT
Field names
Datatypes
DATADICTIONARY
STORING ON A DB
MANUAL VS ELECTRONIC
Network
Hardware
Ethernet
Modem
Switch
Firewall
computer
router
bridge
printer
Raspbi
purpose of
girls school lab
hardware needed
cost
set-up
How to
Topologies
star
circle
hybrid
bus
Transmission protocol
parallel
serial
datapackets
Types of networks
Lan
Local Area Network
Wan
Wid area network
Cables
Ethernet
Crossover cable
Software
Linux
firewall
advantage/disadvantage
advantage
share resources
disadvantage
hacked/security
if topology cease = stops functioning
simplex transmission
1 way transmission
full duplex
2 way transmission/same time
Internet/Intranet
Digital Media
Screen design
Animation
hardware
element
full dupl