Database

| 2011 |

| |

[database assignment 1, ] |

MUHAMMAD SHAROWER UDDIN, TSD ID: 29001729 |

table of contents

Relational Database Design Requirements 2

The basic steps in designing a database system: 2

To determine the purpose of the system 3

To determine the fields we need – 3

To identify fields with unique values 3

To determine the relationships between tables – 3

Relationships between tables are grouped into 4 groups: 4

To refine the design – 4

To enter data and create other system objects – 4

How a relational database organises its data? 5

Some of the elements of table structure. 5

Primary Keys 6

Candidate Key: 6

Compound key: 6

Indexing 7

Relational Database Design Requirements

A database is a collection of information related to a particular subject or purpose (e.g. tracking customer orders or maintaining a music collection). If database isn't stored on a computer, or only parts of it are, we may be tracking information from a variety of sources that we have to coordinate and organize our self. A well-designed database is a prerequisite for fast data retrieval and updates.

The basic steps in designing a database system:

* To determine the purpose of the system.

* To determine the tables we need in the system.

* To determine the fields we need in the tables.

* To identify fields with unique values.

* To determine the relationships between tables.

* To refine the design.

* To add data and create other system objects.

To determine the purpose of the system

 We need to know what information we want from the database. From that, we can determine what subjects we need to store facts about and what facts we need to store about each subject .

To determine the tables

 It can be the trickiest step in the database design process. That is because the results you want from your database (e.g. the reports we want to print, the forms we want to use, the questions we want answered) don't necessarily...