Create an erd to show the resultant tables

Assignment Help Database Management System

Reference no: EM131033818

Normalisation

Using the table and data given below, normalise the table to 3NF.
Use correct dependency diagram/s to show each normalisation level.
Create an ERD to show the resultant tables at the 3NF level with all the attributes, Primary/Foreign keys, relationships, etc.

^Book_ID	^Book_Title	^{Bk_ Author}	^{Date_Published}	^Publisher	^{Publ_Location}	^Borrower_Num	^D_Borrowed	^D_Returned
¹⁰¹	^{Management of Information Systems}	^Laudon	²⁰¹⁰	^Pearson	^NSW	^AR258714	^25/4/2014	^4/5/2014
¹⁰²	^{Intro to Information Systems}	^Rainer	²⁰¹²	^Wiley	^QLD	^HC258321	^10/2/2014	^16/2/2014
¹⁰³	^{Database systems}	^Coronel	²⁰¹¹	^Cengage	^VIC	^AR258714	^25/4/2014	^6/5/2014
¹⁰⁴	^Management	^Cole	²⁰¹³	^Pearson	^NSW	^KX25894	^15/3/2014	^23/3/2014
¹⁰²	^{Intro to Information Systems}	^Rainer	²⁰¹²	^Wiley	^QLD	^WC258568	^20/2/2014	^27/2/2014
¹⁰³	^{Database systems}	^Coronel	²⁰¹¹	^Cengage	^VIC	^PS258963	^25/5/2014	^2/6/2014
¹⁰²	^{Intro to Information Systems}	^Rainer	²⁰¹²	^Wiley	^QLD	^BW258541	^18/4/2014	^26/5/2014

NOTE - Manually drawing the dependency diagram or the relational schema is NOT acceptable.

Reference no: EM131033818

Questions Cloud

Pertinent ethical issues and points of ethical conflict : Put yourself in the role of a recall coordinator for Ford Motor Company. It is 1973 and field reports have been coming in about rear end collisions, fires and fatalities. You must decide to whether to recall the automobile. Identify the pertinent et..

Group action plan on a social issue or opportunity : There are TWO parts to the assessment: Group action plan on a social issue/opportunity. Presentation or Campaign Video (10%) In week 12 classes, each group will present the social action plan to the class

Weighted moving average in which registrations in most year : The operations chief of Goldman Sachs is trying to estimate the number of job applicants that she will receive next year. Recent data is as follows: Develop a 2-year moving average to forecast registrations from year 3 to year 9. Estimate demand ag..

Increase the insolvency risk of an fi : Do the contingent risks of interest rate, takedown, credit, and aggregate funding tend to increase the insolvency risk of an FI? Why or why not?

Create an erd to show the resultant tables : Normalise the table to 3NF - Use correct dependency diagram/s to show each normalisation level.

You feel your writing can always be improved : You feel your writing can always be improved, or are you tempted to say, "Enough is enough!" If you believe in revision, share one thought or experience that might help someone else. If you don't, share that, too.

How the new architecture supports the goals and strategy : "Enterprise architecture (EA) at American Express was the framework the organization used to align IT and the business. EA provided a common language for leaders to use to collaborate and transform the business. What are the key components of the arc..

Using the exponential smoothing method : Given an actual latest demand of 59, a previous forecast of 64, and α = 0.3, what would be the forecast for the next period using the exponential smoothing method?

What is increase in productivity due to process improvement : A manufacturing industry has introduced a process improvement that reduces processing time of each unit of the product. As a result of the process improvement, the output has increased by 25% with less material but one additional worker is required. ..

User Account

All Pages