DBM/502 Week2

Running Head: DATABASE

1

DATABASE

5

Database

By

Vladimir Lopez

DBM502

Professor: Troy Tuckett

April 23,2020

A database management system that is most commonly called DBMS is a software package that is designed to store, change, and delete data in a database. A DBMS can have an extensive collection of databases. A Database is, however, defined as a collection of data that is arranged in a simple and understandable structure that can be very easily be retrieved and changed. All the data stored in the database is stored in the form of tables. All the data is arranged in an order that makes such data very easy to read and extract information. The database can be summarized as a structured collection of data.

There are many benefits of using databases in a business to store and manage data. The most significant need of every business is security, and database systems are perfect for granting protection. Unlike file systems that can be accessed and readable to anyone, the database systems are more secured and almost always password protected (Bulacan State University, 2019). An organization's data is tightly secured inside a database. The administrator often gives access to permits to the authorized employees only, and only a few can modify or delete the data.

Database systems are also used in businesses for easy management of data. If a user needs to retrieve the data, add information, change the data, he can do it. Any kind of information and data retrieval is straightforward in database management systems.

Data elements can be understood as a small unit that represents a unique value of the data. The tuples and attributes are mainly considered to be a part of data elements. For example, let us find the relation of the customer within a business database. In such scenario, data elements would be the customer name, a specific customer identity number, customer's contact detail whether it would be a phone number or email, customer's address, his credit history, the year since he became the customer of the company, the salesperson who interact with this customer, etc. These are some of the examples of data elements within a customer relationship, which is a very integral part of any business database.

In a similar manner, there are other data elements that are also part of a business database in addition to the customer table. A small business can have tables carrying information about employees, all the offices of the company, all the orders, the products, paycheck details, a different table to other firms with whom they have some kind of contract, etc.

System Development Life Cycle (SDLC) is a process that is used to plan, design, develop, and test an information system. SDLC is a collection of multiple steps, the end result of which would be a fully functional information system. SDLC is a beneficial procedure when designing and developing a Relational Database Management System (RDMS). All the steps of SDLC are also applying correctly to the system development lifecycle. The best part about designing a database system with the process of SDLC is the quality of SDLC that it covers both components of hardware and software. This makes the overall development much easy and remarkably cohesive.

The System Development Life Cycle has seven significant steps that will be used when developing a database system (Swersky, 2018). The first step is planning, which includes making a plan on how to design it, what will be the budget be, and what data would be stored in the system. The second step is gathering requirements. It is an essential part of development as it is necessary to design a system that fulfills all the needs of the business for which it has been developed.

The next step is to design the system, and then comes the actual development step of the system. After the system is developed, it is then tested to eradicate any kind of mistakes or bugs. After it has been tested and came out with no problems, it is then deployed in the system. The last step is maintenance, which is an ongoing phase as support happens whenever some problem occurs. Hence, developing a fully functional database is very important for a business.

References Bulacan State University. (2019). Uses, Advantages & Disadvantages of Database, Guides, Projects, Research for Database Management Systems (DBMS). docsity. Swersky, D. (2018, May 31). The SDLC: 7 phases, famous models, benefits & more. Retrieved from Raygun: https://raygun.com/blog/software-development-life-cycle/#systems