Requirements Analysis
These describe what the user wants the system to do in simple terms.
What are End User Requirements?
This field type is used to store whole numbers such as age or quantity.
What is Number?
This SQL keyword is used to choose which columns to display.
What is SELECT?
When searching for text values in SQL, they must be enclosed in these.
What are quotes?
These describe what the system must do in detail using technical language.
What are Functional Requirements?
This field type is used for names, addresses, and other written information.
What is Text?
This keyword tells the database which table to search.
What is FROM?
This operator finds values strictly lower than a given number.
What is the less than (<) operator?
If a requirement says “The user needs to find all S4 pupils quickly,” it is focusing on this.
What is the user’s goal or need/End-User Requirement?
This field type is used to store dates such as birthdays.
What is Date?
This clause is used to filter records based on criteria.
What is WHERE?
This operator is used to find values greater than a specified number.
What is > (greater than)?
“The system will use WHERE price < 10.”
👉 This is this type of requirement.
What is a Functional Requirement?
This field type is used to store phone numbers.
What is text?
SQL keywords are often written in capital letters for this reason.
What is to make them stand out (improve readability)?
This operator is used when both conditions must be true.
What is AND?
Functional requirements are usually written for this audience.
Who are developers/programmers (or technical staff)?
This field type is best for storing true/false values.
What is Boolean (yes/no)?
This symbol is used to display all fields in a table.
What is * (asterisk)?
This operator broadens a search by matching at least one condition.
What is OR?