Prior to beginning work on this assignment read Chapters 1, 2, and 9 of your textbook, review the Database Life cycle (Links to an external site.)Links to an external site. and (DBL) Database Life Cycle (Links to an external site.)Links to an external site. online resources, and review any relevant information in this week’s lecture. These sources will be used to support your work in the assignment. It is also recommended that you log in to your virtual lab environment and make sure you can access the Structured Query Language (SQL) server housed there.
Successful database development must appropriately reflect the information system of which the database is a part. In order to ensure that the database captures the needed information for the target information system, database architects must work within a framework known as the Database Development Life Cycle (DBL). The DBL includes steps ranging from initial assessment and analysis to operation and maintenance. This assignment will be the first step in the creation of your Week Six Database Design Project.
For this assignment, analyze the user needs laid out in the ISM641 DBL Scenario Preview the document in order to facilitate the development of a database life cycle for the project. Within your paper describe the steps of the Database Development Life Cycle as it relates to the Construct Co needs. Explain the analysis, design, implementation and testing tasks needed to complete each step within the DBL for Construct Co. For the conceptual design phase of the development, describe how unstructured data can be converted to structured data. Explain a minimum of two challenges, either business or technical, you might face when implementing the DBL process and suggest ways in which you would overcome these challenges. Use evidence from your required resources to support your statements.
The final portion of your paper will be a one-page professional memo that will explain the DBL steps to the Construct Co executive team. The objective of the memo is to gain buy-in for the database development process in order to ensure successful project implementation. (Information on Writing a Business Memo Preview the document, as well as a Business Memo Template Preview the document, and a Sample Business Memo Preview the document are provided for your convenience.)
The following are the online resources being requested to review:
https://mariadb.com/kb/en/library/database-lifecycle/
https://www.relationaldbdesign.com/relational-database-design/module3/dblc-design-stages.php