|
Re: database designing v/s modeling [message #278762 is a reply to message #207761] |
Mon, 05 November 2007 10:41 |
harleenflora
Messages: 44 Registered: June 2006
|
Member |
|
|
Data Model instances may be one of three kinds:
1. Conceptual Schema data model
2. Logical Schema data model
3. Physical Schema data model
Database design is defined as: "design the logical and physical structure of one or more databases to accommodate the information needs of the users in an organization for a defined set of applications". The design process roughly follows five steps:
1. planning and analysis
2. conceptual design
3. logical design
4. physical design
5. implementation
The data model is one part of the conceptual design process. The other, typically is the functional model. The data model focuses on what data should be stored in the database while the functional model deals with how the data is processed. To put this in the context of the relational database, the data model is used to design the relational tables. The functional model is used to design the queries which will access and perform operations on those tables.
|
|
|