Multinational Company Database Management System Computer Science Essay

Published:

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Data management system means collection of program which can be able to store, modify information from a database. This is the convenient as well as efficient way to use in retrieving and storing information to promote high standard in sector. Employment record system can be a great example of database management system. Because a better communication can give us a better output of the particular sector. When we run a company we have to keep all the information about employees who are working with this company and which sector they are working; it will convenient not only the manager of that company but also the customer to take information about their product from the particular person. This system can be used in various sectors; some of them are given below:

In the Bank a lot of employees are working and they have many branches as well as they have many clients also. Various client problem may be various from each other. So they can be able to contact to the particular person by this system easily. The manager will be able to communicate with other branch manager in any matter by taking information from the database.

#Multinational Company:

It is helpful for multinational company to connect with the employee and the client. Importer will be able to create connection with the particular person very easily where a lot of employees are working.

#Air lines:

In the Air lines many people are working. If we want to keep data in this system it will convenient for them to contact and work together. They will be able to estimate their cost very quickly. In this sector many branches are inter connected to book ticket. So by taking information into the database their business will run very smoothly. Also customer can book their ticket from the nearest branch or from the particular person where their information will be kept in the database.

#Hotel management:

In the hotel also various people are working in various sectors. So for creating a good communication database management system is necessary.

Hospital, sales and order tracking system are same like as previous which is convenient like them. They can communicate with each other very quickly which is important to give good support to the customer.

If I use it in a company that will be the great opportunity for that company to work together as well as they will be able to promote their standard by communicating with each other very quickly and their service will also better and praise able. Because Database management will contain the information about how many employees are working in the company, their ID, Contact number, E-mail address, post (which sector they are working), Home address, etc. By using this process a customer can be able to reach to the employer easily for their specific reason means which person is necessary for his problem. It is also helpful for the managing director to communicate with the employee very easily without facing any trouble as well as he will find them when he needs. We can say about a pharmaceuticals company where various people are working in various post. Their work is also different from each other. When any problem will be created in the company then MD (managing director) will contact that particular person very easily by using this database where their information will be kept. In a pharmaceuticals company has various post, some of them are given below:

Account and Finance section.

Central product management.

Medical service officer.

Production.

Engineer; etc.

#Account and Finance:

In this section various person are working for the company and their work is to maintain the cost of company as well as to pay salary for others employee. All type of account and finance matter they will handle it. The employees who are working here, their information will stay in the database. If any problem happens the head of the department will contact the entire person quickly. Here then they can be able to communicate with the managing director easily. They will get solution early.

#Central product management:

In this section also they can communicate easily by using this database. They will manage the production. Any problem it happens they can communicate with each other quickly.

#Medical service officer:

Medical service officer will give the service about medicine. He or she will analyse about medicine which medicine will helpful to prevent diseases and what product is needed to create this medicine. Then he will conduct the production officer to produce materials more and safe way. So he will communicate with him or her.

#Production:

Production is the same like previous better communication is necessary for it. How much materials need according to the customer he will get the information from other section and it will be instructed by the officer.

#Engineer:

Engineering section also important. Here many Engineers are working to promote production. They have to communicate with other easily because any time machine can show problem if they need their information will be kept in the database. If any problem occurs then he or she can conduct with each other.

In this case it is clear that they can communicate with each other very easily. If any one leaves the job from his or her sector then new information will keep in the database that is doing that job. So it will convenient for the company. When any person will involve in the job every body in the company will get the information.

Without using this type of database management system many problems may be created. The director can’t be able to contact with the particular person whom he want. Company will face problem about communication with each of the person easily. They can’t be able to take decision quickly which is very important for a company. When any employer change his or her any information it will unknown to all. Other recruitment will also unknown to all. To take all the information in the paper it will guarantee less and MD or other person fail to get proper information at the right time because to find data from the paper it will a lot time. But we have to give value of time to continue a good company. So problem will create a lot. Importer will fail to contact with the particular person about his enquiry. How many employees are working with the company it will unknown to all. During the time of salary it will also complicated. Any evidence will not be found that this person has done this job. It will also a problem they were present. A lot of miscommunication will create with out this system. How many employees are working here and how much salary they will get it will problem to solve an estimate according to the employees. Company will fail to achieve the real profit for this cause.

Database management system in this case it is really a helpful thing for the company to communicate very early. Importer can be able to contact with the particular person of the company which is the important thing to make a good profit. Manager can communicate with all of the section when he need. Internal and external relation will increase because employee can change or recruit but his information will find in the database. Because database can store or retrieve data. When any important meeting occur in that time he can call them or give them e-mail to call them. All of the person will be able to know about it. If any decision has taken all will know about it which will helpful to all to promote their strategy about their work. Any person of that company will contact any person very easily if their information kept in the database. So it is really convenient to the company.

Here are given the most important definition which is used in the database to create a good database. We can create database after the basis on this things. Those are given below:

Table:

If we want to give the direct definition of table we will say table is called the consists of rows and columns. Generally a table is set of records which have the same set of fields. Every database contains one or more table that store the data or record or information. In the table columns are identified by name as well as the rows are identified by values. A table has a fixed number of columns but can have any number of rows. Table is used for making relations.

An example of table is given below:

This table contains the information about the employee of an office.

Employee ID

Name

Address

Phone number

Department

113

Shariar

London

07574358447

Engineering

114

Romel

Birmingham

07574123876

Accounts

115

Arafat

Newcastle

07574678345

production

This above table contains the information about the employees who are in which sector and their contact details. In this case by entering data into the table we get proper information of an employee. It is very easy to get information about an employee from this system. Table is the main function for database. Generally a record is a row in a table and a field is a column in a table.

Primary key:

The primary key of a table uniquely identifies each record. It will unique and should not be repeated in that table. Here is an example given below to show it clearly.

Employee ID

Name

Address

Phone number

Department

113

Shariar

London

07574358477

Engineering

114

Romel

London

07574123098

Accounts

115

Shariar

Birmingham

07574532187

production

From this above table we are observing that Employer name may be same in a same company, like that their address and others data may be same, in the time of identification it will complex to find out real person which actually I need. In this case we need to choose primary key of the table to avoid this problem which will unique to identify the particular person. Here Employee ID will be primary key which is unique. In a table one or more fields may be unique which are called candidate keys but we have to take one field as a primary key.

Foreign key:

A foreign key is an attribute which is the main component to create relationship accurately within the tables. A foreign key is an attribute in a relation but it is not the primary key of that table, it is the primary key in another table where it has comes. Foreign key is used to get more information about related things.

Here is an example given below to show foreign key:

In this table, shows the information about Employees (ID, Name, Address, Phone number, Department)

Employee ID

Name

Address

Phone number

Department

113

Shariar

London

07574358447

Engineering

114

Romel

Birmingham

07574123876

Accounts

115

Arafat

Newcastle

07574678345

production

In this table, shows the information about Department (ID, Department name, Employee name, Address, Joining date)

Department ID

Department name

Employee name

Address

Joining date

213

Engineering

Shariar

London

12/03/2007

214

Accounts

Romel

Birmingham

19/02/2008

215

Production

Shariar

London

07/03/2009

In this table it is seen that data is duplicated which will create problem to identify the particular person. Same name, address and other things may be same. So if I create a foreign key in the Department table which links to the primary key in the Employment table. Then we will get proper information what we want.

It has given below:

Department ID

Department name

Employee name

Address

Joining date

Employee ID

213

Engineering

Shariar

London

12/03/2007

113

214

Accounts

Romel

Birmingham

19/02/2008

114

215

Production

Shariar

London

07/03/2009

116

In this condition Employee ID is the foreign key but it is the primary key in the Employment table. But it has created the relation between two tables as well as it has eradicated the repetition problem of data.

Normalisation:

Normalisation is a process to eliminate the data which are duplicated in the database to create efficiency to organize data in the database. By the help of this system we will be able to create relationship with each other tables as well as helps to remove duplication and data redundancies that will better for the table to achieve efficiency.

We can implement normalisation by the help of three forms which are called:

First normal form.

Second normal form.

Third normal form.

At the first time we have to collect the un-normalised data where the data will stay like as raw state. Then

#First form:

Eliminate the duplicative data with in relation of tables.

#Second form:

Remove column which are not dependent upon the primary key it means we have to delete functional dependencies where the composite keys are exist.

#Third form:

All the fields of that table will refer to the primary keys within that relation.

Here is an example is given below after the basis of this normalisation.

If we think of an office to create a database and to create relationship with that table so we have to take row data at first in all sectors for doing normalisation.

Un-normalised data:-

For Manager we can collect data like-(Manager ID, Manager Name, Phone number, E-mail, Address, Age, Sex, Department ID, Department name)

For Department we can collect data like-(Department ID, Department name, Manager ID, Name, Phone number, Number of Employees, Salary)

For Employee we can collect data like-(Employee ID, Name of Employee, Age, Sex, Contact Number, E-mail, Address, Salary, Department name Department ID).These are called the row data of the particular sector.

In this case to create first form of normalisation we have to remove repeated groups in a table.

For Manager (Manager ID, Manager Name, Phone number, E-mail, Address, Age, Sex, Department ID)

For Department (Department ID, Department name, Number of Employees, Salary, Manager ID)

For Employee (Employee ID, Name of Employee, Age, Sex, Contact Number, E-mail, Address, Salary, Department ID)

In the final form we have to create primary key and foreign key of a table. From that system we let that for Manager Table, Manager ID is the primary key and Department ID is the foreign key.

For Department table Department ID is the primary key and Manager ID is the foreign key.

For Employee table Employee ID is the primary key and Department ID is the foreign key.

In the final term all non key fields should refers to the primary keys within that relation.

For Manager (Manager ID, Department ID, Manager Name, Phone number, E-mail, Address, Age, Sex)

For Department (Department ID, Manager ID, Department name, Number of Employees, Salary)

For Employee (Employee ID, Department ID, Name of Employee, Age, Sex, Contact Number, E-mail, Address, Salary)

By following this system we can easily create normalisation which will help to eradicate the duplicate data.

Relationship:

To create relationship among the tables like Employee information, Department information, Manager Information is shown below:

Manager to Department.

Department to Manager.

Manager to Employee.

Employee to Manager.

*A Manager would belong to one and only one Department at a time.

*Department can have one and only one Manager.

*A Department can have one to many Employees

*An Employee can be controlled by one and only one Manager.

ER Diagram:

Department

Manager

Employee

Writing Services

Essay Writing
Service

Find out how the very best essay writing service can help you accomplish more and achieve higher marks today.

Assignment Writing Service

From complicated assignments to tricky tasks, our experts can tackle virtually any question thrown at them.

Dissertation Writing Service

A dissertation (also known as a thesis or research project) is probably the most important piece of work for any student! From full dissertations to individual chapters, we’re on hand to support you.

Coursework Writing Service

Our expert qualified writers can help you get your coursework right first time, every time.

Dissertation Proposal Service

The first step to completing a dissertation is to create a proposal that talks about what you wish to do. Our experts can design suitable methodologies - perfect to help you get started with a dissertation.

Report Writing
Service

Reports for any audience. Perfectly structured, professionally written, and tailored to suit your exact requirements.

Essay Skeleton Answer Service

If you’re just looking for some help to get started on an essay, our outline service provides you with a perfect essay plan.

Marking & Proofreading Service

Not sure if your work is hitting the mark? Struggling to get feedback from your lecturer? Our premium marking service was created just for you - get the feedback you deserve now.

Exam Revision
Service

Exams can be one of the most stressful experiences you’ll ever have! Revision is key, and we’re here to help. With custom created revision notes and exam answers, you’ll never feel underprepared again.