Module 3 Homework Assignment (1)

send answer asap

I am having trouble with Tasks 10-12 Task 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW. Task 11: List all the columns contained within the system catalog, but only display the first 11 records that are in the KimTay TABLE_SCHEMA.  Task 12: List all the views contained within the system catalog, but only display the first 12 records.   I have done Tasks 1-9 Here is the formula for Tasks 1-9 TASK 1.   CREATE VIEW MAJOR_CUSTOMER AS SELECT CUST_ID,FIRST_NAME,LAST_NAME, BALANCE, CREDIT_LIMIT, REP_ID FROM CUSTOMER WHERE CREDIT_LIMIT <= 500 ; NEW QUERY SHOW FULL TABLES WHERE table_type = 'VIEW' and tables_in_KimTay = 'MAJOR_CUSTOMER'   TASK 2.  SELECT CUST_ID,FIRST_NAME,LAST_NAME FROM MAJOR_CUSTOMER WHERE BALANCE > CREDIT_LIMIT ;   TASK 3.  SELECT CUST_ID,FIRST_NAME,LAST_NAME  FROM CUSTOMER WHERE CREDIT_LIMIT <= 500 ;   TASK 4.  CREATE VIEW ITEM_INVOICE AS SELECT C.ITEM_ID AS ITEM_ID,…

Step 1 Introduction: The correct answer is option a. HIT Below is the Explanation Step 2 Explanation: HIT Number of blocks cache has = 83block offset = 1block number = 1 % 8 =1Tag = 1/8 =0 180block offset = 0block numbe

spreedsheet application

Please help with the following: Make two acceptance test for each user story card. 1.As a supervisor, I want to be able to modify inventory so that I can update product quantities

Use the content of the AdventureWorks sample database. Identify and explain which field on what table tells you whether a product will be built or bought?

I want Unique Answer Based on the dataset information given above, please answer the following questions. You are required to perform the following tasks using R Studio. Please provide the script and screenshot of the output. 1. Create a histogram with bins=10 to see the distribution in the number of pregnancies inside the dataset. Please include the proper header and label.