Normalisation
Normalisation
1. Using the table and data given below, normalise the table to 3NF.
2. Use correct dependency diagram/s to show each normalisation level.
3. Create an ERD to show the resultant tables at the 3NF level with all the attributes, Primary/Foreign keys, relationships, etc.
1. Book_ID Book_Title Bk_ Author Date_Published Publisher Publ_Location Borrower_Num D_Borrowed D_Returned
101 Management of Information Systems Laudon 2010 Pearson NSW AR258714 25/4/2014 4/5/2014
102 Intro to Information Systems Rainer 2012 Wiley QLD HC258321 10/2/2014 16/2/2014
103 Database systems Coronel 2011 Cengage VIC AR258714 25/4/2014 6/5/2014
104 Management Cole 2013 Pearson NSW KX25894 15/3/2014 23/3/2014
102 Intro to Information Systems Rainer 2012 Wiley QLD WC258568 20/2/2014 27/2/2014
103 Database systems Coronel 2011 Cengage VIC PS258963 25/5/2014 2/6/2014
102 Intro to Information Systems Rainer 2012 Wiley QLD BW258541 18/4/2014 26/5/2014
NOTE
Manually drawing the dependency diagram or the relational schema is NOT acceptable.
Online submission via Turnitin is required for this assignment. Details will be provided by your subject lecturer.
Rationale
1. This assessment item is designed to test your understanding of more advanced database design, your ability to use an iterative approach to modelling, and to examine data problems due to redundancy.
2. Specifically you are required to apply the normalisation process to existing data in order to minimise redundancies and data anomalies.
Marking criteria
The marking criteria for this assignment are shown below:
Task HD DI CR PS
Draw a dependency diagram to show the functional dependencies in the relation The dependency diagram accurately identifies and correctly shows all PKs and all functional, partial, and transitive dependencies The dependency diagram accurately identifies and correctly shows all PKs and most functional, partial, and transitive dependencies The dependency diagram identifies and shows most PKs and some functional, partial, and transitive dependencies The dependency diagram identifies and shows few PKs and few functional, partial, and transitive dependencies
Decompose table into a set of 3NF relations The set of 3NF relations accurately identifies and correctly shows all PKs and all the relevant attributes The set of 3NF relations accurately identifies and correctly shows all PKs and most of the relevant attributes The set of 3NF relations identifies and shows most PKs and some of the relevant attributes The set of 3NF relations identifies and shows few PKs and few of the relevant attributes
Draw a relational schema for your 3NF relations and show the referential integrity constraints The relational schema accurately identifies and correctly shows all of the referential integrity constraints The relational schema accurately identifies and correctly shows most of the referential integrity constraints The relational schema identifies and shows some of the referential integrity constraints The relational schema identifies and shows few of the referential integrity constraints
Our Service Charter
-
Excellent Quality / 100% Plagiarism-Free
We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers. -
Free Revisions
We keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed. -
Confidentiality / 100% No Disclosure
We make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service. -
Money Back Guarantee
If the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit. -
24/7 Customer Support
We have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.