Database Design

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


Looking for help with your homework?
Grab a 30% Discount and Get your paper done!

30% OFF
Turnitin Report
Title Page
Place an Order

Grab A 14% Discount on This Paper
Pages (550 words)
Approximate price: -

What Makes Us Unique?

Outstanding Quality is an essay writing service that helps High-school, college, University, Master’s and PhD students from distinct regions globally. Over the years, we have generated a wide range of assignments, in almost all fields. This has enhanced our ability to deliver high quality papers and outstanding work to such extents that we have retained most of our customers.

Experienced Academic Writers has invested in a highly selective hiring process that is unnatural and distinct from other companies. Additionally, our reward techniques and approaches are structured in ways that motivate our writers to give high quality work on all orders.

Free revisions

Our customers can freely place orders on revision on instances where they feel that something ought to be modified after the paper has been completed. However, we highly discourage our customers from misusing this policy.

Timely delivery

At, all papers, regardless of how URGENT, are completed within the deadline indicated by the client. At, we encourage our writers to submit work ahead of the deadline indicated to give ample time for the client to go through the work.

Plagiarism-Free Papers

All our papers are completed from scratch with strict adherence to the instructions provided by the clients. Customers can request for a plagiarism report at their own convenience.

24/7 Customer Support

You can simply get in touch with our customer support team via the chat window on the Bottom right corner or via the email:

Try it now!

Grab A 14% Discount on This Paper

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

Are you struggling with your academic work? Well, we are here to ensure that we complete the most daunting assignments/homework for you at affordable fee.


Custom Essay Writing Service

You can simply select the type of paper, which could be a research paper, essay, Coursework, Case study, among others. We understand that assignments and homework form an essential part of the learning curriculum. However, you might be held up at work, in family or other personal matters to an extent that you cannot complete a certain task yet it is mandatory for you to graduate. Simply click the place order button to get started.


Admission Essay

Regardless of the institution you are joining, your admission essay form a major component. The admission essay is the initial thing that the admission board look at. Therefore, it is important to make a good first impression as this really counts. We are here to ensure that we generate an admission essay that will get you accepted and one which is completed on time.


Editing and Paraphrasing

At, we understand that you might have completed your homework paper, but at the same time, you might be looking for professional writers to polish your work in terms of grammar, paraphrasing and plagiarism.


Urgent Papers

Are you experiencing the last minute rush? At, we can complete a task in less than 4 hours. Simply click the place order button and enter the order instructions.