Description

Everything is based on Qsee SuperLite Software company Part 1 to be completed in 2 Days Review your company's mobile system by completing the following using Microsoft® SQL Server 2014: Create an Entity Relationship Diagram (ERD) for the mobile database Write SQL scripts in Microsoft® SQL Server for the mobile database, including: A Data Definition Language (DDL) script with a minimum of three tables Four Data Manipulation Language (DML) scripts that can be an insert, truncate, update, delete or any combination thereof Write and run a test script for Step Two. Save a screen shot of the results.

 Part 2 to be completed in 3 days Design a process flow illustrating your proposed data migration process. Include it in your presentation. Create a 6-slide PowerPoint® presentation that includes the following topics: The ERD The SQL scripts in Microsoft® SQL Server and test script and results The data migration process flow Compile your PowerPoint® presentations you created from Weeks One through Five into a final presentation directed to the Chief Information Office (CIO) and Governance Review Board. Include any feedback received from your instructor and ensure your presentation includes content that addresses the following criteria: Differentiates between general purpose and specialized databases Identifies uses of special purpose databases in business Introduces goals for effective database design Explains how temporal databases are used in business Explains how structured query language (SQL) is used with temporal databases Demonstrates how a temporal database is used in business Explains how spatial databases are used in business Explains how structured query language (SQL) is used with spatial databases Explains the importance of indexing with spatial databases Demonstrates how a spatial database is used in business Demonstrates how an extensible markup language (XML) database is used Explains how multimedia databases are used in business Explains how NoSQL databases are being used to store unstructured business data Explains how mobile databases are used in business Contrasts online transaction processing (OLTP) and online analytical processing (OLAP) databases Describes data warehouses and data mining Explains knowledge management Explains the process of information retrieval If you need more information please ask.