Why would it be a good primary key

Assignment Help Basic Computer Science

Reference no: EM131404747

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.

Reference no: EM131404747

Questions Cloud

Design the network and price its components : In the memo, estimate the costs of constructing a 60-person client/server network, including the costs of one server, cabling, desktop computers for the 50 new employees, and switches. Use resources such as dell.com and hp.com to design the networ..

How much each component of the new network will cost : Make sure to fully explain what equipment and cabling will be required and how much each component of the new network will cost.

Discuss about the post given below : Summary can be beneficial to you as a writer in many ways. You may want to summarize a chapter from a textbook so you can better understand it, or you may need to summarize an author's point of view to support your argument in a research paper. ..

Which two departments should be converted to wireless first : What precautions should the school take to help recover the computers in the event they are lost or stolen?

Why would it be a good primary key : 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.

Explain which method is better for the company being discuss : Explain, with the help of an example, how a company could use a variable costing system, as well as an absorption costing system. Explain which method is better for the company being discussed.

Explain why reported correlation values should be supported : Explain why reported correlation values should be supported with either a scatterplot or a description of the scatterplot.

Evaluate both bob and pharma argument : This is the only instance of poisoning from the affected XLT batch. Bob sues Pharma for Product Liability based on Strict Liability. Evaluate both Bob's and Pharma's argument for each element of the law. Include the result that you think will happ..

Suggest variance measures identified company can employ : Suggest at least two variance measures the identified company can employ in a balanced scorecard performance evaluation system, and examine how the company can use these variances to improve performance.

User Account

All Pages