DBM 298 Week 5 Individual Assignment Final Flight Data Mart Project with Reports
This is the final portion of a cumulative database project. You will need to include your entire flight data mart files from the previous weeks. In Week Five, you will enhance your data mart by creating the following queries:
Write three SQL queries from your flight data mart that would be useful for management on a monthly basis. Write three SQL queries that would be useful for management on a yearly basis.
Submit a single document that contains the text of each query (suitable for copying and pasting - no images) and a screenshot of the output from the query. Write an explanation of why these queries would be essential.
Review your Flight Data Mart that you have created throughout Weeks Two through Five, along with any feedback you received from your instructor.
Ensure you have successfully completed the following:
- Selected an appropriate hardware platform for a data warehouse
- Designed and implementeda data warehouse
- DevelopedTools for data extraction, transformation & loading
- Cleansed Data by using Data Quality Services
- Created databases & database objects
- Demonstrated an understanding of SQL Server Security
- Secured a SQL Server and objects
- Created a backup for databases
- Created databases and objects using Data Manipulation Language (DML) statements
- Modified data and created indexes and triggers
Submit all of your files, scripts, SQLs and screenshots for your Flight Data Mart with Reports in a single .zip file, to the Assignment Files tab above.
Questions & Answers
Have a Question?
Be the first to ask a question about this.