Assignment title: Information


You have been assigned to be the Data Architect at your company. Your company is trying to create a baseline governance process for multiple systems and you have been tasked with preparing a review of each system. Review Figure 2-8, "Introduction to the Relational Model," in Database System Concepts. Review a company that you are familiar with or your company's Online Transaction Processing (OLTP) system, then complete the following using Microsoft ®  SQL Server 2014: 1. Create an Entity Relationship Diagram (ERD) for OLTP. 2. Write SQL scripts in Microsoft ®  SQL Server for OLTP that includes:  o A Data Definition Language (DDL) script with a minimum of three tables o 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. Use PowerPoint ®  to design a process flow illustrating your proposed data migration process. Keep in mind that data migration to a temporal database is inevitable. Create a 6-slide PowerPoint ®  presentation that addresses following topics:  The ERD  The SQL scripts in Microsoft ®  SQL Server, test script, and results  The data migration process flow