2. DATA INGESTION

Start by populating the MC_MENU_CATEGORY and MC_MENU_ITEM tables. These tables correspond to

the spreadsheet attached to this assignment.

You DO NOT need to work with SQLLDR. Instead, you can copy the content of those table

directly from my account (hc848).

select from hc848. MC_MENU_CATEGORY;

9 records

select * from hc848.MC_MENU_ITEM;

260 records

Then, provide the screenshot below.

Screenshot (2.5 points)

Check 1

Query (SQL)

Screenshot

Include a screenshot resulting from the following query to show you have all

required tables created and the two tables above populated.

count(*) from MC_MENU_CATEGORY

select USER, 'MC_MENU_CATEGORY'

UNION ALL

I

select USER, 'MC_MENU_ITEM'

UNION ALL

select USER, 'MC_90_DAYS_MEAL_TYPE', count(*) from MC_90_DAYS_MEAL_TYPE

UNION ALL

select USER, 'MC_90_DAYS_MENU'

UNION ALL

select USER, 'MC_90_DAYS_MENU_ITEM', count(*) from MC_90_DAYS_MENU_ITEM;

I

count(*) from MC_MENU_ITEM

I

count(*) from MC_90_DAYS_MENU