Using MYSQL Instructions This assignment has two 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. Submission Details •Name your report SU_ITS3102_W1_A3_LastName_FirstInitial.doc. •Submit your document to the Submissions Area by the due date assigned.

You are a data mining consultant hired by your organization to implement a data mining process. What challenges does your organization face in ensuring that the data mining models are receiving clean data?250 words

Read Chapters 9 & 10 For this assignment, you must reply to this post and address the questions below, prior to 11:59 p.m. ET on Thursday, February 18th. Continue to follow your classmates' posts for the remainder of the week and post follow-up messages to at least two of your classmates' posts prior to 11:59 p.m. ET on Sunday, February 21st. Your follow-up posts can add additional insight to a classmate's opinions or can challenge their opinions. Use examples from the readings, or from your own research, to support your views, as appropriate. For your follow-up posts this week, you may wish to visit a couple of the web sites contributed by your classmates and share your opinion of these sites with the class. Be sure to read the follow-up posts to your own posts and reply to any questions or requests for clarification. You are encouraged to conduct research and use other sources to support your answers. Be sure to list your references at the end of your post. References must be in APA citation format.  All posts must be a minimum of 250-300 words. All follow-up posts to your classmates must be a minimum of 150 words for each required post. Peer responses posted after 11:59 pm on Sunday evenings will not be accepted or calculated into the weekly forum grade.  Discussion Grading Rubric (100 Points)Synthesis of Concepts55Clear Citations using APA format10Writing Standards10Peer Reviews (minimum of 2) - Responses posted after the current week will not be accepted25Timeliness - 10% penalty per week for late work  - - - -- https://youtu.be/sreWy3higfo 1.Research the limitations to mobile forensics. (HINT: look at the new iPhone and Android). Please discuss the limitations to forensics investigators in regard to the new and old models. What will investigators need to do in order to retrieve information/evidence from the device? Student 1: NATHANIEL MEREDITH Week 6 Discussion Mobile forensics covers a wide array of products, not just mobile phones. This can make a mobile investigator’s job quite difficult at times, as there are a wide array of products to deal with. Not only this, but mobile products are actively upgraded and improved, especially in security and encryption capabilities. This can limit how much information a mobile investigator can pull from a mobile device. An article from MSAB summarizes the concept fairly well, “Extracting data from unlocked smartphones is a relatively straightforward task. But accessing locked devices can prove challenging. Manufacturers are developing password and encryption schemes that make it practically impossible for law enforcement agents to access the data” (Eichbaum, 2019). Eichbaum continues by explaining that almost as soon as a vulnerability is found, it is almost immediately patched. This means most new phone models can be tough to crack open. However, there are software and hardware tools that can assist in dumping raw data from the device, thus bypassing some security protocols (Eichbaum, 2019). This continual improvement and push to find vulnerabilities and alternative methods to accessing new phone data will ensure that law enforcement can continue to analyze seized phone data. On the other hand, some older phone models are still in use and are no longer actively updated. This means any vulnerabilities that are found may not be patched and therefore give law enforcement a way to extract information from these devices. With the use of these older devices comes the issue that less people are focusing on ways to extract data from them. Some of these phones, like feature phones, have unique ways of storing data. “In order to handle such phones, law enforcement members need proper training to ensure safe preservation of the extracted data” (Eichbaum, 2019). Overall, mobile forensic investigators will see many more limitations when compared to other digital forensic fields due to the large variety in devices and the active update capabilities that come with them. References: Eichbaum, J. (2019, October 31). Five continual challenges with SMARTPHONE FORENSICS. Retrieved from https://www.msab.com/2019/09/09/five-continual-cha... Reiber, L. (2016). Mobile forensic investigations: A guide to evidence collection, analysis, and presentation. New York, New York: McGraw-Hill Education.   Student 2 ADRIAN OLIVERIO Week 6 Discussion Advancements in technology have become both beneficial and hurtful to mobile forensics. On one hand, the amount of data that can be recovered from devices now-a-days is massively more incriminating than that of old devices with less features. On the other hand, new obstacles have been created for investigators. “One of the biggest forensic challenges when it comes to the mobile platform is the fact that data can be accessed, stored, and synchronized across multiple devices. As the data is volatile and can be quickly transformed or deleted remotely, more effort is required for the preservation of this data. Mobile forensics is different from computer forensics and presents unique challenges to forensic examiners” (Mahalik & Tamma, 2016). New phones such as the new Samsung or the new iPhone are starting to use cloud storage as the primary storage location for certain files. This can be beneficial to users because they can access those files anywhere on many different devices, but for investigators it creates another layer that they have to gain access to so they can obtain the data. Other limitations or obstacles include differences in hardware and software between devices, Mobile platform security features such as two factor authentication, and Anti-forensic technique possibilities on the devices. The differences in hardware and software makes it so investigators have to have a broad knowledge base on how to analyze all of the different hardware and software utilized in mobile technology. Two Factor Authentication can also be a burden to investigators because it creates an extra layer that investigators will have to get past. This could slow down an investigation or lead to investigators not getting the evidence all together. Lastly, “Anti-forensic techniques, such as data hiding, data obfuscation, data forgery, and secure wiping, make investigations on digital media more difficult” (Mahalik & Tamma, 2016). In order to capture all of the evidence behind the obstacles mentioned above, investigators need to be prepared. They need to have knowledge of all of the different cloud location and how to access them in situation where they are unable to obtain the data from the mobile device. They also need to be aware of two factor authentication methods used. They will have to either gain access to the person’s authentication account or get a warrant to serve the company who handles the 2FA. Finally, they have to also be vigilant in looking for any anti-forensic techniques and preventing future issue like remote data wipe. Reference: Mahalik, Heather & Tamma, Rohit (2016, April 25) Mobile Forensics and Its Challenges. Retrieved from https://hub.packtpub.com/mobile-forensics-and-its-...