Basic SQL
6.1. How do the relations (tables) in SQL differ from the relations defined formally in Chapter 3? Discuss the other differences in terminology. Why does
SQL allow duplicate tuples in a table or in a query result?
6.2. List the data types that are allowed for SQL attributes.
6.3. How does SQL allow implementation of the entity integrity and referential
integrity constraints described in Chapter 3? What about referential triggered actions?
6.4. Describe the four clauses in the syntax of a simple SQL retrieval query. Show
what type of constructs can be specified in each of the clauses. Which are
required and which are optional?
