Development Phases of Database System Last Updated : 17 Jul, 2020 Comments Improve Suggest changes Like Article Like Report The Database System is developed in the following phases: Phase-1: Requirements Collection Phase - Goal of this phase is collecting correct requirements from stakeholders and users. This is only possible when user has a clear view of his needs. If user is not clear about his needs, entire process can go off track. The entire system is built on findings of this phase; hence, this is a very important stage. Following two kinds of requirements are collected in this phase: Data model requirements : These deal with different pieces of data that need to be stored along with their relationships with one another. The data model requirements are represented using conceptual level data models, like entity/relationship model (ER model) and Unified Modelling Language (UML). Note - UML is more popular in case of large scale software development processes. Functional requirements : This involves day-to-day tasks and operations that are undertaken by enterprise for which database is being developed. E.g. The functional requirements for a Hospital System would be: acquiring new medicines, maintaining doctor records, maintaining patient records, adding new patient records etc. Phase-2: Data Model to Representational Model Conversion Phase - In this phase, we need to convert the data model into a representational level model such as Relational Data Model and choose an RDBMS system (i.e., from the providers of the RDBMS system e.g. Oracle, DB2, MySQL) to create database. Phase-3: Functional Requirements to Application Programs Conversion Phase - In this phase, high level languages (HLL), like C, C++, Java etc. are used in combination with SQL to communicate with the databases and modify them, to capture the day-to-day activities of the enterprise (for which the database system is being developed). Comment More infoAdvertise with us Next Article Development Phases of Database System supriya_saxena Follow Improve Article Tags : Software Engineering Similar Reads Database Application System Life Cycle - Software Engineering This article focuses on discussing the database application system life cycle in detail. What is the Database Application Development?Database application development is the process of obtaining the following things: Real-world requirements.Analyzing the real-world requirements.To design the data an 2 min read Introduction of Unified Database Language (UDL) Unified Database Language (UDL) is language that supports all three of the well known approaches - relations, hierarchies, networks in a uniform and consistent manner. It is not a self-contained language, rather it is explicitly intended as "tightly coupled" set of database extensions to existing pr 2 min read Information System Life Cycle - Software Engineering Information System Life Cycle (ISLC) is a framework used to manage the development, maintenance, and retirement of an organization's information systems. This article focuses on discussing the Information System Life Cycle in detail. What is the Information System Life Cycle (ISLC)?The ISLC is a use 6 min read Basic Database Concepts The database system is an excellent computer-based record-keeping system. A collection of data, commonly called a database, contains information about a particular enterprise. It maintains any information that may be necessary for the decision-making process involved in the management of that organi 6 min read Database Development Life Cycle In computer systems, data are stored in file-based systems and database systems. File-based systems fail to effectively check data duplication, accuracy, and integrity, leading to decreased security. To handle this constraint the database approach is convinced.A database plays a crucial role in deve 5 min read Application of DBMS The efficient and safe management, saving and retrieval of data is made possible by the Database Management Systems. They provide strong solutions for the data management demands and are the foundation of the numerous applications used in a variety of the sectors. Recognizing the uses of DBMSs aids 5 min read DBMS Full Form - Database Management System DBMS stands for Database Management System. DBMS is the software that is used to manage databases. For example, MySQL, Oracle, PostgreSQL, etc., are popular commercial DBMSs used in different applications. It is a reliable, easy, and efficient way of data processing and management. History of DBMSIn 3 min read Characteristics of the Database Approach In this article, we will discuss the overview of the Database Approach and will mainly focus on its characteristics. Also, we will cover the Characteristics of the Database Approach in detail. Overview of Database ApproachThere are different characteristics of the database approach from the much old 5 min read Introduction of Enterprise Database Today is world that is full of data. We have ample number of resources which generate data on daily basis and all these data are stored in very secure manner in databases. All data is linked to each other in Database. With help of database, it becomes easy to, insert, use and remove data as per need 4 min read Like