NUMBER STUDENT OF STUDENT LAST NAME STUDENT FIRST ВОOKS BOOK ВООK DATE DUE ID NUMBER NAME OUT CALL NO TITLE OUT DATE 678-98-4567 Baker hf351.j6 Avalanches 09-02-09 09-16-09 Amy Amy Ramesh 4 678-98-4567 Baker 4 hf878.k3 Tomadoes 09-02-09 09-16-09 244-23-2348 Sunder 1 1835.123 Politics 09-02-09 09-16-09 Talley Talley 398-34-8793 James 3 k987.d98 Sports Legal Rights 09-02-09 09-16-09 Earthquakes 09-03-09 09-17-09 09-02-09 09-16-09 398-34-8793 James 3 d879.39 p987.t87 q875.i76 678-98-4567 Amy Ramesh Baker 4 244-23-2348 Sunder 1 Past Heroes 09-03-09 09-17-09
NUMBER STUDENT OF STUDENT LAST NAME STUDENT FIRST ВОOKS BOOK ВООK DATE DUE ID NUMBER NAME OUT CALL NO TITLE OUT DATE 678-98-4567 Baker hf351.j6 Avalanches 09-02-09 09-16-09 Amy Amy Ramesh 4 678-98-4567 Baker 4 hf878.k3 Tomadoes 09-02-09 09-16-09 244-23-2348 Sunder 1 1835.123 Politics 09-02-09 09-16-09 Talley Talley 398-34-8793 James 3 k987.d98 Sports Legal Rights 09-02-09 09-16-09 Earthquakes 09-03-09 09-17-09 09-02-09 09-16-09 398-34-8793 James 3 d879.39 p987.t87 q875.i76 678-98-4567 Amy Ramesh Baker 4 244-23-2348 Sunder 1 Past Heroes 09-03-09 09-17-09
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
A table of data for a library is shown in the table. 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 are related.
![NUMBER
STUDENT
OF
STUDENT
LAST NAME
STUDENT
FIRST
ВОOKS
BOOK
ВООK
DATE
DUE
ID NUMBER
NAME
OUT
CALL NO
TITLE
OUT
DATE
678-98-4567
Baker
hf351.j6
Avalanches 09-02-09 09-16-09
Amy
Amy
Ramesh
4
678-98-4567
Baker
4
hf878.k3
Tomadoes
09-02-09 09-16-09
244-23-2348
Sunder
1
1835.123
Politics
09-02-09 09-16-09
Talley
Talley
398-34-8793
James
3
k987.d98
Sports
Legal Rights 09-02-09 09-16-09
Earthquakes 09-03-09 09-17-09
09-02-09 09-16-09
398-34-8793
James
3
d879.39
p987.t87
q875.i76
678-98-4567
Amy
Ramesh
Baker
4
244-23-2348
Sunder
1
Past Heroes
09-03-09 09-17-09](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F656ab09d-bb94-442b-8cac-c276fb6e348b%2F5543c2e8-e160-4947-b8f5-1d6af1e960b2%2Fqjofi4g.png&w=3840&q=75)
Transcribed Image Text:NUMBER
STUDENT
OF
STUDENT
LAST NAME
STUDENT
FIRST
ВОOKS
BOOK
ВООK
DATE
DUE
ID NUMBER
NAME
OUT
CALL NO
TITLE
OUT
DATE
678-98-4567
Baker
hf351.j6
Avalanches 09-02-09 09-16-09
Amy
Amy
Ramesh
4
678-98-4567
Baker
4
hf878.k3
Tomadoes
09-02-09 09-16-09
244-23-2348
Sunder
1
1835.123
Politics
09-02-09 09-16-09
Talley
Talley
398-34-8793
James
3
k987.d98
Sports
Legal Rights 09-02-09 09-16-09
Earthquakes 09-03-09 09-17-09
09-02-09 09-16-09
398-34-8793
James
3
d879.39
p987.t87
q875.i76
678-98-4567
Amy
Ramesh
Baker
4
244-23-2348
Sunder
1
Past Heroes
09-03-09 09-17-09
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education