Assignment : 1
Class : BESE 2K23
Subject: CS220 Database Systems
Submission Date: Monday 7-10-2024 12:00 pm
Instructions:
1. It is an individual Assignment.
2. It is a handwritten Assignment.
Structure Query Language has been supported with many built-in functions. These functions facilitate
the developers for efficient query designing and retrieving data as per specific requirement to build
required reports.
Tasks: Consider the given list of functions from different categories, analyze their working and usage by
designing and implementing Test-Classes (Upper boundary, Random, Lower boundary). Express the
working of these functions with solution against each test-class (min three cases of each function).
String Function Number Function Date Function
ASCII AVG ADDDATE
CHAR_LENGTH CEIL ADDTIME
CHARACTER_LENGTH CEILING CURDATE
CONCAT COUNT CURRENT_DATE
CONCAT_WS DIV CURRENT_TIME
FIELD EXP CURRENT_TIMESTAMP
FIND_IN_SET FLOOR CURTIME
FORMAT GREATEST DATE
INSERT LEAST DATEDIFF
INSTR MAX DATE_ADD
LCASE MIN DATE_FORMAT
LEFT MOD DATE_SUB
LENGTH POW DAY
LOCATE POWER HOUR
LOWER RAND MINUTE
LPAD ROUND MONTH
LTRIM SIGN MONTHNAME
MID SQRT STR_TO_DATE
POSITION SUM SUBDATE
REPEAT TRUNCATE SYSDATE
REPLACE TIME_FORMAT
REVERSE TIMEDIFF
RIGHT TIMESTAMP
RPAD TO_DAYS
RTRIM WEEK
SPACE WEEKOFYEAR
STRCMP YEAR
SUBSTR YEARWEEK
SUBSTRING
SUBSTRING_INDEX
TRIM
UCASE
UPPER
