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

  Middle of the distribution with respect to processing time

The time it takes to process phone orders in a small gift shop is normally distributed with a mean of 6 minutes and a standard deviation of 1.24 minutes. what cutoff values would separate the 95% of orders that are in the middle of the distribution w..

  Determine the equation of the aggregate supply curve

Assume that there are 100 identical firms that would be willing to sell 10 units each of the same good if the market price were $5 per unit. Draw a graph of the aggregate supply curve. Indicate on your aggregate supply curve the quantities supplied a..

  Lasting eight times longer than conventional light sources

You are the marketing manager for Herman Miller, the company that sells the Leaf Personal Light in the US. The product was designed by Yves Behar, an entrepreneur and sustainability advocate. It is cool to the touch, has adjustable intensity and cons..

  How many autoimmunity tests per year will have to be perform

How many autoimmunity tests per year will have to be performed on the array machine to break even?

  Dollar is trading on the foreign exchange market

One U.S. dollar is trading on the foreign exchange market for about 1.47 Chesterfield ales (the Chesterfield currency). Therefore, one Chesterfield ale would have purchased how many U.S. dollars?

  What is the profit-maximizing quantity of output

The AAA Aquarium Co. sells aquariums for $20 each. Fixed costs of production are $20. The total variable costs are $20 for one aquarium, $25 for two units, $35 for three units, $50 for four units, and $80 for five units. In the form of a table, calcu..

  Describe the importance of an organization

Describe what you learned about change management; include your personal perspective on your learning of the concepts on change management as explored through the modules of this course.

  About the financial ramifications of her decision

Yolanda is a licensed marriage counselor in Oklahoma and earns an annual salary of $40,000 there. She recently learned that marriage counselors earn $55,000 per year in Kansas, and she is thinking of moving. Assuming that she is only concerned about ..

  Total cost is function of output

Total cost is a function of output Q. TC = f (Q). The average total cost function can be found by dividing the total cost function by Q. What does the first derivative (dATC/dQ) of the ATC function show?

  Calculate the coefficient of determination

Determine whether size is a statistically significant variable in estimating selling price. Calculate the coefficient of determination.

  What is approximately maximum amount rm is willing to pay

What is approximately maximum amount rm is willing to pay to be allowed to use e more units of input x, for e small.

  Three alternatives for investing these funds

The Rule of 70 applies in any growth rate application. Let’s say you have $1000 in savings and you have three alternatives for investing these funds.

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