Question: Consider a library wanted to normalize their database. They need to hold the following information for books, borrowers, and branches. Help them to normalize the

Consider a library wanted to normalize their database. They need to hold the following information for books, borrowers, and branches. Help them to normalize the database and show your steps for 1NF, 2NF, and 3NF. Note: BookID, BranchID, BorrowerID are unique. See the un-normalized attributes below.

LibraryDB (BookID, Title, Publishers, AuthorName, BranchID, BranchName, BranchAddress, BorrowerID, BorrowerName, BorrowerAddress, BorrowerPhones (multiple phones), BorrowDateOut, BorrowDueDate, NumberofCopiesofBookinBranch)

After working through the normalization steps about how many entities (tables) did you come up with after getting to 3rd Normal Form?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

The design of a new multinational personnel selection system at MobilCom. Louisa is a senior HR manager at MobilCom, currently residing and working in the Kuala Lumpur (KL) office. She had completed...

Lab 5 - Normalization Consider the library system shown in the following figure which is used to keep track of books and borrowers. Book_ Book Title - Det er hon her_State Publisher Phong 23 13001...

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

I need some help with both Case 1 and Case 2 of this assignment. See attached document for full assignment. Here is an excerpt from each. Case 1: Purchase Point Media Corporation (PPMC) Media...

1 WILMINGTON UNIVERSITY LIBRARY Business Continuity Plan (BCP) and Disaster Recovery Plan (DRP) 2 WILMU LIBRARY SERVICES 20,000 student population served 13 physical locations of access to university...

Determine whether dix x ((3-c) + Inx) + converges or diverges. Use proper test to investigate the convergence of the improper integral e-{c+1)x x(+2)-(c+1) -dx.

What advice would you give? Excuse me, we are both professional accountants, and I need some advice. I have a full-time management position with a company. I was wondering if I would be in violation...

MJ , an associate accountant, overheard one of the other accountants in her office refer to her as a freak and gothic looking and that her butch hair and numerous earrings were inappropriate business...

Use a computer algebra system to find the exact value of C x 3 y 2 z ds, where C is the curve with parametric equations x = e t cos 4t, y = e t sin 4t, z = e t , 0 t 2.

The creation of the single market in Europe has led to harmonization. What does this mean? How does harmonization affect a companys global marketing strategies?

An electric car is subjected to acceleration tests along a straight and level test track. The resulting v-t data are closely modeled over the first 10 seconds by the function v = 24 t t 2 + 5t,...

Mike and Iris were flying home from the meeting. The audit committees reaction had not been what they expected. Im glad they understood the situation, Mike said. Id like you to start revising our...

Outdoor Expo provides guided fishing tours. The company charges $300 per person but offers a 20% discount to parties of four or more. Consider the following transactions during the month of May. May...

Discuss the key risks you feel might limit the successful execution of a plan/strategy using an example of your choice to illustrate. What methods could be used to combat and address these issues?...

What taxes must an S corporation prepay by making quarterly estimated tax payments? Can a shareholder owning S corporation stock use the corporations estimated tax payments to reduce the amount of...

For the following independent situations, determine the optimum filing status for the years in question. a. Wayne and Celia had been married for 24 years before Wayne died in an accident in 2013....

What specific rules are applicable to Non-degree candidates who receive scholarships?

Victor Anderson, the owner of Anderson Belts Inc., is studying absenteeism among his employees. His workforce is small, consisting of only five employees. For the last 3 years, 2011 through 2013, he...

Calculate a four-quarter weighted moving average for the number of shares outstanding for the Boxley Box Company for the nine quarters of data. The data are reported in thousands. Apply weights of...

Determine a value index for 2013 using 1990 as the baseperiod.