The Diagram above shows the stages of development of a database system life cycle…..
- STRATEGY AND ANALYSIS OF DATABASE
Study and Analyze the Business requirement, speak with the users or manager of the firm to identify the necessary Information required for the development of the database. After gathering information from user, set up their business been narrated to into a Graphical Representation. Try to confirm the representation and refine.
- DESIGN
Design the database according to the graphical representation made in stage 1 (Strategy and Analysis).
- RELATIONAL MODEL
Database was in Hierarchical and Network Model or even a Flat File Data Structure before Relational Database Management System Was Now introduced and became very popular, because
- It is very easy to use
- It is Flexible in structure
- SQL Statements
SQL Which is Structured Queried Language Can be control in 4 – 5 different language Which are: DL [Data Retrieval], DML [Data Manipulation Langauge], DDL [Data Definition Language], DCL [Data Control Language], and TC [Transaction Control].
All This language has their own specification which is very easy to understand.