Best practices when creating/modeling databases?

Posted by Oscar Mederos on Programmers See other posts from Programmers or by Oscar Mederos
Published on 2011-02-08T05:24:09Z Indexed on 2014/06/13 15:41 UTC
Read the original article Hit count: 538

Filed under:

database

|

methodology

I learned at the University some steps to model a database:

Model the problem using the Extended Entity-Relationship Model.
Extract the functional dependencies
Apply some algorithms to normalize the database (3NF or Boyce-Codd)
Create the database

I'm studying Computer Science and since I received that course I'm wondering if I always need to do those steps when creating a ~~complex~~ database for an specified problem.

For example, do PHP / .NET / .. programmers always do that? or there are some tools to simplify that process, maybe using another way of represent the problem instead of the EERM?

© Programmers or respective owner

Related posts about database

SQL SERVER Retrieve and Explore Database Backup without Restoring Database Idera virtual database

as seen on Dot net Slackers - Search for 'Dot net Slackers'
I recently downloaded Ideras SQL virtual database, and tested it. There are a few things about this tool which caught my attention.My ScenarioIt is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database… >>> More
Cloning A Database On The Same Server Using Rman Duplicate From Active Database

as seen on Oracle Blogs - Search for 'Oracle Blogs'
To clone a database using Rman we used to require an existing Rman backup, on 11g we can clone databases using the "from active" database option. In this case we do not require an existing backup, the active datafiles will be used as the source for the clone. In order to clone with the source database… >>> More
cPickle ImportError: No module named multiarray

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I'm using cPickle to save my Database into file. The code looks like that: def Save_DataBase(): import cPickle from scipy import * from numpy import * a=Results.VersionName #filename='D:/results/'+a[a.find('/')+1:-a.find('/')-2]+Results.AssType[:3]+str(random.randint(0,100))+Results.Distribution+"… >>> More
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

as seen on SQL Authority - Search for 'SQL Authority'
Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More

Related posts about methodology

I need help on methodologies for information system project [closed]

as seen on Programmers - Search for 'Programmers'
Basically I will be developing a student information system for parents and I am confused on what type of methodology I can use. Please recommend me a methodology which involves use cases the system development life cycle. I'm confused on what a methodology is as I've read loads of books and researched… >>> More
What is the difference between a software development pattern a methodology(agile, dsdm etc) and a p

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the difference between a software development pattern? A methodology such as agile DSDM etc how is OO classed as a methodology and a paradigm? How can OO be applied to a methodology such as agile if itself is a methodology? Whats the difference between a paradigm and a methodology or… >>> More
Agile, a Different Methodology

as seen on Internet.com - Search for 'Internet.com'
If you wonder why you are hearing so much about the chaotic Agile methods lately, this is the article for you. We'll show you how to put the Agile method to work for you. >>> More
Using DMAIC Methodology to Enhance Information Portals

as seen on Internet.com - Search for 'Internet.com'
Discover how to enhance your website's revenue and traffic from an end-to-end perspective by applying DMAIC (Six Sigma) methodology to your website. Learn about the key metrics, fundamentals of SEO (Search Engine Optimization) and Ad Words, and how to increase your site traffic all in one place. >>> More
Papers on Software Methodology recommendation

as seen on Stack Overflow - Search for 'Stack Overflow'
Please recommend me software engineering/methodology/practices paper. So far I have enjoyed: 1968 Dijkstra : Go To Statement Considered Harmful Reason about correctness about program Nikalus Wirth : Program Development by Stepwise Refinement Not worried about program structure 1971 David Parnas… >>> More