Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Create a Database that will contain at least 4 different tables 2. Create the schema based on your plan/requirements 3. Populate the 4 tables

1. Create a Database that will contain at least 4 different tables 2. Create the schema based on your plan/requirements 3. Populate the 4 tables in the schema with data All fact tables must have at least 30 lines of data each if not more. They dont need to have an equal number of records, tables can be designed as both dimension and fact tables. So dimension tables can have 10 or more records, while fact tables should ideally have more than dim tables. 4. Create views for end users similar to what we saw during our sessions Have a rationale for each view that you may create 5. Apply at least 10 SQL functions through queries (Filters, Joins, Sub-queries, CTEs, etc.) - The more diverse the set of functions applied to the data, the better the project will be regarded

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Budgeting Auditing And Evaluation Functions And Integration In Seven Governments

Authors: Andrew Gray

1st Edition

0765807246, 9780765807243

More Books

Students also viewed these Accounting questions