Computer Science

The dependency diagram in figure below indicates that authors are paid royalties for each book that they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the book.

Book royalty dependency diagram

a. Based on the dependency diagram, create a database whose tables are at least in 2NF, showing the dependency diagram for each table

CR [10]

b. Create a database whose tables are at least in 3NF, showing the dependency diagram for each table.



Hillar Furniture Enterprise is a furniture store owned by Dr. Hillar Addo of AIT. The materials manager of this company maintains a list of suppliers for each of the materials items purchased by the company from outside vendors. The following table shows the essential data required for this application.

Hillar Furniture Company Purchasing Data is shown below:

Attribute Name


Material_ Name








Sample Value


Hinges 3” locking


GHC 5.00


Apex Hardware

GHC 4.75



a) Using the dependency diagram, identify the functional dependencies for this data. You may assume the following:

i. Each material has one or more suppliers. Each supplier may have supply

one or more items or may not supply many items.

ii. The unit price for a material may vary from one vendor to another

iii. The terms of a code for a supplier uniquely identifies the terms of a sale

(e.g. code 2 means 10% net 30 days, etc.). The terms for a supplier are the same for all material items ordered from that supplier.


b) Convert your data into a set of 3NF relations, identifying all the primary and foreign keys

My MasterPapers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Us

Outstanding Academic Writing Service

At, you are assured of professional essay writing help from the leading experts online. Quality comes at the forefront of our custom writing service to ensure that all our customers are satisfied with the work delivered. We value repeat customers. For this reason, we ensure that each task is completed to perfection for high scores.

Top Writers

Our hiring process is highly intensive. The writers are exposed to a strict selection procedure before hiring to ensure that we acquire the most qualified, well-educated and experienced writers. Our team of writers, professors, editors and researchers will ensure that you get incredible results.

Plagiarism-Free Papers

We highly discourage plagiarism. For this reason, we have trained our writers in such a way that all the papers are written from scratch and are free from plagiarism. We also pay attention to ensure that each paper is completed as per the instructions provided. Referencing and citations are done as per the paper format selected by the customer. These include: APA, MLA, Chicago, Harvard, Turabian among others.

24/7 Customer Support

You can contact our support team via the chat window at the bottom right corner. Alternatively, feel free to email us via our support email: Our team is available 24/7 to respond to your queries and guide you though where need be.

Swift Delivery & 100% Money Back Guarantee

Simply choose the desired deadline when placing the order. The task is assigned to the most qualified writer as soon as the order is successfully placed. All the papers are delivered to you within the deadline selected. In case a paper cannot be delivered within the deadline selected, we request for a deadline extension within the shortest time possible.

Free Unlimited Revisions

Our customers can always request for a revision in case they feel that something needs to be added or changed after the final paper has been delivered. We do not charge for revisions. However, we highly discourage our customers from misusing this policy.

Try it now!

Calculate the price of your order

Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services specializes in custom essay writing for all level of students. Simply relax as we get your paper done within the timeline indicated.


Academic Help Service

Our team of skilled writers and researchers is readily available to get any type of academic paper completed. We deliver high quality papers and projects to our customers to ensure that we maintain a long-term relationship that will shine your academic career.


Admission Essays & Professional Writing

An admission essay allows you to express yourself by providing personal details that wouldn’t have fit on other areas of an application. We have a team of experienced writers who will get you to the desired academic level through a professional and a personalized admission essay.


Editing & proofreading

Are you seeking for editing or proofreading help? We have a team of editors who will ensure that any issue within you paper has been addressed. Upload the paper to be cleaned up and relax as we get the job done.


Revision Support

At, you can always ask for revision in case you want some changes in you paper. We focus on ensuring that the grammar, research and formatting are done as per the latest academic writing standards.