Phases of database design
Database designing for a real-world application starts from capturing the requirements to physical implementation using DBMS software which consists of following steps shown below:
Requirements: Before going to database design the needs of all stakeholders (people who work with database) are collected and analyzed.
Conceptual Design: The requirements of database are captured using high level conceptual data model.
For Example, the ER model is used for the conceptual design of the database.
Logical Design: Logical Design represents data in the form of relational model. ER diagram produced in the conceptual design phase is used to convert the data into the Relational Model.
Physical Design: In physical design, data in relational model is implemented using commercial DBMS
like Oracle, DB2.
0 comments:
Post a Comment