DATABASES
Key to the data city
CSEC IT
DATA SECURITY?
CSEC IT 2
A QUICK CAPE NOTE
Data warehouses
Data Marts
CSEC IT 3
WHAT YOU SHOULD ALREADY KNOW
S I M P L E D ATA B A S E T E R M S
D ATA B A S E O B J E C T S
FIELD – one item which represents
1. TABLES
one piece of information in a
record 2. QUERIES
RECORD – a row or a set of related 3. FORMS
fields which provide whose 4. REPORTS
combination represent information
on a particular person or thing
CSEC IT 4
EXAM TIP
KNOW THE
CONTENT
CSEC IT
WHAT YOU SHOULD ALREADY KNOW
CSEC IT 6
What’s missing????
CSEC IT 7
LOOK AT THIS TABLE
StID First Name Address DOB
2201918 Mary-Kate Olsen 3/23/2007
2201318 Jackie Chan 3/11/2008
CSEC IT 8
THE PHONE!!
SUBTITLE GOES HERE
CSEC IT 9
CSEC IT
CSEC IT 11
Fingerprints
Voice Timbre
CSEC IT 12
Today’s objects
CSEC IT 13
STUDENT TABLE
CSEC IT 14
QUICK QUESTION:
•What would happen if a the letters
HTR12342 were entered for a
students Identification?
StID First Name Address DOB
HTR12342 Mary-Kate Olsen 3/23/2007
2201318 Jackie Chan 3/11/2008
CSEC IT
INFORMATION PROCESSING
•1. Is the data valid?
•2. Has the data verified?
StID First Name Address DOB
HTR12342 Mary-Kate Olsen 3/23/2007
2201318 Jackie Chan 3/11/2008
CSEC IT
PRACTICE TIME
Objectives
• Types of Queries
• Simple Select Queries
• Calculated fields
CSEC IT 17
TYPES OF QUERIES - ACCESS
SELECT – get information from existing tables
APPEND – add information to a table
UPDATE – make changes to specific fields in a table
DELETE – re m o ve s re co rd s f ro m a ta b l e
CSEC IT
WORKING WITH QUERIES
• SELECT QUERIES
• Simple criterion examples
• Like Keyword
• Calculated field
CSEC IT 19
THE FIRST QUERY
First name and Date of
Birth of ALL Students
whose first name start
with the letter “J”
CSEC IT 20
THE FIRST QUERY
Ta b l e b e i n g u s e d Query Grid
• L i ke “J * ”
• WILDCARD
CSEC IT 21
CRITERION USING A DATE – FIND THE PERSON
BORN AFTER SEPTEMBER 1 ST, 2007
criterion Dissecting the query:
• DOB > #9/1/2007#
• Note the number
signs (hashtags)
CSEC IT 22
CALCULATED QUERY –FEES OWED
CSEC IT 23
CALCULATED QUERY – OWING
OWING: 5000 – [Fee Paid]
CSEC IT 24
WHAT DID WE REVIEW?
• Database: Segues
• Fields
• Data and Internet Security
• Data types
• Primary Keys • Mobile Networks
• Types of Queries • IP Address
• SELECT Queries • Data Va lidation a nd
• The Like Keyword Verification
• Wildcards (*)
• Date criterion
• Calculated field CSEC IT 25
“PROGRAMMING??
BAAH, DEBUG!!”
CSEC IT 26
QUICK QUESTION:
This program should display whether
students of 5L receive iPhone 11s, for
attaining only ones and twos in their
subjects on the upcoming CSEC
examination.
CSEC IT
QUICK QUESTION:
This program should display whether
students of 5L receive iPhone 11s, for
attaining eight (8) or more grade ones
in the upcoming CSEC examination.
CSEC IT
MY BREAKDOWN
What I need to know to start
• The amount of grade ones
• Maybe the student’s name
Rule:
• 8 or more subjects – get iPhone
CSEC IT
POP QUIZ
Name five tools used in problem
solving to dissect a problem and arrive
at a solution.
#tvjschoolsnotout
CSEC IT
Times up!!!
IPO Chart
Truth Tables
Pseudocodes
Flowcharts
Trace Tables
CSEC IT 31
IPO Chart
Input Processing Output
StudentName GradesOnes >= 8
(condition in IF
iPhone recipient
GradeOnes statement; you
should write message (or Not)
everything out)
CSEC IT 32
Truth Table
8 or more subjects – get iPhone
GradeOnes >= 8 Get iPhone
No No
Yes Yes
CSEC IT 33
Truth Table
8 or more subjects – get iPhone
GradeOnes >= 8? Good behaviour? Get iPhone
No No No
No Yes No
Yes No No
Yes Yes Yes
CSEC IT 34
PSEUDOCODE ---- AAAAHHHH!!!!!!!!
- Represents the solution to an algorithm
- Uses Mathematical operators and symbols
- Uses Logical operators and symbols
- Uses English language
CSEC IT
Solution: One Student
START
Initialization
StudentName = “AAAAA”
GradeOnes = 0
PRINT “Please enter name of student and the number of grade User Prompt
ones attained”
READ StudentName, GradeOnes Input statements
IF GradeOnes >= 8 THEN
IF statement begins
PRINT StudentName, “ gets iPhone”
ELSE
PRINT StudentName, “ does not get and iPhone” Whitespaces
ENDIF End of IF statement
STOP
CSEC IT 36
POP QUIZ
This program should display whether
students of 5L receive iPhone 11s, for
attaining only ones and twos in all
their subjects on their upcoming CSEC
examination.
#tvjschoolsnotout
CSEC IT
START
Solution:
StudentName = “AAAAA” undetermined
GradeOnes = 0
Number of
REPEAT Student
PRINT “Please enter name of student and the number of grade ones
attained. Enter -1 for grade ones or the word ‘end’ for the student’s name”
READ StudentName, GradeOnes
IF GradeOnes >= 8 THEN
PRINT StudentName, “ gets iPhone”
ELSE
PRINT StudentName, “ does not get and iPhone”
ENDIF
UNTIL StudentName = “end” OR GradeOnes = -1
CSEC IT 38
THANK YOU
DOWNLOAD THIS
PRESENTATION
CSEC IT
DOWNLOAD THIS PRESENTATION
CSEC IT
