CIS 355 SQL Homework 10 points Use the Pine Valley Furniture Database in Access or SQLServer to answer the following questions. Show the SQL syntax (copy and paste) and the answer (copy and paste from the screen). 1) How many orders have been placed? 2) How many different customers do those orders represent? 3) What does the following query do? SELECT Customer_t.Customer_name, Order_t.Order_ID FROM Customer_t INNER JOIN Order_t ON Customer_t.Customer_ID = Order_t.Customer_ID; a. Describe the steps b. What question does it answer? c. Copy and paste the query into Pine Valley Furniture in Access or SQL Server. Compare the attribute names and make sure it runs. What did you have to do to make it run? Provide the answer to the query..

In this project, you are going to implement a single cycle CPU simulator called MiniCPU using C language. Your MiniCPU will demonstrate some functions of MIPS processors as well as the principle of the datapath and the control signals. MiniCPU should read in a file containing MIPS machine codes (in the format specified below) and simulate what the MIPS processor does cycle-by-cycle. A C file called component.c will be provided to you which implementing each component of the single-cycle datapath, you are required to modify and fill in the body of the functions in this file.

2. Specification of the simulator

2.1. Instructions to be simulated

The 14 instructions listed in Figure 1 in the appendix. Note that you are NOT required to treat situations leading to exception.

2.2. Registers to be handled

MiniCPU should handle the 32 general purpose registers. At the start of the program, the registers are initialized to be the values specified in minicpu.c

Explanation: