I am going to start a database and need to know the difference between
Data Modeling, Schema and Database design?
I always thought of Data Modeling and schema as defining relationships
and primary and secondary key?
What is mean when someone designs an E-R diagram and a Data Flow
Diagram?? 2 1836
Data Modeling is the process of creating a description of the
relationships between data elements of interest. When data modeling
for relational databases, your description usually identifies tables,
columns, and foreign key relationships. The "description" usually
involves pictorial representation, e.g., boxes and arrows.
A logical data model is sometimes developed before the physical model.
The logical model is perhaps not as normalized as the physical, and
usually does not describe indexes or other performance-related
considerations. This model is most useful for communicating with
non-dba's who are interested in the data content of a system but don't
care about the physical storage considerations.
A physical data model more closely resembles the way that the data will
be actually stored in the db. It may specify indexes.
A Entity-Relationship diagram is the most common pictorial
representation of a data model, logical or physical. It's just a way
of showing the model with boxes and arrows and some special symbols
(e.g., 0..1 or 0..n) . A picture is worth a thousand words.
The schema is the actually definition of the data model in the dbms.
When you take your data model and start creating tables, columns,
indexes, and fkeys, you are creating the schema.
Of course, the data model is a representation of the schema that you
intend to create, so the terms are sometimes used interchangably. As
you show the data model to someone, you might say "here's the schema
design" or you might just shorten that to say "here's the schema". Not
quite correct, but good enough.
So, in summary, Data Modeling is an activity that results in a Data
Model. An ERD is one way of representing a data model. The data model
is used to create the databases's schema.
A data flow diagram is something entirely different. It is a pictorial
representation of how data is transformed as it moves through
processing steps of an application. For example, a data flow diagram
may show a authorization for a credit purchase as input. In an early
processing step, it will be matched against a database of account
holders. Then the purchase amount will be compared to the balance.
etc.
Hope this helps.
THANKS!! li*@twcny.rr.com wrote: Data Modeling is the process of creating a description of the relationships between data elements of interest. When data modeling for relational databases, your description usually identifies tables, columns, and foreign key relationships. The "description" usually involves pictorial representation, e.g., boxes and arrows.
A logical data model is sometimes developed before the physical
model. The logical model is perhaps not as normalized as the physical, and usually does not describe indexes or other performance-related considerations. This model is most useful for communicating with non-dba's who are interested in the data content of a system but
don't care about the physical storage considerations.
A physical data model more closely resembles the way that the data
will be actually stored in the db. It may specify indexes.
A Entity-Relationship diagram is the most common pictorial representation of a data model, logical or physical. It's just a way of showing the model with boxes and arrows and some special symbols (e.g., 0..1 or 0..n) . A picture is worth a thousand words.
The schema is the actually definition of the data model in the dbms. When you take your data model and start creating tables, columns, indexes, and fkeys, you are creating the schema.
Of course, the data model is a representation of the schema that you intend to create, so the terms are sometimes used interchangably. As you show the data model to someone, you might say "here's the schema design" or you might just shorten that to say "here's the schema".
Not quite correct, but good enough.
So, in summary, Data Modeling is an activity that results in a Data Model. An ERD is one way of representing a data model. The data
model is used to create the databases's schema.
A data flow diagram is something entirely different. It is a
pictorial representation of how data is transformed as it moves through processing steps of an application. For example, a data flow diagram may show a authorization for a credit purchase as input. In an early processing step, it will be matched against a database of account holders. Then the purchase amount will be compared to the balance. etc.
Hope this helps. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Michael T. Babcock |
last post by:
I'm working with databases (MySQL primarily) more and more with Python,
and having used PERL in the past for similar work, I'm wondering if
there are good tools for doing 'intelligent'...
|
by: mountain man |
last post by:
Greetings to all database professionals and laymen,
Let us make a bold assumption that we have developed a software
tool for the SQL Server environment which simply acts as an interface
between...
|
by: Moti |
last post by:
I have SQL server 2000 which recently crashed. I try to recover it and
found out that the Master database is corrupt. I never backup my
server using inline sql backup nor any third party backup...
|
by: Graham Taylor |
last post by:
I've tried posting this in the 'microsoft.public.access' but I will post it
here also, as I think it might be the webserver which is causing my problem.
---------
I have an Access 2003 database...
|
by: Charles L |
last post by:
Can someone explain to me what the following means?
"C permits multiple definitions of a variable in any given namespace,
provided the definitions are the same and it generates only a single...
|
by: Bas Cost Budde |
last post by:
I play in a band (contrabass) and store the chords for our songs in an
application. Its two main purposes are
* to easily transpose a song
* to display a set list (enlarged chord symbols) that...
|
by: brucedodds |
last post by:
This post is for senior developers.
I'm an Access contractor. This morning I see a listing for a position
that seems to require development of a self-modifying database. The
application may need...
|
by: Jeff S |
last post by:
I'm relatively new to non trivial OOP programming and recently stumbled
across the idea of Factory classes that can create objects at runtime. I
know we can hard-code class definitions for use by...
|
by: zouyongbin |
last post by:
Stanley B Lippman in his "C++ Primer" that a definition like this
should not appear in a header file:
int ix;
The inclusion of any of these definitions in two or more files of the
same...
|
by: mark_aok |
last post by:
Hi all,
I have a situation where I have a split database. At the back end, I
need to
- create a new table (I will call it newTable) with the exact fields,
and relationships as another table...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |