A start-up is working on an online personal financial management system. The goal of the system is
Question:
To provide this capability, the system maintains the following data regarding the transactions:
Based on the facts stated above,
a. Identify the functional dependencies between the attributes.
b. Identify the reasons why this set of data is not in 3NF and indicate the normal form (if any) it is in.
c. Including all intermediate stages, organize the attributes into a set of 3NF relations.
d. Draw an ER diagram based on the normalized relations.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Question Posted: