Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started