Here is the figure 1.5 use this to answer this question

1.6 Give an example of two related tables other than the example used in this book. Use the STUDENT and GRADE tables in Figure 1-5 as an example pattern for your tables. Name the tables and columns using the conventions in this book. 1.7 For the tables you created in Review Question 1.6, what are the primary keys of each table? Do you think that any of these primary keys could be surrogate keys? Are any of these primary keys composite keys? 1.8 Explain how the two tables you provided in Review Question 1.6 are related. Which table contains the foreign key, and what is the foreign key? 1.9 Show your two tables from Review Question 1.6 without the columns that represent the relationships. Explain how the value of your two tables is diminished without the relationships. The STUDENT table The CLASS table E STUDENT StudentNumber LastName - FirstName 1 Cooke Sam + 2 Lau Marcia 3 Harris Lou 4 Greene Grace * (New) Record: # 1 of 4 No Filter Search EmailAddress Sam.Cooke@Ouru.edu Marcia.Lau@Ouru.edu Lou.Harris@Ouru.edu Grace Greene@Ouru.edu + The GRADE table with foreign keys-now each grade is linked back to the STUDENT and CLASS tables E CLASS ClassNumber Section + + ClassName. 10 CHEM 101 20 CHEM 101 30 CHEM 101 40 ACCT 101 50 ACCT 101 Term 2014-Fall 2014-Fall 2015-Spring 2014-Fall 2015-Spring + + + ** Record: * 1 of 1 N No Filter Search 3 GRADE Student Number ClassNumijer Grade 1 2 3 3 4 4 10 40 20 30 40 50 3.7 3.5 3.7 3.1 3.0 3.5 0.0 4 FIGURE 1-5 The Key Database Characteristic: Related Tables Record: 1 of 6 No Filter Search