What Are The Different Phases Involved In The Process Of Developing A Database?

Following are the different phases of database development process.Planning The planning starts when a customer requests to develop a database system. It consists of various activities. These activities are used to identify the resource needed to develop the system. It also identifies the time limits for the completion of the system.

Analysis.The analysis phase is used to study the current system in detail. It identifies how the current system works and where the improvements are required. It includes a detailed study of various operations performed in the system.

Database design.The database designing is divided into two parts:
Logical Database design.The logical or conceptual model describes the data stored in the database. It also contains the rules and information about the structure and type of data. It is the complete description of data stored in database.

Physical database design.Physical database design is the last stage of database design process. The major objectives of physical database design are to implement the database as a set of stored records, files, indexes and other data structure. These data structures provide adequate performance.Implementation.The database system is implemented after it has been design and develops. The database systems installed are executed for the user.

Add Comment

Report

To develop a database is very easy job, indeed if you know all the necessary steps, Here I'd like to tell you the practical steps that are used to create a robust database.

1. First of all you'd gather your requirements that why you need a database? what the information it would store for you etc.

2. After this you'd identify the entities in your requirements. Now what are entities? well the entities are those information which has further sub information or in simple words these are the roles in your requirements or even simple all the nouns in your requirements can be your entities for example if we are making a database for school than our entities can be teacher, student, classes, courses etc as these info contains further sub info example a teacher has name, education, experience etc and similarly a student has age, class or grade, academic records etc

3. After all this make your ERD (Entity Relationship Diagram) which would show that which entity is relating to another entity for example the relation of a teacher entity with student entity, in this way we define the relationship like one-to-one, one-to-many, many-to-one and many-to-many or these are also known as cardinality.Then we make the table of each entity by identifying theirs attribute for example a student entity has name, age, grade etc as attributes and same for others
Entities

Using any RDBMS tool you can carry these steps to develop your database.

Add Comment

Report