Okay, let's see the second one! The subscription table is basically a junction (associative) table that contains primary keys from the newsletter and dim_customer tables along with a flag denoting whether a subscription is still active and a column indicating the last updated timestamp. See the subscription table structure below:

CREATE TABLE subscription (
  newsletter_id int NOT NULL,
  customer_id int NOT NULL,
  start_timestamp timestamp(0)
);