Application of Database Developmental Cycle

Application of Database Developmental CycleTask 1 Apply the database developmental cycle to a given data set or a case of your own Myreadingroom1.1 details that the database development lifecycle, DDLC, contains six conformations the initial guinea pig, the design, implementation and loading, interrogatory and evaluation, operation, and living and evolution.The number 1 phase of the DDLC is the initial study. This involves investigating the companys current solution, determining what is causing it to fail and providing a future solution to resolve the issues, whilst ensuring that it is in the companys capabilities. This can be achieved in four stages analysing the company, defining the problems and constraints, defining the objectives, and defining the scope and boundaries.To analyse1.6 is to examine something regularityically and in detail. An understanding of what is currently in place helps to decipher the problems and constraints of the current port of working, whilst help ing to determine what the companys objectives ar.Whilst developing a database on that portend is always an objective1.7, something planned to be achieved, or thither can be several, depending on the requirements. During the initial study consideration should be made as to what the the desired outcome is, as well as the scope and boundaries of the solution.The issue I have been asked to resolve is that in that respect is no way for my client to determine if they have, or want to purchase, a dvd, blu-ray or tv series. The objectives they have defined for the outcome is a fully in operation(p) corpse which takes a users to bewitch and update a media. My client similarly requires the ability to generate a wish list, as well as view a list of all current media.The solution I have proposed is a Microsoft Access database as there are minor point of accumulations to the administration. The only limitation I believe may pass along is that the data held may grow to be astronomica l so a desktop database practical application may non be sufficient in the long term. A limited review should be undertaken throughout the lifecycle of the application to determine if it demand to be transferred to a relational database, hosted on a server. As Access allows you to customise the database to your requirements, my understanding is that there will be no limitations of the data stored.The second phase is the design1.1. This is defined as the intimately crucial phase in the database development lifecycle as this phase revolves around ensuring that the users requirements and objectives are met. If they are disregarded by the system developer, it would ultimately be deemed a failure and the DDLC should commence again.The implementation and loading phase of the database development lifecycle consists of installing the database management system, creating the database and loading, or converting, the data. Installation of the database plat impress should only occur if it is required. If the platform is already existent, or the install of the database has taken place, macrocosm of the database can occur.The proposed design of the application is a main fudge which is essentially based on a series of lookups from other tables indoors the application. This is to ensure data integrity and remove any duplication that may otherwise need to occur. As parcel of the proposal for the table layout and relationships, consideration should be made as to the performance of the system. Due to Microsoft Access being preinstalled as part of Office, an installation does not need to occur, however creation of the database, designed in the previous phase, is required.The proposed solution for the application is as follows, with each relationship defined utilising a star-to-one relationship1.8, where a row in one table is linked to one and only one row in another.From there the data needfully to be loaded, and possibly manipulated, into the database. As there is no current solution in place a request has been given to my client in order for the main core data to be imported. at a time this has been completed, data should be added through the application itself.The third phase, testing and evaluation, consists of testing the solution, tuning the database and finally evaluating the database and its application program. Testing is often referred to as User bridal Testing, UAT, in Yorkshire Coast Homes and involves both yourself and the superusers reviewing the system to determine if it is fit for purpose and if navigation throughout is fluid. From there, the system needs amending to introduce any of the anomalies found as part of UAT.My client will undertake the testing of the application which involves ensuring that data is able to be added to system, without any errors or having to go back to any previously accessed fields. In increase to this, they should also review if the application performs adequately and transactions are easily comple ted without delay.The penultimate phase is operation, which is essentially making the system live and operational. This involves the superusers training any users, indoors their department, how to use the system to undertake their job role. This results in the application moving from a project state to change state part of the day to day workings of a department.As my client is going to be the only user of the database at give, no training needs to occur and the transition to live should have minimal impact to them as they have worked on base myself to deliver the application.Throughout the lifecycle of the application being used, livelihood needs to occur and the application needs to evolve as the industry does. This phase is known as maintenance and evolution.Google1.2 informs that the purpose of system maintenance is to sustain the cogency of a system to return a service. This phase consists of four maintenance types, which will occur as regularly as required. They are per iodic, corrective, permissions and adaptive.Periodic maintenance refers to something of a regular occurrence. For example, in Yorkshire Coast Homes, the main housing system has a regular nightly queue which imports any monies received from customers and processes each night, alongside abandoning any no longer required repairs. Another example of periodic maintenance, which should occur in any disposal, is a backup1.3, the copying and archiving of computer data so it may be used to restore the original after a data loss matter. These can occur as regularly as an organisation requires.Periodic maintenance is partnered with corrective maintenance. This is most commonly known as recovery1.4, the process of salvaging inaccessible data which has been lost, go bad, damaged or formatted. As a database executive director you must always be prepared to restore any loss of data for any user, however this form of maintenance should only occur as and when required.The permissions element of maintenance consists of three aspects adding, amending, removing and reviewing. for each one aspect of the permissions are closely linked as a user may change job roles, requiring the adding or removing of permissions, or a third party decision may require a change. An example of where this has occurred in Yorkshire Coast Homes is access to tenants rent accounts. As part of a historic decision, everyone within the organisation had access to the rent account. Following a change in the law, users permissions were removed so that those who can access it are only those who require it within their job role, whether it be for informing a tenant of their rent, chasing any arrears or for IT to support any technical issues.The final maintenance type is adaptive. This is the process of adding features to the current system, or enhancing it. This can also be referred to as evolution. This is the process of the system evolving throughout time as either an organisation, or the technology utilis ed, advances. An example of where this has occurred in Yorkshire Coast Homes is our Total Mobile solution1.5, a digital workforce management solution. We recently upgraded to the latest reading material of software, as the interpretation we were previously running was old technology, which didnt support Android.Through the final phase of DDLC for the Media Database, the periodic maintenance that should occur is the copying of the database. This is to extend a recovery point in the event of data corruption or loss of data. Both the permissions element and adaptive maintenance have limited impact on the application. before long only one user accesses and updates data, however periodic reviews should be undertaken to determine if my client requires further users to have access. From there, adaptive maintenance may need to occur to lock down certain parts of the system my client may not want users to access. In addition to this, Microsoft may upgrade the Access application which may potentially corrupt or remove a functionality currently used within the application. Reviews should be undertaken to determine if an upgrade to a new version of Access may corrupt the application. If a decision is made to undertake an upgrade, the DDLC lifecycle should commence again.Task 2b Evaluate the effectiveness of the database solution and suggests methods of improvementMy client asked me to bring on a fully functional system which allows users to view and update a media. The solution I proposed was a Microsoft Access database which utilised relationships and joins, rather than duplicating data.The first objective, a fully functional system which allows a users to view and update a media, has been achieved utilising the Media Information form. As you can see from the diffuse print below the form details the title of the media, the media type and category. It also includes the purchase information and the genre(s).The second and third objective are closely related as my cli ent request the ability to generate a wish list, as well as view a list of all current media. This information can be accessed from the main form, as you can see from the print overwhelm below.When selecting either the Wish List or Purchased icon the following newspaper publisher appears, detailing the information.As each of the objectives have been achieved, with the addition of my client being able to access sold media, I would deem the development of the database a success.One factor within applications that should always be considered is performance2b.2, how well something works. in that respect are three elements that I would deem beneficial to the applications performance. These are the storing of data, the navigation and functionality.When defining the tables and relationships in the design phase of the database development lifecycle, I ensured that the data is stored with a series of joins, rather than duplicated data. This data is then collated in a query and presented i n a form to provide the information required to my client. This ensures data integrity2b.1, the assurance of the accuracy and consistency of data. It also changes the end user to access the information required without having to navigate throughout the square of the system.The application also benefits from having a limited number of ways to access the data. Providing the information required in one form, and a few reports, provides consistent information. As well as all of the information being provided, the inputting of information is simplistic as when entering data and moving through each field, it navigates in a top to bottom method rather than a muddled method.In addition to navigation through the form, navigation through the application is simple also. Each report and form has been provided with an exit icon, as well as the form having a pee, save and delete button. These are controlled by macros. The macros have also been created in a managed way as rather than having mul tiple macros in one location, they are all their own macro. This removes the need for a triggered action to see a long macro before undertaking it, saving time and increasing performance.As well as successes in the system there are also failures2b.3, the state or condition of not meeting a desirable or intended object. There are two failures which have simple resolutions. There are inputting data into the data dictionary form and the search functionality.In order for information to be entered into the data dictionary, the superuser must bypass the initial gear up to display the tables. From there information can be entered into both of the data dictionary tables in order to update the related query. There are two issues with this method firstly, having to enter data in both tables separately, and secondly, there is no password protection so anyone can update the tables. The solution for this issue would be to create an input form which its sole purpose would be to update the data dictionary. In addition to this, the form can be password defend so that only users with the password can update information.The second, and final issue, is the search functionality. As the database has minimal information currently, the only search available in the system is the one provided by Microsoft Access. As more information is entered, the harder it will be to locate the required media. The recommendation for this issue would be to provide a search option on the home screen with the ability to query any value within the database which may need to be updated, such as go a list of wish list items. Although there is currently a report in the system available, this does not provide the ability to update the data. A form would be required for this.To conclude, the application is fit for purpose and meets the objectives defined by my client. However, there are some minor failures of the system which can be easily addressed.Task 2c Provide supporting user and technical document ationSupporting your systemThe Media Information database is a desktop application database developed within the application Access, which is both provided and supported by Microsoft. Any issues relating to the core application is supported until Microsoft decide to cease cover, which is currently set to be October 20202c.1.In the event support has expired, you can quite simply convert to the latest version of Access. In order to do this, make a copy of the database so you dont corrupt the information.With the copied database open, select File, Save As.Select the Save as type drop down menu and change it to the latest version.Ensure full testing is undertaken so that you know that functionality has not been lost, including adding new media types or genres. From there, you are able to delete, or archive, the previous database version. **Please note DO NOT delete the previous database until testing has been completed, as it may result in corruption of your data**OverviewThe database p rovided is referred to as the Media Information database. It is a series of tables which logs whether a media type is owned, the format, genre, and many other things.Upon launch of the application, the following screen is displayedThis screen allows the user to navigate through the system. An exit application button is also provided to close the database.Upon selecting the Media Information icon the following screen is displayedThe main screen details the media title and any information held regarding it, including the status of purchase.Along the bottom pain, there is the ability to navigate throughout the records. In addition to this, the user has the ability to create, save and delete records. A Close button is also provided to return to the home screen.A number of blue boxes open the listed report for the user to peruse. Each report which opens correlates to the title detailed on each icon. The report displayed will look similar to thisAs you can see from the screen above, there is also a Close button provided. This is available on each report to navigate back to the home screen.The final icon on the home screen is Data Dictionary. This report details, the table name, a description, what fields are included and the data type. The information is displayed as followsMaintaining the databaseThroughout the lifecycle of a database, review and development must occur to determine if it is still fit for purpose. As a result, additional fields or tables may be added.If this is required there are a few things which need to be considered or rememberedThe database is currently set up to provide lookups rather than having to manually enter information. This is the preferred method for data integrity.There are multiple relationships defined, detailed belowYou must remember to update the Data Dictionary tablesAdding fields or tables is easily achievable through the backend, which can be accessed from the left hand panel of the application.The current tables in use are a s followsThe core tables begin with Media, whereas those which help provide the Data Dictionary, begin with Data Dictionary.If you want to add additional tables into the system, try to add tables with a lookup to the original database. In order to do this, create your table with a primary unique key and the columns required. Then add the lookup column into the required table.For future reference, the database as it currently stands is configured alike thisThe main tables included and the relationships definedB) The data dictionary tables and the relationships definedFunctionality helpAs part of the configuration for the forms and reports, there are a series of macros enabled which allow fluid interactions throughout the application, without having to exit it completely.These are the macros that are currently in useWhen creating macros, ensure that a user friendly name is assigned to enable yourself, and support, to easily determine what it is for as a later date. This can easily be done by selecting the Properties of the tab and creating a description in the furnish field. This will ensure that it is displayed correctly in the macro overview window.In some instances, there may be things you dont know. As Office is one of the market leaders, there are many forums and online help sites available for use. The sites I would recommend are https//support.office.com/en-gb/access and https//answers.microsoft.com/en-us/msoffice/forum/msoffice_access?auth=1. If these sites do not provide the solution, Youtube is always an alternative or a Google search.References1.1 http//www.myreadingroom.co.in/notes-and-studymaterial/65-dbms/506-database-development-life-cycle.html1.2 https//www.google.co.uk/search?ei=QbCXWN_AL4vQgAaC57GQDAq=system+maintenanceoq=syatem+maintenancegs_l=mobile-gws-serp.1.2.0i13k1l5.11736.12598.0.14403.8.8.0.0.0.0.149.897.1j6.7.0.01c.1j4.64.mobile-gws-serp..4.4.54735i39k1j0i7i30k1.g8bS8KwNeBs1.3 https//en.m.wikipedia.org/wiki/Backup1.4 https//en.m.wiki pedia.org/wiki/Data_recovery1.5 https//www.totalmobile.co.uk1.6 https//www.google.co.uk/search?client=tablet-android-googleei=ZOaYWMLKJcLCwATvz5bwDAq=analyseoq=analysegs_l=mobile-gws-serp.3..0l5.14074.14927.0.15108.8.8.0.3.3.0.149.769.6j2.8.0.01c.1.64.mobile-gws-serp..1.7.466.3..41j0i131k1j0i67k1.uUVjfA3KtLw1.7 https//www.vocabulary.com/dictionary/objective1.8 http//www.databaseprimer.com/pages/relationship_1to1/2b.1 https//en.m.wikipedia.org/wiki/Data_integrity2b.2 http//dictionary.cambridge.org/dictionary/english/performance2b.3 https//en.m.wikipedia.org/wiki/Failure2c.1 https//support.microsoft.com/en-gb/lifecycle?p1=13615