Database Development Process

Only available on StudyMode
  • Download(s) : 168
  • Published : February 23, 2013
Open Document
Text Preview
Database Development Process
1. Define business processes
Many database development efforts begin by defining the key business and/or operational processes within the organization
Developers first create high-level models showing the major activity steps associated with marketing, sales, production, human resource management, public relations, research and development, and so on

Taken together, these process maps represent an enterprise-wide model of the organization and its core 2. Determine scope of database development effort
The next step in the database development effort is to select one process or a set of related processes for further analysis and improvement 3. Define the information needs

Once a business process (or set of processes) has been selected, the next step is to define the information needs of users involved in or affected by the business process. 4. Develop conceptual design

A basic understanding of these needs is used to create a conceptual design for the database
At this stage, a conceptual data model is created that illustrates relationships between information sources, users, and business process steps 5. Develop logical data model
The conceptual data model is used to develop a logical data model based on one of the primary DBMS types: relational, hierarchical, network, or object-oriented approaches. 6. Develop physical design

With the logical data model in hand, developers move to the physical design, which involves determining the specific storage and access methods and structures 7. Create and test database
Once this step is complete, developers can go ahead and create the database using whatever DBMS has been selected
Small amounts of data can be entered into the database for testing purposes
This is also the time to start developing sample screens and reports to determine if the database design will meet the predefined requirements
It is much easier to revise and change the database during this testing...
tracking img