Extending the book dimension
In the video, we saw how the book dimension differed between the star and snowflake schema.
The star schema's dimension table for books, dim_book_star, has been loaded and below is the snowflake schema of the book dimension.
In this exercise, you are going to extend the star schema to meet part of the snowflake schema's criteria. Specifically, you will create dim_author from the data provided in dim_book_star.
Bu egzersiz
Database Design
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Create dim_author with an author column
CREATE TABLE ___ (
___ ___ NOT NULL
);
-- Insert distinct authors
INSERT INTO ___
SELECT ___ ___ FROM ___;