As a database expert, you are invited to write a report of maximal one page on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
As a database expert, you are invited to write a report of maximal one page on the design and functionality the Library database. Your report must address each of the following questions: 1. The Dewey Decimal Classification (DDC) system is used by libraries around the world to organise books for storage according to subject classes. Here is the Wikipedia entry on the list of DDC classes. The DDC is structured around ten main subject classes covering the entire world of knowledge, each main class is further structured into ten hierarchical divisions, each having ten divisions of increasing specificity. For example 000-099 is for the subject class of "Computer science, information and general works", and 005 is specifically for "Computer programming, programs and data". A book on SQL programming may have a Dewey call number like 005.789, where 005 is for the main subject class and 789 is for a specific subclass. Discuss if the DDC implies any data integrity constraint on the Dewey call number and the subject class of books, and if the given Library database schema enforces such constraint. Further explain if any such constraint can be enforced using the data integrity mechanism in the relational data model. 2. With the current Library database ER model, Person (as a library user) and Author are separate entity types and there are not any relationships between them. Discuss any weakness of this design choice, and give your recommendations to improve the ER model and the corresponding relational database schema. 3. Using artificial primary keys for entity types (and tables) is commonly used for ER modelling (and relational database design). Read this blog post "Natural vs. Artificial Primary Keys" on this topic. Artificial primary keys are often necessary for modelling complex real world applications, but artificial primary keys can also lead to data fragmentation - data about one data object are kept in multiple tables, which means complex join queries on many tables. In the given Library database ER diagram, "transactionID" is the artificial primary key for the "borrow" entity type and the "borrow" table. Discuss the real-world scenario of "users borrow books" modelled in the current Library database. Further discuss how the real-world scenario of "users borrow books" would be different if without the artificial primary key "transactionID". As a database expert, you are invited to write a report of maximal one page on the design and functionality the Library database. Your report must address each of the following questions: 1. The Dewey Decimal Classification (DDC) system is used by libraries around the world to organise books for storage according to subject classes. Here is the Wikipedia entry on the list of DDC classes. The DDC is structured around ten main subject classes covering the entire world of knowledge, each main class is further structured into ten hierarchical divisions, each having ten divisions of increasing specificity. For example 000-099 is for the subject class of "Computer science, information and general works", and 005 is specifically for "Computer programming, programs and data". A book on SQL programming may have a Dewey call number like 005.789, where 005 is for the main subject class and 789 is for a specific subclass. Discuss if the DDC implies any data integrity constraint on the Dewey call number and the subject class of books, and if the given Library database schema enforces such constraint. Further explain if any such constraint can be enforced using the data integrity mechanism in the relational data model. 2. With the current Library database ER model, Person (as a library user) and Author are separate entity types and there are not any relationships between them. Discuss any weakness of this design choice, and give your recommendations to improve the ER model and the corresponding relational database schema. 3. Using artificial primary keys for entity types (and tables) is commonly used for ER modelling (and relational database design). Read this blog post "Natural vs. Artificial Primary Keys" on this topic. Artificial primary keys are often necessary for modelling complex real world applications, but artificial primary keys can also lead to data fragmentation - data about one data object are kept in multiple tables, which means complex join queries on many tables. In the given Library database ER diagram, "transactionID" is the artificial primary key for the "borrow" entity type and the "borrow" table. Discuss the real-world scenario of "users borrow books" modelled in the current Library database. Further discuss how the real-world scenario of "users borrow books" would be different if without the artificial primary key "transactionID".
Expert Answer:
Answer rating: 100% (QA)
As a database expert you are invited to write a report of maximal one page on the design and functionality the Library database Your report must addre... View the full answer
Related Book For
College Mathematics For Business Economics, Life Sciences, And Social Sciences
ISBN: 978-0134674148
14th Edition
Authors: Raymond Barnett, Michael Ziegler, Karl Byleen, Christopher Stocker
Posted Date:
Students also viewed these databases questions
-
(08 Marks) In the Fig.1(c), compare the output of the network, if the activation function is a sigmoid 1 function y=- and (X1, X2) (1, 1). 1+e 1+1 AYY Y YC.) B YC. ye D 46 (06 Marks)
-
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...
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
For the beam illustrated in the figure, find the locations and magnitudes of the maximum tensile bending stress due to M and the maximum shear stress due toV. 4500 N 20 mm 300 mm 150 mm 40 mm
-
Two B85 V belts are used in a drive composed of a 5.4-in driving sheave, rotating at 1200 rev/min, and a 16-in driven sheave. Find the power capacity of the drive based on a service factor of 1.25,...
-
The fund-basis financial statements of the City of Cottonwood have been completed for the year 2017 and appear in the first tab of the Excel spreadsheet provided with this exercise. In addition, the...
-
Innovative Technologies Ltd uses a job order costing system to control costs in its two production departments. Factory overhead is applied on the basis of machine hours in the Construction...
-
Croftmark Co. began operations on May 1, 2010. Its Work in Process Inventory account on May 31 appeared as follows: The company applies overhead on the basis of direct labor cost. Only one job was...
-
How do you think a risk manager might work through a difference of opinion with a unit manager? Explain in details.
-
Brad?s Building Supplies entered into the following transactions involving current liabilities during 2020 and 2021: Required Prepare journal entries to record these transactions for Brad?s Building...
-
Devina has owned the house next door to Caf Paris for three years. The owner of the Caf, Aoife, assured Devina that the building work would only take six weeks. Aoife is a sole trader and has been...
-
Haywards Bay Seafoods General Journal GJ1 Date 30/9/x3 Depreciation Expense 30/9/X5 Details Accumulated depreciation Truck Depreciation expense for truck at time of sole. 30/9/x5 Accounts receivable...
-
Sully deposits $20,000 into Monsters Inc. in exchange for stock. What would be the correct journal entry? Sully deposits $20,000 into Monsters Inc. in exchange for stock. What would be the correct...
-
Select the benefit to Cassidy of contributing $50,000 lumpsum to the RESP rather than making annual contributions. Maximizes the government grant in future years. Maximizes compound returns. Extends...
-
Toshiba Corporation, a Japanese electronics and engineering conglomerate with headquarters in Tokyo, produces a wide range of products, including personal computers, semiconductors, consumer...
-
Consider the roof system shown. The roof is supported by stud walls around the exterior, and a cantilever roof beam system through the middle, as shown in the plan view below. The loads are as...
-
The [H3O+] of a solution with pH = 2 is O 1 x 10-12 M. O 10 M. O 1 10 M. O O -10 M. 1 x 102 M. Submit Request Answer
-
Periwinkle Company is a multinational organization. Its Parts Division is located in Lavender Land, while its Assembly Division is located in North Orchid. During the current year Periwinkle Companys...
-
In Problem assume that the annual interest rate on a credit card is 25.74% and interest is calculated by the average daily balance method. The unpaid balance at the start of a 28-day billing cycle...
-
In Problem find the relative rate of change of f(x) at the indicated value of x. Round to three decimal places. f(x) = 4x 2 - ln x; x = 2
-
In Problem convert the given i-system to an e-system using slack variables. Then construct a table of all basic solutions of the e-system. For each basic solution, indicate whether or not it is...
-
Give three specialized subclasses for the Student class.
-
How does encapsulation protect the object from an intruder?
-
Explain the difference between multiple and simple inheritance and provide one example of each.
Study smarter with the SolutionInn App