1. Consider the ER diagram below. CardNumber PaymentMode Expiry Date Has reason. Email 1 Client M...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Consider the ER diagram below. CardNumber PaymentMode Expiry Date Has reason. Email 1 Client M RentDuration Rents Discount Start Time N Name Title Duration Price Address a. All the data that we want to store in this database application is given in the above ERD. Create one big relation (as the early day database researchers did) for this database application. Use strictly the same names/titles as in the ERD. Hint: This question is not about the conversion approach suggested in Chapter09. [2 marks] b. Identify all functional dependencies in this one big relation, from part a. [3 marks] c. Suggest a primary key for this one big relation, from part a/b. Justify your selection with sufficient [2 marks] d. Following from part c, is the one big relation compliant with 2NF. If yes explain, if not then make it compliant with 2NF by doing necessary changes. [2 marks] 1. Consider the ER diagram below. CardNumber PaymentMode Expiry Date Has reason. Email 1 Client M RentDuration Rents Discount Start Time N Name Title Duration Price Address a. All the data that we want to store in this database application is given in the above ERD. Create one big relation (as the early day database researchers did) for this database application. Use strictly the same names/titles as in the ERD. Hint: This question is not about the conversion approach suggested in Chapter09. [2 marks] b. Identify all functional dependencies in this one big relation, from part a. [3 marks] c. Suggest a primary key for this one big relation, from part a/b. Justify your selection with sufficient [2 marks] d. Following from part c, is the one big relation compliant with 2NF. If yes explain, if not then make it compliant with 2NF by doing necessary changes. [2 marks]
Expert Answer:
Answer rating: 100% (QA)
Question Part a Client Email PK Address CardNumber PK Expiry D... View the full answer
Related Book For
Introduction to Governmental and Not for Profit Accounting
ISBN: 978-0132776011
7th edition
Authors: Martin Ives, Terry K. Patton, Suesan R. Patton
Posted Date:
Students also viewed these accounting questions
-
The City of Nickston uses the purchases method to account for the acquisition of supplies by its General Fund. At the end of fiscal 2012, the supplies inventory was valued at $ 63,000. At the end of...
-
A government uses the purchases method to account for both inventories and prepaid assets. Its General Fund balance sheet includes Inventory of Materials of $35,000 and Prepaid Insurance of $40,000....
-
What is the purpose of the general business tax credit?
-
On your first day as a intern at Tri-Star Management Incorporated the CEO asks you to analyze the following information pertaining to two common stock investments, Tech.com Incorporated and Sam's...
-
Visit the website for the American Management Association (www.amanet.org). Find a course on supervisory skills, and summarize the content of that course: What does the training include? What will it...
-
An object has several forces acting on it. One force is F = axfi, a force in the x-
-
The \(f\)-chart is based on \(F_{R}(\tau \alpha)\) and \(F_{R} U_{c}\) values, which can be deduced from a plot of collector efficiency versus \(\left(T_{\text {fin }}-T_{a} ight) / I\). If such a...
-
Mike Devereaux Company shows the following entries in its Equipment account for 2015. All amounts are based on historical cost. Instructions (a) Prepare any correcting entries necessary. (b) Assuming...
-
What advanced methodologies are used to measure and quantify stress, and how reliable are these methods in different contexts ?
-
Suppose that East-West airlines is a small airline that offers passanger air transportation between two major east coast cities, namely Boston and New York; two major west coast cities , namely San...
-
The largest corporate fraud in history entailed the falsification of $11 billion in operating profits at WorldCom Inc. WoridCom was among the three largest longdistance telecommunications providers...
-
A recent study on high-deductible health plans and health savings accounts found that individuals who are switched from generous coverage to high-deductible insurance plans reduce their adherence to...
-
Senator Lee, making the case for universal, free health care, argues that we dont need to worry that health care costs might go up under such a universal and free system, because people are not price...
-
Describe the main components of Massachusetts health care reform. In what ways did Massachusetts provide a model for the Affordable Care Act? How was Massachusetts experience with reform similar and...
-
The National Bureau of Economic Researchs TAXSIM model allows you to calculate tax liabilities for a given individual in different years. Navigate to https://users.nber.org/~taxsim/taxsim27/ and fill...
-
_____________ is the tendency among members of highly cohesive groups to self-censor, suspend critical thinking, and make faulty decisions.
-
The following data pertain to Dakota Divisions most recent year of operations. Income $ 10,500,000 Sales revenue 130,000,000 Average invested capital 51,000,000 Assume that the companys minimum...
-
Data 9.2 on page 540 introduces the dataset Cereal, which includes information on the number of grams of fiber in a serving for 30 different breakfast cereals. The cereals come from three different...
-
Describe the implications of the phrase normally expected to be liquidated with expendable avail-able financial resources as applied to accruing liabilities for compensated absences in...
-
What is the difference between an Enterprise Fund and an Internal Service Fund?
-
Which organizations establish GAAP for not- for- profit health care organizations? Do these organizations establish GAAP also for governmental health care organizations?
-
Examine the process activities and transactions for the supply chain and production management process shown in Figure 12-3. a. Using the example transactions listed in the same figure, describe...
-
The following are routine procedures for the audit of the purchases process. For each procedure, (1) state whether it is a test of controls or a substantive test of transactions or balances, (2)...
-
Examine the inherent risk, impact of controls, and residual risk plots in Figure 12-8 for the supply chain and production management process. Based on this plot, what conclusions should an auditor...
Study smarter with the SolutionInn App