Data Warehouse Evaluation & Recommendation

*Please see attached document for details.

*

1- In a paragraph, write a simple design plan of a star schema for the convention center described above. Explain your decision for choosing the tables and fields that you think are needed to perform analytics.

2- Identify the tables and fields needed in the star schema. You can either list the tables with the corresponding fields, identifying the primary and foreign key fields, **or** include a snapshot of the star schema that shows the tables and fields. Do not include an actual database file. Do not show sample data with your tables.

3- Identify the relationships between the various tables.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Microsoft Access

Microsoft Word

Odd Jobs

Project ID: #3582902

About the project