What are the steps in the development of a database system?
|
Sep 28 • Notes • 6603 Views • No Comments on Database Development Process Show Database development process is an important aspect of database engineering. As a database system is an essential component of the larger enterprise information system. The database development is a process of designing, implementing, and maintaining a database system to meet the strategic or operational needs of an organisation or enterprise such as improved customer support and customer satisfaction, better production management in an organisation, better inventory management and more accurate sales forecasting. Database development process is useful develop different types of relations between data in an organisation, which may be further easily accessed by the user or the administrator. Database development Normally, information system is the larger environment surrounds a database. We can say that database is a part of an information system. Information system contains a large number of data or information which includes the all the results for which the client should ask or order to the server. We can say that information system is the largest platform in the database management system. Components of an Information system There are several components associated in information system. Information System Development Process Normally, development of a system mean to create, update, maintain that particular system. Likewise information system development process is a procedure through which we can update, maintain the whole information system. The development process consists of several phases through which the system is to be developed. These may include certain backtracking process which may help to correct and modify the errors during the development process. Information System Development Life Cycle A life cycle is the diagrammatic representation of the development process. This cycle is easy to understand to the customer as well as to the programmer. The information system development life cycle consists of the
following phases: Preliminary Investigation Phase It is the first phase of the life cycle. It produces the problem statement and the feasibility study. The problem statements include the objectives, constraints and scope of the system. The feasibility study identifies the cost and benefit of the system. If the system is feasible, then the system analysis phase will start. System analysis phase System analysis phase is the second phase in the life cycle model. It comes after the completion of feasibility study. This phase produces requirements describing processes, data and environment interaction. In this phase, the diagrammatic techniques are used to document processes, data and environment interactions. To produce requirements, the current system is studied. Role of system design phase System design phase is the third phase in the information system development life cycle. It comes after the system analysis phase. This phase produces the plans to efficiently implement the requirements. Design specifications are created for processes , data and environment interaction. The design specification focuses on choices to optimize resources of the given constraints. Goals of Database Development Normally the
goal of database development is to create a database which contains a high quality of data and provides the important access to the organisation. Beside this there are certain other goals of database development. These are: Phases of Database Development To produce an operational database we need
to define external, internal and conceptual schema and supply the data to the database. To create these schema, we have to follow some processes. The first two phases are concerned with the information content of the database whereas the last two phases are concerned with the efficient implementation. The phases are listed below. Skills in Database Development As a database designer, we have the following two types skills in database development. Related Links Sample Paper for DBMS Oureducation.in is the best source of your learning Please help us to improve by providing your feedback database development processDatabase management systemInformation system About the Author:Niroj Kumar Pahi B-Tech Computer Science Engineering From Oxford College of Engineering and Management, Bhubaneswar, Odisha. Currently Working in Ruva Customer Services pvt. Ltd as IT promotional Consultant « Concepts of J2EE and MySQL Playschools in the city of Jodhpur » What are the 3 steps of a database development process?Database Development Process
The database development starts by first selecting the suitable Database Management System ( DBMS ) and creating physical data model. Step 1 - Selecting the DBMS For Building the Database. Step 2 - Creating Physical Data Model. Step 3 - Developing the Database With DBMS.
What are the four phases of database development?The database life cycle consists of four phases: requirements analysis, design, implementation, and maintenance. In the requirement analysis phase, you specify relevant data to the users entirely and accurately. The design phases consist of conceptual data modeling, logical design, and physical design.
What is the first step toward development of a database?The first step is requirements gathering. During this step, the database designers have to interview the customers (database users) to understand the proposed system and obtain and document the data and functional requirements.
What are the five steps in creating a database?Here are five database design steps to help.. Determine the purpose of the database. The very first thing you must do is decide the purpose of your database. ... . Find and organize the information. ... . Create tables for the information. ... . Establish relationships between the tables. ... . Redefine your design.. |
