Tag: Data Structures

  • [Solved] Help APA 1

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    APA Cite – 2 years ago **files (2)** – ## Lesson1Statementofwork.docx – ## Lesson1StatementofworkInfo.pdf **## Lesson1Statementofwork.docx** Answer the following in a separate word document. 1. How many items and which items can the consultant specifically do? 2. What type of methodology is being …

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    APA Cite

    – 2 years ago

    **files (2)**

    – ## Lesson1Statementofwork.docx

    – ## Lesson1StatementofworkInfo.pdf

    **## Lesson1Statementofwork.docx**

    Answer the following in a separate word document.

    1. How many items and which items can the consultant specifically do?

    2. What type of methodology is being used to conduct the penetration test?

    3. Is the consultant legally allowed to gain privileged access or attempt to exfiltrate data?

    4. Which section approves/denies this action?

    5. What software is being used to conduct the phishing campaigns?

    6. What is the name of the phases the consultant will use as part of their methodology?

    **## Lesson1StatementofworkInfo.pdf**

    S3-SOW-20-0001

    Initials 1

    CONSULTING SERVICES AGREEMENT

    Thank you for choosing JLA ENTERPRISE, LLC as the provider for your comprehensive cyber security needs.

    We will be providing monthly vulnerability and compliance scanning exclusively for your business. We are

    excited to be part of your team.

    This CONSULTING SERVICE AGREEMENT (“The Agreement”), is entered into on this date by
    and between JLA ENTERPRISE, LLC, a Georgia limited liability company (“The Consultant”) and ;

    CLIENT, LLC (“The Client”).

    (collectively, “The Parties”)

    1 Statement of Work

    1.1 Setup Services: The Consultant will perform the following actions to prepare for the Client's

    penetration test.

    A. The Consultant will install the latest version of Gophish software and conduct necessary updates,

    testing, documentation, and troubleshooting to perform the monthly phishing attacks against the

    Client. The Consultant will cover all licensing fees.

    B. The Consultant will acquire a dedicated server using linode.com hosting services. The Consultant

    will install Ubuntu Linux and update all installed software packages necessary. The Consultant will

    cover all licensing fees.

    1.2 Penetration Testing Services: The Consultant will assign a team to conduct open-source research,

    build phishing campaigns, attempt compromise against identified vulnerabilities, gain privileged access,
    and attempt to exfiltrate data. These services will be performed within the parameters of the agreed upon

    Consultant/Client rules of engagement as outlined below:

    A. Once the penetration test has started, it could take approximately seven weeks to complete and

    produce a report.

    B. The Consultant will conduct open-source research in accordance with Blackbox methodology as
    determined by the Client. The Consultant will acquire data regarding employee’s social media

    footprint as well as specific company data to include but not limited to employment, location, and

    services. Below are specific Client outcomes:

    I. Compromise of Executive's email

    II. Compromise of Executive's documents

    III. Compromise of financial information and financial systems

    IV. Monitoring audio or video especially Executive offices

    V. Access to sensitive Intellectual Property

    VI. Exfiltration of data

    C. The Consultant will use the information found in section 1.2B to create one to three phishing

    campaigns utilizing traditional phishing, spearphishing, or whaling methodology.

    S3-SOW-20-0001

    Initials 2

    D. The Consultant’s proprietary penetration testing methodology includes a five-phased approach:

    I. Reconnaissance – The Consultant will conduct open-research on the Client’s company to

    determine points of interest to further scan for vulnerabilities.

    II. Information Gathering – The Consultant will perform in-depth network scans to identify

    access vectors to gain access during the Exploitation phase.

    III. Exploitation – The Consultant will attempt exploitation against vulnerabilities and seek to
    gain privileged access based on findings from the Reconnaissance and Information

    Gathering phases.

    IV. Maintaining Access – The Consultant will maintain access on various points of interest during

    the penetration test to exfiltrate data.

    V. Cleanup – The Consultant agrees to remove all proprietary tools used during the penetration

    test and will remove persistence tools and user accounts from the Client’s systems.

    E. During particular circumstances, the Consultant may approach the Client to request switching the

    penetration test to white box methodology. The Consultant request would only be made after black
    box methodology has been exhausted. The Consultant can only switch penetration testing

    methodology if it is in the best interest of the Client.

    F. The Consultant’s penetration testing methodology is designed and operated on a measured risk
    basis, with safety for the Client’s systems and personnel at the forefront. The Consultant will

    communicate to the Client every vulnerability identified, for written approval, prior to an

    exploitation attempt.

    G. Penetration testing services will be conducted Monday through Friday from 6 PM to 8 AM after

    standard business hours, and anytime on Saturday and Sunday (The time is calculated for any time
    zone). Penetration testing service will be performed via electronic means; travel is not permitted. If

    the Client requests travel, the Client agrees to cover costs.

    H. At the end of the penetration testing service, the Consultant will produce a finding report. This

    report will contain the scope of work, executive summary, findings, methodology, screenshots per

    successful exploit, definitions of risk levels, systems information, and the Consultant’s

    recommendations.

    I. Retention of Results can be found in section 8.

    1.3 Penetration Testing Reporting: The Consultant will produce a report to the Client after the

    completion of the penetration testing services outlined in this Agreement. This report will contain the

    scope of work, executive summary, findings, methodology, screenshots per successful exploit, definitions

    of risk levels, systems information, and the Consultant’s recommendations.

    3 Compensation and Payment

    A. Set up Fees: For the Services described in this agreement, the Client setup fees are included in

    the ongoing management fees section below. The first month of vulnerability scanning service will

    act as an installation period. Reports for vulnerability scanning will start on the second month of

    service. Setup can take varying lengths of time, but will usually take around ten days.

    B. Network Vulnerability and Compliance Scanning Fees: For the Services described in this
    agreement, the Client agrees to pay to the Consultant $560.00 per month and should be paid via

    direct deposit, then check, if necessary. Payment is subject to net-10 payment rules.

    S3-SOW-20-0001

    Initials 3

    C. Additional Fees: Pending Client approval, if the Consultant has determined additional services
    are required such as, but not limited to: computer forensics, or in-depth vulnerability research, the

    Client will be billed at a rate of $250/hr. The Consultant and the Client will agree upon the number

    of additional hours required to provide additional services.

    4 TERM

    A. This Agreement will commence on the effective date first set forth above and remain in full force

    and effect for a minimum period of 365 days. This Agreement shall continue on a month to month

    basis unless otherwise terminated by the Consultant or Client or unless otherwise agreed to by the
    Consultant and the Clients.

    5 TERMINATION

    A. This Agreement may be terminated by either party for any reason or no reason, whether or not

    extended beyond the initial term, by giving the other party written notice 30 days in advance.

    Written requests to terminate may be made by e-mail. If Client chooses to terminate this
    agreement in writing, all monies owed to the Consultant will be due immediately. Under no

    circumstances will the Consultant give refunds of the amount paid for the Services hereunder.

    6 OWNERSHIP OF INTELLECTUAL PROPERTY

    All plans, reports, programs, software (source and object code), digital tools, pictures, video,
    music, content, artwork, designs, websites, framework, web services, software engines, products,

    models, footage, applications of any kind, work, ideas, derivative works, confidential information,

    concepts, deliverables, results of the services and all other tangible and intangible materials or
    property provided, prepared or created under or resulting from this Agreement, whether or not

    rejected by Client, and all copies thereof (collectively, the “The Materials”), shall be owned by
    Client and shall be deemed “works made for hire,” under United States copyright Laws (17 U.S.C. §

    101 or any future statute). Consultant represents, warrants and covenants that all Materials, along

    with all rights contained therein, including, without limitation, the exclusive copyright and all other
    intellectual property rights, are and shall be the property of Client immediately upon creation. If

    any of the Materials are considered by a court of competent jurisdiction not to be a “work made for
    hire” or under any circumstances where the full title and ownership thereof has not vested in

    Client, Consultant hereby assigns to Client all right, title, and interest in such Materials immediately

    upon creation and agrees to execute any future assignments to evidence or effect such
    assignments. Without limiting the generality of the foregoing, Client will have, and Consultant shall

    be responsible for ensuring Client has, the unlimited right to reproduce, transmit, distribute,
    exhibit, perform, create derivative works based upon, exploit or otherwise use the Materials, and

    all elements thereof, in any manner and in any and all media now known or hereafter devised

    throughout the world in perpetuity.

    7 CONFIDENTIAL INFORMATION

    A. Except as provided elsewhere in this Agreement, all information disclosed by one Party to the other
    Party shall be deemed to be confidential and proprietary (“Proprietary Information”). Such

    Proprietary Information includes, without limitation, information regarding marketing, sales

    programs, sales volume, sales conversion rates, sales methods and processes, sales proposals,
    products, services, vendors, customer lists, training manuals, sales scripts, telemarketing scripts,

    names of investors, and customer information, operating procedures, pricing policies, strategic
    plans, intellectual property, information about a Party’s employees and other confidential or

    Proprietary Information belonging to or related to a Party’s affairs. The Receiving Party

    acknowledges and agrees that in any proceeding to enforce this Agreement it will be presumed that
    the Proprietary Information constitutes protectable trade secrets and that the receiving Party will

    bear the burden of proving that any portion of the Proprietary Information was publicly or rightfully
    known and disclosed by the receiving Party. The Parties, their employees, subsidiaries, affiliates,

    agents, and assigns agree to hold all Proprietary Information, regardless of when or how disclosed,

    in strict confidence and with not less than the same degree of care that they provide for their own

    S3-SOW-20-0001

    Initials 4

    confidential and proprietary information. The Parties warrant and represent that the degree of care

    contemplated herein is adequate and the Parties will take any and all steps reasonably necessary

    to preserve such Proprietary Information.

    B. Nothing in this Agreement shall prohibit or limit the receiving Party’s use of information that can be

    demonstrated as: (a) previously known to the receiving Party, (b) independently developed by the
    receiving Party, (c) acquired from a third party, not under similar nondisclosure obligations to the

    disclosing Party, or (d) acquired through the public domain through no breach by the receiving

    Party of this Agreement.

    C. License. Client grants The Consultant a limited, nontransferable, nonexclusive license to copy,

    use, store, set up, publicly display, publicly perform and transmit any trade names, trademarks,
    service marks, copyrights, content, text, images, software, functionality, page and other design

    and layout, media and other materials therein and solely in connection with creation of the
    Campaign and direct response marketing in accordance with this Agreement. Other than as

    specifically provided herein, the Parties, their employees, subsidiaries, affiliates, agents and

    assigns, shall not disclose any Proprietary Information without the express written consent of the
    other Party. Also, neither Party shall use the Proprietary Information for any purpose other than

    purposes related to their business relationship as laid out in this Agreement. In the event that the

    receiving Party is required by applicable law, rule, regulation or lawful order or ruling of any court,
    government agency or regulatory commission to disclose any Proprietary Information, the receiving

    Party understands that the disclosing Party may desire to seek an appropriate protective order or
    take steps to protect the confidentiality of such Proprietary Information. Consequently, the

    receiving Party agrees that it will provide the Disclosing Party with prompt notice of such

    request(s).

    Remedies. The Parties acknowledge that the Proprietary Information exchanged is valuable and

    unique, and that disclosure in breach of this Agreement will result in irreparable injury to the
    adversely affected Party, for which monetary damages, on their own, would be inadequate.

    Accordingly, the Parties agree the adversely affected Party shall have the right to seek an

    immediate injunction enjoining any such breach or threatened breach of the Agreement.

    8 RETENTION OF RESULTS

    A. Data will be stored encrypted and, in a manner, accessible only by the Consultant. If relevant, after
    a period of one year, the Consultant will destroy all historical data not required and provide a

    certificate of authenticity (if needed) to the Client.

    9 WARRANTY AND DISCLAIMER

    A. Consultant warrants that Consultant’s Work will be provided in a workmanlike manner, and in
    conformity with generally prevailing industry standard and Client’s reasonable requirements.

    SUBJECT TO CONSULTANT’S FULFILLMENT OF ITS OBLIGATIONS UNDER THIS AGREEMENT, CONSULTANT WILL NOT

    BE LIABLE FOR ANY LOSS OR DAMAGE CAUSED BY A DENIAL-OF-SERVICE ATTACK, UNIDENTIFIED VULNERABILITY,
    VIRUSES OR OTHER TECHNOLOGICALLY HARMFUL MATERIAL THAT MAY INFECT YOUR COMPUTER EQUIPMENT, COMPUTER

    PROGRAMS, DATA NETWORK OR OTHER PROPRIETARY MATERIAL, EXCEPT TO THE EXTENT CAUSED BY NEGLIGENCE OF

    OR WRONGFUL ACT BY CONSULTANT.

    B. Consultant represents, warrants and covenants that it does currently, and will at all times during

    the Term, operate its business and provide its services in accordance with industry standard
    security practices, including, without limitation, the proper use and configuration of industry

    standard anti-virus/anti-malware software.

    10 LIMITATIONS OF REMEDIES

    A. Client’s sole and exclusive remedy for any claim against Consultant with respect to the quality of
    Consultant’s Work shall be the correction by Consultant of any material defects or deficiencies

    therein, of which Client notifies Consultant in writing within 90 days after the completion of that

    portion of Consultant’s Work, and Consultant shall fully correct all such material defects and
    deficiencies to Client’s reasonable satisfaction within 10 business days following the date of such

    S3-SOW-20-0001

    Initials 5

    notice; provided, that Client will be entitled to a full refund of all fees paid with respect to such

    defective/deficient work if Consultant does not fully correct the same to Client’s reasonable
    satisfaction within such 10 day period. In the absence of any such notice within such 90-day

    period, Consultant’s Work shall be deemed satisfactory to and accepted by Client.

    11 LIMITATIONS OF LIABILITY

    A. In no event shall either party be liable for any loss of profit or revenue by the other party, or for
    any other consequential, incidental or indirect damages incurred or suffered by such other party

    arising as a result of or related to this Agreement, whether in contract, tort, or otherwise, even if

    such party has advised of the possibility of such loss or damages. Client further agrees that the
    total liability of Consultant for all claims of any kind arising as a result of or related to this

    Agreement, or to any act or omission of Consultant, whether in contract, tort, or otherwise, shall

    not exceed an amount equal to the amount actually paid by Client to Consultant for Consultant’s
    Work during the period preceding the date the claim arises, except for any claims arising from

    Consultant’s gross negligence or wrongful acts, which shall not be subject to any limitation of
    liability. Consultant shall indemnify and hold Client harmless against any claims by third parties,

    including all costs, expenses and attorneys’ fees incurred by Client, arising out of or in conjunction

    with Consultant’s performance under or breach of this Agreement.

    12 RELATIONS OF PARTIES

    A. The performance by Consultant of its duties and obligations under this Agreement shall be that of
    an independent contractor, and nothing herein shall create or imply an agency relationship

    between Consultant and Client, nor shall this Agreement be deemed to constitute a joint venture or
    partnership between the Parties.

    13 EMPLOYEE SOLICITATION/HIRING
    A. During the period of this Agreement and for 12 months thereafter, neither party shall directly or

    indirectly solicit or offer employment to or hire any employee, former employee, subcontractor, or

    former subcontractor of the other. The terms “former employee” and “former subcontractor” shall

    include only those employees or subcontractors of either party who were employed or utilized by
    that party during the Term.

    14 NO GUARANTEE

    A. The Consultant does not warrant or guarantee any specific level of performance or results. There is

    no guarantee that indicators of compromise exist.

    15 ENTIRE AGREEMENT

    A. This Agreement is the final, complete, and exclusive Agreement of the Parties. No modification of
    or amendment to this Agreement shall be valid unless in writing and signed by each of the Parties.

    16 SEVERABILITY

    A. If any provision of this Agreement shall be held to be illegal, invalid or unenforceable, such

    provision shall be fully severable, and this Agreement shall be construed and enforced as if such

    illegal, invalid, or unenforceable provision had never comprised part of this Agreement, the
    remaining provisions of this Agreement shall remain in full force and effect.

    17 ADJUSTMENT FOR INFLATION

    A. The ongoing vulnerability scanning services fees rate set forth in section 3B above, shall be

    increased yearly for inflation by a percentage amount equal to 2.5%.

    S3-SOW-20-0001

    Initials 6

    18 HEADINGS

    A. The headings used in this Agreement are for convenience only and shall not be used to limit or

    construe the contents of this Agreement.

    19 INTERPRETATION AND ENFORCEMENT

    A. The parties understand and agree that the construction and interpretation of this Agreement are
    governed by the laws of the State of Georgia. If either party must initiate legal action to enforce

    this Agreement, the Parties agree that the proper venue for such action shall be the courts of the
    State of Georgia. By their signatures below, the parties hereby understand and agree to all terms

    and conditions of this Agreement.

    By their signatures below, the Parties hereby understand and agree to all terms and conditions of this

    Agreement.

    JLA ENTERPRISE, LLC CLIENT, LLC

    Jake Gramm, CEO

    Jim Halpert, CTO

    Date

    Date

    – CONSULTING SERVICES AGREEMENT
    – 1 Statement of Work

    – 1.1 Setup Services: The Consultant will perform the following actions to prepare for the Client's penetration test.

    – 3 Compensation and Payment
    – 4 Term
    – 5 Termination
    – 6 Ownership of Intellectual Property
    – 7 Confidential Information
    – 8 Retention of Results
    – 9 Warranty and Disclaimer
    – 10 Limitations of Remedies
    – 11 Limitations of Liability
    – 12 Relations of Parties
    – 13 Employee Solicitation/Hiring
    – 14 No Guarantee
    – 15 Entire Agreement
    – 16 Severability
    – 17 Adjustment for Inflation
    – 18 Headings
    – 19 Interpretation and Enforcement

    **## Lesson1StatementofworkInfo.pdf**

    S3-SOW-20-0001

    Initials 1

    CONSULTING SERVICES AGREEMENT

    Thank you for choosing JLA ENTERPRISE, LLC as the provider for your comprehensive cyber security needs.

    We will be providing monthly vulnerability and compliance scanning exclusively for your business. We are

    excited to be part of your team.

    This CONSULTING SERVICE AGREEMENT (“The Agreement”), is entered into on this date by
    and between JLA ENTERPRISE, LLC, a Georgia limited liability company (“The Consultant”) and ;

    CLIENT, LLC (“The Client”).

    (collectively, “The Parties”)

    1 Statement of Work

    1.1 Setup Services: The Consultant will perform the following actions to prepare for the Client's

    penetration test.

    A. The Consultant will install the latest version of Gophish software and conduct necessary updates,

    testing, documentation, and troubleshooting to perform the monthly phishing attacks against the

    Client. The Consultant will cover all licensing fees.

    B. The Consultant will acquire a dedicated server using linode.com hosting services. The Consultant

    will install Ubuntu Linux and update all installed software packages necessary. The Consultant will

    cover all licensing fees.

    1.2 Penetration Testing Services: The Consultant will assign a team to conduct open-source research,

    build phishing campaigns, attempt compromise against identified vulnerabilities, gain privileged access,
    and attempt to exfiltrate data. These services will be performed within the parameters of the agreed upon

    Consultant/Client rules of engagement as outlined below:

    A. Once the penetration test has started, it could take approximately seven weeks to complete and

    produce a report.

    B. The Consultant will conduct open-source research in accordance with Blackbox methodology as
    determined by the Client. The Consultant will acquire data regarding employee’s social media

    footprint as well as specific company data to include but not limited to employment, location, and

    services. Below are specific Client outcomes:

    I. Compromise of Executive's email

    II. Compromise of Executive's documents

    III. Compromise of financial information and financial systems

    IV. Monitoring audio or video especially Executive offices

    V. Access to sensitive Intellectual Property

    VI. Exfiltration of data

    C. The Consultant will use the information found in section 1.2B to create one to three phishing

    campaigns utilizing traditional phishing, spearphishing, or whaling methodology.

    S3-SOW-20-0001

    Initials 2

    D. The Consultant’s proprietary penetration testing methodology includes a five-phased approach:

    I. Reconnaissance – The Consultant will conduct open-research on the Client’s company to

    determine points of interest to further scan for vulnerabilities.

    II. Information Gathering – The Consultant will perform in-depth network scans to identify

    access vectors to gain access during the Exploitation phase.

    III. Exploitation – The Consultant will attempt exploitation against vulnerabilities and seek to
    gain privileged access based on findings from the Reconnaissance and Information

    Gathering phases.

    IV. Maintaining Access – The Consultant will maintain access on various points of interest during

    the penetration test to exfiltrate data.

    V. Cleanup – The Consultant agrees to remove all proprietary tools used during the penetration

    test and will remove persistence tools and user accounts from the Client’s systems.

    E. During particular circumstances, the Consultant may approach the Client to request switching the

    penetration test to white box methodology. The Consultant request would only be made after black
    box methodology has been exhausted. The Consultant can only switch penetration testing

    methodology if it is in the best interest of the Client.

    F. The Consultant’s penetration testing methodology is designed and operated on a measured risk
    basis, with safety for the Client’s systems and personnel at the forefront. The Consultant will

    communicate to the Client every vulnerability identified, for written approval, prior to an

    exploitation attempt.

    G. Penetration testing services will be conducted Monday through Friday from 6 PM to 8 AM after

    standard business hours, and anytime on Saturday and Sunday (The time is calculated for any time
    zone). Penetration testing service will be performed via electronic means; travel is not permitted. If

    the Client requests travel, the Client agrees to cover costs.

    H. At the end of the penetration testing service, the Consultant will produce a finding report. This

    report will contain the scope of work, executive summary, findings, methodology, screenshots per

    successful exploit, definitions of risk levels, systems information, and the Consultant’s

    recommendations.

    I. Retention of Results can be found in section 8.

    1.3 Penetration Testing Reporting: The Consultant will produce a report to the Client after the

    completion of the penetration testing services outlined in this Agreement. This report will contain the

    scope of work, executive summary, findings, methodology, screenshots per successful exploit, definitions

    of risk levels, systems information, and the Consultant’s recommendations.

    3 Compensation and Payment

    A. Set up Fees: For the Services described in this agreement, the Client setup fees are included in

    the ongoing management fees section below. The first month of vulnerability scanning service will

    act as an installation period. Reports for vulnerability scanning will start on the second month of

    service. Setup can take varying lengths of time, but will usually take around ten days.

    B. Network Vulnerability and Compliance Scanning Fees: For the Services described in this
    agreement, the Client agrees to pay to the Consultant $560.00 per month and should be paid via

    direct deposit, then check, if necessary. Payment is subject to net-10 payment rules.

    S3-SOW-20-0001

    Initials 3

    C. Additional Fees: Pending Client approval, if the Consultant has determined additional services
    are required such as, but not limited to: computer forensics, or in-depth vulnerability research, the

    Client will be billed at a rate of $250/hr. The Consultant and the Client will agree upon the number

    of additional hours required to provide additional services.

    4 TERM

    A. This Agreement will commence on the effective date first set forth above and remain in full force

    and effect for a minimum period of 365 days. This Agreement shall continue on a month to month

    basis unless otherwise terminated by the Consultant or Client or unless otherwise agreed to by the
    Consultant and the Clients.

    5 TERMINATION

    A. This Agreement may be terminated by either party for any reason or no reason, whether or not

    extended beyond the initial term, by giving the other party written notice 30 days in advance.

    Written requests to terminate may be made by e-mail. If Client chooses to terminate this
    agreement in writing, all monies owed to the Consultant will be due immediately. Under no

    circumstances will the Consultant give refunds of the amount paid for the Services hereunder.

    6 OWNERSHIP OF INTELLECTUAL PROPERTY

    All plans, reports, programs, software (source and object code), digital tools, pictures, video,
    music, content, artwork, designs, websites, framework, web services, software engines, products,

    models, footage, applications of any kind, work, ideas, derivative works, confidential information,

    concepts, deliverables, results of the services and all other tangible and intangible materials or
    property provided, prepared or created under or resulting from this Agreement, whether or not

    rejected by Client, and all copies thereof (collectively, the “The Materials”), shall be owned by
    Client and shall be deemed “works made for hire,” under United States copyright Laws (17 U.S.C. §

    101 or any future statute). Consultant represents, warrants and covenants that all Materials, along

    with all rights contained therein, including, without limitation, the exclusive copyright and all other
    intellectual property rights, are and shall be the property of Client immediately upon creation. If

    any of the Materials are considered by a court of competent jurisdiction not to be a “work made for
    hire” or under any circumstances where the full title and ownership thereof has not vested in

    Client, Consultant hereby assigns to Client all right, title, and interest in such Materials immediately

    upon creation and agrees to execute any future assignments to evidence or effect such
    assignments. Without limiting the generality of the foregoing, Client will have, and Consultant shall

    be responsible for ensuring Client has, the unlimited right to reproduce, transmit, distribute,
    exhibit, perform, create derivative works based upon, exploit or otherwise use the Materials, and

    all elements thereof, in any manner and in any and all media now known or hereafter devised

    throughout the world in perpetuity.

    7 CONFIDENTIAL INFORMATION

    A. Except as provided elsewhere in this Agreement, all information disclosed by one Party to the other
    Party shall be deemed to be confidential and proprietary (“Proprietary Information”). Such

    Proprietary Information includes, without limitation, information regarding marketing, sales

    programs, sales volume, sales conversion rates, sales methods and processes, sales proposals,
    products, services, vendors, customer lists, training manuals, sales scripts, telemarketing scripts,

    names of investors, and customer information, operating procedures, pricing policies, strategic
    plans, intellectual property, information about a Party’s employees and other confidential or

    Proprietary Information belonging to or related to a Party’s affairs. The Receiving Party

    acknowledges and agrees that in any proceeding to enforce this Agreement it will be presumed that
    the Proprietary Information constitutes protectable trade secrets and that the receiving Party will

    bear the burden of proving that any portion of the Proprietary Information was publicly or rightfully
    known and disclosed by the receiving Party. The Parties, their employees, subsidiaries, affiliates,

    agents, and assigns agree to hold all Proprietary Information, regardless of when or how disclosed,

    in strict confidence and with not less than the same degree of care that they provide for their own

    S3-SOW-20-0001

    Initials 4

    confidential and proprietary information. The Parties warrant and represent that the degree of care

    contemplated herein is adequate and the Parties will take any and all steps reasonably necessary

    to preserve such Proprietary Information.

    B. Nothing in this Agreement shall prohibit or limit the receiving Party’s use of information that can be

    demonstrated as: (a) previously known to the receiving Party, (b) independently developed by the
    receiving Party, (c) acquired from a third party, not under similar nondisclosure obligations to the

    disclosing Party, or (d) acquired through the public domain through no breach by the receiving

    Party of this Agreement.

    C. License. Client grants The Consultant a limited, nontransferable, nonexclusive license to copy,

    use, store, set up, publicly display, publicly perform and transmit any trade names, trademarks,
    service marks, copyrights, content, text, images, software, functionality, page and other design

    and layout, media and other materials therein and solely in connection with creation of the
    Campaign and direct response marketing in accordance with this Agreement. Other than as

    specifically provided herein, the Parties, their employees, subsidiaries, affiliates, agents and

    assigns, shall not disclose any Proprietary Information without the express written consent of the
    other Party. Also, neither Party shall use the Proprietary Information for any purpose other than

    purposes related to their business relationship as laid out in this Agreement. In the event that the

    receiving Party is required by applicable law, rule, regulation or lawful order or ruling of any court,
    government agency or regulatory commission to disclose any Proprietary Information, the receiving

    Party understands that the disclosing Party may desire to seek an appropriate protective order or
    take steps to protect the confidentiality of such Proprietary Information. Consequently, the

    receiving Party agrees that it will provide the Disclosing Party with prompt notice of such

    request(s).

    Remedies. The Parties acknowledge that the Proprietary Information exchanged is valuable and

    unique, and that disclosure in breach of this Agreement will result in irreparable injury to the
    adversely affected Party, for which monetary damages, on their own, would be inadequate.

    Accordingly, the Parties agree the adversely affected Party shall have the right to seek an

    immediate injunction enjoining any such breach or threatened breach of the Agreement.

    8 RETENTION OF RESULTS

    A. Data will be stored encrypted and, in a manner, accessible only by the Consultant. If relevant, after
    a period of one year, the Consultant will destroy all historical data not required and provide a

    certificate of authenticity (if needed) to the Client.

    9 WARRANTY AND DISCLAIMER

    A. Consultant warrants that Consultant’s Work will be provided in a workmanlike manner, and in
    conformity with generally prevailing industry standard and Client’s reasonable requirements.

    SUBJECT TO CONSULTANT’S FULFILLMENT OF ITS OBLIGATIONS UNDER THIS AGREEMENT, CONSULTANT WILL NOT

    BE LIABLE FOR ANY LOSS OR DAMAGE CAUSED BY A DENIAL-OF-SERVICE ATTACK, UNIDENTIFIED VULNERABILITY,
    VIRUSES OR OTHER TECHNOLOGICALLY HARMFUL MATERIAL THAT MAY INFECT YOUR COMPUTER EQUIPMENT, COMPUTER

    PROGRAMS, DATA NETWORK OR OTHER PROPRIETARY MATERIAL, EXCEPT TO THE EXTENT CAUSED BY NEGLIGENCE OF

    OR WRONGFUL ACT BY CONSULTANT.

    B. Consultant represents, warrants and covenants that it does currently, and will at all times during

    the Term, operate its business and provide its services in accordance with industry standard
    security practices, including, without limitation, the proper use and configuration of industry

    standard anti-virus/anti-malware software.

    10 LIMITATIONS OF REMEDIES

    A. Client’s sole and exclusive remedy for any claim against Consultant with respect to the quality of
    Consultant’s Work shall be the correction by Consultant of any material defects or deficiencies

    therein, of which Client notifies Consultant in writing within 90 days after the completion of that

    portion of Consultant’s Work, and Consultant shall fully correct all such material defects and
    deficiencies to Client’s reasonable satisfaction within 10 business days following the date of such

    S3-SOW-20-0001

    Initials 5

    notice; provided, that Client will be entitled to a full refund of all fees paid with respect to such

    defective/deficient work if Consultant does not fully correct the same to Client’s reasonable
    satisfaction within such 10 day period. In the absence of any such notice within such 90-day

    period, Consultant’s Work shall be deemed satisfactory to and accepted by Client.

    11 LIMITATIONS OF LIABILITY

    A. In no event shall either party be liable for any loss of profit or revenue by the other party, or for
    any other consequential, incidental or indirect damages incurred or suffered by such other party

    arising as a result of or related to this Agreement, whether in contract, tort, or otherwise, even if

    such party has advised of the possibility of such loss or damages. Client further agrees that the
    total liability of Consultant for all claims of any kind arising as a result of or related to this

    Agreement, or to any act or omission of Consultant, whether in contract, tort, or otherwise, shall

    not exceed an amount equal to the amount actually paid by Client to Consultant for Consultant’s
    Work during the period preceding the date the claim arises, except for any claims arising from

    Consultant’s gross negligence or wrongful acts, which shall not be subject to any limitation of
    liability. Consultant shall indemnify and hold Client harmless against any claims by third parties,

    including all costs, expenses and attorneys’ fees incurred by Client, arising out of or in conjunction

    with Consultant’s performance under or breach of this Agreement.

    12 RELATIONS OF PARTIES

    A. The performance by Consultant of its duties and obligations under this Agreement shall be that of
    an independent contractor, and nothing herein shall create or imply an agency relationship

    between Consultant and Client, nor shall this Agreement be deemed to constitute a joint venture or
    partnership between the Parties.

    13 EMPLOYEE SOLICITATION/HIRING
    A. During the period of this Agreement and for 12 months thereafter, neither party shall directly or

    indirectly solicit or offer employment to or hire any employee, former employee, subcontractor, or

    former subcontractor of the other. The terms “former employee” and “former subcontractor” shall

    include only those employees or subcontractors of either party who were employed or utilized by
    that party during the Term.

    14 NO GUARANTEE

    A. The Consultant does not warrant or guarantee any specific level of performance or results. There is

    no guarantee that indicators of compromise exist.

    15 ENTIRE AGREEMENT

    A. This Agreement is the final, complete, and exclusive Agreement of the Parties. No modification of
    or amendment to this Agreement shall be valid unless in writing and signed by each of the Parties.

    16 SEVERABILITY

    A. If any provision of this Agreement shall be held to be illegal, invalid or unenforceable, such

    provision shall be fully severable, and this Agreement shall be construed and enforced as if such

    illegal, invalid, or unenforceable provision had never comprised part of this Agreement, the
    remaining provisions of this Agreement shall remain in full force and effect.

    17 ADJUSTMENT FOR INFLATION

    A. The ongoing vulnerability scanning services fees rate set forth in section 3B above, shall be

    increased yearly for inflation by a percentage amount equal to 2.5%.

    S3-SOW-20-0001

    Initials 6

    18 HEADINGS

    A. The headings used in this Agreement are for convenience only and shall not be used to limit or

    construe the contents of this Agreement.

    19 INTERPRETATION AND ENFORCEMENT

    A. The parties understand and agree that the construction and interpretation of this Agreement are
    governed by the laws of the State of Georgia. If either party must initiate legal action to enforce

    this Agreement, the Parties agree that the proper venue for such action shall be the courts of the
    State of Georgia. By their signatures below, the parties hereby understand and agree to all terms

    and conditions of this Agreement.

    By their signatures below, the Parties hereby understand and agree to all terms and conditions of this

    Agreement.

    JLA ENTERPRISE, LLC CLIENT, LLC

    Jake Gramm, CEO

    Jim Halpert, CTO

    Date

    Date

    – CONSULTING SERVICES AGREEMENT
    – 1 Statement of Work

    – 1.1 Setup Services: The Consultant will perform the following actions to prepare for the Client's penetration test.

    – 3 Compensation and Payment
    – 4 Term
    – 5 Termination
    – 6 Ownership of Intellectual Property
    – 7 Confidential Information
    – 8 Retention of Results
    – 9 Warranty and Disclaimer
    – 10 Limitations of Remedies
    – 11 Limitations of Liability
    – 12 Relations of Parties
    – 13 Employee Solicitation/Hiring
    – 14 No Guarantee
    – 15 Entire Agreement
    – 16 Severability
    – 17 Adjustment for Inflation
    – 18 Headings
    – 19 Interpretation and Enforcement

    **## Lesson1Statementofwork.docx**

    Answer the following in a separate word document.

    1. How many items and which items can the consultant specifically do?

    2. What type of methodology is being used to conduct the penetration test?

    3. Is the consultant legally allowed to gain privileged access or attempt to exfiltrate data?

    4. Which section approves/denies this action?

    5. What software is being used to conduct the phishing campaigns?

    6. What is the name of the phases the consultant will use as part of their methodology?

    **## Lesson1StatementofworkInfo.pdf**

    S3-SOW-20-0001

    Initials 1

    CONSULTING SERVICES AGREEMENT

    Thank you for choosing JLA ENTERPRISE, LLC as the provider for your comprehensive cyber security needs.

    We will be providing monthly vulnerability and compliance scanning exclusively for your business. We are

    excited to be part of your team.

    This CONSULTING SERVICE AGREEMENT (“The Agreement”), is entered into on this date by
    and between JLA ENTERPRISE, LLC, a Georgia limited liability company (“The Consultant”) and ;

    CLIENT, LLC (“The Client”).

    (collectively, “The Parties”)

    1 Statement of Work

    1.1 Setup Services: The Consultant will perform the following actions to prepare for the Client's

    penetration test.

    A. The Consultant will install the latest version of Gophish software and conduct necessary updates,

    testing, documentation, and troubleshooting to perform the monthly phishing attacks against the

    Client. The Consultant will cover all licensing fees.

    B. The Consultant will acquire a dedicated server using linode.com hosting services. The Consultant

    will install Ubuntu Linux and update all installed software packages necessary. The Consultant will

    cover all licensing fees.

    1.2 Penetration Testing Services: The Consultant will assign a team to conduct open-source research,

    build phishing campaigns, attempt compromise against identified vulnerabilities, gain privileged access,
    and attempt to exfiltrate data. These services will be performed within the parameters of the agreed upon

    Consultant/Client rules of engagement as outlined below:

    A. Once the penetration test has started, it could take approximately seven weeks to complete and

    produce a report.

    B. The Consultant will conduct open-source research in accordance with Blackbox methodology as
    determined by the Client. The Consultant will acquire data regarding employee’s social media

    footprint as well as specific company data to include but not limited to employment, location, and

    services. Below are specific Client outcomes:

    I. Compromise of Executive's email

    II. Compromise of Executive's documents

    III. Compromise of financial information and financial systems

    IV. Monitoring audio or video especially Executive offices

    V. Access to sensitive Intellectual Property

    VI. Exfiltration of data

    C. The Consultant will use the information found in section 1.2B to create one to three phishing

    campaigns utilizing traditional phishing, spearphishing, or whaling methodology.

    S3-SOW-20-0001

    Initials 2

    D. The Consultant’s proprietary penetration testing methodology includes a five-phased approach:

    I. Reconnaissance – The Consultant will conduct open-research on the Client’s company to

    determine points of interest to further scan for vulnerabilities.

    II. Information Gathering – The Consultant will perform in-depth network scans to identify

    access vectors to gain access during the Exploitation phase.

    III. Exploitation – The Consultant will attempt exploitation against vulnerabilities and seek to
    gain privileged access based on findings from the Reconnaissance and Information

    Gathering phases.

    IV. Maintaining Access – The Consultant will maintain access on various points of interest during

    the penetration test to exfiltrate data.

    V. Cleanup – The Consultant agrees to remove all proprietary tools used during the penetration

    test and will remove persistence tools and user accounts from the Client’s systems.

    E. During particular circumstances, the Consultant may approach the Client to request switching the

    penetration test to white box methodology. The Consultant request would only be made after black
    box methodology has been exhausted. The Consultant can only switch penetration testing

    methodology if it is in the best interest of the Client.

    F. The Consultant’s penetration testing methodology is designed and operated on a measured risk
    basis, with safety for the Client’s systems and personnel at the forefront. The Consultant will

    communicate to the Client every vulnerability identified, for written approval, prior to an

    exploitation attempt.

    G. Penetration testing services will be conducted Monday through Friday from 6 PM to 8 AM after

    standard business hours, and anytime on Saturday and Sunday (The time is calculated for any time
    zone). Penetration testing service will be performed via electronic means; travel is not permitted. If

    the Client requests travel, the Client agrees to cover costs.

    H. At the end of the penetration testing service, the Consultant will produce a finding report. This

    report will contain the scope of work, executive summary, findings, methodology, screenshots per

    successful exploit, definitions of risk levels, systems information, and the Consultant’s

    recommendations.

    I. Retention of Results can be found in section 8.

    1.3 Penetration Testing Reporting: The Consultant will produce a report to the Client after the

    completion of the penetration testing services outlined in this Agreement. This report will contain the

    scope of work, executive summary, findings, methodology, screenshots per successful exploit, definitions

    of risk levels, systems information, and the Consultant’s recommendations.

    3 Compensation and Payment

    A. Set up Fees: For the Services described in this agreement, the Client setup fees are included in

    the ongoing management fees section below. The first month of vulnerability scanning service will

    act as an installation period. Reports for vulnerability scanning will start on the second month of

    service. Setup can take varying lengths of time, but will usually take around ten days.

    B. Network Vulnerability and Compliance Scanning Fees: For the Services described in this
    agreement, the Client agrees to pay to the Consultant $560.00 per month and should be paid via

    direct deposit, then check, if necessary. Payment is subject to net-10 payment rules.

    S3-SOW-20-0001

    Initials 3

    C. Additional Fees: Pending Client approval, if the Consultant has determined additional services
    are required such as, but not limited to: computer forensics, or in-depth vulnerability research, the

    Client will be billed at a rate of $250/hr. The Consultant and the Client will agree upon the number

    of additional hours required to provide additional services.

    4 TERM

    A. This Agreement will commence on the effective date first set forth above and remain in full force

    and effect for a minimum period of 365 days. This Agreement shall continue on a month to month

    basis unless otherwise terminated by the Consultant or Client or unless otherwise agreed to by the
    Consultant and the Clients.

    5 TERMINATION

    A. This Agreement may be terminated by either party for any reason or no reason, whether or not

    extended beyond the initial term, by giving the other party written notice 30 days in advance.

    Written requests to terminate may be made by e-mail. If Client chooses to terminate this
    agreement in writing, all monies owed to the Consultant will be due immediately. Under no

    circumstances will the Consultant give refunds of the amount paid for the Services hereunder.

    6 OWNERSHIP OF INTELLECTUAL PROPERTY

    All plans, reports, programs, software (source and object code), digital tools, pictures, video,
    music, content, artwork, designs, websites, framework, web services, software engines, products,

    models, footage, applications of any kind, work, ideas, derivative works, confidential information,

    concepts, deliverables, results of the services and all other tangible and intangible materials or
    property provided, prepared or created under or resulting from this Agreement, whether or not

    rejected by Client, and all copies thereof (collectively, the “The Materials”), shall be owned by
    Client and shall be deemed “works made for hire,” under United States copyright Laws (17 U.S.C. §

    101 or any future statute). Consultant represents, warrants and covenants that all Materials, along

    with all rights contained therein, including, without limitation, the exclusive copyright and all other
    intellectual property rights, are and shall be the property of Client immediately upon creation. If

    any of the Materials are considered by a court of competent jurisdiction not to be a “work made for
    hire” or under any circumstances where the full title and ownership thereof has not vested in

    Client, Consultant hereby assigns to Client all right, title, and interest in such Materials immediately

    upon creation and agrees to execute any future assignments to evidence or effect such
    assignments. Without limiting the generality of the foregoing, Client will have, and Consultant shall

    be responsible for ensuring Client has, the unlimited right to reproduce, transmit, distribute,
    exhibit, perform, create derivative works based upon, exploit or otherwise use the Materials, and

    all elements thereof, in any manner and in any and all media now known or hereafter devised

    throughout the world in perpetuity.

    7 CONFIDENTIAL INFORMATION

    A. Except as provided elsewhere in this Agreement, all information disclosed by one Party to the other
    Party shall be deemed to be confidential and proprietary (“Proprietary Information”). Such

    Proprietary Information includes, without limitation, information regarding marketing, sales

    programs, sales volume, sales conversion rates, sales methods and processes, sales proposals,
    products, services, vendors, customer lists, training manuals, sales scripts, telemarketing scripts,

    names of investors, and customer information, operating procedures, pricing policies, strategic
    plans, intellectual property, information about a Party’s employees and other confidential or

    Proprietary Information belonging to or related to a Party’s affairs. The Receiving Party

    acknowledges and agrees that in any proceeding to enforce this Agreement it will be presumed that
    the Proprietary Information constitutes protectable trade secrets and that the receiving Party will

    bear the burden of proving that any portion of the Proprietary Information was publicly or rightfully
    known and disclosed by the receiving Party. The Parties, their employees, subsidiaries, affiliates,

    agents, and assigns agree to hold all Proprietary Information, regardless of when or how disclosed,

    in strict confidence and with not less than the same degree of care that they provide for their own

    S3-SOW-20-0001

    Initials 4

    confidential and proprietary information. The Parties warrant and represent that the degree of care

    contemplated herein is adequate and the Parties will take any and all steps reasonably necessary

    to preserve such Proprietary Information.

    B. Nothing in this Agreement shall prohibit or limit the receiving Party’s use of information that can be

    demonstrated as: (a) previously known to the receiving Party, (b) independently developed by the
    receiving Party, (c) acquired from a third party, not under similar nondisclosure obligations to the

    disclosing Party, or (d) acquired through the public domain through no breach by the receiving

    Party of this Agreement.

    C. License. Client grants The Consultant a limited, nontransferable, nonexclusive license to copy,

    use, store, set up, publicly display, publicly perform and transmit any trade names, trademarks,
    service marks, copyrights, content, text, images, software, functionality, page and other design

    and layout, media and other materials therein and solely in connection with creation of the
    Campaign and direct response marketing in accordance with this Agreement. Other than as

    specifically provided herein, the Parties, their employees, subsidiaries, affiliates, agents and

    assigns, shall not disclose any Proprietary Information without the express written consent of the
    other Party. Also, neither Party shall use the Proprietary Information for any purpose other than

    purposes related to their business relationship as laid out in this Agreement. In the event that the

    receiving Party is required by applicable law, rule, regulation or lawful order or ruling of any court,
    government agency or regulatory commission to disclose any Proprietary Information, the receiving

    Party understands that the disclosing Party may desire to seek an appropriate protective order or
    take steps to protect the confidentiality of such Proprietary Information. Consequently, the

    receiving Party agrees that it will provide the Disclosing Party with prompt notice of such

    request(s).

    Remedies. The Parties acknowledge that the Proprietary Information exchanged is valuable and

    unique, and that disclosure in breach of this Agreement will result in irreparable injury to the
    adversely affected Party, for which monetary damages, on their own, would be inadequate.

    Accordingly, the Parties agree the adversely affected Party shall have the right to seek an

    immediate injunction enjoining any such breach or threatened breach of the Agreement.

    8 RETENTION OF RESULTS

    A. Data will be stored encrypted and, in a manner, accessible only by the Consultant. If relevant, after
    a period of one year, the Consultant will destroy all historical data not required and provide a

    certificate of authenticity (if needed) to the Client.

    9 WARRANTY AND DISCLAIMER

    A. Consultant warrants that Consultant’s Work will be provided in a workmanlike manner, and in
    conformity with generally prevailing industry standard and Client’s reasonable requirements.

    SUBJECT TO CONSULTANT’S FULFILLMENT OF ITS OBLIGATIONS UNDER THIS AGREEMENT, CONSULTANT WILL NOT

    BE LIABLE FOR ANY LOSS OR DAMAGE CAUSED BY A DENIAL-OF-SERVICE ATTACK, UNIDENTIFIED VULNERABILITY,
    VIRUSES OR OTHER TECHNOLOGICALLY HARMFUL MATERIAL THAT MAY INFECT YOUR COMPUTER EQUIPMENT, COMPUTER

    PROGRAMS, DATA NETWORK OR OTHER PROPRIETARY MATERIAL, EXCEPT TO THE EXTENT CAUSED BY NEGLIGENCE OF

    OR WRONGFUL ACT BY CONSULTANT.

    B. Consultant represents, warrants and covenants that it does currently, and will at all times during

    the Term, operate its business and provide its services in accordance with industry standard
    security practices, including, without limitation, the proper use and configuration of industry

    standard anti-virus/anti-malware software.

    10 LIMITATIONS OF REMEDIES

    A. Client’s sole and exclusive remedy for any claim against Consultant with respect to the quality of
    Consultant’s Work shall be the correction by Consultant of any material defects or deficiencies

    therein, of which Client notifies Consultant in writing within 90 days after the completion of that

    portion of Consultant’s Work, and Consultant shall fully correct all such material defects and
    deficiencies to Client’s reasonable satisfaction within 10 business days following the date of such

    S3-SOW-20-0001

    Initials 5

    notice; provided, that Client will be entitled to a full refund of all fees paid with respect to such

    defective/deficient work if Consultant does not fully correct the same to Client’s reasonable
    satisfaction within such 10 day period. In the absence of any such notice within such 90-day

    period, Consultant’s Work shall be deemed satisfactory to and accepted by Client.

    11 LIMITATIONS OF LIABILITY

    A. In no event shall either party be liable for any loss of profit or revenue by the other party, or for
    any other consequential, incidental or indirect damages incurred or suffered by such other party

    arising as a result of or related to this Agreement, whether in contract, tort, or otherwise, even if

    such party has advised of the possibility of such loss or damages. Client further agrees that the
    total liability of Consultant for all claims of any kind arising as a result of or related to this

    Agreement, or to any act or omission of Consultant, whether in contract, tort, or otherwise, shall

    not exceed an amount equal to the amount actually paid by Client to Consultant for Consultant’s
    Work during the period preceding the date the claim arises, except for any claims arising from

    Consultant’s gross negligence or wrongful acts, which shall not be subject to any limitation of
    liability. Consultant shall indemnify and hold Client harmless against any claims by third parties,

    including all costs, expenses and attorneys’ fees incurred by Client, arising out of or in conjunction

    with Consultant’s performance under or breach of this Agreement.

    12 RELATIONS OF PARTIES

    A. The performance by Consultant of its duties and obligations under this Agreement shall be that of
    an independent contractor, and nothing herein shall create or imply an agency relationship

    between Consultant and Client, nor shall this Agreement be deemed to constitute a joint venture or
    partnership between the Parties.

    13 EMPLOYEE SOLICITATION/HIRING
    A. During the period of this Agreement and for 12 months thereafter, neither party shall directly or

    indirectly solicit or offer employment to or hire any employee, former employee, subcontractor, or

    former subcontractor of the other. The terms “former employee” and “former subcontractor” shall

    include only those employees or subcontractors of either party who were employed or utilized by
    that party during the Term.

    14 NO GUARANTEE

    A. The Consultant does not warrant or guarantee any specific level of performance or results. There is

    no guarantee that indicators of compromise exist.

    15 ENTIRE AGREEMENT

    A. This Agreement is the final, complete, and exclusive Agreement of the Parties. No modification of
    or amendment to this Agreement shall be valid unless in writing and signed by each of the Parties.

    16 SEVERABILITY

    A. If any provision of this Agreement shall be held to be illegal, invalid or unenforceable, such

    provision shall be fully severable, and this Agreement shall be construed and enforced as if such

    illegal, invalid, or unenforceable provision had never comprised part of this Agreement, the
    remaining provisions of this Agreement shall remain in full force and effect.

    17 ADJUSTMENT FOR INFLATION

    A. The ongoing vulnerability scanning services fees rate set forth in section 3B above, shall be

    increased yearly for inflation by a percentage amount equal to 2.5%.

    S3-SOW-20-0001

    Initials 6

    18 HEADINGS

    A. The headings used in this Agreement are for convenience only and shall not be used to limit or

    construe the contents of this Agreement.

    19 INTERPRETATION AND ENFORCEMENT

    A. The parties understand and agree that the construction and interpretation of this Agreement are
    governed by the laws of the State of Georgia. If either party must initiate legal action to enforce

    this Agreement, the Parties agree that the proper venue for such action shall be the courts of the
    State of Georgia. By their signatures below, the parties hereby understand and agree to all terms

    and conditions of this Agreement.

    By their signatures below, the Parties hereby understand and agree to all terms and conditions of this

    Agreement.

    JLA ENTERPRISE, LLC CLIENT, LLC

    Jake Gramm, CEO

    Jim Halpert, CTO

    Date

    Date

    – CONSULTING SERVICES AGREEMENT
    – 1 Statement of Work

    – 1.1 Setup Services: The Consultant will perform the following actions to prepare for the Client's penetration test.

    – 3 Compensation and Payment
    – 4 Term
    – 5 Termination
    – 6 Ownership of Intellectual Property
    – 7 Confidential Information
    – 8 Retention of Results
    – 9 Warranty and Disclaimer
    – 10 Limitations of Remedies
    – 11 Limitations of Liability
    – 12 Relations of Parties
    – 13 Employee Solicitation/Hiring
    – 14 No Guarantee
    – 15 Entire Agreement
    – 16 Severability
    – 17 Adjustment for Inflation
    – 18 Headings
    – 19 Interpretation and Enforcement

    **## Lesson1Statementofwork.docx**

    Answer the following in a separate word document.

    1. How many items and which items can the consultant specifically do?

    2. What type of methodology is being used to conduct the penetration test?

    3. Is the consultant legally allowed to gain privileged access or attempt to exfiltrate data?

    4. Which section approves/denies this action?

    5. What software is being used to conduct the phishing campaigns?

    6. What is the name of the phases the consultant will use as part of their methodology?

    **## Lesson1StatementofworkInfo.pdf**

    S3-SOW-20-0001

    Initials 1

    CONSULTING SERVICES AGREEMENT

    Thank you for choosing JLA ENTERPRISE, LLC as the provider for your comprehensive cyber security needs.

    We will be providing monthly vulnerability and compliance scanning exclusively for your business. We are

    excited to be part of your team.

    This CONSULTING SERVICE AGREEMENT (“The Agreement”), is entered into on this date by
    and between JLA ENTERPRISE, LLC, a Georgia limited liability company (“The Consultant”) and ;

    CLIENT, LLC (“The Client”).

    (collectively, “The Parties”)

    1 Statement of Work

    1.1 Setup Services: The Consultant will perform the following actions to prepare for the Client's

    penetration test.

    A. The Consultant will install the latest version of Gophish software and conduct necessary updates,

    testing, documentation, and troubleshooting to perform the monthly phishing attacks against the

    Client. The Consultant will cover all licensing fees.

    B. The Consultant will acquire a dedicated server using linode.com hosting services. The Consultant

    will install Ubuntu Linux and update all installed software packages necessary. The Consultant will

    cover all licensing fees.

    1.2 Penetration Testing Services: The Consultant will assign a team to conduct open-source research,

    build phishing campaigns, attempt compromise against identified vulnerabilities, gain privileged access,
    and attempt to exfiltrate data. These services will be performed within the parameters of the agreed upon

    Consultant/Client rules of engagement as outlined below:

    A. Once the penetration test has started, it could take approximately seven weeks to complete and

    produce a report.

    B. The Consultant will conduct open-source research in accordance with Blackbox methodology as
    determined by the Client. The Consultant will acquire data regarding employee’s social media

    footprint as well as specific company data to include but not limited to employment, location, and

    services. Below are specific Client outcomes:

    I. Compromise of Executive's email

    II. Compromise of Executive's documents

    III. Compromise of financial information and financial systems

    IV. Monitoring audio or video especially Executive offices

    V. Access to sensitive Intellectual Property

    VI. Exfiltration of data

    C. The Consultant will use the information found in section 1.2B to create one to three phishing

    campaigns utilizing traditional phishing, spearphishing, or whaling methodology.

    S3-SOW-20-0001

    Initials 2

    D. The Consultant’s proprietary penetration testing methodology includes a five-phased approach:

    I. Reconnaissance – The Consultant will conduct open-research on the Client’s company to

    determine points of interest to further scan for vulnerabilities.

    II. Information Gathering – The Consultant will perform in-depth network scans to identify

    access vectors to gain access during the Exploitation phase.

    III. Exploitation – The Consultant will attempt exploitation against vulnerabilities and seek to
    gain privileged access based on findings from the Reconnaissance and Information

    Gathering phases.

    IV. Maintaining Access – The Consultant will maintain access on various points of interest during

    the penetration test to exfiltrate data.

    V. Cleanup – The Consultant agrees to remove all proprietary tools used during the penetration

    test and will remove persistence tools and user accounts from the Client’s systems.

    E. During particular circumstances, the Consultant may approach the Client to request switching the

    penetration test to white box methodology. The Consultant request would only be made after black
    box methodology has been exhausted. The Consultant can only switch penetration testing

    methodology if it is in the best interest of the Client.

    F. The Consultant’s penetration testing methodology is designed and operated on a measured risk
    basis, with safety for the Client’s systems and personnel at the forefront. The Consultant will

    communicate to the Client every vulnerability identified, for written approval, prior to an

    exploitation attempt.

    G. Penetration testing services will be conducted Monday through Friday from 6 PM to 8 AM after

    standard business hours, and anytime on Saturday and Sunday (The time is calculated for any time
    zone). Penetration testing service will be performed via electronic means; travel is not permitted. If

    the Client requests travel, the Client agrees to cover costs.

    H. At the end of the penetration testing service, the Consultant will produce a finding report. This

    report will contain the scope of work, executive summary, findings, methodology, screenshots per

    successful exploit, definitions of risk levels, systems information, and the Consultant’s

    recommendations.

    I. Retention of Results can be found in section 8.

    1.3 Penetration Testing Reporting: The Consultant will produce a report to the Client after the

    completion of the penetration testing services outlined in this Agreement. This report will contain the

    scope of work, executive summary, findings, methodology, screenshots per successful exploit, definitions

    of risk levels, systems information, and the Consultant’s recommendations.

    3 Compensation and Payment

    A. Set up Fees: For the Services described in this agreement, the Client setup fees are included in

    the ongoing management fees section below. The first month of vulnerability scanning service will

    act as an installation period. Reports for vulnerability scanning will start on the second month of

    service. Setup can take varying lengths of time, but will usually take around ten days.

    B. Network Vulnerability and Compliance Scanning Fees: For the Services described in this
    agreement, the Client agrees to pay to the Consultant $560.00 per month and should be paid via

    direct deposit, then check, if necessary. Payment is subject to net-10 payment rules.

    S3-SOW-20-0001

    Initials 3

    C. Additional Fees: Pending Client approval, if the Consultant has determined additional services
    are required such as, but not limited to: computer forensics, or in-depth vulnerability research, the

    Client will be billed at a rate of $250/hr. The Consultant and the Client will agree upon the number

    of additional hours required to provide additional services.

    4 TERM

    A. This Agreement will commence on the effective date first set forth above and remain in full force

    and effect for a minimum period of 365 days. This Agreement shall continue on a month to month

    basis unless otherwise terminated by the Consultant or Client or unless otherwise agreed to by the
    Consultant and the Clients.

    5 TERMINATION

    A. This Agreement may be terminated by either party for any reason or no reason, whether or not

    extended beyond the initial term, by giving the other party written notice 30 days in advance.

    Written requests to terminate may be made by e-mail. If Client chooses to terminate this
    agreement in writing, all monies owed to the Consultant will be due immediately. Under no

    circumstances will the Consultant give refunds of the amount paid for the Services hereunder.

    6 OWNERSHIP OF INTELLECTUAL PROPERTY

    All plans, reports, programs, software (source and object code), digital tools, pictures, video,
    music, content, artwork, designs, websites, framework, web services, software engines, products,

    models, footage, applications of any kind, work, ideas, derivative works, confidential information,

    concepts, deliverables, results of the services and all other tangible and intangible materials or
    property provided, prepared or created under or resulting from this Agreement, whether or not

    rejected by Client, and all copies thereof (collectively, the “The Materials”), shall be owned by
    Client and shall be deemed “works made for hire,” under United States copyright Laws (17 U.S.C. §

    101 or any future statute). Consultant represents, warrants and covenants that all Materials, along

    with all rights contained therein, including, without limitation, the exclusive copyright and all other
    intellectual property rights, are and shall be the property of Client immediately upon creation. If

    any of the Materials are considered by a court of competent jurisdiction not to be a “work made for
    hire” or under any circumstances where the full title and ownership thereof has not vested in

    Client, Consultant hereby assigns to Client all right, title, and interest in such Materials immediately

    upon creation and agrees to execute any future assignments to evidence or effect such
    assignments. Without limiting the generality of the foregoing, Client will have, and Consultant shall

    be responsible for ensuring Client has, the unlimited right to reproduce, transmit, distribute,
    exhibit, perform, create derivative works based upon, exploit or otherwise use the Materials, and

    all elements thereof, in any manner and in any and all media now known or hereafter devised

    throughout the world in perpetuity.

    7 CONFIDENTIAL INFORMATION

    A. Except as provided elsewhere in this Agreement, all information disclosed by one Party to the other
    Party shall be deemed to be confidential and proprietary (“Proprietary Information”). Such

    Proprietary Information includes, without limitation, information regarding marketing, sales

    programs, sales volume, sales conversion rates, sales methods and processes, sales proposals,
    products, services, vendors, customer lists, training manuals, sales scripts, telemarketing scripts,

    names of investors, and customer information, operating procedures, pricing policies, strategic
    plans, intellectual property, information about a Party’s employees and other confidential or

    Proprietary Information belonging to or related to a Party’s affairs. The Receiving Party

    acknowledges and agrees that in any proceeding to enforce this Agreement it will be presumed that
    the Proprietary Information constitutes protectable trade secrets and that the receiving Party will

    bear the burden of proving that any portion of the Proprietary Information was publicly or rightfully
    known and disclosed by the receiving Party. The Parties, their employees, subsidiaries, affiliates,

    agents, and assigns agree to hold all Proprietary Information, regardless of when or how disclosed,

    in strict confidence and with not less than the same degree of care that they provide for their own

    S3-SOW-20-0001

    Initials 4

    confidential and proprietary information. The Parties warrant and represent that the degree of care

    contemplated herein is adequate and the Parties will take any and all steps reasonably necessary

    to preserve such Proprietary Information.

    B. Nothing in this Agreement shall prohibit or limit the receiving Party’s use of information that can be

    demonstrated as: (a) previously known to the receiving Party, (b) independently developed by the
    receiving Party, (c) acquired from a third party, not under similar nondisclosure obligations to the

    disclosing Party, or (d) acquired through the public domain through no breach by the receiving

    Party of this Agreement.

    C. License. Client grants The Consultant a limited, nontransferable, nonexclusive license to copy,

    use, store, set up, publicly display, publicly perform and transmit any trade names, trademarks,
    service marks, copyrights, content, text, images, software, functionality, page and other design

    and layout, media and other materials therein and solely in connection with creation of the
    Campaign and direct response marketing in accordance with this Agreement. Other than as

    specifically provided herein, the Parties, their employees, subsidiaries, affiliates, agents and

    assigns, shall not disclose any Proprietary Information without the express written consent of the
    other Party. Also, neither Party shall use the Proprietary Information for any purpose other than

    purposes related to their business relationship as laid out in this Agreement. In the event that the

    receiving Party is required by applicable law, rule, regulation or lawful order or ruling of any court,
    government agency or regulatory commission to disclose any Proprietary Information, the receiving

    Party understands that the disclosing Party may desire to seek an appropriate protective order or
    take steps to protect the confidentiality of such Proprietary Information. Consequently, the

    receiving Party agrees that it will provide the Disclosing Party with prompt notice of such

    request(s).

    Remedies. The Parties acknowledge that the Proprietary Information exchanged is valuable and

    unique, and that disclosure in breach of this Agreement will result in irreparable injury to the
    adversely affected Party, for which monetary damages, on their own, would be inadequate.

    Accordingly, the Parties agree the adversely affected Party shall have the right to seek an

    immediate injunction enjoining any such breach or threatened breach of the Agreement.

    8 RETENTION OF RESULTS

    A. Data will be stored encrypted and, in a manner, accessible only by the Consultant. If relevant, after
    a period of one year, the Consultant will destroy all historical data not required and provide a

    certificate of authenticity (if needed) to the Client.

    9 WARRANTY AND DISCLAIMER

    A. Consultant warrants that Consultant’s Work will be provided in a workmanlike manner, and in
    conformity with generally prevailing industry standard and Client’s reasonable requirements.

    SUBJECT TO CONSULTANT’S FULFILLMENT OF ITS OBLIGATIONS UNDER THIS AGREEMENT, CONSULTANT WILL NOT

    BE LIABLE FOR ANY LOSS OR DAMAGE CAUSED BY A DENIAL-OF-SERVICE ATTACK, UNIDENTIFIED VULNERABILITY,
    VIRUSES OR OTHER TECHNOLOGICALLY HARMFUL MATERIAL THAT MAY INFECT YOUR COMPUTER EQUIPMENT, COMPUTER

    PROGRAMS, DATA NETWORK OR OTHER PROPRIETARY MATERIAL, EXCEPT TO THE EXTENT CAUSED BY NEGLIGENCE OF

    OR WRONGFUL ACT BY CONSULTANT.

    B. Consultant represents, warrants and covenants that it does currently, and will at all times during

    the Term, operate its business and provide its services in accordance with industry standard
    security practices, including, without limitation, the proper use and configuration of industry

    standard anti-virus/anti-malware software.

    10 LIMITATIONS OF REMEDIES

    A. Client’s sole and exclusive remedy for any claim against Consultant with respect to the quality of
    Consultant’s Work shall be the correction by Consultant of any material defects or deficiencies

    therein, of which Client notifies Consultant in writing within 90 days after the completion of that

    portion of Consultant’s Work, and Consultant shall fully correct all such material defects and
    deficiencies to Client’s reasonable satisfaction within 10 business days following the date of such

    S3-SOW-20-0001

    Initials 5

    notice; provided, that Client will be entitled to a full refund of all fees paid with respect to such

    defective/deficient work if Consultant does not fully correct the same to Client’s reasonable
    satisfaction within such 10 day period. In the absence of any such notice within such 90-day

    period, Consultant’s Work shall be deemed satisfactory to and accepted by Client.

    11 LIMITATIONS OF LIABILITY

    A. In no event shall either party be liable for any loss of profit or revenue by the other party, or for
    any other consequential, incidental or indirect damages incurred or suffered by such other party

    arising as a result of or related to this Agreement, whether in contract, tort, or otherwise, even if

    such party has advised of the possibility of such loss or damages. Client further agrees that the
    total liability of Consultant for all claims of any kind arising as a result of or related to this

    Agreement, or to any act or omission of Consultant, whether in contract, tort, or otherwise, shall

    not exceed an amount equal to the amount actually paid by Client to Consultant for Consultant’s
    Work during the period preceding the date the claim arises, except for any claims arising from

    Consultant’s gross negligence or wrongful acts, which shall not be subject to any limitation of
    liability. Consultant shall indemnify and hold Client harmless against any claims by third parties,

    including all costs, expenses and attorneys’ fees incurred by Client, arising out of or in conjunction

    with Consultant’s performance under or breach of this Agreement.

    12 RELATIONS OF PARTIES

    A. The performance by Consultant of its duties and obligations under this Agreement shall be that of
    an independent contractor, and nothing herein shall create or imply an agency relationship

    between Consultant and Client, nor shall this Agreement be deemed to constitute a joint venture or
    partnership between the Parties.

    13 EMPLOYEE SOLICITATION/HIRING
    A. During the period of this Agreement and for 12 months thereafter, neither party shall directly or

    indirectly solicit or offer employment to or hire any employee, former employee, subcontractor, or

    former subcontractor of the other. The terms “former employee” and “former subcontractor” shall

    include only those employees or subcontractors of either party who were employed or utilized by
    that party during the Term.

    14 NO GUARANTEE

    A. The Consultant does not warrant or guarantee any specific level of performance or results. There is

    no guarantee that indicators of compromise exist.

    15 ENTIRE AGREEMENT

    A. This Agreement is the final, complete, and exclusive Agreement of the Parties. No modification of
    or amendment to this Agreement shall be valid unless in writing and signed by each of the Parties.

    16 SEVERABILITY

    A. If any provision of this Agreement shall be held to be illegal, invalid or unenforceable, such

    provision shall be fully severable, and this Agreement shall be construed and enforced as if such

    illegal, invalid, or unenforceable provision had never comprised part of this Agreement, the
    remaining provisions of this Agreement shall remain in full force and effect.

    17 ADJUSTMENT FOR INFLATION

    A. The ongoing vulnerability scanning services fees rate set forth in section 3B above, shall be

    increased yearly for inflation by a percentage amount equal to 2.5%.

    S3-SOW-20-0001

    Initials 6

    18 HEADINGS

    A. The headings used in this Agreement are for convenience only and shall not be used to limit or

    construe the contents of this Agreement.

    19 INTERPRETATION AND ENFORCEMENT

    A. The parties understand and agree that the construction and interpretation of this Agreement are
    governed by the laws of the State of Georgia. If either party must initiate legal action to enforce

    this Agreement, the Parties agree that the proper venue for such action shall be the courts of the
    State of Georgia. By their signatures below, the parties hereby understand and agree to all terms

    and conditions of this Agreement.

    By their signatures below, the Parties hereby understand and agree to all terms and conditions of this

    Agreement.

    JLA ENTERPRISE, LLC CLIENT, LLC

    Jake Gramm, CEO

    Jim Halpert, CTO

    Date

    Date

    – CONSULTING SERVICES AGREEMENT
    – 1 Statement of Work

    – 1.1 Setup Services: The Consultant will perform the following actions to prepare for the Client's penetration test.

    – 3 Compensation and Payment
    – 4 Term
    – 5 Termination
    – 6 Ownership of Intellectual Property
    – 7 Confidential Information
    – 8 Retention of Results
    – 9 Warranty and Disclaimer
    – 10 Limitations of Remedies
    – 11 Limitations of Liability
    – 12 Relations of Parties
    – 13 Employee Solicitation/Hiring
    – 14 No Guarantee
    – 15 Entire Agreement
    – 16 Severability
    – 17 Adjustment for Inflation
    – 18 Headings
    – 19 Interpretation and Enforcement

  • [Solved] Penetration testing help

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    Need help with penetration testing. VMware software needed but download links included. – 2 years ago **files (2)** – ## assignment_questionnaire.txt – project1writeup-2.docx **## assignment_questionnaire.txt** Assignment Questionnaire ======================== NOTE: DO NOT DELETE –> and <–, and …

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Need help with penetration testing. VMware software needed but download links included.

    – 2 years ago

    **files (2)**

    – ## assignment_questionnaire.txt

    – project1writeup-2.docx

    **## assignment_questionnaire.txt**

    Assignment Questionnaire
    ========================

    NOTE: DO NOT DELETE –> and <–, and place your answers within the marks.
    Example:
    –>
    130.207.7.210
    <–

    Info
    ====

    –>
    Your Login ID: zclarke6
    Your Name: Z. Clarke
    <–

    Task 1
    =======

    1. What is the IP address of the vulnerable VM on the NAT network?

    Example:
    IP : 10.0.2.3
    –>
    IP :
    <–

    2. Which port receives http traffic on the vulnerable VM.

    Example:
    Port : 73

    –>
    Port :
    <–

    Task 2
    =======

    1. What command did you use to exploit the shellshock vulnerability?

    Example:
    Command : curl http://10.0.2.1:6262/cgi-bin/shellshock.cgi

    –>
    Command :
    <–

    2. What hash value is returned by running ./bin/task2 with your login ID.

    –>
    Hash :
    <–

    Task 3
    =======

    1. Give the full name of the exploit module you used.

    Example:
    Module : auxiliary/scanner/portscan/tcp

    –>
    Module :
    <–

    2. Give the full name of the payload you used:

    Example:
    Payload : auxiliary/scanner/portscan/tcp

    –>
    Payload :
    <–

    3. What hash value is returned by running ./bin/task3 with your login ID.

    –>
    Hash :
    <–

    Task 4
    =======

    1. What command did you use to find the program with the vulnerable setUID bit (assume the command is being rurn from the /usr/bin directory).

    Example:
    Command : find . php

    –>
    Command :
    <–

    2. Give the name of the vulnerable program in /usr/bin.

    Example:
    Program : passwd

    –>
    Program :
    <–

    3. What command did you use to exploit the setUID vulnerability to spawn a shell.

    –>
    Command :
    <–

    4. What hash value is returned by running ./bin/task4 with your login ID.

    –>
    Hash :
    <–

    Task 5
    =======

    1. Give the John the Ripper command you used to find the password of task51.zip.

    –>
    Command :
    <–

    2. What is the password for task51.zip.

    Example:
    Password : 1234

    –>
    Password :
    <–

    3. What hash value is returned by running python task51.pyc with your login ID.

    –>
    Hash :
    <–

    4. Give the cewl command you used to create your wordlist.

    –>
    Command :
    <–

    5. Give the John the Ripper command you used to find the password of task52.pyc.gpg.

    –>
    Command :
    <–

    6. What is the password for task52.pyc.gpg.

    –>
    Password :
    <–

    7. What hash value is returned by running python task52.pyc with your login ID.

    –>
    Hash :
    <–

    **project1writeup-2.docx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/project1writeup-2-docx)

    **project1writeup-2.docx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/project1writeup-2-docx)

    **## assignment_questionnaire.txt**

    Assignment Questionnaire
    ========================

    NOTE: DO NOT DELETE –> and <–, and place your answers within the marks.
    Example:
    –>
    130.207.7.210
    <–

    Info
    ====

    –>
    Your Login ID: zclarke6
    Your Name: Z. Clarke
    <–

    Task 1
    =======

    1. What is the IP address of the vulnerable VM on the NAT network?

    Example:
    IP : 10.0.2.3
    –>
    IP :
    <–

    2. Which port receives http traffic on the vulnerable VM.

    Example:
    Port : 73

    –>
    Port :
    <–

    Task 2
    =======

    1. What command did you use to exploit the shellshock vulnerability?

    Example:
    Command : curl http://10.0.2.1:6262/cgi-bin/shellshock.cgi

    –>
    Command :
    <–

    2. What hash value is returned by running ./bin/task2 with your login ID.

    –>
    Hash :
    <–

    Task 3
    =======

    1. Give the full name of the exploit module you used.

    Example:
    Module : auxiliary/scanner/portscan/tcp

    –>
    Module :
    <–

    2. Give the full name of the payload you used:

    Example:
    Payload : auxiliary/scanner/portscan/tcp

    –>
    Payload :
    <–

    3. What hash value is returned by running ./bin/task3 with your login ID.

    –>
    Hash :
    <–

    Task 4
    =======

    1. What command did you use to find the program with the vulnerable setUID bit (assume the command is being rurn from the /usr/bin directory).

    Example:
    Command : find . php

    –>
    Command :
    <–

    2. Give the name of the vulnerable program in /usr/bin.

    Example:
    Program : passwd

    –>
    Program :
    <–

    3. What command did you use to exploit the setUID vulnerability to spawn a shell.

    –>
    Command :
    <–

    4. What hash value is returned by running ./bin/task4 with your login ID.

    –>
    Hash :
    <–

    Task 5
    =======

    1. Give the John the Ripper command you used to find the password of task51.zip.

    –>
    Command :
    <–

    2. What is the password for task51.zip.

    Example:
    Password : 1234

    –>
    Password :
    <–

    3. What hash value is returned by running python task51.pyc with your login ID.

    –>
    Hash :
    <–

    4. Give the cewl command you used to create your wordlist.

    –>
    Command :
    <–

    5. Give the John the Ripper command you used to find the password of task52.pyc.gpg.

    –>
    Command :
    <–

    6. What is the password for task52.pyc.gpg.

    –>
    Password :
    <–

    7. What hash value is returned by running python task52.pyc with your login ID.

    –>
    Hash :
    <–

    **project1writeup-2.docx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/project1writeup-2-docx)

    **## assignment_questionnaire.txt**

    Assignment Questionnaire
    ========================

    NOTE: DO NOT DELETE –> and <–, and place your answers within the marks.
    Example:
    –>
    130.207.7.210
    <–

    Info
    ====

    –>
    Your Login ID: zclarke6
    Your Name: Z. Clarke
    <–

    Task 1
    =======

    1. What is the IP address of the vulnerable VM on the NAT network?

    Example:
    IP : 10.0.2.3
    –>
    IP :
    <–

    2. Which port receives http traffic on the vulnerable VM.

    Example:
    Port : 73

    –>
    Port :
    <–

    Task 2
    =======

    1. What command did you use to exploit the shellshock vulnerability?

    Example:
    Command : curl http://10.0.2.1:6262/cgi-bin/shellshock.cgi

    –>
    Command :
    <–

    2. What hash value is returned by running ./bin/task2 with your login ID.

    –>
    Hash :
    <–

    Task 3
    =======

    1. Give the full name of the exploit module you used.

    Example:
    Module : auxiliary/scanner/portscan/tcp

    –>
    Module :
    <–

    2. Give the full name of the payload you used:

    Example:
    Payload : auxiliary/scanner/portscan/tcp

    –>
    Payload :
    <–

    3. What hash value is returned by running ./bin/task3 with your login ID.

    –>
    Hash :
    <–

    Task 4
    =======

    1. What command did you use to find the program with the vulnerable setUID bit (assume the command is being rurn from the /usr/bin directory).

    Example:
    Command : find . php

    –>
    Command :
    <–

    2. Give the name of the vulnerable program in /usr/bin.

    Example:
    Program : passwd

    –>
    Program :
    <–

    3. What command did you use to exploit the setUID vulnerability to spawn a shell.

    –>
    Command :
    <–

    4. What hash value is returned by running ./bin/task4 with your login ID.

    –>
    Hash :
    <–

    Task 5
    =======

    1. Give the John the Ripper command you used to find the password of task51.zip.

    –>
    Command :
    <–

    2. What is the password for task51.zip.

    Example:
    Password : 1234

    –>
    Password :
    <–

    3. What hash value is returned by running python task51.pyc with your login ID.

    –>
    Hash :
    <–

    4. Give the cewl command you used to create your wordlist.

    –>
    Command :
    <–

    5. Give the John the Ripper command you used to find the password of task52.pyc.gpg.

    –>
    Command :
    <–

    6. What is the password for task52.pyc.gpg.

    –>
    Password :
    <–

    7. What hash value is returned by running python task52.pyc with your login ID.

    –>
    Hash :
    <–

    **project1writeup-2.docx**

    This file is too large to display. [View in new window](https://www.sweetstudy.com/files/project1writeup-2-docx)

  • [Solved] questionnare

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    [>Machine Learning homework help](https://www.sweetstudy.com/fields/computer-science-machine-learning) **in the files are the screenshots of my learning styles questionnaire** The simple online learning style inventory you took this week, [Index of Learning Styles QuestionnaireLinks to an external s…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    [>Machine Learning homework help](https://www.sweetstudy.com/fields/computer-science-machine-learning)

    **in the files are the screenshots of my learning styles questionnaire**

    The simple online learning style inventory you took this week, [Index of Learning Styles QuestionnaireLinks to an external site.](https://capella.alma.exlibrisgroup.com/leganto/public/01CAPELLA_INST/lists/2548710600006731?auth=SAML&section=2548710700006731), evaluated whether you are active or reflective, sensing or intuitive, visual or verbal, or sequential or global. For this discussion, evaluate your responsibilities as an IT educator to address your learners' learning styles and preferences.

    – Should your learners adjust their style to suit your teaching style, or the other way around?
    – Does the fact that you are teaching IT affect your position?

    – [\
    \
    ss1.JPG](https://www.sweetstudy.com/files/ss1-jpg-10180087 "ss1.JPG")
    – [\
    \
    ss2.JPG](https://www.sweetstudy.com/files/ss2-jpg-10180089 "ss2.JPG")

    – 2 years ago

  • [Solved] framework

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    [>Machine Learning homework help](https://www.sweetstudy.com/fields/computer-science-machine-learning) This week you identify an appropriate theoretical foundation or practice orientation as the theoretical framework through which to view your proposed project. Let's discuss how you are determining …

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    [>Machine Learning homework help](https://www.sweetstudy.com/fields/computer-science-machine-learning)

    This week you identify an appropriate theoretical foundation or practice orientation as the theoretical framework through which to view your proposed project. Let's discuss how you are determining an appropriate theoretical framework for your proposed study. Choose one of the following for your post:

    – Discuss the theoretical foundation or practice orientation for your study. What have others in your field said about their theoretical frameworks? How does the theoretical foundation or practice orientation support your proposed study?
    – Share your questions about the purpose of theoretical foundation or practice orientation for your study. How might you resolve those questions to ensure appropriate alignment with your topic?
    – As we wrap up this week, identify the most valuable resources for clarifying the purpose of the project.

    – 2 years ago

  • [Solved] authentic

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    [>Machine Learning homework help](https://www.sweetstudy.com/fields/computer-science-machine-learning) **Examples of the work in the file frm a classmate** Use one of the objectives that you have created and create one authentic learning activity to map to the objective. Here is an example: You are …

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    [>Machine Learning homework help](https://www.sweetstudy.com/fields/computer-science-machine-learning)

    **Examples of the work in the file frm a classmate**

    Use one of the objectives that you have created and create one authentic learning activity to map to the objective. Here is an example: You are teaching a course about Microsoft Word. The objective is Create and save a Word file.

    The activity would be:

    1. Log in to Microsoft Word and create a file named "myfile."
    2. Save the file to My Documents.

    – [\
    \
    exampleofwork.txt](https://www.sweetstudy.com/files/exampleofwork-txt "exampleofwork.txt")

    – 2 years ago

  • [Solved] Fundamentals of computer applications

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    [>Machine Learning homework help](https://www.sweetstudy.com/fields/computer-science-machine-learning) – 2 years ago

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    [>Machine Learning homework help](https://www.sweetstudy.com/fields/computer-science-machine-learning)

    – 2 years ago

  • [Solved] Virtual Motherboard Builder

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    In-depth study guidance and analytical solution covering Virtual Motherboard Builder.

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Full assignment prompt and step-by-step guidance are included in the downloadable solution file.

  • [Solved] Project: Addressing a New Business’s Compliance Responsibilities Part 1answers

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    #### Purpose This project provides an opportunity for you to apply principles related to auditing to ensure information systems are in compliance with pertinent laws and regulations, as well as industry requirements. #### Required Source Information and Tools To complete the project, you will need t…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    #### Purpose

    This project provides an opportunity for you to apply principles related to auditing to ensure information systems are in compliance with pertinent laws and regulations, as well as industry requirements.

    #### Required Source Information and Tools

    To complete the project, you will need the following:

    1. Course textbook
    2. Access to the Internet to perform research for the project
    1. PCI Security Standards Council: [https://www.pcisecuritystandards.org](https://www.pcisecuritystandards.org/)
    2. Important PCI Compliance Information for Merchants: [https://www.bigcommerce.com/blog/pci-compliance/#weve-successfully-achieved-pci-compliance-whats-next](https://www.bigcommerce.com/blog/pci-compliance/#weve-successfully-achieved-pci-compliance-whats-next)
    3. COSO Internal Control—Integrated Framework Executive Summary: [https://www.coso.org/_files/ugd/3059fc_1df7d5dd38074006bce8fdf621a942cf.pdf](https://www.coso.org/_files/ugd/3059fc_1df7d5dd38074006bce8fdf621a942cf.pdf)
    4. [COSO Internal Control—Integrated Framework PowerPoint](https://moodle.pittcc.edu/pluginfile.php/3431060/grading/description/25444/842072876.pdf)

    5. COSO Internal Control—Integrated Framework (2013) whitepaper: [https://assets.kpmg/content/dam/kpmg/pdf/2016/05/2750-New-COSO-2013-Framework-WHITEPAPER-V4.pdf](https://assets.kpmg/content/dam/kpmg/pdf/2016/05/2750-New-COSO-2013-Framework-WHITEPAPER-V4.pdf)

    _**Note:**_ The 2013 version of the framework is also available for purchase, or you may be able to retrieve it through our library.

    #### Learning Objectives and Outcomes

    You will be able to:

    – Explain the purpose of PCI DSS
    – Analyze business factors that influence PCI DSS compliance
    – Describe potential consequences of failing to demonstrate PCI DSS compliance
    – Apply standards and frameworks to the development of information security internal control systems
    – Analyze the use of information security controls within IT infrastructure domains

    #### Introduction

    Public and private sector companies are expected to comply with many laws and regulations as well as industry requirements to promote information security. Assessments and audits of the information technology (IT) environment help to ensure a company is in compliance. A successful information security professional must be able to assess a business’s needs, evaluate various standards and frameworks, and develop a customized, integrated internal control system that addresses the company’s compliance responsibilities. Furthermore, the professional must be able to communicate with various people—both inside and outside the organization—to facilitate awareness of how control activities mitigate weaknesses or potential losses that could compromise the company’s information security.

    #### Scenario

    S&H Aquariums is a new online retailer that is about to begin selling aquariums and other items for aquarium hobbyists. In recent months, many companies have been featured in the news because of information security breaches that have exposed customers’ credit card data. S&H Aquariums’ management team is worried about the negative impact a potential breach could have on the company’s reputation and business standing.

    S&H Aquariums has hired you, an information systems security expert, to ensure that the company is prepared to accept credit card payments for purchases made through the company’s Web site. To kick off the planning phase, the board of directors would like you to write a report explaining what the company will need to do to minimize risks to sensitive data and comply with applicable laws and regulations, as well as industry standards. In preparation, you sit down with the company’s president and discuss the following details:

    – Per the company’s strategic plan, the company expects to have between 20,000 and 1,000,000 credit card transactions during the first year of operations. However, the board would like to know what differences to anticipate as the volume of credit card transactions grows in the coming years.
    – The company will initially accept payments made with MasterCard and Visa only, but it may decide to accept other credit cards in the future.
    – The board of directors is discussing the possibility of opening a bricks-and-mortar store in the future, and the board would like to consider any compliance-related issues prior to making that decision.
    – The board consists of professionals from a variety of fields. It is unlikely that any of the board members are familiar with complex information security concepts or with PCI DSS, the set of requirements that prescribes operational and technical controls to protect cardholder data.

    #### Tasks

    1. Review the information related to PCI DSS compliance provided in the course textbook and in the Internet resources listed for this project. Consider how this information relates to the description of S&H Aquariums provided in the scenario above.
    2. Write a report for S&H Aquariums’ board of directors. Include the following:
    1. Introduction
    2. PCI DSS Overview
    1. Include a discussion of the **six principles**, **twelve primary requirements**, and the sub-requirements of PCI DSS.
    3. Rationale

    1. Explain why the company needs to address the PCI DSS requirements and **describe potential consequences if the company is not able to demonstrate compliance**.
    4. Immediate Considerations for PCI DSS Compliance
    1. Analyze factors (including those introduced in the scenario above) that will influence S&H Aquariums’ immediate plans for PCI DSS compliance. Discuss **payment brands** (credit card companies), **transaction volumes**, **merchant levels (i.e., 1 through 4)**, and **types of reporting** required in relation to S&H Aquariums’ business projections.
    5. Future Considerations for PCI DSS Compliance
    1. Analyze contingencies that may influence PCI DSS compliance in the future. Address potential questions from the board, including but not limited to:
    1. What would be expected of the company **if credit card volume increases past 1,000,000 transactions** in future years?
    2. What should S&H Aquariums do to demonstrate PCI DSS compliance if it **begins to accept American Express or Discover**?
    3. How would opening a **bricks-and-mortar store** affect the company’s responsibilities for PCI DSS compliance?
    6. Conclusion

    _As a reminder,_ you may use the textbook for this course and the Internet to conduct research. You are encouraged to respond creatively, but you must cite credible sources to support your work.

    #### Submission Requirements

    – Format: Microsoft Word
    – Font: Arial, 12-point, double-space
    – Citation Style: APA
    – Length: 2–3 pages

    **Self-Assessment Checklist**

    – I have created a report that uses a professional tone and includes correct terminology.
    – In my report, I have described PCI DSS, provided a sound rationale for addressing PCI DSS compliance, and analyzed immediate and future considerations for PCI DSS compliance.
    – I have conducted adequate independent research for this part of the project.

    – 2 years ago

  • [Solved] SQL & Data Management

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    Write a SQL query to find the **second-highest salary** from an `Employee` table without using `LIMIT`. – Given a `Sales` table with `Date`, `Product_ID`, and `Revenue`, write a query to find the **cumulative revenue per product** over time. – Design a **normalized database schema** for an **e-comme…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    Write a SQL query to find the **second-highest salary** from an `Employee` table without using `LIMIT`.

    – Given a `Sales` table with `Date`, `Product_ID`, and `Revenue`, write a query to find the **cumulative revenue per product** over time.
    – Design a **normalized database schema** for an **e-commerce application** handling customers, orders, and payments.
    – Implement a **stored procedure** to automatically update product stock levels after a purchase.

    – 2 years ago

  • [Solved] SQL 1

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    SQL help – 2 years ago **files (2)** – ## SQLLesson3Questionstocomplete.docx – ## Lesson3ExerciseDirections.docx **## SQLLesson3Questionstocomplete.docx** Exercise 8: Write your SQL statement in a file named CIS276DA_Lesson3Exercise8_MEID.sql. Run the script and export the results to CIS276DA_Les…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    SQL help

    – 2 years ago

    **files (2)**

    – ## SQLLesson3Questionstocomplete.docx

    – ## Lesson3ExerciseDirections.docx

    **## SQLLesson3Questionstocomplete.docx**

    Exercise 8: Write your SQL statement in a file named CIS276DA_Lesson3Exercise8_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise8_MEID.csv.

    Exercise 9: Write your SQL statement in a file named CIS276DA_Lesson3Exercise9_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise9_MEID.csv.

    Exercise 10: Write your SQL statement in a file named CIS276DA_Lesson3Exercise10_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise10_MEID.csv.

    Exercise 11: Write your SQL statement in a file named CIS276DA_Lesson3Exercise11_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise11_MEID.csv .

    Custom Query 1: Create a SELECT statement that uses WHERE. Save this SQL statement as CIS276DA_Lesson3Custom1_MEID.sql . Run the script and export the results to CIS276DA_Lesson3Custom1_MEID.csv.

    Custom Query 2: Create a SELECT statement that uses ORDER BY and LIMIT. Save this SQL statement as CIS276DA_Lesson3Custom2_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Custom2_MEID.csv.

    Place all SQL files(6) and CSV files(6) in a folder labeled "Lesson 3".

    Replace "MEID" in the file names with your actual MEID.

    Zip the entire "Lesson 3" folder as described in the Syllabus.

    Submit the zipped assignment folder using the link below

    **## Lesson3ExerciseDirections.docx**

    Run some of the examples in this chapter In these exercises, you’ll use MySQL Workbench to run some of the scripts for the examples in this chapter. This assumes that you already know how to use MySQL Workbench, as described in chapter 2.

    1. Start MySQL Workbench.

    2. Open the script named 3‐02.sql that you should find in this directory: c:\murach\mysql\book_scripts\ch03. When it opens, you should see all of the queries for figure 3‐2. Note that each of these queries has a semicolon at the end of it.

    3. Move the insertion point into the first query and press Ctrl+Enter or click on the Execute Current Statement button to run the query. This shows you the data that’s in the Invoices table that you’ll be working with in this chapter.

    4. Move the insertion point into the second query and run it.
    parameter

    5. Open the script named 3‐05.sql in the ch03 directory. Then, run the second query. When you do, you’ll see that the result set is in sequence by the invoice_id column.

    6. Delete the ORDER BY clause from the SELECT statement and run the query again. Scroll through the result set to see that the rows are no longer in a particular sequence. When you’re done, close the script without saving the changes.

    7. Open and run the queries for any of the other examples in this chapter that you’re interested in reviewing.

    Enter and run your own SELECT statements In these exercises, you’ll enter and run your own SELECT statements. To do that, you can open the script for an example that is similar to the statement you need to write, copy the statement into a new SQL tab, and modify the statement. That can save you both time and syntax errors.

    8. Write a SELECT statement that returns three columns from the Vendors table: vendor_name, vendor_contact_last_name, and vendor_contact_first_name. Then, run this statement to make sure it works correctly. Add an ORDER BY clause to this statement that sorts the result set by last name and then first name, both in ascending sequence. Then, run this state‐ment again to make sure it works correctly. This is a good way to build and test a statement, one clause at a time.

    9. Write a SELECT statement that returns one column from the Vendors table named full_name that joins the vendor_contact_last_name and vendor_contact_first_name columns. Format this column with the last name, a comma, a space, and the first name like this:
    Doe, John
    Sort the result set by last name and then first name in ascending sequence. Return only the contacts whose last name begins with the letter A, B, C, or E. This should retrieve 41 rows.

    10. Write a SELECT statement that returns these column names and data from the Invoices table: Due Date
    Invoice Total 10%
    Plus 10%
    The invoice_due_date column The invoice_total column
    10% of the value of invoice_total The value of invoice_total plus 10%
    Return only the rows with an invoice total that’s greater than or equal to 500 and less than or equal to 1000. This should retrieve 12 rows. Sort the result set in descending sequence by invoice_due_date.

    11. Write a SELECT statement that returns these columns from the Invoices table: invoice_number invoice_total
    The invoice_number column The invoice_total column
    payment_credit_total balance_due
    Sum of the payment_total and credit_total columns
    The invoice_total column minus the payment_total and credit_total columns
    Return only invoices that have a balance due that’s greater than $50. Sort the result set by balance due in descending sequence. Use the LIMIT clause so the result set contains only the rows with the 5 largest balances.

    **## Lesson3ExerciseDirections.docx**

    Run some of the examples in this chapter In these exercises, you’ll use MySQL Workbench to run some of the scripts for the examples in this chapter. This assumes that you already know how to use MySQL Workbench, as described in chapter 2.

    1. Start MySQL Workbench.

    2. Open the script named 3‐02.sql that you should find in this directory: c:\murach\mysql\book_scripts\ch03. When it opens, you should see all of the queries for figure 3‐2. Note that each of these queries has a semicolon at the end of it.

    3. Move the insertion point into the first query and press Ctrl+Enter or click on the Execute Current Statement button to run the query. This shows you the data that’s in the Invoices table that you’ll be working with in this chapter.

    4. Move the insertion point into the second query and run it.
    parameter

    5. Open the script named 3‐05.sql in the ch03 directory. Then, run the second query. When you do, you’ll see that the result set is in sequence by the invoice_id column.

    6. Delete the ORDER BY clause from the SELECT statement and run the query again. Scroll through the result set to see that the rows are no longer in a particular sequence. When you’re done, close the script without saving the changes.

    7. Open and run the queries for any of the other examples in this chapter that you’re interested in reviewing.

    Enter and run your own SELECT statements In these exercises, you’ll enter and run your own SELECT statements. To do that, you can open the script for an example that is similar to the statement you need to write, copy the statement into a new SQL tab, and modify the statement. That can save you both time and syntax errors.

    8. Write a SELECT statement that returns three columns from the Vendors table: vendor_name, vendor_contact_last_name, and vendor_contact_first_name. Then, run this statement to make sure it works correctly. Add an ORDER BY clause to this statement that sorts the result set by last name and then first name, both in ascending sequence. Then, run this state‐ment again to make sure it works correctly. This is a good way to build and test a statement, one clause at a time.

    9. Write a SELECT statement that returns one column from the Vendors table named full_name that joins the vendor_contact_last_name and vendor_contact_first_name columns. Format this column with the last name, a comma, a space, and the first name like this:
    Doe, John
    Sort the result set by last name and then first name in ascending sequence. Return only the contacts whose last name begins with the letter A, B, C, or E. This should retrieve 41 rows.

    10. Write a SELECT statement that returns these column names and data from the Invoices table: Due Date
    Invoice Total 10%
    Plus 10%
    The invoice_due_date column The invoice_total column
    10% of the value of invoice_total The value of invoice_total plus 10%
    Return only the rows with an invoice total that’s greater than or equal to 500 and less than or equal to 1000. This should retrieve 12 rows. Sort the result set in descending sequence by invoice_due_date.

    11. Write a SELECT statement that returns these columns from the Invoices table: invoice_number invoice_total
    The invoice_number column The invoice_total column
    payment_credit_total balance_due
    Sum of the payment_total and credit_total columns
    The invoice_total column minus the payment_total and credit_total columns
    Return only invoices that have a balance due that’s greater than $50. Sort the result set by balance due in descending sequence. Use the LIMIT clause so the result set contains only the rows with the 5 largest balances.

    **## SQLLesson3Questionstocomplete.docx**

    Exercise 8: Write your SQL statement in a file named CIS276DA_Lesson3Exercise8_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise8_MEID.csv.

    Exercise 9: Write your SQL statement in a file named CIS276DA_Lesson3Exercise9_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise9_MEID.csv.

    Exercise 10: Write your SQL statement in a file named CIS276DA_Lesson3Exercise10_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise10_MEID.csv.

    Exercise 11: Write your SQL statement in a file named CIS276DA_Lesson3Exercise11_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise11_MEID.csv .

    Custom Query 1: Create a SELECT statement that uses WHERE. Save this SQL statement as CIS276DA_Lesson3Custom1_MEID.sql . Run the script and export the results to CIS276DA_Lesson3Custom1_MEID.csv.

    Custom Query 2: Create a SELECT statement that uses ORDER BY and LIMIT. Save this SQL statement as CIS276DA_Lesson3Custom2_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Custom2_MEID.csv.

    Place all SQL files(6) and CSV files(6) in a folder labeled "Lesson 3".

    Replace "MEID" in the file names with your actual MEID.

    Zip the entire "Lesson 3" folder as described in the Syllabus.

    Submit the zipped assignment folder using the link below

    **## Lesson3ExerciseDirections.docx**

    Run some of the examples in this chapter In these exercises, you’ll use MySQL Workbench to run some of the scripts for the examples in this chapter. This assumes that you already know how to use MySQL Workbench, as described in chapter 2.

    1. Start MySQL Workbench.

    2. Open the script named 3‐02.sql that you should find in this directory: c:\murach\mysql\book_scripts\ch03. When it opens, you should see all of the queries for figure 3‐2. Note that each of these queries has a semicolon at the end of it.

    3. Move the insertion point into the first query and press Ctrl+Enter or click on the Execute Current Statement button to run the query. This shows you the data that’s in the Invoices table that you’ll be working with in this chapter.

    4. Move the insertion point into the second query and run it.
    parameter

    5. Open the script named 3‐05.sql in the ch03 directory. Then, run the second query. When you do, you’ll see that the result set is in sequence by the invoice_id column.

    6. Delete the ORDER BY clause from the SELECT statement and run the query again. Scroll through the result set to see that the rows are no longer in a particular sequence. When you’re done, close the script without saving the changes.

    7. Open and run the queries for any of the other examples in this chapter that you’re interested in reviewing.

    Enter and run your own SELECT statements In these exercises, you’ll enter and run your own SELECT statements. To do that, you can open the script for an example that is similar to the statement you need to write, copy the statement into a new SQL tab, and modify the statement. That can save you both time and syntax errors.

    8. Write a SELECT statement that returns three columns from the Vendors table: vendor_name, vendor_contact_last_name, and vendor_contact_first_name. Then, run this statement to make sure it works correctly. Add an ORDER BY clause to this statement that sorts the result set by last name and then first name, both in ascending sequence. Then, run this state‐ment again to make sure it works correctly. This is a good way to build and test a statement, one clause at a time.

    9. Write a SELECT statement that returns one column from the Vendors table named full_name that joins the vendor_contact_last_name and vendor_contact_first_name columns. Format this column with the last name, a comma, a space, and the first name like this:
    Doe, John
    Sort the result set by last name and then first name in ascending sequence. Return only the contacts whose last name begins with the letter A, B, C, or E. This should retrieve 41 rows.

    10. Write a SELECT statement that returns these column names and data from the Invoices table: Due Date
    Invoice Total 10%
    Plus 10%
    The invoice_due_date column The invoice_total column
    10% of the value of invoice_total The value of invoice_total plus 10%
    Return only the rows with an invoice total that’s greater than or equal to 500 and less than or equal to 1000. This should retrieve 12 rows. Sort the result set in descending sequence by invoice_due_date.

    11. Write a SELECT statement that returns these columns from the Invoices table: invoice_number invoice_total
    The invoice_number column The invoice_total column
    payment_credit_total balance_due
    Sum of the payment_total and credit_total columns
    The invoice_total column minus the payment_total and credit_total columns
    Return only invoices that have a balance due that’s greater than $50. Sort the result set by balance due in descending sequence. Use the LIMIT clause so the result set contains only the rows with the 5 largest balances.

    **## SQLLesson3Questionstocomplete.docx**

    Exercise 8: Write your SQL statement in a file named CIS276DA_Lesson3Exercise8_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise8_MEID.csv.

    Exercise 9: Write your SQL statement in a file named CIS276DA_Lesson3Exercise9_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise9_MEID.csv.

    Exercise 10: Write your SQL statement in a file named CIS276DA_Lesson3Exercise10_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise10_MEID.csv.

    Exercise 11: Write your SQL statement in a file named CIS276DA_Lesson3Exercise11_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Exercise11_MEID.csv .

    Custom Query 1: Create a SELECT statement that uses WHERE. Save this SQL statement as CIS276DA_Lesson3Custom1_MEID.sql . Run the script and export the results to CIS276DA_Lesson3Custom1_MEID.csv.

    Custom Query 2: Create a SELECT statement that uses ORDER BY and LIMIT. Save this SQL statement as CIS276DA_Lesson3Custom2_MEID.sql. Run the script and export the results to CIS276DA_Lesson3Custom2_MEID.csv.

    Place all SQL files(6) and CSV files(6) in a folder labeled "Lesson 3".

    Replace "MEID" in the file names with your actual MEID.

    Zip the entire "Lesson 3" folder as described in the Syllabus.

    Submit the zipped assignment folder using the link below

    **## Lesson3ExerciseDirections.docx**

    Run some of the examples in this chapter In these exercises, you’ll use MySQL Workbench to run some of the scripts for the examples in this chapter. This assumes that you already know how to use MySQL Workbench, as described in chapter 2.

    1. Start MySQL Workbench.

    2. Open the script named 3‐02.sql that you should find in this directory: c:\murach\mysql\book_scripts\ch03. When it opens, you should see all of the queries for figure 3‐2. Note that each of these queries has a semicolon at the end of it.

    3. Move the insertion point into the first query and press Ctrl+Enter or click on the Execute Current Statement button to run the query. This shows you the data that’s in the Invoices table that you’ll be working with in this chapter.

    4. Move the insertion point into the second query and run it.
    parameter

    5. Open the script named 3‐05.sql in the ch03 directory. Then, run the second query. When you do, you’ll see that the result set is in sequence by the invoice_id column.

    6. Delete the ORDER BY clause from the SELECT statement and run the query again. Scroll through the result set to see that the rows are no longer in a particular sequence. When you’re done, close the script without saving the changes.

    7. Open and run the queries for any of the other examples in this chapter that you’re interested in reviewing.

    Enter and run your own SELECT statements In these exercises, you’ll enter and run your own SELECT statements. To do that, you can open the script for an example that is similar to the statement you need to write, copy the statement into a new SQL tab, and modify the statement. That can save you both time and syntax errors.

    8. Write a SELECT statement that returns three columns from the Vendors table: vendor_name, vendor_contact_last_name, and vendor_contact_first_name. Then, run this statement to make sure it works correctly. Add an ORDER BY clause to this statement that sorts the result set by last name and then first name, both in ascending sequence. Then, run this state‐ment again to make sure it works correctly. This is a good way to build and test a statement, one clause at a time.

    9. Write a SELECT statement that returns one column from the Vendors table named full_name that joins the vendor_contact_last_name and vendor_contact_first_name columns. Format this column with the last name, a comma, a space, and the first name like this:
    Doe, John
    Sort the result set by last name and then first name in ascending sequence. Return only the contacts whose last name begins with the letter A, B, C, or E. This should retrieve 41 rows.

    10. Write a SELECT statement that returns these column names and data from the Invoices table: Due Date
    Invoice Total 10%
    Plus 10%
    The invoice_due_date column The invoice_total column
    10% of the value of invoice_total The value of invoice_total plus 10%
    Return only the rows with an invoice total that’s greater than or equal to 500 and less than or equal to 1000. This should retrieve 12 rows. Sort the result set in descending sequence by invoice_due_date.

    11. Write a SELECT statement that returns these columns from the Invoices table: invoice_number invoice_total
    The invoice_number column The invoice_total column
    payment_credit_total balance_due
    Sum of the payment_total and credit_total columns
    The invoice_total column minus the payment_total and credit_total columns
    Return only invoices that have a balance due that’s greater than $50. Sort the result set by balance due in descending sequence. Use the LIMIT clause so the result set contains only the rows with the 5 largest balances.