Indexing & normalisation
Indexing Exercises
A) Employees and departments dataset
The employees from employees and departments receive very few new employees every year. But external API calls uses the database many times daily to view retrieve data of each departments location. What is the current status of the database and how could it be improved?
B) Spotify dataset
Data scientists of spotify have identified that 99% of users always searches for a song according to its title and popularity. Implement a solution that could speed up their requests.
C) Coffee dataset
Coffee inc. have begun selling coffee online with drone delivery. What column(s) should mainly be monitored for query performance? And why?
Normalisation
Ensure the following scheme are in 3NF - present changes (if any) and clarify why
A)
store(store_id, manager_id, longitude, lattitude, continent, country, revenue, goal_revenue, staff_size)
B)
C) Consider the pokemon dataset
Arguably the dataset is in 3rd normal form - but is still susceptible to update anomalies due to data duplication. How can decomposition be utilized to reduce data redundancy?
Last updated