DB Processing & Administration

9514Signature Writing Assignment: Style is APA standard format (Refer to APA Style, under Course Resources, for APA help). Topics for this research focus on adding value to the selected selected project scenario.

Option 1 (use W4_DB_Admin_Security option1.docx file) is based on Ch16 Problems #35, 36, 37, 38, 39, 40, 41, 42 from p.768. Researching and answering these questions is a place to start an action plan for migrating a working prototype database design into a “real” database, as the data layer of a 3-tier architecture to include role of DB administration procedures.

Option 2 (use W4_DataMart_BI_Strategy option2.docx file) is a work plan with a strategy for migrating a working prototype database from a source production OLTP environment, into a Data Mart star schema design. The plan will include steps to migrate non-volatile subject-oriented records into a read-only OLAP environment. Objective is to Develop a action plan for migrating historical data from an operational source into a Business Intelligence (BI) data mart to become historical records for decision making.