you will create a star schema for Bobs Fixit case study. The star schema will allow Bob to get a better understanding of his customers.

Here are the requirements for the star schema.

Bob would like to know the following:

1. The sum of the bid dollar amount by the customer zip code and customer state

2. The sum of the bid dollar amount by the bid month and bid year.

You only need to create the star schema. You do not need to insert rows into your star schema or select any data from your star schema (tables). You only need to use DDL (create table commands) to create the star schema. Once you have completed all your DDL copy and paste the scripts into a word document and submit the document to the link above.

bobs scenario:

"

Case Study

Bob owns a small company called Bobs Home Repairs. He does the small home repair jobs that the large companies pass by.

Here is how the business works:

A customer calls Bob and asks him to bid on a home repair. He drives over, looks at the situation, and provides the customer with a bid. A customer can have more than one bid based on the repair.

Bob decides how long it will take to do the repair (he bills by the hour), how much material will be needed and an overall price. Bob doesnt bill his customers until the work is complete. Bob allows his customers to make monthly payments on the total amount.

Bob purchases material from multiple suppliers. The suppliers allow Bob to purchase material on credit. Bob makes monthly payments to each supplier based on the minimum monthly amount due.

Currently, all business records are kept in Bob's head and in one file cabinet. This doesnt allow Bob to scale his business because he is busy with manual bookkeeping. So, he wants to computerize these elements of the business to make things more efficient. Can you help him?

"