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?
-
In Theorem 11.2.5 we saw that the ANOVA null is equivalent to all contrasts being 0. We can also write the ANOVA null as the intersection over another set of hypotheses. (a) Show that the hypotheses...
-
Discuss the differences among verbal, written, and implied consent.
-
Story Park competes with Splash World by providing a variety of rides. Story sells tickets at $50 per person as a one-day entrance fee. Variable costs are $10 per person, and fixed costs are $240,000...
-
Definition 0.2 Suppose that G = (V,E) is a connected graph. The diameter of G is 8(G)= max d(x, y) x,yV 4. For this question assume that G is not a complete graph (a graph has 8(G) = 1 iff G is...
-
The office currently has the following full-time equivalents (FTEs): 1.5 surgeons, 2 ASRs, 2RNs, and 1 CA. Suppose that in the following year, the office will have 5,400 plagiocephaly visits, 2,000...
-
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...
-
Why has it been difficult, particularly in the United States, to create a satisfactory accounting standard on foreign currency translation?
-
An entity that sells DVDs by sending emails to prospective customers has acquired a customer list from another entity that also markets its products in a similar fashion. The entity estimates that it...
-
How can the standard of care be proven?
-
In Griswold, Justice Stewart skewered the majority for asserting that the Ninth Amendment of the US Constitution supported its decision to overturn the Connecticut contraception statute. He wrote,...
-
We discussed the card game Poker briefly in Section 13.3. Given that the present (probabilistic) state of a player is either good bet, questionable bet, or bad bet, work out a POMDP to represent this...
-
Entity G produces mousetraps and has for some time been the market leader. Its chief competitor, Entity H has recently developed a new product that is widely acknowledged as being superior to entity...
-
On the basis of the results of its surveys, the GLOBE project arranged the countries in 10 clusters (see Table 2.9). What is your opinion concerning this kind of classification of countries? Table...
-
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...
-
why you assume value of Machine A is assumed to decrease by $7,000 each year for the purpose of these calculations?
-
1. You want to create a Dog object. Which of the following would you use to describe it? (Choose all that apply.) A. String breed B. int age C. boolean isADog D. String ownerName E....
-
Part 1: Cathy Forth Photography Services (20 marks) You have been hired by Cathy Forth as her new bookkeeper. She has given you the following information: Use the current date and provide an...
Study smarter with the SolutionInn App