1. Create an initial Entity Relationship Diagram (ERD) for the above system. -­‐
marks 20 2. Normalise the attributes to Third Normal Form (3NF) showing all intermediate stages of Unnormalised Form (UNF), First Normal Form (1NF) and Second Normal Form (2NF). Be careful to highlight attributes used for keys. – marks 50 3. Name the 3NF relations and draw the 3NF Entity Relationship Diagram using the notation of soft boxes and crow’s feet. (You are not required to show optionality on relationships.) – marks 10 4. Compare the initial ERD with the 3NF ERD, discuss the differences and draw the final ERD for the system. – marks 20


Place your order now to enjoy great discounts on this or a similar topic.

People choose us because we provide:

Essays written from scratch, 100% original,

Delivery within deadlines,

Competitive prices and excellent quality,

24/7 customer support,

Priority on their privacy,

Unlimited free revisions upon request, and

Plagiarism free work,


Unlike most other websites we deliver what we promise;

  • Our Support Staff are online 24/7
  • Our Writers are available 24/7
  • Most Urgent order is delivered with 6 Hrs
  • 100% Original Assignment Plagiarism report can be sent to you upon request.

GET 15 % DISCOUNT TODAY use the discount code PAPER15 at the order form.

Type of paper
Academic level
Subject area
Number of pages
Paper urgency
Cost per page