Member information in the member register

Assignment Help Database Management System

Reference no: EM13908839

RockNJazz Universal Album is a leading music library in Florida. The library has various branches located in Weston, Miami, Phoenix, and Greensboro. Each branch of the library has a huge collection of music and movie cassettes, DVDs, and CDs that the members of the library can borrow. To borrow CDs, DVDs, or cassettes from the library, the members need to register themselves with the library by paying a nominal non-refundable fee.

To maintain member records, the library has hired an executive who maintains member information in the Member register. The details stored in this register consist of MemberID, MemberName, Gender, Address, and the amount paid by each member. After registration, a member receives a lifetime membership ID that he/she needs to quote while borrowing from the library. Each time a member borrows or returns a CD, DVD, or cassette, the executive at the issuing counter needs to update the Issue/Return register. The Issue/Return register stores the following details:

MemberID MemberNam

Reference no: EM13908839

Questions Cloud

Banks savings and loan offering introductory rate : You receive a credit card application from Shady Banks Savings and Loan offering an introductory rate of 3.2 percent per year, compounded monthly for the first six months, increasing thereafter to 18.1 percent compounded monthly. Required: Assuming y..

Differences in organizational components and actions : The first section (5-6 pages) is to be a compare/contrast essay where you illustrate the similarities and differences in organizational components, actions, and attributes promoting a healthy culture and organizational components, actions, and att..

Evaluate proposed acquisition of special-tax operating costs : You have been asked by the president of your company to evaluate the proposed acquisition of a new special-purpose truck for $60,000. The truck falls into the MACRS 3-year class, and it will be sold after three years for $20,600. Use of the truck wil..

Why is financial statement important : Why is financial statement important and who could it benefit?

Member information in the member register : To maintain member records, the library has hired an executive who maintains member information in the Member register. The details stored in this register consist of MemberID, MemberName, Gender, Address, and the amount paid by each member.

Find the pair x z of values that maximize the density : Find the pair x, z of values that maximize this density. Find the marginal density fZ (z) and find the value of z that maximizes this.

Annual expense ratio is netted out of the funds return : You purchased 3,800 shares in the New Pacific Growth Fund on January 2, 2010, at an offering price of $42.00 per share. The front-end load for this fund is 5 percent, and the back-end load for redemptions within one year is 2 percent. what is your to..

What is the carrying value of these bonds : On January 1, 2013, Jacob issued $600,000 of 11%, 15-year bonds at a price of 102½. The straight-line method is used to amortize any bond discount or premium and interest is paid semi annually. If all interest has been accounted for properly, what is..

Calculate the present value of total outflows : The Bowman Corporation has a bond obligation of $26 million outstanding, which it is considering refunding. Though the bonds were initially issued at 11 percent, the interest rates on similar issues have declined to 9.9 percent. Calculate the present..

User Account

All Pages