Question-   Sample Assignment on Database

Solution-

DATABASE

TASK 1.

  1. (i)Brief introduction to my chosen organization.

The organization chosen is The Hongkong and Shanghai Banking Corporation(HSBC).

This is a British multinational bank and financial services company which originates from Hong Kong and is the second largest bank in Europe.

The bank was found by Thomas Sutherlandon march 3rd 1865 in then-British colony of British Hong Kong, a month later established in Shanghai and later in 1999 the bank was established as an international bank which has now become one of the largest banking groups in the world, with 3900 offices in 65 countries including Middle East, Africa, Asia, Europe and America, where London is based as the headquarter.

HSBC provides services of finance to banking clients such as personal, commercial, institutional and investment, corporate and private. It also has areas like: environment, community, education and projects to support volunteers and charities.

                 (ii) Database and Database management systems.

A database is an organized collection of information which can easily be accessed, modified, managed, updated and controlled. This is controlled by a database management system which is a software program that allows its end users to retrieve, update and manage the data in the database. These systems also help in control of the database enabling them in operations such as monitoring, tuning and recovery.

Adding on, they are several functions of the database management systems such as data dictionary, transaction management, concurrency control, recovery, authorization, data communication, data integrity and administration utility.

The database of the HSBC bank will be able to show the entities such as customer information, branch information, banker information, transaction information, loan information and customer credit card information.

            (iii)Advantages and disadvantages of databases.

           Advantages.

  1. Sharing of data.

This is where the end users are able to manage as well as access data easily and so they able to make any changes to the database at any given time.

  1. Data security.

Data being very important to the organization therefore the database management systems provides data security for protecting it from the non-end users by proper authentication means such as verifying the login in.

  1. Multi-users views.

Database management systems allows many users to access data at the same time which also gives ability to the users to access the database from different locations and in different ways.

  1. Data manipulation.

As data is centralized, the end users can easily change data such that they can easily insert data, delete data or modify the data.

  1. Data redundancy.

Redundancy means having multiple copies of the same data, therefore the database management systems collects all data in one file which also saves storage space.

   Disadvantages.

  1. Costs.

The cost of maintaining the software, hardware and person required to manage the database is usually very high.

  1. Complexity.

Databases are usually very difficult to understand due to the complex information provided.

  1. Cost of data conversion.

This is usually a time consuming and a difficult process of conversing the data in the computer files into a database file.

  1. Size.

Since these database files are being therefore they take up a lot of the storage and memory which needs high processors to use. The size also contributes to expensive hardware requirements.

  1. Cost of staff training

As database systems are very complex and once the organization will want to implement it, therefore it will require them to train a few of their staffs to run these systems which will factor in the training costs hence making it more expensive for implementation.

 

 

 

Our happy customers

They are fast in responding to homework questions. they have the best technical writers. Thanks for helping me with my programming doubts.

studentDyana
5  stars image

I contact to disklib for homework, they help me out, despite there was some technical issue they gone through extra mile for me and provide me good quality work in first priority. 100% recommended.

studying on laptopAsif Waheed
5  stars image

Desklib's study resources are best & unique. Their study database is easy to access and easy to use.
100 % recommended.

library and studentsMike Taylor
5  stars image