Designing Your Own Database
Suppose you wish to create a database to facilitate the buying and selling of used textbooks for students at your campus. Determine the following:
a. What fields do you need in your database for identifying and categorizing the books? What would be a good primary key to use for the "book inventory" table? Why would it be a good primary key?
b. What fields do you need to capture information about the customers (students) who are buying the books? What would be the primary key of the "customer" table? Why would it be a good primary key?
c. Design a table that tracks the selling transactions. What fields from the other two tables would need to be included in the "sales transaction" table? Justify your answer.