
2. The manager of the Sales Department is both a manager and a salesperson. How
could data about this manager be represented? (3 min)
3. With reference to the library scenario and Fig. 20.1, write table declarations for
Borrower, Adult and Junior. Use plausible data type declarations. (3 min)
8VHUGHÀQHGW\SHV8'7V
A language such as SQL99 provides a variety of built-in data types, such as CHAR,
NUMERIC, REAL, BOOLEAN, BLOB, CLOB, DATE, and TIME. Although built-
in data types may continue to be added to the language, it is not feasible to provide a
complete set of data types to cover the myriad applications for which databases are now
used. SQL99 ...