I have 35 written questions and 5 SQL assignments. I will provide all three Query languages for the database and the ER Diagram. For the SQL assignments, you must provide both the SQL statement an

Review Questions 2


Please answer these questions in your own words:


1. What is a relational database?

2. What is an unnormalized relation?Is it a relation according to the definition of the word relation?

3. How is the term attribute used in the relational model? What is a more common name for attribute?

4. What is a primary key?What is the primary key for each table in the Colonial Adventure Tours database shown in the Colonial Tours ER Diagram file?

5. Describe the purpose of the UNION command in relational algebra.