CP363 Lecture Notes - Lecture 15: Terminal And Nonterminal Symbols, Pattern Matching, Reserved Word
Document Summary
% replaces an arbitrary number of zero or more characters. Where (salary between 30000 and 40000) and dno = 5; Addition (+), subtraction (-), multiplication (*), and division (/) may be included as a part of select. Query 13, show the resulting salaries if every employee working on the productx" project is given a 10 percent raise. Select e. fname, e. lname, 1. 1*e. salary as increased_sal from. Employee as e, works_on as w, project as p where e. ssn=w, Keyword desc to see result in descending order of values. Keyword asc to specify ascending order explicitly. Typically placed at the end of the query. Order by d. dname desc, e. lname asc, e. fname asc. Sort by descending order, then within every department sort (from database ii) Bnf (backus naur form)/ ebnf (extended/enhanced) employees by ascending order. Formal notation to describe the syntax of a given (programming) language. Not a leaf, must be further defined/explained. Fapp (for all practical purposes), bnf notation is highly recursive.