Section $2$: Designing a Database

For these questions, assume that you wish to create a relational database to facilitate the buying and selling of used textbooks for students on your campus. Determine the following:

In a relational database such as Microsoft Access, the structure consists of tables, records and fields, as well as a primary key. Explain how each of these functions. $[8$pts$]$

I Click to enter text

$2.$ The "Book Inventory" table lists every book for sale. Identify at least $4$ fields you need in your database to identify and categorize each of the books. $[2$pts$]$

Click to enter text

$3.$ What would be a good primary key to use for the "Book Inventory" table? $[2$pts$]$

Click to enter text

$4.$ Why would it be a good primary key? $[2$ pts$]$

Click to enter text

$5.$ The "Student Customers" table lists each student who buys a book. Identify at least $4$ fields you need to capture information about the customers $($students$)$ who are buying the books. $[2$pts$]$

$6.$ What would be the primary key of the "Customer" table? $[2$pts$]$

Click to enter text

$7.$ Why would it be a good primary key? $[2$pts$]$

Click to enter text