Based on your previous work in the previous week,createa 700-word entry in yourDatabase Management Plan. Ensure you: Evaluate and assist company decision makers in understanding the importance of data

Database

By

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.

WEEK 2

The database is a very efficient method to store data. It helps to collect data and organize them in a way that makes it easy to extract data and manage it. There are multiple ways to organize data in a database. The database can be hierarchical where each data is stored in a tree or hierarchy, or it can even be the object-oriented database. In the object-oriented database, information is organized around objects rather than actions. But the best method to store and organize data in a database is in the form of a relational database.

Relational database means to store data in a table. In a Relational Database Management System (RDMS), a table is also known as a relation. A relation or a table is always formed of a single entity. A table consists of rows and columns. An attribute represents a characteristic of data, while each row or tuple signifies a unique record of the data. The cell where each row or column collides is known as a field. A field represents a single value of data.

Using a Relational Database Management System is very beneficial for a database administrator as RDMS is very simple in its design. The data could be easily stored and easily discovered through it. Another significant benefit of using RDMS is that it provides the advantage of using Structured Query Language (SQL) in the database, which makes fetching data so comfortable from the database. It simplifies the process of database extraction. SQL is the easiest and efficient language used for running queries on a database.

The database is proved to be very efficient in managing and maintaining data. Database systems remove this issue of space consumption and stored everything in a table where a table denotes a whole school, and one row of the table represents one record of the student. Another essential purpose of Database Systems is definitely the need for digitalizing the storage of data. Now all the data is stored on digital devices rather than manual hardcopy files. The digital version of data makes it extremely easy to manage and maintain the data and make any change whenever needed. A lot of organizations also keep their data on their servers, which makes remote access very easy and manageable.

For any business and organization, data plays a very integral role. It is an essential commodity for any business to manage and maintain data. Therefore, it is in extreme benefits for companies to invest in very efficient database systems. The most commonly used type of database management system is RDMS. It is trendy all around the world, especially for businesses. RDMS helps store numerous amounts of data. Most of the time, companies do not get rid of old or outdated data just for the sole reason that this data could someday be potentially very profitable to them. So, in order to manage such a massive cluster of data, it is essential that the businesses use RDMS, which is stored on their vast servers.

Businesses are also always in need of protection. As mentioned earlier, the data is a massive commodity for any organization, so the safety of said data is a big concern for the company. RDMS provides numerous security and protection features, which make it easy for businesses to protect their data as well as organizing it.

When it comes to designing and developing a database, it is essential to conceptualize what the database will contain and how every entity will interact with each other. This is where the conceptual design phase begins. It is explained as the process sod conceptualizing the design interactions, the strategies, and the elements of the database. The entity-relationship model plays a huge role in this phase.

The entity-relationship diagram or ER diagram is a graphical representation of tables in a database and their relationship between them. ER diagram uses symbols to represent three different types of information (Kriegel, Taylor, Trukhnov, Gillenson, & Ponniah, August 2008). The rectangle is commonly used to represent entities. The diamonds are used to describe relationships, and ovals are used to represent attributes. E-R diagrams are a big help in creating a blueprint on which the entire database will be generated.

Bulacan State University. (2019). Uses, Advantages & Disadvantages of Database, Guides, Projects, Research for Database Management Systems (DBMS). docsity.

Kriegel, A., Taylor, A., Trukhnov, B., Gillenson, M., & Ponniah, P. (August 2008). Introduction to database management. India: Wiley.

Swersky, D. (2018, May 31). The SDLC: 7 phases, popular models, benefits & more. Retrieved from Raygun: https://raygun.com/blog/software-development-life-cycle/#systems