please find the assignment attached below 

these are the poems; choose one and do the assignment on it.

Emily Dickinson, “After great pain, a formal feeling comes”: https://www.poetryfoundation.org/poems/47651/after-great-pain-a-formal-feeling-comes-372 (Links to an external site.)

Emily Dickinson, “Crumbling is not an instant’s Act”: https://www.poetryfoundation.org/poems/56823/crumbling-is-not-an-instants-act-1010 (Links to an external site.)

Emily Dickinson, “I felt a Funeral, in My Brain”: https://www.poetryfoundation.org/poems/45706/i-felt-a-funeral-in-my-brain-340 (Links to an external site.)

Emily Dickinson, “I heard a Fly buzz – when I died”: https://www.poetryfoundation.org/poems/45703/i-heard-a-fly-buzz-when-i-died-591 (Links to an external site.)

Emily Dickinson, “Much Madness is divinest Sense”: https://www.poetryfoundation.org/poems/51612/much-madness-is-divinest-sense-620 (Links to an external site.)

Charlotte Mew, “On the Asylum Road”: https://www.poetrynook.com/poem/asylum-road

This assignment has 3 parts:

1. Hands-on lab
2. Course project

Part I-Hands-on Lab

For this assignment, you will display information from a Microsoft Access database by using SQL commands.

Using the Microsoft Access database Theresa’s Trees, write SQL statements for the given tasks. Once complete, copy the SQL statements from Microsoft Access and paste them in a Microsoft Word document that will be submitted along with part II of the assignment.

Write an SQL statement:

• To display all the information from the Customer table
• To display each shipping date for customer 1 from the Invoice table

Note: Display both the customer number and the shipping date.

• To display the names of all the trees that cost at least $200.00
• To display all the information for invoice number 2
• To list the phone and last name of all customers
• To list the phone, first name, and last name of all customers whose last name starts with “J”
• To return the number of customers
• To determine the average total invoice amount
• To show all the items ordered from invoice number 3 To show the first and last names along with the invoice number of all customers with an invoice of at least $250.00

Part II-Course Project

This part of the assignment is a detailed project designed to help you learn the modeling of business requirements and understand the physical implementation of logical business models through the use of E-R models.

Through each week’s project, you will be adding to the course project. You will be assigned tasks each week, which you will complete and submit as directed.

Course Project Part 1—Database Planning

For this week, imagine that you have been hired by a company to build a database for it and complete the following tasks:

• Describe your idea of the database.
  • This can be a business problem or a hobby you are interested in—for example, an airline reservation system.
• Outline the database you would like to create.
• Outline the SDLC. Include the following subcategories:
  • Strategy and analysis for a business or an idea you plan to develop
  • Analysis of the current system:
    • What does the company have?
    • What business projections does it have?
  • Integration with other systems—plan how the current system can be integrated with other systems
  • Documentation and communication—describe how this vital part will be accomplished
  • Design for changes—prepare a plan for the future
  • Reusable resources—do not redo work; identify what the company has in place that you can use

(This is the best part of the project—you create everything!)

Note: Whatever you create is fiction and the above-mentioned six items will need to be addressed in the final document.

Assignment Deliverable

After you complete the lab and course project, collate the information from both in a 3- to 4-page report in a Microsoft Word document.

Part III-Course Project MIcro-ECONOMIC

Supply and Demand Concepts

As an economist for ABC Plastics, your boss has asked you to respond to some questions she has regarding the company’s main product, tablet cases. A marketing research firm recently developed the following supply and demand schedules for tablet cases:

Price/Case	Quantity Demanded	Quantity Supplied
$24	5000	18000
22	6000	17000
20	7000	16000
18	8000	15000
16	10000	14000
14	11000	13000
12	12000	12000
10	13000	11000
8	14000	10000
6	15000	9000
4	16000	8000
2	17000	7000

You are to develop a report addressing the following questions and present your findings to the Board of Directors:

Questions:

1. Construct a graph showing supply and demand in the tablet case market, using Microsoft Excel.
2. How are the laws of supply and demand illustrated in this graph? Explain your answers.
3. What is the equilibrium price and quantity in this market?
4. Assume that the government imposes a price floor of $16 in the tablet case market. What would happen in this market?
5. Assume that the price floor is removed and a price ceiling is imposed at $8. What would happen in this market?
6. Now assume that the price of tablet cases drops by 50%. How would this change impact the demand for tablet cases? Explain your answer and reconstruct the graph developed in question one to show this change.
7. Assume that incomes of the consumers in this market increase. What would happen in this market? Explain your answer and reconstruct the graph developed in question one to show this change.
8. Assume that the number of sellers decreases in this market. What would happen in this market? Explain your answer and reconstruct the graph developed in question one to show this change.
9. Explain the difference between a normal good and an inferior good. Would your answers to question #7 change, depending on whether this good is a normal or inferior good? Why or why not?

Submission Details:

• Present your analysis in Microsoft Excel format. Enter non-numerical responses in the same worksheet using textboxes.
• Submit to the Submissions Area by the due date assigned.
• All submissions must be original and all resources must be properly acknowledged.

Please answer all the questions correctly in the attachement.

Question 1

Apply C++ language to program a Mastermind game. Some of you may be familiar with the game where the player is to guess the colours of four hidden pegs. Our program will use char (between ‘a’ and ‘h’) to simulate the pegs.

You should use arrays to store both the hidden codes and the player’s guesses. Write individual functions to implement each of the following specification of the game.

(a) You should start the game with a welcome message. It should include your name, PI number and a short introduction. Figure Q1(a) shows a sample welcome message.

Figure Q1(a): Welcome Message
(4 marks)

(b) Initialisation – Your program needs to declare arrays and initialise them with appropriate values for both the hidden codes and the player’s guesses. You need to use a random generator to simulate the hidden codes. (4 marks)

(c) Display – Your program needs to display the player’s guesses and the pins that are awarded. Figure Q1(c)(i) shows the initial display after the welcome message. Figure Q1(c)(ii) shows the result after three guesses.

Figure Q1(c)(i): Initial display

Figure Q1(c)(ii): After Three Guesses
(4 marks)

(d) Awarding Pins – your program should compare the player’s input against the hidden codes. If an input matches a hidden code and is in the correct position, then a black pin is awarded. If an input matches a hidden code but is in a wrong position, then a white pin is awarded.

No pins are awarded if none of the inputs matches any of the hidden codes. If there are duplicate letters in the input, there must be a one-to-one match for a pin to be awarded. (8 marks)

(e) Playing the game – Your program should prompt the player to input the letters. It should validate that the letters are between ’a’ and ‘h’ inclusive. A final message is displayed when the game ends i.e. either the player wins or loses the game.

Figure Q1(e)(i) and Figure Q1e(ii) show the message displayed respectively if the player wins or loses the game.

Figure Q1e(i): Player wins the game

Figure Q1e(ii): Player loses the game

You should also write a main() function to run the program by calling the functions you have implemented above.. (10 marks)

Question 2

A SimpleQuaternion can be represented by four data members namely real, vi, vj and vk. All data members are integers.

Identify suitable coding modules for the SimpleQuaternion class with the following specifications:

(a) Define the four data members: real, vi, vj and vk.
(3 marks)

(b) Implement a parameterised constructor that receives four arguments that represent the values of real, vi, vj and vk respectively. The constructor will initialise the three data members with the arguments with the following rules. (5 marks)

(c) Overload the << operator so that the statements

SimpleQuaternion sq1(2, 3, 4, 5); cout << “sq1 = ” << sq1;

will produce the result

sq1 = (2, 3i, 4j, 5k)
(5 marks)

(d) Overload the + operator so that two instances of SimpleQuaternion can be added using the + operator.

For example sq1 = (5, 2i, 6j, 8k) sq2 = (3, 5i, 7j, 6k) sq3 = sq1 + sq2 = (8, 7i, 13j, 14k)
(5 marks)

(e) Overload the * operator so that two instances of SimpleQuaternion can be multiplied using the * operator.

Given that q1 and q2 are Simple Quaternions. Let q1 = (a1, b1i, c1j, d1k) and q2 = (a2, b2i, c2j, d2k) The product (q1 * q2) is ( a1a2 – b1b2 – c1c2 – d1d2, (a1b2 + b1a2 + c1d2 – d1c2)i, (a1c2 + c1a2 + d1b2 – b1d2)j, (a1d2 + d1a2 + b1c2 – c1b2)k )

For example sq1 = (5, 2i, 6j, 8k) sq2 = (3, 5i, 7j, 6k) sq3 = sq1 * sq2 = (-85, 11i, 81j, 38k)
(8 marks)

(f) Overload the == operator so that we can check whether two instances of SimpleQuaternion are equal. Two instances are equal if each element in one instance is equal to the corresponding element in the other instance. (5 marks)

(g) Write the main function that will demonstrate how all the operators can be used. (4 marks)

Question 3

Implement a C++ program that helps to explain the syntax and use of data structures such as arrays and pointers. These data structures form part of the data members and constructors in a C++ class.

(a) Declare the data members of MonthlySales class as follows:

(i) A string representing the month and year e.g. “January 2019” when the sales are made.

(ii) An integer representing the number of sales invoices in the month.

(iii) Three dynamically locations large enough to store the name of customers, invoice number and the amount invoiced.

The locations are referenced by three pointers string* customer. int* invNo, double* amount. (4 marks)

(b) Implement an application using the C++ language in an object-oriented style. Constructors and destructor are used to initialise and remove objects in an object- oriented manner.

You are asked to write the following constructors to initialise a MonthlySales object and a destructor to remove it from memory.

(i) A parameterised constructor
(5 marks)

(ii) A default constructor (Assuming that there are at least three invoices, you may use any valid default values for the data members) (4 marks)

(iii) A copy constructor
(6 marks)

(iv) A destructor
(2 marks)

(c) Write a main() function to demonstrate how the constructors in part (b) are being used. (4 marks)

Question 4

Appraise the use of sprites and sprite sheet in SDL programming. You are required to write a SDL program that loads a sprite sheet as shown in Figure Q4(a).

Figure Q4(a)

Using the above sprite sheet, the SDL program should produce the following graphical output as shown in Figure Q4(b).

Figure Q4(b): Output of SDL program

Replace the title of the window “John Tan A1234567” with your name and id. The size of the window should be just big enough to show the entire output.

Note that all the circles in the sprite sheet have different colours and therefore the output of your program should show the semi-circles in the corresponding colours. (10 marks)

Police received a tip that a man has been selling drugs out of his house and that there are several teenagers who work for him as peddlers. Two officers stopped him outside his house and asked if he would accompany them to the station to answer some questions. He agreed to come along.

On the way to the station, the officers pointed to children walking around and mentioned that penalty is heavy for those who sell drugs to children, or involve them in selling drugs. The suspect said, “Hey, I may have dealt some drugs, but I have never sold to kids or dealt with kids.“

When they arrived at the station, the officers arrested him and read him his rights, based on the tip they had received initially, and his admission to selling drugs. Then he was taken to a room and confronted with being the center of a drug ring that uses teenagers to distribute drugs. He asked, “Maybe I should call my lawyer?“ The officers replied, “Telling us the truth will do much more for you than seeing a lawyer.“ The man admitted to his involvement and called his lawyer afterward.

Based on the case study for this week, submit a 6- to 8-page case analysis using Microsoft Word that answers the following questions:

• Assume that you are the judge on this case. What motions to dismiss would you expect to hear from the defense in the case? How would the prosecution counter these motions?
• What are the key issues arising from the defendant’s admission made while in the police car? Is the case within the ambit of Miranda, or outside it? Why do you think so?
• Should the defendant’s admission in the police car be admissible? Why or why not? Discuss with reference to United States v. Patane (2004).
• What are the key issues surrounding the defendant’s admission while at the police station? Explain in detail with reference to the Miranda warnings and the fact that during interrogation the defendant had mentioned, not demanded, a lawyer.
• Should the admission made at the station be admissible? Why or why not?
• What would have been the effect on this case if the suspect had not asked for his lawyer? Discuss with reference to Escobedo v. Illinois.
• What evidence could be added to the scenario to strengthen a defense attorney’s motion to dismiss the evidence? What evidence could be added to weaken it?