You have been invited to participate in a "lightning round" presentation for a conference attended by federal government IT managers and staff. For this activity, you must prepare a 3 to 5 paragraph briefing statement which answers the following questions. Use information from the weekly readings and Case Study #1. Go to Content >> Course Resources >> Expanded Explanation for Discussion Question Responses to learn more about the format requirements for each discussion.1. What is a privacy impact assessment (PIA)?2. Name and briefly describe 3 “best” practices for federal government IT managers who are charged with preparing a PIA.3. Name and briefly describe 3 "worst" practices for protecting privacy of individuals whose information is collected, processed, transmitted, and stored in federal government IT systems and databases.Provide in-text citations and references for 3 or more authoritative sources. Put the reference list at the end of your posting.

Compare the IoT with regular Internet.Discuss the potential impact of autonomous vehicles on our lives.Why must a truly smart home have a bot?Why is the IoT considered a disruptive technology?AT&T is active in smart city projects. Investigate their activities (solutions). Write a summary.It is said that the IoT will enable new customer service and B2B interactions. Explain how.Find information about Sophia, a robot from Hanson Robotics. Summarize her capabilities.

The Northwind Company is a small product shipping company that has grown to encompass multiple regions and territories. The company database system was established using Oracle 9e and was designed and maintained on a single Microsoft Server 2003 server by a contracted system provider. The users of the system are located at both the home office and at other sites scattered throughout their established regions/territories. The users currently access the system remotely through a Virtual Private Network (VPN). The various users of the system include:• Home Office which utilizes the system for both employee tracking as well as customer, orders, product, shippers and supplier data and reporting and as an operational real-time database management system.• Remote Region/Territory users use the system to input live data and to obtain needed sales and order information as well as using it as providing reports and information manually in response to customer, shipper and provider requests.• Customers, shippers and suppliers currently have no direct access to the system.The reports and queries generated from the system are written using various applications including Visual Basic.NET, Java, Crystal Reports, C++ and C#. All reports are custom built by the current provider. All updates, additions and deletions are accomplished by the Home Office and regional employees.Database backup and recovery is accomplished through a full backup run once weekly to a tape system that is maintained onsite in a corporate vault.Database security is provided by the current provider and was set up to meet minimum security needs for a semi-closed system. There are no restrictions on user roles.The current provider has decided not to renew their contract with Northwind and will cut off all support for the system and the licensed Microsoft SQL Server software at the end of the next six months.The company has made some preliminary decisions for migrating their system.• A financial and operational decision has been made to port all data structures and current functionality from an Oracle 9e DBMS to MSSQLS 2012.• The current database tables and relationships will remain intact• The migrated system will be hosted on a Microsoft Server 2008 server• The migrated system will allow regional employees to access the system through the web• The migrated system will restrict all users to roles specific to their needs and access requirements• The migrated system will allow customers, shippers and suppliers to access limited and customized reports• All current reporting and applications will be migrated• System backups will be scheduled on a more frequent basis but should not detract from system availability and performance• The migrated system which accommodates 200 users must be scalable in order to accept up to 2,000 users of all types over the next five yearsThe following links provide two different ERD views. One is a Microsoft SQL Server diagram and the other is a Visio diagram of the system. There is also a .sql script containing the Microsoft SQL Server DDL that would be used to create and populate the tables depicted in the ERD. It is suggested that you might want to obtain Visio from DreamSpark ( Academic Alliance) in order to view the Visio ERD which also contains information on data types, constraints and keys in a more viewable format than the DDL file. There are also a couple of documents that present some examples of best practices.instnwnd.sqlMSSQLS_diagram.docxnorthwind.vsdNGS_migration.pdfsoftek-best-practices-data-migration.pdfThe following links are provided as starter sites for your research:http://www.datamigrationpro.com/data-migration-articles/2008/12/3/data-migration-project-checklist-a-template-for-more-effecti.htmlhttp://www.swissql.com/Templates for the projectThe two templates linked below are suggested as the best templates to follow. Select one., For either plan template you choose include most if not all of the areas covered in the template. Some sections may not be applicable and you may annotate them as N/A but be very careful if you do that because there are very few items in either template that do not merit at least some level of consideration.EPLC_Implementation_Plan_Template.doc Implementation_Plan.doc The plan you present should cover in as much detail as possible the following:• All assumptions and constraints• References you used to develop your plan• System hardware and software component considerations (think in terms of what the new system will use)• Possible application component migration requirements such as migration and testing tools• System components to be integrated• How data conversions will be accomplished and how the table/relationship structures will be migrated• How the implementation will be validated• General personnel support• Impacts of implementation• Performance monitoring and evaluation• Any site changes or requirements• Estimated cost of the migration to include any new software or hardware you are recommending• Any risks and problems you foresee in the implementation plan• System backup and recovery• System, data, and user security• Rollback plan – (I recommend including a section for what to do if the implementation plan fails, will there be an option to back it out or roll it back?)This is an academic project and the details given are purposely high level and vague. It will be up to you to make general assumptions about the basic infrastructure used to support the current system and of greater interest are your proposed best recommendations for what hardware and software might be required. I want you to put your plan emphasis on migration requirements and implementation plan. Assume that any estimates of costs will be consistent with company budget constraints for this project.Again, you are developing a migration plan. While you will need to be reasonably detailed in your presentation points and should document your sources of information in developing the plan, you do not have to provide specific implementation details on setting up any new software, hardware or actual migration steps. Remember that you are presenting this to executive and IT staff and not providing an overall checklist for each step in the execution of the plan.GradingThe entire project is will be graded on a 300 point scale, divided among the milestones and paper as follows:Milestone #1 will be graded on a 50 point scale. Your clear and concise submission meeting the given requirements will receive 50 points. Late submissions will receive no points unless advance arrangements are made.Milestone #2 will be graded on a 50 point scale. Complete outlines in required format that demonstrate good progress toward completing the project will receive 50 points. Those that are incomplete or that demonstrate lack of progress toward successful completion of the project will receive something less down to zero points.Milestone #3 for your research project will be graded on a 50 point scale and will be the submission of your final draft (90% complete) of your plan to your fellow students on the Migration Project discussion form for critique.Final plan submissions will be graded on a 150 point scale. The primary grading criteria will be:1. A clearly detailed plan.2. Background information on the problem that provides convincing evidence of your own knowledge of the requirements.3. Requirements or alternatives that are clearly spelled out for a business audience.4. Recommendations or observations that are clearly stated and defended.5. Depth, accuracy, clarity, and completeness of the technical discussion and critical analysis.6. Proper grammar and spelling.7. Proper documentation.8. Was your plan submitted on time? Do you have a working knowledge of the plan you are presenting?9. Did your submission address each of the areas of interest detailed above?