Relational modeling is the logical representation of the physical relation of the DB tables.

I will think of reading your post only if you are ready to pay for it.

What exactly is a LAN search engine ?

have you started working on that ?

you want to build the database or the search functionality using any front end tool ?

What exactly the existing product does .

You need to post more details.

DBA job is to manage the database.

I don't think size of database is a big factor. What matters most is how complicated the design is and how easily the existing features can be implemented / migrated in the new version/database. You...

that depends on so many factors

1. are both DB compatible ?
2. are both DB directly compatible (do you need an intermediate level)?
3. Price of new S/W & H/W
4. Professional expenses.

How much you are ready to pay ?

how both the tables are related ?

please post the structure of both the tables.

That's why i suggested to use some flag settings .

It is not advisable to store all the code into one table. but if you want store those with some flag setting . Always create index for faster access of data.

you need to say what exactly is your requirement.

What is the error code/ message ?

Power Builder is not a good alternative to Form Builder.

Nothing is clear from your post . what do you want application design or database design ?

From your post i am not sure what exactly you are looking for . Why you need to store the codes in database . What is the database that you are using ?

If the database is oracle you need to play with USER_TAB_COLS view. You need to frame queries dynamically at run time in a loop and execute.

Power builder is a RAD tool.

you do not need an intermediate table only defining the relationship by PK and FK will do that for you. But from your post i am not use what exactly you are looking for. I think you need to pass more...

I don't think that is an ER diagram.

That seems to be a flow chart to me.

You need to understand the basis difference bewtwen the two.

create two tables and link them by using primay key and foreign key.

Can you mention your exact requirments in details please.

i will try to help you during the weekend if I am free, not possible before that.

Before drawing the ER you need to gather all informations and be sure of all your requirments.

what kind of application ?

what exactly you are loking for ?

You guys need to follow some book on the basic of DBMS / RDBMS.

What did Google say ? Have you tried for that option yet ?

What did Google say ? Have you tried for that option ? You nned to go through some basic book on the subject for all that.

I don't think this question has anything to do with database designing.

Its nice to know you got the acurate solution of the problem and your problem got solved.

Thanx for shairing the info .the book is really useful. I have already gone throught that one.

The logic is so simple .This can be implemented at the database level it self by using SQL statments. When the user tries to login check for existance of such an user with the corresponding password...

Its really very difficult to suggest from here without having the knowlwdge of actual requirment at your side.
I would suggest you instead of storing them separately ,store with some flag setting...

That should be defined in the time of table / relationship creation . If you wnat to delete all the child records by deleting the parent record thenu need specify ON DELETE CASCADE. Other wise it...

You can store the details of the mails in a separate table with fileds like date,from,subject, contents ect.

You need to join the tables in the quert to get desired outout.

The problem for you is others should only be able to select records not change ,right.

Its so simple you need to grant only SELECT previlege on that specified table to the users not full access.

also i am unsure about using a separate id field for the primary key in the join tables rather than using the two foreign keys together as a primary key. what is ur opinion on this? thanks

Even...