Database management system (DBMS), how it works and its benefit for the organizations.

Database Management System (DBMS) is the software that allows a computer to store, retrieve, add, delete, and modify data. A DBMS manages all primary aspects of a database including managing data manipulation, such as user authentication as well as inserting or extracting data.

 How it works

Relational database management systems implement the relational model of tables and relationships. The primary design challenge of today’s DBMS is to maintain data integrity which protects the accuracy and consistency of the data, this is ensured through a series of constraints and rules on the data to avoid duplication or data loss.

DBMSs also control access to the database through authorization, which can be implemented at various levels. For example, managers or administrators might have access to data that is not visible to other employees.

How it benefits the organisation: Most DBMSs use the structured query language SQL, which provides a way to interact with the database. Database also provides a graphical interface that allows users to easily view, select, edit or manipulate the data, SQL performs these tasks in the background which saves time for the employees and cost effective for the organisation because many of the DBMSs are open source and available however choosing which database you need is a complex task, it depends of a type of your organisation and business

Software Development Life Cycle (SDLC) and some models

The software development life cycle (SDLC) is a terminology used to explain how software is delivered to a customer in a series of steps. That is the one thing all the various methods have in common, one way or another, software like all products starts as an idea then becomes a document or prototype depending on the method in use, then that artefact becomes the inputs to the next step, eventually the software is delivered to the customer ready to be used. The sequences of steps used by these methods is commonly referred to as the Software Development Life Cycle

The seven Phases of the SDLC

1. Planning
2. Requirements
3. Design and prototyping
4. Software development
5. Testing
6. Deployment
7. Operations and maintenance

Popular SDLC models

The two best-known methodologies within the SDLC are Waterfall and Agile, there is a contrast between Waterfall and agile as explained below.

 Waterfall tends to be a “one-way road”, begins with long planning and design phases of testing and finally deployed for use. Waterfall does not support feedback throughout the process, leading to the implementation of requirements that may have changed during the development effort. This weakness in Waterfall led to develop more flexible methodology such as Agile.

Agile is a more flexible framework that allows for uncertainty, Agile emphasises teamwork, prototyping, and feedback loops that can change the direction of the development effort in response to changing requirements.

Waterfall is still used by many companies around the world, however, Agile is rapidly gaining ground. Regardless of the method used, there are practices that reduce risk and increase chances of success.

How a hosting provider works

Web hosting provider is the service of providing storage space for a website or application on server on the internet and can be accessed by other connected to the internet.

Web hosts are companies that rent out their services and technologies to host websites on the internet and users can access it by typing in your website address (domain name) in their web browser. By doing this, they connect to the server your website is hosted on, the server in turn sends the files you have stored on the storage to display to your visitor in their web browser.

Tools we need to create, deploy and maintain a simple website

• A computer
• A text editor, to write code in, (e.g. Visual Studio Code, Notepad++, Sublime Text, Atom, etc.)
• Web browsers, to test code in.
• A graphic editor, to make images for your web pages (e.g. Photoshop, GIMP, Paint Net)
• A version control system, to manage files on servers, collaborate on the project with the team, share code and assets and avoid editing conflict.
• An FTP (File transfer Protocol) program including Cyberduck, Fetch and FileZilla
• An automation system like Grunt or Gulp to automatically perform repetitive tasks such as minifying codes and running tests.

 

Plan a software installation and an application removal 

The plan is building 2 different types of websites, a static website which is built on HTML, CSS and JS, and dynamic website is built on CMS technology with an e-commerce integration.

For both websites I’ve chosen Hostinger as web hosting provider which provides lots of services and technologies that allow us to create, customize and publish a website with easy and fast way.

There are lots of tools available when I signed up for Hostinger and created an account that helped to build, deploy and even export and import the website that I am working on from same place, interface and no need to re-upload the file or even install FTP to upload the static website. Nonetheless, it’s recommended for large files.

The daily backup is available on the web hosting provider with full control to delete part or whole website if it’s necessary.