Question: ( 2 8 points ) The file programming _ languages.xlsx ( Picture included ) tracks information about 3 5 computer programming languages, including their creators,

(28 points) The file programming_languages.xlsx(Picture included) tracks information about 35 computer programming languages, including their creators, number of users, and number of published books about the language. The file also stores information on the Wikipedia entry for the language, though some languages do not have a Wikipedia entry. This data is adapted from a Kaggle dataset posted by user Sujay Kapadnis.
a. Construct a single graphical relation (i.e., 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 this data (before any normalization)? Be specific with your reasoning. Leave your answer as a textbox in the same sheet as parts a and c.
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. Create this diagram on the same sheet as part a and b.
 (28 points) The file programming_languages.xlsx(Picture included) tracks information about 35 computer

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!