Database Design
Subject: Management | Topics:


In this chapter we will learn:

The discussions of what data items are needed in a system and how they flow; We also discussed how a data dictionary is developed for a system. For designing database we need three things – entities, relationships and attributes. In database design it is necessary to develop a conceptual model of data which specifies the relationships between data. This is used to group data into a number of tables. The tables are organized to reduce duplication of data, simplify functions like adding, deleting and changing data in other words, updating data and select data required for processing, in other word, retrieving data. There is also another functionality of database design is normalization. The methods of organizing or structuring data into tables are known as normalization. The normalized database is later converted to a physical database.

By the end of this chapter we should know:

  • The use of entity-relationship modeling to develop a conceptual model of data.
  • How to organize the data required in an application as a relation.
  • The idea of normalization of relations and the need for normalization.
  • The methodology of converting relations to successively higher normal forms.
  • Collection of normalized relations as a relational database.
  • The use of a method called entity-relationship analysis to obtain a conceptual model of data used in applications.
  • The organization of data as relations, normalizing relations and obtaining a relational database.

Entity Relationship Model:

The entity-relationship model for data uses three features to describe data. These are:

  1. Entities which specify distinct real-world items in an application.
  2.  Relationships Which connect entities and represent meaningful dependencies between them.
  3. Attribute which specify properties of entities and relationships.[2]

Database Design

Related Management Paper:

Popular Management Paper:

Basic Concepts of TQM

Total Quality Management (TQM) is an enhancement to the traditional way of doing business. It is a proven technique to guarantee survival in world‑class competition. Only by changing the actions of management will the culture and actions of an entire organization be transformed. TQM is for the .....

Assignment on Conflict Management With real life Example

What is Conflict? We define conflict as a disagreement through which the parties involved perceive a threat to their needs, interests or concerns. It’s human nature to have conflicts and it arises for any number of reasons, including: Misunderstandings Personality clashes Disagreements about th.....

Recruitment and Selection Process in Nestle Bangladesh Ltd.

INTRODUCTION 1.1: Background of the Report An employee might more knowledgeable and skilful by training and development program or process that maintaining an effective level job performance. So it acts an important role in HR department. As a part of BBA program, our Human Resources practices in.....

Report on Janata Bank Limited

1.1 Introduction of the Study The primary purpose of this report is to get an idea about the operations of Janata Bank Limited, a second-generation bank of the country and make an industry analysis on the banking sector of Bangladesh. Banks are profit – earning concern. The ‘word “Bank.....

Contemporary Issues of Cost and Management Accounting in Bangladesh

Abstract Cost and Management Accounting practice helps an organization to survive in the competitive, ever-changing world, because it provides an important competitive advantage for an organization that guides managerial action, motivates behaviors, supports and creates the cultural values necess.....