Examples of rows you'll find in each of these tables are as follows:$\backslash$table$[[$ca$\_$authors,name$],[$author$\_$id$,$Twain, Mark,$],[184,$Atherton, Gertrude,$],[379,$Orsi, Richard,$],[390,$Guti$$rrez$,$ Ram$$n$,],[419,,]]$

$\backslash$table$[[$ca$\_$book$\_$authors,$],[$boo

Answer the following questions using the information provided above. Do not write SQL$.$

$(1$ pt$)$ What is the area of Sacramento county?

$(1$ pt$)$ What city is the seat of Kern county?

$(1$ pt$)$ In what mountain range is Breckenridge Mountain?

$(1$ pt$)$ What are the titles of two books by Mark Twain in the database?

$(1$ pt$)$ Who are the two authors of the book Contested Eden: California Before the Gold Rush?

$(2$ pts$)$ Besides

$,$ what other field could serve as a primary key for the

ca$\_$counties table? Explain your thinking.

$(1$ pt$)$ Explain why

would not be a good field to select as the primary key for the

table. $($Make sure that your explanation is supported by the definition of a

primary key.$)$

$(2$ pts$)$ Identify two foreign key fields in the database. Provide the name of each field, and the

name of the table in which each field resides.

$(2$ pts$)$ What is the relationship between the ca$\_$mountain$\_$ranges and

ca$\_$mountain$\_$peaks tables? Explain your thinking.

$(2$ pts$)$ What would be a reasonable primary key for the

table? Explain your

thinking.

$(2$ pts$)$ Imagine that you have a mountain peak named after you in the Panamint Range, and this

is recorded in the Californiana database. Provide an example of what such a row might look like

in the

table.

$(1$ pt$)$ Suppose you've written a book about California, and this is recorded in the Californiana

database. Provide an example of what such a row might look like in the

table.

$(1$ pt$)$ Suppose the book you've written is titled Weird Sacramento, and this is recorded in the

Californiana database. Provide an example of what such a row might look like in the

table.

$(2$ pts$)$ What additional row would need to be added to the database to clearly indicate that you

are the author of the book Weird Sacramento? Show what the row would look like, and identify

the table in which it belongs.