Why do database searches matter
- Help us when entering records (make data entry faster, reduce mistakes, and ensure consistency
What are the 2 different types of users that use information systems
- Ordinary users use searches to find things quickly (ex: filter emails)
- Advanced users use searches to answer business questions (ex: analytics)
What are the 4 main search functions
- Lookup
- Choices
- Filter
- Search
What is the Lookup function and how does it work
Links a record in Table B to a single record in Table A
1. Enter a value in Table A (foreign key)
2. System scans Table A (primary key side)
3. When finds match links them
What is the choices function
Drop down lists, used when adding a new record select predefined values
Values come from linked Airtable table
Drop down list must be synchronized with airtable source. If synced: choices match the linked table values. If not synced: drop down shows nothing or wrong values
= user friendly version of airtable lookup link (Airtable doesn’t allow filtering drop downs)
What is the Function filter
Base of most databases queries, restricts a databased on criteria
Keeps only records that match, ignores others
Always returns a table with the same columns but fewer rows
What is the difference between AND vs OR
AND= restrictive, applied to a different column
OR= permissive, multiple criteria applied to the same column
Always use parentheses when combining AND or OR (to many criteria’s, performance slows down)
the 2 ways of applying filters
- Filter by column (click head and filter by this filed)
- Filter from menu bar (click filter in toolbar)
What are examples of text field operators, numeric and date field
Text filed operators contains, is, empty
Numeric field operators: greater than, less than, equal
Date filed operators: before, after, is, within
What is the search function
Used in search boxes (websites, apps)
More flexible than filters because just type and returns a table with the same columns as the original but only rows where the string is found
input = a string of characters, it searched anywhere in the word
can’t guarantee referential integrity (unlike Lookup)
What is a form
edit or enter data into a system (name, email password log in) they let you create or update records easily
What are values
actual pieces of info stored in a tables cell. Field: age Value: 23
What are interfaces
face or way users interact with data
What is a record
one row in a table
What are attributes
A property of a record (column in a table)
What is Soft
no-code tool, to build apps and websites on top of airtable data. Like a user-friendly interface layer built on top of airtable
What is Airtable
spreadsheet + database
What are rules of Filters of Softr
- Airtable filters are persistent = carry over into Softr unless cleared
- Always clear Airtable filter before using Softer to avoid unwanted results
- Filters are displayed as Dropdowns or Tags (each are synced with Airtable– normal text filed cannot sync)
Filter vs search
Filter = restricts based on exact filed values
Search =. Scans across multiple fields
What is a responsive interface
has a unique web layout whose dimensions and content changes according to the size of the browser
Influences by width of the browser
Content can move dynamically and automatically rearranges itself according to available space for optimal interface on any device
What is an adaptive interface
Requires the design of several layouts adapted to the screen used
System detects the users screen size to select appropriate layout
ensures that content is displayed optimally on each type of device, without being resized or reorganized
Generally suggest designing for 6 resolutions
What are cybersecurity challenges
Constant concern
cybersecurity the concern should be kept in mind throughout the cycle
Joint Responsibility
everyone is responsible, everyone has a role to play
Links in the chain responsibility
Human element (individual, data user, employees) can be both a weak and strong link in organization (ex: password is password (weak link in the chain, the strong bridge will break even if only one part is weaker)
(strength of the chain is dependant in the weakest link)
Counterbalancing these challenges: cyber hygiene
Set of regular practices and habits that individuals and or organizations adopt to maintain the health and safety of their systems and data
What are some of cybersecurities best practise (things you should do)
- Update software and operating systems regularly
- Use and manage passwords appropriately
- Regularly back up important data
- Use up-to-date anti-virus and anti-malware software
- Monitor and filter traffic on the organizations network
- Navigate the web and email links safely
- Continuous monitoring and training on emerging threats
