Jeremy D. Moore
IT190-1503B-01 Introduction to IT
Instructor William Nelson
Discussion Board 2
August 26, 2015
Information Systems Concepts
A Database Management System or (DBMS) is an essential tool for any organization or company in today’s modern world. A DBMS is “a group of programs that manipulate the database and provide an interface between the database and its users and other application programs” (Stair & Reynolds, 2011, p. 189). So in choosing the right DBMS there are many factoring issues with choosing the right one for the company or organization. When choosing a DBMS one has to think about how the system will ultimately help the company or organization with day to day processes and the goals of the company or organization.
…show more content…
If the company or organization does not require much data then a Flat File DBMS (Stair & Reynolds, 2011) would be a perfect fit because it is not structured or have a relationship connection like many of the DBMS do today. The next two types of systems could be considered based off how big the company or organization will become or if it will stay the same size. If you have a system that is manageable and a majority of the data comes from an individual section or person you could consider using a Single User DBMS (Stair & Reynolds, 2011) which would be an acceptable system. Now if the company or organization needs more data storage or capabilities and your data varies too much the company or organization may want to look into a Multiple User DBMS (Stair & Reynolds, 2011). Microsoft, IBM, and Oracle are companies that are currently leaders for these types of DBMS (Stair & Reynolds, 2011). These are used if the amount of data varies and you …show more content…
A database administrator (DBA) according to dictionary.com (2015) is an IT professional responsible for the installation, configuration, upgrading, administration, monitoring, maintenance, and security of databases in an organization. These individuals within the company have total rights to all systems because they are administrators. The users of the system are just that, they use the system to complete task and work for the company or organization from their area. Now users can ask the administrators to help or do certain task within the system. For example, the user needs a certain spread sheet done for where it is a read open or for only certain people to be able to access certain spread sheets.
Now since Lockheed Martin is such a huge company and has multiple sites around the world the DBMS would have to be a larger multiple user system. Due to the fact that the company is so large it will have to have a system that is scalable as needed for any all data upgrades. Factoring in the Lockheed Martin has multiple divisions within one corporation and multiple users within one division the company would have to be able to manipulate data from multiple users within a division along with data transferred outside of that division for
I was first introduced into the IT industry through my personal favourite sport, which is F1. Since I was a small boy, I had a dream to work for one of the 10 teams travelling around the world to race. IT in Organisations will make me suitable for a job at any of those teams no matter which one whether it is Red Bull or Manor. The course suits me because I have been interested in a large amount of areas within the industry. Level 3 has already touched on some of these areas and I am fascinated by modules I haven't done such as Data Management in year one involving the use of a command line interface which I haven't used very much if at all.
I am using last week new implementation of prioritizing my time in a positive way and not reacting in a defensive manner.
In respense to the postion of a Peer Support Specilaist, working in various shifts has strengthen and acklnowledged me as an employee.
Today I received a few emails pertaining to MWH communication from either “MWH Shareholder Communications“ or Computershare” being delivered to people Clutter folder or their Trash folder in Outlook. We have done some work to understand our options and consider the following
1) Before using any DBMS, the creators should have created a data model from the users' requirements.
Like all businesses, Getronics can improve how it utilizes databases and related technology. For instance, the less is more theory could apply when describing the number of databases that store employee information. There is a human resources database, a phone database, network database, an incident management system database, and many more. If these databases could be consolidated and linked then management of the systems could be reduced.
Relational Database Management System (RDBMS) is an engine/system based on the relational model created by Edgar F. Codd in 1970. The major distinguish of this system is the ability to use tables for data storage while maintain and enforce certain data relationship. Another aspect of this system is that allow users to insert, update, retrieve, and delete specific content or contents storage in the database. Also, RDBMS provides relational operator codes that enable the relationship between two or more entities in a database (Dangerfield & Morris,1990). These system’s characteristics can be applied on business operations improving company management of small and large amount of information from a specific department or workplace. Relational Database Management allows monitoring all information flow from that specific department
A significant disadvantage of the DBMS system is cost. In addition to the cost of purchasing of developing the software, the hardware has to be upgraded to allow for the extensive programs and the workspace required for their execution and storage. While centralization reduces duplication, the lack of duplication requires that the database be adequately backed up so that in case of failure the data can be recovered.
The decision on what type of database to employ heavily depends on the scale of the business, plans for expansion, and flexibility. The benefit of a relational database structure for the system architecture is that it will offer the ability to link the
When you start thinking about getting a database program for your company there are many popular software names that come to mind. The first that come to my mind are Oracle, MySQL (structured query language) and SQL Server, but let’s take it one step further you have to know the pros and cons for each program. By educating yourself on the differences between the programs you can know that you are getting exactly what you need from the software. Even though they all do create databases, different companies have special needs and the program that is chosen may not do what it is needed without research. Some users might say that the cost plays a big part of the decision making process, but you do not always just want to know how much they cost because you want to know how they differ from each other. There are quite a few out there, let’s start with the top three companies Oracle, MySQL and SQL Server.
Database Management System is a kind of software used to manage complex and large data in a related format. It allows us to pull the data from different sources, store and sort the data. It is a
Improved decision making – Organization no more underestimate the power of data. While data is the king, it needs better management. DBMS helps organizations manage data and improve data access. When data is not lost and kept safe in a DBMS, management and CEOs can make use of this data
In order to complete the implementation of a database for the company I will focus on the database structure that will be utilized to store and manage end-client information. The association 's data is one of an association 's most vital assets. So I will recommend a Database Management System (DBMS) to keep information on customers, employees, demands, and receipts and so forth. These things are all necessary to the existence of an organization; I will utilize a relational database management system (Linked List) which is a
The company chosen for analysis of database management is Amazon Incorporated. Amazon is an online shopping portal that is now listed as the 4th largest database holder, even above firms like YouTube or
What is DBMS? -Data base management Systems-This is a collection of computer processes which can be software, or firmware. A generalize or specialized computer is used to run this system. The DBMS uses a language or device to: Define the logical database of a specific database directly or through IRDS. (information resource dictionary system). Define the physical component, specify interrogations, and specify system control. (Gorman, 2015)