OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » database design (9.0.4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database design [message #315576]

Tue, 22 April 2008 00:46

user71408
Messages: 585
Registered: November 2007
Location: NE

Senior Member

Please let me know how to designed

table,index,views,sysnonyms,sequence

1. What is considered to design those object from bussiness point of view and how it influnced it?
2. What are the oracle paremeter need to be considered to design those object and how it benifit/degrade?
3. Anything which you think it is important?

4. Do we have any tool to do this JOB?

Thank you

Report message to a moderator

Re: database design [message #315577 is a reply to message #315576]

Tue, 22 April 2008 00:52

gopu_g
Messages: 54
Registered: March 2008
Location: mumbai

Member

Hi,
you have to desgin the tables,indexes,.. etc based on your business requirement.....
i did't get you what you mean by tool, you can use the tool TOAD to create tables,..etc...

Regards
Gopu

Report message to a moderator

Re: database design [message #315583 is a reply to message #315576]

Tue, 22 April 2008 01:31

flyboy
Messages: 1903
Registered: November 2006

Senior Member

1. I would prefer a human, who is working as system analyst and/or designer.
2. It depends. You shall get many of them from Oracle Concepts book, a part of documentation found eg. online on http://tahiti.oracle.com/
3. Follow steps of software development process.
4. There are many tools covering different parts of the analysis/design process, eg. Oracle Designer.

Report message to a moderator

Previous Topic:	SQL%FOUND
Next Topic:	certification (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 08:40:30 CDT 2024