Question: This policy will be reviewed no later than 5 years of its authorisation date. At this point it will need to be re-authorised by the

 This policy will be reviewed no later than 5 years ofits authorisation date. At this point it will need to be re-authorisedby the relevant authority at Xxz Financial Services Version Published Description' AuthorNext review Version 1.2022 05/02/2022 Policy extended by 5 Sharon Apple Tobe reviewed no years from current later than 30" October version 2026OFFICIALOFFICIAL Client/Company address Service agreements Company file Financial details Sharon Apple hasbeen named as the Privacy Officer for Xyz Financial Services and sheis based in the CEO's office Refer to the supplementary documents tohelp you complete this assessment. SD_BHFS_DataHandlingPolicy_V1_20230310.docx. SD_BHFS_DataHandlingProcedures_V1_20230310.docx. SQ .BHES_Database BackupProcedure_V1_20230310.docx. SD_BHFS_UsingCompanyDatabases_V1_20230310.docx Forthis section, Xyz Financial Services Have asked for your help completing aprivacy impact assessment against the APP. They have asked you to reviewthe following APPs. APP 1 - Open and transparent management of personalinformation APP 3- Collection of solicited personal information. APP 6 - Useor disclosure of personal information. APP 12 - Access to personal information.You will address your report to Sharon Apple, Privacy Officer for XYZFS,recommending these changes Suggested headings for report: Report Date Student Name OrganisationName Executive Summary List of relevant Organisation Policies List of Identified issuesList of associated recommendations ConclusionStep 3: Upload the backup file into thespecified location OneDrive Search + New f Upload * Share @ Copylink & Sync + Download ". IF Sort O My files >ThreatSystems Backups Uploaded 1 item to ThreatSystems Backups 189 KB O DName Modified Modif sales.sql 189 KB sales sql A few seconds agoKate Si Share Step 4: Rename and Verify the file has beenuploaded OneDrive Search E + New F Upload * 4 Share Copy

This policy will be reviewed no later than 5 years of its authorisation date. At this point it will need to be re-authorised by the relevant authority at Xxz Financial Services Version Published Description' Author Next review Version 1.2022 05/02/2022 Policy extended by 5 Sharon Apple To be reviewed no years from current later than 30" October version 2026OFFICIAL OFFICIAL Client/Company address Service agreements Company file Financial details Sharon Apple has been named as the Privacy Officer for Xyz Financial Services and she is based in the CEO's office Refer to the supplementary documents to help you complete this assessment. SD_BHFS_DataHandlingPolicy_V1_20230310.docx. SD_BHFS_DataHandlingProcedures_V1_20230310.docx. SQ .BHES_Database BackupProcedure_V1_20230310.docx. SD_BHFS_UsingCompanyDatabases_V1_20230310.docx For this section, Xyz Financial Services Have asked for your help completing a privacy impact assessment against the APP. They have asked you to review the following APPs. APP 1 - Open and transparent management of personal information APP 3- Collection of solicited personal information. APP 6 - Use or disclosure of personal information. APP 12 - Access to personal information. You will address your report to Sharon Apple, Privacy Officer for XYZFS, recommending these changes Suggested headings for report: Report Date Student Name Organisation Name Executive Summary List of relevant Organisation Policies List of Identified issues List of associated recommendations ConclusionStep 3: Upload the backup file into the specified location OneDrive Search + New f Upload * Share @ Copy link & Sync + Download ". IF Sort O My files > ThreatSystems Backups Uploaded 1 item to ThreatSystems Backups 189 KB O D Name Modified Modif sales.sql 189 KB sales sql A few seconds ago Kate Si Share Step 4: Rename and Verify the file has been uploaded OneDrive Search E + New F Upload * 4 Share Copy link s Sync + Download IF Sort Y Y O My files > ThreatSystems Backups Name " Modified v Modified By File size Sharing 7BU-SalesDB-2022.05.22.sql.sql A few seconds ago Kate Simpson 189 KB Private The offsite backup has now been completed.10. Definitions Sensitive information" is a sub-set of personal information and is given a higher level of protection under the national privacy principles. Sensitive information is information relating to an individual's: racial or ethnic origin political opinions; membership of a political association; religious beliefs or affiliations' philosophical beliefs" membership of a professional or trade association; membership of a trade union: sexual preferences or practices: or criminal record. 11. Reporting incidents Any user that is witness to malfunctioning infrastructure or software or is made aware of a security breach must report the event to the IT security team. The first step in reporting the incident is to complete the incident report form with all peauicead, information. No section is to be left blank for this form so that It security team have enough information to review the incident thoroughly. An example of the incident form is below. Incident Report Template REPORTED BY: DATE OF REPORT: Date of activity Name TITLE / ROLE: INCIDENT NO.: 001 Data analyst INCIDENT INFORMATION INCIDENT TYPE: Type of event DATE OF INCIDENT: Date of activity LOCATION: Location of activity Luz SYSTEMS AFFECTED: Company Database Financial Services office INCIDENT DESCRIPTION Describe what the incident is and was malfunctioning or performing as expected? STEPS TO REPLICATE THE ISSUE What did you do before the incident happened? Can this incident be replicated? REPORTING OFFICER: Name PHONE FOLLOW-UP ACTION What steps have you taken since the event? SUPERVISOR NAME: Sharon Apple (privacy officer) 12. Revision History / Review periodCreate an offsite backup file: To create an offsite backup, you will need to have completed the onsite backup first. Offsite backups must be named: BU-SalesDB-YYYY.MM.DD.sql for example BU-SalesDB-2022.05.22.sql Once completed move on to the following: Step 1: Locate the backup file Downloads > UniServerZ > db_backup_restore Search db_backup_restore Name Date modified Type Size sales.sql 22/05/2022 4:19 PM SQL Source File 190 KB Step 2: Login to your cloud file host Microsoft OmeDrive Sign in Microsoft account What's this? Password Sign in Can't access your socount? Don't have a Microsoft account? Sign up now Privacy & Cookies | Terms of Use @2016 MicrosoftU UniServer Zero XIV MySQL Database Backup X General Extra Apache MySOL PHP Perl About Display all databases Select a database to backup Enter backup file name ZERO Stop Apache production sales.sql sales Stop MySQL Apache Utilities MySQL Utilities Clear Help Server Console MySQL Console VIEW WWW phpMyAdmin Create backup View ssl opt2 Documentation opt Step 6: Verify the backup has completed by navigating to the folder where the backup has saved (..UniServer2\\db_backup restore) Downloads > UniServerZ > db_backup_restore O Search db_backup_restore Name Date modified Type Size sales.sql 22/05/2022 4:19 PM SQL Source File 190 KB The onsite backup has now been completed.Database Backup Procedure-XYZ Financial Services PTY LTD 1. PURPOSE The purpose of this policy is to establish a consistent and secure mechanism to store company database files. This involves creating 2 locations of the database backup files. The first location is to be kept onsite and the second location is to be kept offsite through a cloud provider. Create an onsite backup file: (If any technical difficulties arise refer back to the manufacturer's guide: http://www.uniformserver.com/ZeroXI documentation/mysql database backup restore.html Step 1: Open the UniServer, Control Panel U UniServer Zero XIV X General Extra Apache MySQL PHP Perl About UZERO Stop Apache Stop MySQL Apache Utilities MySQL Utilities Server Console MySQL Console View www phpMyAdmin View ssl opt2 Documentation opt3 Step 2: Select the MYSQL menu U UniServer Zero XIV 0 X General Extra Apache MySOL PHP Perl About ERO Stop Apache Stop MySQL Apache Utilities MySQL Utilities Server Console MySQL Console View www phpMyAdmin View ssl opt2 Documentation opt3Step 3: Select the database backup option U UniServer Zero XIV X General Extra Apache MySQL PHP Perl About Change MySQL port U ZERO Change MySQL password Restore default password (root) Database create-delete Apache Utilities Create restricted MySQL user Server Console Edit restricted MySQL user View www Database backup Database restore View s5l 12 Edit Config file my.ini Documentation C) MySQL error log Step 4: In the pop-up window, select the database to backup (sales) UniServer Zero XIV MySQL Database Backup General Extra Apache MySOL PHP Perl About Display all databases Select a database to backup Enter backup file name ZERO Stop Apache production sales.sql sales Stop MySQL Apache Utilities MySQL Utilities Clear Help Server Console MySQL Console View www phpMyAdmin Create backup View ssl opt2 Documentation opt3 Step 5: select "create backup"Step 3: You will now see the control panel for our webserver and database. To turn this infrastructure on select *start Apache". Once this webserver start 2 windows will open automatically in your default web browser. You can safely close these 2 windows as we will not be using them. U UniServer Zero XIV O X General Extra Apache MySQL PHP Perl About UZ ERO Start Apache Start MySQL Apache Utilities MySQL Utilities Server Console MySQL Console View www phpMyAdmin View sEl opt2 Documentation opt3 Wait for a moment for it to start and then select Start MySQL If this has started correctly you will see two green icons next to their name indicating they are active. U UniServer Zero XIV X General Extra Apache MySQL PHP Perl About ERO Stop Apache Stop MySQL Apache Utilities MySQL Utilities Server Console MySQL Console View www phpMyAdmin View sal opt2 Documentation opti The webserver and database are now ready to useCreating a new user account Step 1: Select phpMyAdmin from the control panel. U UniServer Zero XIV X General Extra Apache MySQL PHP Perl About UZERO Stop Apache Stop MySQL Apache Utilities MySQL Utilities Server Console MySQL Console View www phpMyAdmin View sal 0p12 Documentation Step 2: A website will appear asking you to login. The default username is mont and the default password is root. If you changed your password in the earlier step of setting up the database server, please use that password here phpMyAdmin C O localhost #1/us_opt1/index.php phpMyAdmin Welcome to phpMyAdmin Language English Log in Usemama Password: Go Step 3: Select user accounts from the tab at the top of the home page.Read through the following scenario, and then complete the deliverables and submit as a report. Scenario XYZ Financial Services Pty Ltd provides financial services to both individual clients and small to medium size enterprises. They offer Audit & Assurance, Tax assistance, Consulting, and Finance & Funding assistance. BHFS uses a sophisticated backup and integrity system to store their customer data as the customer data in their onsite and cloud systems must be very secure to meet state and federal law. The company have several systems in place to store and handle their customer private data and client business information. These policies and procedures can be found in the supporting documentation for your assessment upload area. Throughout the assessment you will look at different aspects of the organisation to offer advice on how they can best handle, store, and backup their customers data. Threat systems currently collect information from their clients for only the purpose of providing essential services. They do not sell or allow third parties to have access to customer data. Daily backups of BHFS data are stored in the cloud. Currently Xyz Financial Services store the following client details on their local data server: o Client/company name o Client'company liaison o First contact (Including verification of this person) Name, Email, Driver license, Phone number, after hours contact number, Police check (including criminal record). o Back up contact (Including verification of this person) Name, Email, Driver license, Phone number, after hours contact number, Police check (including criminal record). o General contact: Name, Email, phone (limited access to customer information) o PCI/ Banking information for the purpose of refunds and accounts receivable automatic payment allocations Information on complaints is kept confidentially in the company database. This location has strict access controls in place to ensure only case managers can. Complaint dons nut Provide an outcome Close the complaint Acknowledg the noenlight the comp aint Complaint is received co-plan! Associa Low complaint Provide an update to be -panant Complaint carries an Provide the final butcoms cloin the complaint 9. References In the event of a suspected theft involving data, data breaches or exposures (including unauthorised access, use, or disclosure) to Xxz Financial Services clients. The Company's Data Breach policy will come into effect. This policy will outline the response to a confirmed theit, data breach or exposure based on the type of data involved. 9.1 Australian Privacy principles Xxz Financial Services is committed to ensuring privacy and ethical hand ing of data within the company. We aim to adhere to and comply with the Australia Privacy Principles (APPs) as listed below: Open and transparent management of Ensures that APP entities manage personal information in an open and transparent APP 1 personal information way. This includes having a clearly expressed and up to date APP privacy policy APP 2 Requires APP entities to give individuals the option of not identifying themselves, or Anonymity and pseudonymity of using a pseudonym. Limited exceptions apply. APP 3 Collection of solicited personal Outlines when an APP entity can collect personal information that is solicited. It information. applies higher standards to the collection of sensitive information. Dealing with unsolicited personal APP 4 Outlines how APP entities must deal with unsolicited personal information. information Notification of the collection of APP 5 Outlines when and in what circumstances an APP entity that collects personal personal information information must tell an individual about certain matters. Use or disclosure of personal APP 6 Outlines the circumstances in which an APP entity may use or disclose personal information information that it holds. APP 7 An organisation may only use or disclose personal information for direct Direct marketing marketing purposes if certain conditions are met. Cross-border disclosure of personal Outlines the steps an APP entity must take to protect personal information before it is APP a information disclosed overseas. APP 9 Adoption, use or disclosure of Outlines the limited circumstances when an organisation may adopt a government government related identifiers related identifier of an individual as its own identifier, or use or disclose a government related identifier of an individual. An APP entity must take reasonable steps to ensure the personal information it APP 10 Quality of personal information collects is accurate, up to date and complete. An entity must also take reasonable steps to ensure the personal information it uses or discloses is accurate, up to date, complete and relevant, having regard to the purpose of the use or disclosure. An APP entity must take reasonable steps to protect personal information it holds APP 11 Security of personal information from misuse, interference and loss, and from unauthorised access, modification or disclosure. An entity has obligations to destroy or de-identify personal information in certain circumstances. Outlines an APP entity's obligations when an individual requests to be given access to APP 12 Access to personal information personal information held about them by the entity. This includes a requirement to provide access unless a specific exception applies. APP 13 Correction of personal information Outlines an APP entity's obligations in relation to correcting the personal information it holds about individuals.The data owner assigns each piece of data a classification label based on the overall impact level: OVERALL IMPACT LEVEL CLASSIFICATION LABEL High Restricted (often referred to as 'Classified") Moderate Confidential (often referred to as 'Sensitive" Low Public (often referred to as 'Official") 5. Types of Information that Must be Classified as "Restricted" The definitions and examples below is taken from the NIST framework which is the company's prefer framework for impact level and determining a classification label AUTHENTICATION INFORMATION, used to verify users on Xyz Financial Services infrastructure and portals. Authentication information is data or information used to prove the identity of an individual, system or service. Examples include: Passwords Shared Secrets Cryptographic private keys Hash tables PAYMENT CARD INFORMATION (PCI) Payment card information is defined as a credit card number in combination with one or more of the following data elements: Cardholder name Service code Expiration date CVC2, CVV2 or CID value PIN or PIN block Contents of a credit card's magnetic stripe PERSONALLY IDENTIFIABLE INFORMATION (PI) Pll is defined as a person's first name or first initial and last name in combination with one or more of the following data elements: Social security number State-issued driver's license number State-issued identification card number Financial account number in combination with a security code, access code or password that would permit access to the account Medical and/or health insurance information Collection of confidential information Where confidential information is collected, it must be consented by the client prior to the information being collected. A record of the consent must be kept in the company file. Collection of restricted information Xux Financial Services will inform any client/customer prior to the collection of restricted data however will not require consent where the data collected is essential to providing our services to the customer. 6. Disclosure of information Xwz Financial Services will not disclose or use client information for any secondary or additional purposes. Should the use and disclosure arrangements be changed in the future XXX Financial Services will require written consent for secondary use or disclosure of data held by the company. 7. Access to information Xxx Financial Services will provide access to your collected information for the purpose of updating and revoking inaccurate data. In order to access your data, you will be required to phone the privacy officer. There is a verification process required to ensure we can confirm your identity prior to access to collected information. All concerns related to privacy should be forwarded to the privacy officer. All concerns relating to ethic of the data use should be forwarded to the ethics advisor. B. Complaints Xxx Financial Services clients have the right to complain and provide feedback about the ways personal information is access and handled. To the right is the process of complaints and steps involved for the complaints procedure.Iwin Step 8: To login to this account you will need to log out as the root user. Me localhost:81 / Uniform Server | pl X C O localhost 81/us_opt1/i phpMyAdmin Recent Favorites Us To New + Information_schema +0 mysql +0 performance_schema +0 phpmyadmin +HC production +0 sales + sys Step 7: you can now use the new account you just created. A test account has been loaded into program with the credentials of: Username: test Password: 1234Services Authorised 05/12/20 Data handling Procedures - Xxz Financial Services PTY LTD Guide Data used in the company may contain sensitive or restricted information. the type of protection to be applied to your information will be subject it's impact assessment of the need for the Confidentiality special handling. The flowchart below summarises the process of determining and classifying information used by Myz Financial Services. Data classification Flowchart: Obtain customer Data Is the data Restricted asper the company's policy? Restricted Data Is there a high need for Integrity or availability? In the data sentitvel (would it be a problem is anybody had this Information Confidential Data Is there a moderate need need for Integrity of availabley? the date public? this data wile for everyone to tee?) Public Data Is there a low need for Integrity or manilablity? Comult with Unable to clanally Refer to 800-600 Company's Data data m above Volume 2 custodian to categories determine Classification levelServices Authorised US 12/2027 Using Company Databases- Xxz Financial Services PTY LTD 1. PURPOSE The purpose of this policy is to establish a secure mechanism and ongoing maintainability of company information. Company information is store in databases that have user accounts and privilege levels. In this guide we will look at access and use of company database. Setting the company Database In the supporting documentation of this assessment there is a folder called UniServer, This folder contains all the files required to access the company database. Please note this setup requires a windows operating system no spaces in the file path leading to this folder Step 1: Open the UniController.exe file > This PC > Downloads > UniServerZ P Search UniServerZ Name Date modified Type Sure core 6/04/2022 2:38 AM File folder db_backup_restore 22/05/2022 4:19 PM File folder 2/10/2019 8:47 PM File folder home 6/04/2022 2:39 AM File folder hipasswid 6/04/2022 2:38 AM File folder ogs 7/05/2019 11:46 PM File folder 6/04/2022 2:37 AM File folder - Box Hill Institute Imp 22/05/2022 4:17 PM File folder util 12/08/2019 1:39 AM File folder WWW 6/04/2022 2:37 AM File folder http2_read_me.txt 6/04/2022 2:26 AM Text Document 2 KB loud Files MUST READ.txt 12/04/2022 9:00 AM Text Document 2 KB U UniController.exe 3/04/2022 12:49 PM Application 3,689 KB ZeroXIV_controller_read_me.txt 12/04/2022 11:09 AM Text Document B KB Step 2: A pop up window will appear asking you the MySQL password. Enter root as the password. If you change this value, please write it down as you will need this password later in this guide. MySQL root password - current value root X Enter new MySQL root password or press cancel: OK X Cancel You will then receive a confirmation the password has been set / changed MySQL Info X MySQL root password changed OKStep 4: Select add new account on this page phpMyemin User accounts overview Step 5: Enter in the user information you require, for example this would create a read only user access: Add user account Login Information Auchainborton pluginData handling Policy - XXx Financial Services PTY LTD 1. PURPOSE The purpose of this policy is to establish a framework for Handling data at Xux Financial Services PTY LTD, this involves the septs to classify company data based on its sensitivity level, value to the company and importance to the company. sensitive client data must be protected and secured properly which includes being protected by misuse or misconduct. 2. SCOPE This policy applies to all forms of data, paper or digital, that is stored by Xyz Financial Services PTY LTD company end user device and service infrastructure. It applies to all employees of Xxx Financial Services, as well as to third-party agents authorised to access the data. 3. ROLES AND RESPONSIBILITIES Data owner The person responsible for the data, this may be a Team leader in any service area in Xyz Financial Services PTY LTD. The data owner must ensure the following objectives: 1. Reviewing the classification: Review the data classifications and information including the purpose of collection for the company. 2. Access controls: Safeguard and implement access controls, maintained and auditable in line with the data / information classification categories. 3. Audit reporting: Submit quarterly and annual reports that cover confidentiality. integrity and availability of classified or restricted datasets 4. Classification labels: Allocate and maintain classification categories and document labelling that is aligned with the data's potential impact level. 5. Data compilation: Ensure that data compiled from multiple sources is classified with at least the most secure classification level of any individually classified data Data classification management: Confirm that shared data is labelled as classified or where possible deidentified to protected from misuse or misconduct 7. Classification compliance: information with a moderate or higher impact level is protected in agreement with federal and state legislation, regulations and standards 8. Data access: Maintain data access strategies for each of the classification categories or labels and access levels. Data custodians Information security officers are accountable for maintaining and backing up the systems, critical infrastructure that store the company's data. These privacy and confidentially techniques listed below are to be implemented on all company devices that may be used to store edit or in any way handle customer data. In addition, a custodian's responsibilities include: Data backups: ensure that we perform regular backups both on site and off site Data validation: ensure that we regularly validate data integrity to ensure system compliance and readiness Data restoration: ensure that we are able to restore data from the primary and secondary backup locations and that the system is tested at least annually. Compliance: ensure that we comply with the data handling specified in the organisation's security and privacy policies Monitor activity: ensure that we are able to monitor and record data activity, including logging of information specifying an individual who accessed the data, when it was accessed and how was it accessed. Secure storage: ensure that we have encrypted sensitive data at minimum while it is at rest and ideally while it is in transit. Data classification compliance: information with a moderate or higher impact level is secured in line with federal and state legislation, regulations and standards Data access: Maintain data access guidelines for each data classification label and access level. Data user A data user may be anyone including employee that interacts with, access, use or update the company data files for the purpose of performing a task in line with the services provided. Data users must only use the data for the primary purpose of service. 4. DATA CLASSIFICATION PROCEDURE How to determine overall impact level, as follows: (referring to data handling procedure) At its highest rating any information that matches a category listed in the restricted data below it is assigned an overall impact level of "High" by default. If it does not match any of the types below, it is assigned an overall impact level based on the Company's chosen data handling reference model: NIST 800-800 Volume 2. If you are unable to determine overall impact level, you must speak to the Privacy officer who will then determine its impact level.Shutting down the web and database server The web and database server are persistent so any changes you make to it are kept and saved. This web stack does not restore after each use. In order to shut down the servers simple turn them off from the control panel. You will need to turn off the MySQL server first and then the Apache server last. Once the icon beside their names has turned red it is safe to close the control panel. U UniServer Zero XIV X General Extra Apache MySQL PHP Perl About U ERO Start Apache Start MySQL Apache Utilities MySQL Utilities Server Console MySQL Console View www phpMyAdmin View sEl opt2 Documentation opt3 If you lose the control panel, it may be hiding in the task tray of your operating system. Uniform Server Zero Portable WAMP Server U + 1059% 5:55 PM 12"C Cloudy * 6 4 40 7 ENG 22/05/2022Retrieving information from the database: Step 1: login to the phpMyAdmin application (as per previous instructions) b locwhoull / Uniform Server | Fl (@) localhost #1/us_opt1/index.php/route=/ #O phpMyAdmin I'll Server Uniform Server 1306 E Recent Favorites General settings -information_schema -mysql 3 Change password +0 performance_schema Server connection collation: @ utfe_general_ci +0phpmyadmin (40 production More settings sales New He customers Appearance settings Old employees OH offices Language O English orderdetails orders Theme: pmahomme v CH payments Hid productlines OH products Database server Step 2: Select the sales databaseOperations . Tracking Exporting rows from "customers" table New template: Existing templates: SOL gary Export method CWimMIN How in bean of: If you used the export option, the data will be saved to the following folder: I phpmyadmin HOME Share New This PC > Downloach > UniserenZ , etc . phpmyadmin Search phpmyadmin Date modified Sing Quick access customer-table 2022-05-21.cow 22/05/2032 5:40 PM Microsoft Exel C.. I KE Desktop Downloads The clipboard function will copy the table formatting which you can then paste in Excel with ease. You have now retrieved information from the database.X de look hot!1 / Ureform Server / 1 C (@ Iocehost 81/us_opt1/index.php/route=/database/structurekeserver=16idb=sales phpMyAdmin Soiver Urilor Somer 1306 > ) Database sales Recent Favorites Filters HO information_schema Containing the word HO performance_schema Rows H phpmyadmin Table Action Type Call Ha production customers Browse } Structure S Search Ji Insert # Empty ( Drop 122 InnoDB latin employees A Browse }{ Structure 4 Search Fe Insert Empty @ Drop 23 InnoDB latin Lo New #-1 customers offices A Browse /4 Structure . Search Ji Insert Empty @ Drop 7 InnoDB latin F-1 employees O orderdetails # Browse J Structure Search Fe Insert Empty @ Drop 2,996 InnoDB latin $ 1 ofices _ orders A Browse 4 Structure & Search : Insert Empty ( Drop 326 InnoDB latin +-1 orderdetails payments Wil Browse d Structure * Search De Insert Empty @ Drop 270 InnoDB latin +-12 order productlines * Browse / Structure & Search Ti Insert Empty O Drop 7 InnoDB latin -1 payments (#-1 productlines O products Ar In Browse 14 Structure . Search be Ingan Empty O Drop 110 InnoDB latin 4-1 products i tables Sum 3,864 InnoDB Latin O Check all With selected Print a Data dictionary id Create table Name Number of columns: 4 Go Step 3: select the customers tableUh localhost:81 / Uniform Server / s C @) localhost 1/us_opt 1/index.phprroute =/squserver= 14db=salesStable - customersapos=0 phpMyAdmin Gill Server Uniform Server: 3306 @ @) Database: sales > d Tables customers Recent Favorites / Showing rows 0- 121 (122 total, Query took 0.0912 seconds.) information_schema SELECT . FROM "customers" $0 mysql +-performance_schema () Profiling [ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh | 30phpmyadmin production Show all | Number of rows: 25 Filter rows: Search this table Sort by key: Non sales Options New customerNumber customerName contactlastName contactFirstH Col-1/ customers 0 Edit a Copy O Delete Schmitt Carina CH employees 103 Atolior graphique OH offices O Edit to Copy ) Delete 112 Signal Git Stores King Jean Corderdetails O Edit Fi Copy O Delete Australian Collectors, Ferguson Pater Co. His orders payments 0 Edit 1 Copy @ Delete 119 La Rochelle Gifts Labrung Janing CH productlines products D Edit Fi Copy O Delete 121 Banne Mini Imports Bergulfsen Jonas 1 Edit ji Copy ( Delete 124 Mini Gifts Distributors Malson Susan Lid. D Ed 1 Copy O Delete 125 Havel & Zbyszek Co Piestrzeniewice Zbyszek 0 Edit is Copy O Delete 128 Blaver See Auto, Co. Keitel Roland 0 Edit Fi Copy O Delete 129 Mini Wheels Co. Murphy Julio 1 Edit To Copy ) Delate 131 Land of Toys Inc. Lag 0 Edd 1 Copy O Delete 141 Euro+ Shopping Channel Freyre Diego Valve Model 0 Edit He Copy Of Delete 144 Replicas, Co Berglund Christina O Edit i Copy Of Delete 145 Danish Wholesale Paterson Jytha Imports Saveley & Henriot, 0 Edit $ Copy @ Delete 146 Savelay Mary Ca O Edd i Copy 6 Delete 148 Dragon Souvenirs. Natividad Eric Console Step 4: Select the SQL tab at the topphpMyAdmin Tricking Shoving rows D . 121 (13d total Query tock 0 1012 seconds.) Profiling [ Edt inline ][ Dee | | Copbin SOL ][ Create PHP code ][ Hutrech ] producion Show al | Number of maes: 25 Filter Kerk Search this table Sort by kay Name Step 5: Enter in the SQL query required to retrieve the information, then select GO. phpMyadmin Step 6: export or clipboard the information in order to download it. If you use a CSV file in the export settings note you will have to reformat the data before it can be used

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Law Questions!