Assume that a university has hired you to develop a database system for online enrollment. Using the database systems development lifecycle approach:

 

• Identify the user groups involved in this stage, and  
• What specific data you will obtain from them?
•  

Stages Database Planning System Definition Database Design DBMS Selection Application Design Prototyping (optional) Implementation Data Conversion and Loading Testing Operational Maintenance Main Activities Involves planning the various stages of the lifecycle in order to realize the activities Collection and analysis of the new database system requirements. The scope and boundaries are defined (e.g. data to use or generate, details of how data will be stored or generated, and other requirements Design conceptual, logical and physical database models Selecting a suitable DBMS for the database system Designing the application programs and user interface that is used to manage and control access of the database Creating a prototype of the database system to enable the designers to visualize and evaluate the final look and function of the system. Creating the physical database definitions and the application programs. Migrating the data from the old system to the new system and converting any existing applications to run on the new database Testing the database system for errors and validated against the user requirements. Full implementation of the database system as well as performing monitoring and maintenance.