A table of data for a library is shown in the table for Problem. Normalize these data
Question:
A table of data for a library is shown in the table for Problem. Normalize these data into the third normal form, preparing it for use in a relational database environment. The library’s computer is programmed to compute the due date to be 14 days after the checkout date. Document the steps necessary to normalize the data similar to the procedures found in the chapter. Index any fields necessary and show how the databases arerelated.
Transcribed Image Text:
NORMALIZATION OF DATA STUDENT FIRST ID NUMBER NAME LAST NAME NUMBER OF BOOKS OUT STUDENT STUDENT BOOK CALL NO TITLE BOO K DATE DUE OUT DATE 678-98-4567 Amy 678-98-4567 Amy 244-23-2348 Ramesh Sunder 398-34-8793 James 398-34-8793 James 678-98-4567 Amy 244-23-2348 Ramesh Sunder Baker Baker hf351.j6Avalanches 09-02-09 09-16-09 hf878k3 Tomadoes 09-02-09 09-16-09 i835123 Poliics k987.d98 Sports d879.39Legal Rights 09-02-09 09-16-09 p987.t87 Earthquaks 09-03-09 09-17-09 q875.176 Past Heroes 09-03-9 09-17-09 09-02-09 09-16-09 09-02-09 09-16-09 Talley Talley Baker
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 71% (7 reviews)
The first step is to remove repeating groups The removal of repeating groups results in the followin...View the full answer
Answered By
Aqib Parvej
I am teaching since my graduation time so I have teaching experience of about 5 years and in these years I learn to teach in the best and interesting way .
4.80+
20+ Reviews
41+ Question Solved
Related Book For
Question Posted:
Students also viewed these Accounting questions
-
The market for oil-based paint is shown in the following table: Suppose the production of the paint creates a negative externality of $10 for each unit of paint, which is the cost of repairing the...
-
A possible clock is shown in the figure. It consists of a flashtube F and a photocell P shielded so that each views only the mirror M, located a distance d away, and mounted rigidly with respect to...
-
A simple series system is shown in the accompanying figure. The reliability of each component is shown in the figure. Assuming that the components operate independently, calculate the system...
-
A stream of particles of one size are 80% converted (SCMIash diffusion control, uniform gas environment) on passing through a reactor. If the reactor is made twice the size but with the same gas...
-
A solenoid has 4850 turns per meter and radius 3.3 cm. The magnetic field inside has magnitude 0.24 T. What is the current in the solenoid?
-
What types of jobs do you need to be able to complete in your at-home or personal shop? How do these jobs relate to your immediate goals (i.e., if you plan on working for a manufacturer or...
-
In 2006, CKX, Inc., a New York sports entertainment company, paid \($50\) million for an 80 percent ownership interest in G.O.A.T. LLC. (G.O.A.T. stands for Greatest of All Time and is a business...
-
Sharon Smith, the financial manager for Barnett Corporation, wishes to evaluate three prospective investments: X, Y, and Z. Sharon will evaluate each of these investments to decide whether they are...
-
SnowBunny Company purchased a gondola for $440,000 (no residual value) at the beginning of 2018. The gondola was being depreciated over a 10-year life using the double-declining method. At the...
-
Canadian Express provides overnight delivery of small parcels to locations throughout Canada. As a small public company, Canadian Express follows IFRS. Required: Record the journal entries necessary...
-
The ABC Company is a geographically distributed organization with several sites around the country. Users at these sites need rapid access to data for transaction processing purposes. The sites are...
-
A college bookstore maintains all of its records on index cards. This has proven to be a very tedious chore, and the manager has asked you to design a database that will simplify this task. The index...
-
Given data points (xo, uo). .........(xn un) with x, , i j, prove that there is a unique continuous piecewise affine interpolant u = f(x), so u = 0..........n. (a) Prove that the piecewise affine...
-
. What was the reason you picked this documentary movie? . What was the story/content? . How was it related to Marketing? . How was it related to Supply Chain, Marketing communication or Ethics and...
-
Could crocs have been able to stay float and rejuvenate their brand had they not shifted their marketing strategy to digital marketing? Would the comfort and brand recognition of the shoe had been...
-
Course Learning Outcomes Evaluated CLO 6: Examine management strategies utilized to build and sustain top performing organizations CLO 7: Detail how businesses effectively manage production and...
-
An Fitness Center charges $50 per month. Variable costs are about $5 per account per month. With marketing spending of $15 per month per customer, their retention rate is 98% per month. At a monthly...
-
4. Customer demands are uniformly distributed between 0 and 1 at a linear line. There are three suppliers A, B, and C, located at 0.3, 0.5 and 0.9, respectively (as shown in the following figure)....
-
What impact may cultural differences between partners have on global alliances?
-
Assume that your audit team has established the following parameters for the examination of ELM's sales transactions: LO G-3 Risk of incorrect acceptance...
-
The data set contains observations from the years 1871 through 2020 , so the midpoint is 1945.5 . For some records, the record temperature occurred more than once. In these cases, only the most...
-
The following is a list of six control plans from this chapter or from Chapter 9. Control Plans A. Digital signatures B. Manually reconcile batch totals C. Preformatted screens D. One-for-one...
-
The following is a list of six control plans from this chapter or from Chapter 9. Control Plans A. Digital signatures B. Manually reconcile batch totals C. Preformatted screens D. One-for-one...
-
There are many opportunities for fraud within the OE/ S process. One of these opportunities is the use of the system to fraudulently ship goods to an employee, posing as a customer. Describe the...
-
In Jamala's school, high school seniors may choose their Science and English classes. For Science, 40% of the students choose Geology. For English, 30% of Geology students choose Creative Writing....
-
1.Pharoah, Inc., management expects to pay no dividends for the next six years. It has projected a growth rate of 25 percent for the next seven years. After seven years, the firm will grow at a...
-
The following information appears in the records of Bock Corporation at year-end: Accounts Receivable $28,000 Retained Earnings $ ? Accounts Payable 12,000 Supplies 8,000 Cash 7,000 Equipment, net...
Study smarter with the SolutionInn App