Assignment:
Planning the DBLC" Please respond to the following:
• The development of a database requires thorough methodology that ensures quality within the solution. Imagine you have been contracted to develop a finance database that will help an organization track monthly expenditures by departments. Using the DBLC, discuss the various activities that you would have to achieve each phase. Assess possible challenges that may exist within each phase. Suggest actions that one can perform in order to overcome these possible challenges.
• In order to mitigate risks associated with a database, it is essential to consider common sources of database failures. Describe at least two possible database failures that may occur once a database is placed into operation. Suggest actions that may be performed in order to avoid or mitigate these possible failures.
Classmate:
"Planning the DBLC" Please respond to the following:
The development of a database requires thorough methodology that ensures quality within the solution. Imagine you have to been contracted to develop a finance database that will help an organization track monthly expenditures by departments. Using the DBLC, discuss the various activities that you would have to achieve each phase. Assess possible challenges that may exist within each phase. Suggest actions that one can perform in order to overcome these possible challenges.
Database Initial Study : This is the phase where the decision is made of what the goals are when it comes to the database.If a database is designed and there is no idea what the concept of it will be. It will just be confusing. Ex. A database for sales.
Database Design: This is the phase where the physical design of the database is created. There needs to be a layout (design) for the database and what are the components for the design. Ex. hardware, software, procedures, data access language, etc.
Implementation and Loading: This is the phase the database is installed and data is loaded. If the design specifications aren't implemented.
Testing and Evaluation: This is the phase where the database is tested. If the database isn't tested there can be problems with connections and usage. Ex. loading the data, setting up the users and security.
Operation: This the phase where the information is produced and how it flows. If the database isn't operational then the users won't be able to use it. Ex.
Maintenance and Evolution: This is the phase where changes are introduced. If the other steps haven't been fixed then the database won't run correctly. Ex. Boosting performance, additional user requirements are met.
In order to mitigate risks associated with a database, it is essential to consider common sources of database failures. Describe at least two possible database failures that may occur once a database is placed into operation. Suggest actions that may be performed in order to avoid or mitigate these possible failures.
The first possible database failure that may occur once a database is placed into operation is that of a network. There can be a lost connection between the client and database server. The second possible database failure that may occur once a database is placed into operation is when it comes to user process. This is when a single database connection fails.