Relational database schema for library database

Assignment Help Business Economics
Reference no: EM131399371

Relational Database Schema for a Library Database:

  • BOOK(BKID, BK_TITLE, BK_LIST_PRICE, PBID)
  • PUBLISHER(PBID, PB_NAME, PB_STREET, PB_ZIPCODE, PB_PHONE)
  • AUTHOR(AUID, AU_NAME, AU_DOB)
  • LIBRARY_BRANCH(LBID, LB_NAME, LB_STREET, LB_ZIPCODE)
  • BORROWER(CRID, CR_NAME, CR_DOB, CR_STREET, CR_ ZIPCODE)
  • ZIPCODE(ZIPCODE, CITY, STATE)
  • BOOK_COPIES(BKID, LBID, NO_OF_COPIES)
  • BOOK_AUTHORS(BKID, AUID)
  • BOOK_LOANS(BK_ID, LB_ID, CR_ID, DATE_OUT, DUE_DATE)

For each query below, write the Relational Algebra statement(s):

List the AU_Name, AU_DOB,BK_Title, & BK_List_Price for books and authors where the Author was born after January 15, 1976 and the book's BK_List_Price was more than $60.00. List the AU_Name and AU_DOB for each Author born after January 15, 1929 who has never written a book whose BK_List_Price was more than $60.00. List the AU_Name and AU_DOB for each Author born after January 15, 1929 and all of whose books have BK_List_Price greater than $60.00.List the BK_TITLE & BK_LIST_PRICE of each Book which has been loaned to Borrowers whose Zipcode is 23284.List the BK_TITLE & BK_LIST_PRICE of each Book which has never been loaned to a Borrower whose Zipcode is 23284.

Reference no: EM131399371

Questions Cloud

Discuss how globalization is affecting the political : Discuss how globalization is affecting the political, legal, and economic forces impacting todays business environment? Explain the role that organizational learning and creativity play in helping managers to improve their decisions. Essentially rela..
People favorite php tutorials and resources : What are people's favorite PHP tutorials and resources? Any sites with example applications to learn from?
Response analysis paper to a short story : Response analysis paper to a short story - The story is "Salvation" written by Hughes.
New system of billing and record-keeping : Suppose you are the manager of an accounts receivable unit in a large company. You are switching to a new system of billing and record-keeping and need to train your three supervisors and twenty-eight employees in the new procedures. What training me..
Relational database schema for library database : List the AU_Name, AU_DOB,BK_Title, & BK_List_Price for books and authors where the Author was born after January 15, 1976 and the book's BK_List_Price was more than $60.00.
How quantitative research is used in your discipline : Research how quantitative research is used in your discipline. Using this information, write an essay that describes how quantitative research tools can be used to aid in decision making within your field.
Research consistently shows that early parenthood is a time : Research consistently shows that early parenthood is a time of reduced marital or couple satisfaction. What are some of the factors that contribute to this decline in marital or couple satisfaction?
Impact of the proliferation of mobile devices : Analyze and explain the impact of the proliferation of mobile devices on cloud-based computing in various industries. For example, the rise of mobile phones and cloud-based computing has impacted the high-tech industries and education through a sh..
What is the meaning of a colonial legacy : "South Asia has a lower income per capita than sub-Saharan Africa." Comment on the validity of this statement? What is the meaning of a "colonial legacy"? Discuss any disadvantages and possible advantages.

Reviews

Write a Review

Business Economics Questions & Answers

  Exchange rate causes the demand for domestic assets

A increase in the expected future domestic exchange rate causes the demand for domestic assets to ________ and the domestic currency to ________, everything else held constant.

  An increase in fixed costs might affect

"An increase in fixed costs might affect a firms decsion to produce or not but would not affect its profit-maximizing output"

  Employed in project selection decision

The Analytical Hierarchy Process is being employed in a project selection decision. One major criteria, cost, receives a weighting value of 40%, which is split into short-term (50%), intermediate term (30%), and long-term (20%). Which of these statem..

  Find the per worker production function

Find the per worker production function. Find the steady-state capital stock per worker as a function of the savings, population growth, rate of technological change and depreciation rate. How much is steady state per capita GDP growth?

  The short-run if customers incomes increases

Assume that apples are an inferior good. Draw a perfectly competitive market for apples and a firm selling apples in the long run equilibrium where price is $10 and the firm’s equilibrium quantity is 50. EXPLAIN what happens in the short-run if custo..

  What is actuarially fair premium for each type of policy

Chimnesia has two equally sized groups of people: smokers and nonsmokers. Both types of people have utility U = √C where C is the amount of consumption that people have in any period. So long as they are healthy, individuals will consume their entire..

  Calculate the accounting profit for pottery firm

Gomez runs a small pottery firm. He hires one helper at $14,500 per year, pays annual rent of $7,500 for his shop, and spends $18,000 per year on materials. He has $40,000 of his own funds invested in equipment (pottery wheels, kilns, and so forth) t..

  Compare the present value of economic profit

Samantha Roberts has a job as a pharmacist earning $30,000 per year, and she is deciding whether to take another job as the manager of another pharmacy for $40,000 per year or to purchase a pharmacy that generates a revenue of $200,000 per year.Compa..

  Government moves to reduce budget deficit

Suppose a government moves to reduce a budget deficit. Using the model developed in class: a) Graphically illustrate the impact of reducing the government’s budget deficit by increasing (lumpsum) taxes on household income. Be sure to label:

  Elucidate what happens to the price of oranges

Elucidate what happens to the price of oranges and the marginal product of orange pickers as a result of the freeze. Can you say what happens to the demand for orange pickers.

  Small airline recently sold to a private equity group

A small airline recently sold to a private equity group for $145 million. The airline has earned profits of $9 million last year. The new managers believe they can grow profits at 5% per year. The private equity group borrows money from wealthy indiv..

  Policymakers should do to the fed funds rate

What does the Taylor rule imply that policymakers should do to the fed funds rate under the following scenarios?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd