Database Environment

Database Environment Paper DBM-380 November 18, 2012 Introduction A database defines a structure for storing info and it collects information that is organized in such a charge that a computer program can quickly admit desired pieces of data. A database can also be thought of as anelectronic filingsystem. Data and information atomic number 18 extracted from a database by creating a doubtfulness and then submitting it to the ask database management system (DBMS) and it is comprise 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 information, you sustain to limit how much responsibility for data management your software will take. A database can be rather galactic or it can be sm tout ensemble depending on the information that is being stored. Request for information from a database are made in the form of a query or a question asking the database for particular information.All databasemanagement systemsare non the resembling from a technical standpoint. They differ mostly in the way they organize their information intern ally. The internal organization can then determine how quickly and supplely the information can be extracted (Jupitermedia, 2011) . Analyzing the use of databases Analyzing the use of databases In the Client Fulfillment department at Tactical Training host Pacifics, there are two databases that are mainly utilise and those are the Command Active directory and the Military & Civilian SME (MC&SME).These databases are rattling vital to this department because they service of process with the daily production goals. With the use of the subordination directory, it is laborsaving in finding different link ups throughout the organization as well as finding certain departments, phone numbers, mail codes, locations of ascendance t eaching centers, and realize Station machines. When creating anew accountfor a client or associate they must state whether they are an existent client or that they are an associate the command directory is accessed to verify this information in order for them to receive the benefits as an associate.Another advantage of the command directory is back up to find other department phone numbers or Watch Station locations. With the command directory database you select the field that you are appearing for wish well associate search, location, telephone number, Watch Station and then you enter your query not in the form of a question but a certain query language that is understood by this database to extract this information. This database relies on the Microsoft SQL server.Another database that is employ command is the Military & Civilian Subject bet Experts (MC&SME). This database is used to help associates across all lines of business to do their job effectively. MC&SME contains processes and procedures for to each one department to abide by so if you are not sure on how to complete a customer request or the correct information to give to a customer it can all be found on MC&SME. MC&SME works on structured query language or SQL that it is usually asked a stylised question in order to execute and answer.This is a very large database because it contains so umpteen work procedures and specialists that are very important for each and every department at TTGP Command. Data specifications For TTGP it is important to reappendage that we let ternary types of people in our database Command Staff, Clients and Subject Matter Experts(SME) for training areas and certifications. The Following entities and attributes will apply relationally to all three areas 1. Command Staff * Name * Address * speech sound number * subdivision Name * Supervisor . Client/Customer * Name * Address * Phone number * Company Name * Company POC/Supervisor 3. Subject Matter Expert(SME) * SME Name * Company Name * Certifications (Separated By Commas) * Special Training * exist for Services The requirement for this Database is to ensure a check is made relationally for either name or skills to ensure duel entities arent entered. This DB is highschool usage throughout the day and has to backup and saved daily so that repairs up curb and caution can be done by the dark 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 very day in order to minimize craft or if new products are on the market and other ones are no longer being offered, MC&SME sends a n alert immediately so if it affects your part of production, you will have to read it right away and construct all necessary changes on how your work is done so the disposal of both databases are important in order to take plentiful advantage of the output to the relevant query. Proposing Improvements Improvements that can be done in order to maximize results for both of these atabases are to make them more than client friendly. The Command directory could contain less fields in order to search for results since the 411information page search and the location search is going to give you the same results and if you are not sure or the correct spelling of an member of staffs name, the sounds like field is not very helpful because it will come back with too many results and you still have to keep looking. MC&SME can definitely be made more user friendly.This is the most confusing database because if you dont have the beseeming training it will take hours just to look up simple i nformation. MC&SME rents to be reduced in search / query size in order to maximize retrieval results faster. Conclusion Because this 3 entity with attributes relational Database has such a high operational Tempo we need to ensure that only the critical attributes fields are used. This will help in not only over all DB surgical operation but help with query retrieval speed as well.Keeping the relational processing required down to a minimum is imperative. Constant upgrades, maintenance along with security patches are done and need to remain vapourish to the user. This database is akin to the lungs that breathe life into our command. References Jupitermedia. (2011, Spring). Internal Database Organization. Retrieved from http//jupitermedia. org/DBorg Reynolds, J. N. (2004). Database Structures. PC Magizine, 10(7), 123.