The Topics Covered In This Book Are: Understanding the Oracle
Environment; Understanding the Oracle Instance; Understanding the
working of Oracle Instance; Understanding the Oracle Database; Oracle
9i Software Installation; Oracle 9i Database Design using DBCA;

In the early phase of data modeling how do you usually start with
these steps:
data layout, normalization, key definition, and performance tuning
Considering that application needs to design from dcratch and it is

What would be the most efficient way to have items displayed on a webpage
sorted in the order a CMS administrator wishes? So for instance, lets say I
have a table employee:
CREATE TABLE  `employee` (

Here is a theoretical, and definition question for you.
In databases, we have:
Relation
a table with columns and rows

Suppose I've got a part of schedule as:
...
T1 : Read(X)
T2 : Write(X)

I'm on a project called Enterprise Data Architecture where in I'm
required to draw some diagrams showing systems connectivity,showcasing
interfaces between the systems and a data dictionary.I want to know if
i can do these diagrams using the ERwin data modeling tool.

How do you check if an index has been sucessfully created?
For example under mysql:
mysql > alter table TABLE_A add index (Field1);
is successful?

For a database design, I'm looking for the best way to model history.
For example (but it can of course get more complex):
We have a PERSON table and one of the attributes is status which can
be [baby, toddler, child, adolescent, adult] or something like that.

Not too experienced yet when it comes to database normalization. And right
now I'm working on a project in which I would like to have user profiles:
My first impulse was to create a User table, a Person table and a
Person_profile table

I am tasked with maintaining a large database still on SQL Server 7.0.
Performance is an issue not surprisingly and I've targeted two rather
large tables to see what I can do with the indexes.
The 2 tables are described as follows:

Given a transaction that posts some data, and it bounces back with a
MySqlException (in the .Net connector) because of a duplicate key/unique
value, in general one needs to know which column and value were
involved. Of course one could parse the error message, but that's a

Hello Friends,
I am using berkeley-DB for my work. As you might know berkeley-db
allows variable length records to be inserted.
The problem is,

I want to run queries, browse schemas, etc., and I want to be able to
connect to a bunch of different DB's with the same application -
Oracle, SQL Server, MySQL, etc.
I know commercial Embarcadero can do it. Any others?

i want manual for MS Excel for doing Programming. how can i access the
functions of excel.