Question: ( 2 8 points ) The file programming _ languages.xlsx ( Picture included ) tracks information about 3 5 computer programming languages, including their creators,
points The file programminglanguages.xlsxPicture included tracks information about 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 ie one row of boxes to represent the entire dataset. Make sure to denote the primary keys and diagram all functional dependencies. Do not create any surrogate keys ie 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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
