1. A query language is a language in which a user requests information from a database. These are typically higher-level than programming languages.They may be one of:
- Procedural, where the user instructs the system to perform a sequence of operations on the database. This will compute the desired information.
- Nonprocedural, where the user speci es the information desired without giving a procedure for ob-taining the information.
2. A complete query language also contains facilities to insert and delete tuples as well as to modify parts of existing tuples.
| bname | loan# | cname | amount |
|
Downtown Lougheed Mall SFU |
17 23 15 |
Jones Smith Hayes |
1000 2000 1500 |
| bname | bname | bcity |
|
Downtown Lougheed Mall SFU |
9,000,000 21,000,000 17,000,000 |
Vancouver Burnaby Burnaby |
Figure 3.3: The borrow and branch relations.