We are seeking a skilled freelancer to transform an ER diagram into a visually appealing graphical relational schema using draw.io. The successful candidate will not only convert the diagram but also construct a single graphical relation that accurately represents our database structure. Attention to detail and proficiency in using draw.io are essential. If you are passionate about database design and visualization, we would love to hear from you.
Assignment intructions:
1. Transform the ER diagram into a graphical relational schema using draw.io. Make sure to
include primary keys, foreign keys, and relationships. Do not include dependency arrows,
and do not create any surrogate keys (i.e., no new ID fields that are not present in the
diagram).
2. Construct a single graphical relation (one row of boxes) to represent the entire
dataset. Make sure to denote the primary key(s) and diagram all functional
dependencies. Do not create any surrogate keys (i.e., no new ID fields that are not
present in the data).
b. What is the normal form of the raw data (before any normalization)? Be specific with
your reasoning. Why is it in X normal form and not in Y? Give your answer as a text box
in the same sheet as part a.
c. Break down the data into third normal form and draw a graphical relational schema
using draw.io. Make sure to include primary keys, foreign keys, relationships, and
dependencies. Diagram the functional dependencies and relationships using arrows with
different color or style. Do not create any surrogate keys. Place this diagram on the
same sheet as part a.