this is the script for week 9

create table DimSuppliers (supplier_id int primary key,suuplier_name varchar(30))create table DimDates (date_id int primary key,month varchar(10),year varchar(10))create table DimCustomers (customer_id int primary key,state varchar(30),zip varchar(12))create table FactPayments (payment_id int,supplier_id int,customer_id int,payment_month varchar(10),payment_year varchar(10),payment_amount money,primary key (payment_id, supplier_id, customer_id),foreign key (supplier_id) REFERENCES DimSuppliers(supplier_id),foreign key (customer_id) REFERENCES DimCustomers(customer_id))create table FactBid (bid_id int,customer_id int,bid_month varchar(10),bid_year varchar(10),bid_amount money,primary key (bid_id, customer_id),foreign key (customer_id) REFERENCES DimCustomers(customer_id))

now do this:

populate each table with a minimum of four rows of sample data.