Home » SQL & PL/SQL » SQL & PL/SQL » Database design document (oracle)
Database design document [message #320559] Thu, 15 May 2008 08:31 Go to next message
abhishekswamy
Messages: 11
Registered: May 2008
Junior Member

Hi ,
can anyone provide me a detailed database design document and also the steps to make a design document,as i need to learn how to make a database design document.

Thanks in advance..
abhishek
Re: Database design document [message #320561 is a reply to message #320559] Thu, 15 May 2008 08:33 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Have a look at the database design documents that your current employer uses.
Base the new document on the layout and contents of those.
Re: Database design document [message #320562 is a reply to message #320561] Thu, 15 May 2008 08:34 Go to previous messageGo to next message
abhishekswamy
Messages: 11
Registered: May 2008
Junior Member

i'm not able to get from my employer...the reason is it is confidential...please help Sad
Re: Database design document [message #320574 is a reply to message #320562] Thu, 15 May 2008 09:05 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Then tell him you can't learn how to create one.
Re: Database design document [message #320581 is a reply to message #320574] Thu, 15 May 2008 10:06 Go to previous messageGo to next message
abhishekswamy
Messages: 11
Registered: May 2008
Junior Member

guys i have tried from my end every possibility...please help me on this if u have one..will b thankful
Re: Database design document [message #320582 is a reply to message #320559] Thu, 15 May 2008 10:11 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
a blank form should NOT be confidential.
Re: Database design document [message #320608 is a reply to message #320559] Thu, 15 May 2008 11:46 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
> the reason is it is confidential...
It shall be kept from third-party subjects; but keeping it confidential to the people supposed to contribute to it seems paranoiac. Just curious, whether the document you would create would be kept confidential to you after you finished it.
On the other hand you suppose somebody has so benevolent company policy as they would provide it to totally unknown people.

Back to topic: database design may have various results depending on the company standards, so you shall follow your company ones.
By the way do you mean by "document"? The text file or any set of data models?
In other words, do you have at least some diagrams available or you do not have any design at all and you are supposed to create it from blank?
Re: Database design document [message #320614 is a reply to message #320608] Thu, 15 May 2008 12:01 Go to previous messageGo to next message
abhishekswamy
Messages: 11
Registered: May 2008
Junior Member

flyboy: i have to create it from blank...so just want to get an idea..how to go about it Sad
Re: Database design document [message #320615 is a reply to message #320608] Thu, 15 May 2008 12:03 Go to previous messageGo to next message
abhishekswamy
Messages: 11
Registered: May 2008
Junior Member

i need data model and ER diagrams
Re: Database design document [message #320631 is a reply to message #320615] Thu, 15 May 2008 13:11 Go to previous messageGo to next message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
Not sure what you are asking here. Why don't you do a search for "data model" and "ER Diagram."

One's data model and ER Diagrams wn't work for someone else.
Re: Database design document [message #320670 is a reply to message #320559] Thu, 15 May 2008 17:52 Go to previous message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
As now we are in the computer era, all models are not done by hand, but using one of the data modelling tools. First, get acknowledged with the one your company is using (at least the system administrator should know it).

There are two possible ways how you got this task:
- you were delegated it - then ask the submitter to give you appropriate training (shall take weeks at least)
- you are the one responsible for it - then do you think you are suitable for the position you are in?
Previous Topic: Group by months
Next Topic: SQL join question
Goto Forum:
  


Current Time: Wed Dec 07 12:38:52 CST 2016

Total time taken to generate the page: 0.11657 seconds