Home » Developer & Programmer » Designer » database designing v/s modeling
database designing v/s modeling [message #207761] Wed, 06 December 2006 22:58 Go to next message
Messages: 16
Registered: February 2006
Junior Member

Can anybody explain what are the differences between database designing and database modeling?

Re: database designing v/s modeling [message #278762 is a reply to message #207761] Mon, 05 November 2007 10:41 Go to previous message
Messages: 44
Registered: June 2006
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.
Previous Topic: It prompt swap not enough when I install developer suit in XP,how can I?
Next Topic: ERD Tool
Goto Forum:

Current Time: Wed Jun 23 15:22:37 CDT 2021