1. 
2. Give 5 informal queries and 5 updates that you would expect to apply to the database shown in Figure 1.2.
3. What is the difference between controlled and uncontrolled redundancy
4. Give 2 additional views that may be needed by other user groups for the database shown in Figure 1.2.
5. Give 5 examples of integrity constraints that you think should hold on the database shown in Figure 1.2.
6. What is the difference between a database schema and a database state?
7. What is the difference between logical data independence and physical data independence? Which one is harder to achieve, why?

8 Chapter 1 Databases and Database Users STUDENT Name Smith Student_number Class Major CS 17 1 Brown 8 2 CS COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Course_number CS1310 Credit_hours Department 4 CS 4 CS3320 MATH2410 CS MATH 3 Database CS3380 3 CS Semester Fall Fall Year 07 Instructor King 07 Anderson SECTION Section_identifier Course_number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 119 CS1310 135 CS3380 08 Knuth 08 Spring Fall Fall Fall 08 Chang Anderson Stone 08 GRADE_REPORT Student_number 17 Grade Section_identifier 112 B 17 119 8 85 A 8 92 A 8 102 B 8 135 A Figure 1.2 A database that stores student and course information. PREREQUISITE Course_number CS3380 CS3380 CS3320 Prerequisite_number CS3320 MATH2410 CS1310 8 Chapter 1 Databases and Database Users STUDENT Name Smith Student_number Class Major CS 17 1 Brown 8 2 CS COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Course_number CS1310 Credit_hours Department 4 CS 4 CS3320 MATH2410 CS MATH 3 Database CS3380 3 CS Semester Fall Fall Year 07 Instructor King 07 Anderson SECTION Section_identifier Course_number 85 MATH2410 92 CS1310 102 CS3320 112 MATH2410 119 CS1310 135 CS3380 08 Knuth 08 Spring Fall Fall Fall 08 Chang Anderson Stone 08 GRADE_REPORT Student_number 17 Grade Section_identifier 112 B 17 119 8 85 A 8 92 A 8 102 B 8 135 A Figure 1.2 A database that stores student and course information. PREREQUISITE Course_number CS3380 CS3380 CS3320 Prerequisite_number CS3320 MATH2410 CS1310