i will be attaching multiple documents follow the formulas given do not create any formulas and follow the rubric milestone 2 and the final milestone need to be completed

Shelly owns a hardware store and would like a database that would help track her customers and their purchases. It should be able to keep track of the customers’ first and last names along with their street address, city, state, ZIP code, and main phone number. In addition, the database should track all of the customers' invoices along with the invoice date.  Each order line should list the products (through the ProductID) along with the quantity of that product. For example, if a customer orders 2 hammers then the quantity (2) is listed in this table.  You database must also track each product along with its price and manufacturer. Create a new database for this assignment. Then create the tables and relationships depicted in the assignment document. Populate the tables by entering enough sample data to demonstrate the functionality of your database. At the minimum, have at least  5 customers,  8 invoices (some customers have 2 or more invoices),  each invoice must include at least 2 products,  10 unique products

Prior to beginning your written assignment, read Kim’s Fourth Amendment (Links to an external site.)Links to an external site. article, Machado’s Fourth Amendment article, view the Fourth Amendment: Exceptions to the Warrant Requirement (Part I) (Links to an external site.)Links to an external site. and the Fourth Amendment: Exceptions to the Warrant Requirement Part II) (Links to an external site.)Links to an external site. videos, and review the Supreme Court Opinion synopses. You may want to review the recommended resource, Fourth Amendment Remedies as Rights: The Warrant Requirement article, for a more complete understanding of the Fourth Amendment and remedies for its violation.Read the following case scenario:Linda Rhodes and her boyfriend, Joe Marshall, were arrested as a result of a drug raid. Linda was making dinner for her children, who were with her in the kitchen, and Joe, who was in the living room, when the police, led by Sgt. Rick Rodgers, broke down her door. Linda owns the house. Joe has no ownership interest in the house but has been living there for the last year. The police found several ounces of cocaine, packaging material, scales, and a large amount of currency in small denominations in Linda and Joe’s bedroom. The cocaine was found in a dresser drawer, but the rest of the items were on the bed in plain view. Both Linda and Joe were charged with possession of cocaine with the intent to distribute it.Joe Marshall has been arrested twice before for drug offenses. The first arrest was three years ago when he was charged with intent to sell, to which he pled guilty to possession and received five years’ probation. The second arrest was six months ago; however, the case was dropped for lack of evidence when the police evidence room lost the drugs.Joe was also arrested three times for domestic violence: five years ago and three years ago against his former wife, and three months ago for beating Linda. All the cases were dropped when the victims refused to testify.Linda has been arrested twice, eight and five years ago, for possession of marijuana. The first case was dropped when she identified her dealer. She pled guilty to the second charge and received one year of probation.Linda works for a maid service, cleaning private homes. Joe has no known employment and claims to be a musician. Linda’s income from the maid service is the only known source of income for the household.On the day in question, the police broke down the door without knocking or announcement. There was no other damage to the house, but the house was turned “upside down.” The police properly collected and tagged all of the evidence and immediately transferred it to the police evidence room. Both Joe and Linda claim to have no knowledge of the cocaine.The police questioned Linda’s daughters, Sally (age 3) and Sara (age 9). Sally was crying and had no coherent statement about the incident. Sara told the police that she saw Joe with the “white powder” and that he said it was for a bubble bath and a surprise for mommy and that Sara should “keep it secret.”An informant told Sgt. Rodgers about the cocaine. The informant’s name was not revealed, but he has provided reliable information in the past. The police were watching the house while waiting for a warrant. They claim they heard screams and decided to enter the house due to the knowledge that young children were in the house. The warrant was delivered one hour later.Research Fourth Amendment cases involving searches, warrants, and exigent circumstances.In your paper,Define probable cause and its relationship to determining the legality of a search.Explain the purpose and application of the exclusionary rule.Identify whether Joe had legal standing to object to the search.Describe whether the cash, packaging material, and scales admissible at trial if the police rely on exigent circumstances.Explain whether the evidence of the cocaine is admissible at trial.Identify whether the police had the right to go into the bedroom when relying on exigent circumstances.4th Amendment Application, the "Case of the Bad Boyfriend" paperMust be 750 to 1,000 words in length (not including title and references pages) and formatted according to APA style as outlined in the Ashford Writing Center’s APA Style (Links to an external site.)Links to an external site.Must include a separate title page with the following:Title of paperStudent’s nameCourse name and numberInstructor’s nameDate submittedFor further assistance with the formatting and the title page, refer to APA Formatting for Word 2013 (Links to an external site.)Links to an external site..Must utilize academic voice. See the Academic Voice (Links to an external site.)Links to an external site. resource for additional guidance.Must include an introduction and conclusion paragraph. Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.For assistance on writing Introductions & Conclusions (Links to an external site.)Links to an external site. as well as Writing a Thesis Statement (Links to an external site.)Links to an external site., refer to the Ashford Writing Center resources.Must use at least three court cases and one scholarly source.The Scholarly, Peer-Reviewed, and Other Credible Sources (Links to an external site.)Links to an external site. table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.To assist you in completing the research required for this assignment, view this Ashford University Library Quick ‘n’ Dirty (Links to an external site.)Links to an external site. tutorial, which introduces the Ashford University Library and the research process, and provides some library search tips.Must document any information used from sources in APA style as outlined in the Ashford Writing Center’s Citing Within Your Paper (Links to an external site.)Links to an external site.Must include a separate references page that is formatted according to APA style as outlined in the Ashford Writing Center. See the Formatting Your References List (Links to an external site.)Links to an external site. resource in the Ashford Writing Center for specifications.