ISBN 9781119333418 A librarian at the Department of Finance, Operations, and Information Systems (FOIS) in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ISBN 9781119333418 A librarian at the Department of Finance, Operations, and Information Systems (FOIS) in the Goodman School of Business would like to create a database that would hold the data of books published in the area of Finance, Operations and Information Systems. The librarian maintains the following data on each book: ISBN, Title (title of the book), edition, year of publication, place of publication, name of the publisher, author(s), and email addresses of the authors. The following table shows sample contents. 9781119335455 9781119309901 (a) 9781119333562 organizing (b) 1 c) Title Collective mindfulness in post-implementation is adaptation processes Knowing in practice: Enacting a collective capability in distributed Blockchains and the economic institutions of capitalism Introduction to Information Systems: Supporting and Transforming Businesses Ed. 3rd 4th Year Place Publisher 2013 Oslo 2002 London 2018 Toronto McGraw Hill Oxford University Press McGraw Hill 2017 Toronto McGraw Hill Authors Aanestad, Margunn Jensen, Tina Blegind wanda J. Orlikowski Davidson, Sinclair De Filippi, Primavera Potts, Jason R. Kelly Raine Casey G. Cegielski Ingrid Splettstoesser Cristobal Sanchez- Rodriguez Email maanestad@uio.no blegind@cbs.dk wanda@mit.ed jason.potts@rmit.edu.au A user can search the database using an author's last name, the book's title, year of publication, publisher, or a combination of them. As part of the design process, normalize the table by answering the following questions: Describe why the above table is not in first normal form (1NF). (1 Mark) Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table (if necessary). (2 Marks) Using the functional dependencies identified in part (b), describe and illustrate the normalization process by converting the above table to the third normal form. Identify the primary and foreign keys correctly. (4 Marks) ISBN 9781119333418 A librarian at the Department of Finance, Operations, and Information Systems (FOIS) in the Goodman School of Business would like to create a database that would hold the data of books published in the area of Finance, Operations and Information Systems. The librarian maintains the following data on each book: ISBN, Title (title of the book), edition, year of publication, place of publication, name of the publisher, author(s), and email addresses of the authors. The following table shows sample contents. 9781119335455 9781119309901 (a) 9781119333562 organizing (b) 1 c) Title Collective mindfulness in post-implementation is adaptation processes Knowing in practice: Enacting a collective capability in distributed Blockchains and the economic institutions of capitalism Introduction to Information Systems: Supporting and Transforming Businesses Ed. 3rd 4th Year Place Publisher 2013 Oslo 2002 London 2018 Toronto McGraw Hill Oxford University Press McGraw Hill 2017 Toronto McGraw Hill Authors Aanestad, Margunn Jensen, Tina Blegind wanda J. Orlikowski Davidson, Sinclair De Filippi, Primavera Potts, Jason R. Kelly Raine Casey G. Cegielski Ingrid Splettstoesser Cristobal Sanchez- Rodriguez Email maanestad@uio.no blegind@cbs.dk wanda@mit.ed jason.potts@rmit.edu.au A user can search the database using an author's last name, the book's title, year of publication, publisher, or a combination of them. As part of the design process, normalize the table by answering the following questions: Describe why the above table is not in first normal form (1NF). (1 Mark) Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table (if necessary). (2 Marks) Using the functional dependencies identified in part (b), describe and illustrate the normalization process by converting the above table to the third normal form. Identify the primary and foreign keys correctly. (4 Marks)
Expert Answer:
Answer rating: 100% (QA)
The image appears to be a screenshot of an examination or assignment question dealing with database normalization The question pertains to a sample table containing bibliographic information of books ... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these general management questions
-
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 governance of an enterprise is the sum of those activities that make up the internal regulation of the business in compliance with the obligations placed on the firm by legislation, ownership and...
-
A study was conducted at the Department of Health and Physical Education at Virginia Polytechnic Institute and State University to determine if 8 weeks of training truly reduces the cholesterol...
-
Because Natalie has been so successful operating Cookie Creations, Katy would like to have Natalie become her partner. Katy believes that together they will create a thriving cookie-making business....
-
It is commonly said that a certain resistor draws a certain current. Does this mean that the resistor "attracts" the current? Defend your answer.
-
This chapter describes maintenance of tight control over each entity's critical success factors as being important. Yet a criticism of some organizational control systems is that they are stifling...
-
E 11-13 Determining the primary beneficiary in a VIE Pop Corporation and Son Company participate in a business classified as a VIE. Under terms of their contractual arrangement, Pop and Son share...
-
Herman and Sons Law Offices opened on January 1, 2015. During the first year of business, the company had the following transactions: January 2: The owners invested $ 250,000 (the par value of the...
-
The per-unit standards for direct materials are 2 gallons at $4 per gallon. Last month, 12500 gallons of direct materials that actually cost $46250 were used to produce 8000 units of product. The...
-
Using the Public MACRO BITCOIN scorecard spreadsheet (linked in its associated masterclass lesson - Long Term 32), create a COPY of it and perform a complete analysis for the date 22/2/2022....
-
Dear tutor, I am having trouble trying to figure out this answer. Could you please help me and as well explain the reasoning behind your answer? Gifts and Inheritances Practice Hanna, a cash basis...
-
Drs. Draper and Keys run a partnership family medical practice in Brownsville, Texas. While the practice is profitable, both physicians are making payments on heavy debt loads for student loans that...
-
Sweetlip Ltd and Warehou Ltd are two family-owned flax-producing companies in New Zealand. Sweetlip Ltd is owned by the Wood family and the Bradbury family owns Warehou Ltd. The Wood family has only...
-
Small Sample Weights of M&M plain candies are normally distributed. Twelve M&M plain candies are randomly selected and weighed, and then the mean of this sample is calculated. Is it correct to...
-
Swain Athletic Gear (SAG) operates six retail outlets in a large Midwest city. One is in the center of the city on Cornwall Street and the others are scattered around the perimeter of the city....
-
The Tokyo Olympics After watching How the Tokyo Olympics Became the Most Expensive Summer Game Ever video answer the following questions. * * The numbers can be made up . I just need help with an...
-
last year abc company had the following data net sales (in million) $1,200 Last year, ABC Company had the following data Net Sales (in million) $1,200 780 Cost of Goods Sold 420 Gross Profit Margin...
-
Integration is a vital concept when applied in one?s life. Integrating your life means making ideal choices. Perfect choices on the other go in line with quality decisions. Quality decisions lead to...
-
What are predetermined indirect cost rates commonly called in practice?
-
What four categories of processes are useful in developing the process perspective measures for a Balanced Scorecard?
-
Assigning corporate support costs, activity-based costing Zeta Department Store has developed the following information in order to develop a timedriven ABC model for its Accounts Receivable...
-
3. On December 31, 2014, Jenna OYJ purchased a building from Mikko OYJ for $2,000,000. At that date, the building had a book value of $1,500,000 and a remaining useful life of 20 years. Jenna OYJ...
-
4. If Khun sold the building back to Khap at the same price and date, how and in what amount will the sale of the building affect Khaps income from Khun and net income for 2016 and the balance of...
-
1. In 2014, Pop Corporation sold land that cost $20,000 to Minang Corporation, its 80 percent-owned subsidiary, for $30,000. Minang still owns the land at December 31, 2017. How will this transaction...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App