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: How to set up foreign keys across 2 schemas
Next Topic: migrate from oracle 7.3.4 to oracle 9i or 10g
Goto Forum:

Current Time: Wed Aug 23 01:16:29 CDT 2017

Total time taken to generate the page: 0.01801 seconds