Final Project I will upload all information that will be need to complete this assignment. I want daily updates and I am giving more than enough time to complete. Please a just any prior work that needs it.
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
3. 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 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.