Database Environment

1114 WordsNov 11, 20125 Pages
Database Environment Paper DBM-380 November 18, 2012 Introduction A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. The query can be in the form of a question or just a keyword and once these queries run against the database, it will find a matching record (Reynolds, 2004) . Database Decisions When building a system for…show more content…
This DB is high usage throughout the day and has to backup and saved daily so that repairs’ upkeep and maintenance can be done by the night IT crew. Database Management/Upkeep Both of these databases, the Command Directory and MC&SME have to be managed and regular maintenance has to be done in order to keep the information up to date. There are so many changes for associate / employee information if they leave the company or switch department or even if a department is no longer functioning all of this information has to be current. With MC&SME, there are so many changes to job procedures qualifications Etc... every day in order to minimize fraud or if new products are on the market and other ones are no longer being offered, MC&SME sends an alert immediately so if it affects your part of production, you will have to read it right away and make all necessary changes on how your work is done so the administration of both databases are important in order to take full advantage of the output to the relevant query. Proposing Improvements Improvements that can be done in order to maximize results for both of these databases are to make them more client friendly. The Command directory could contain less fields in order to search for results
Open Document