ISBN 9781119333418 A librarian at the Department of Finance, Operations, and Information Systems (FOIS) in the...

 

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)

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