What open source tools for creating ER diagrams / database design do people here like?

AT

06-08-2006 08:27 AM
AT

Is it a good idea to have two tables with the same primary key? For example, I have one table which has "QID" as its primary key - this table...

Dave

06-07-2006 01:50 PM
Ed Prochak

Hi all, I've been working with a (potential) customer who has requested that our product support the Faircom c-Tree Server. Up until now, we...

AT

06-06-2006 09:07 PM
David

Hello, I'm surveying the MySQL privilege system... as long as roles don't seem to be implemented, I'm running some tests about emulating roles...

Antoun

06-06-2006 08:23 PM
Markus Popp

Ive seen on the postgresql website some limits, which may even be able to worked around Karl Lehenbauer from www.flightaware.com mentions in a...

geletine

06-05-2006 05:11 PM
geletine

What are the legal implications of storing bank details and/or debit or credit card details of customers in a database in the UK? Assuming it's...

Dave

06-05-2006 04:44 PM
Alex Heney

Hi, I have a script (.sql file) to create nearly 15 tables and also some sequences. This script was originally written for Oracle DB. I was trying...

Raga

06-05-2006 09:37 AM
Raga

Is it best practise to: 1) Store users in a User table, with a numeric UserID as primary key, and reference these users in other tables using that...

Dave

06-05-2006 08:00 AM
Daud Lee Lambert

Hello, I hope this is the right place to ask a question about database research... I am looking for a data structure that stores a set of keys which...

hbdere

06-05-2006 03:11 AM
hbdere

Hi, Is there any freeware/shareware tool for migrating from Oracle to Derby? Or any tips for migrating from Oracle to Derby? Thanks, Raga

Raga

06-05-2006 03:07 AM
Raga

Hi I am studying an IT course and thought I was just beginning to master the basics of normalization. However I came across an example in my text...

smitj2 (AT) tiscali (DOT) co.uk

06-04-2006 03:00 PM
Ed Prochak

If you went to a company and saw that their programming applications were pulling data from un-normalized tables, how would you transition them to...

metaperl

06-04-2006 02:52 PM
Ed Prochak

Hello everybody, I am 6-year IT professional who has only done Perl for that time. I have done countless jobs with Perl and MySQL as buddies. As you...

metaperl

06-04-2006 04:10 AM
David Segall

I'm trying to understand why MySQL isn't using all parts of the primary key when I add in an OR statement in the query. I have a people database,...

AT

06-04-2006 03:46 AM
AT

I need suggestions on how I can publicly archive on the Internet a 30k encrypted file that twenty years from now I will publicly release the key to...

Mike Vance

06-03-2006 06:31 AM
John

I International Conference on Multidisciplinary Information Sciences and Technologies, InSciT2006 Mérida, SPAIN, October 25th-28th,...

AT

06-02-2006 04:55 AM
AT

Hi everybody, Where can I found a C source code for conecting to Oracle database ? My gaol is to write a little program which extract some tables...

elekaj34

06-01-2006 04:38 PM
David Cressey

Hi, I have a question on firebird license. Is it legal to bundle Firebird with a commercial (proprietary) product & sell the product? This product...

Raga

05-31-2006 10:04 AM
Raga

Hi Everybody. May I draw your attention to our new SQL database, which can be used both as Distributed client/server and as an embedded database. We...

AT

05-31-2006 03:01 AM
AT

Hello everyone. I need some help to design the database or table for my application on scheduling task. My application is to do some scheduling task...

Lemune

05-30-2006 08:39 PM
Lemune

Export and Import http://quickdba.blogspot.com/2006/05/export-and-import-in-oracle.html More Daily updated Articles

rmli

05-30-2006 04:42 PM
Ed Prochak

I'll go closer; A shop must exist PHYSICALLYin one district as a sub of cities. My hierarchies (countries) -> (states) -> (cities) -> (districts)...

coosa

05-30-2006 04:36 PM
Ed Prochak

I am not sure If I can do this with a lookup, but what I would like to do is perhaps use lookup to retrieve a control date from an unassociated table...

AT

05-26-2006 12:01 AM
Ed Prochak

My chief want me to edit old program for our firm. Only files that I have are with mdb, dbt, and exe extension. What can I do? Can anybody tell me...

AT

05-25-2006 12:07 PM
Bill Karwin

Does anyone know of a way to compare the structure of a MySQL db to the structure of a MS SQL db? thx.

AT

05-24-2006 06:28 PM
AT

I have made a simple flat file for my wife in Access XP. I understand Access is not the best choice for use in a dynamic web site. I also use the...

Frankly

05-24-2006 01:46 PM
Ed Prochak

hi, can anyone plz tell me how do i get the inventory for lotus approach applications....i mean the things like forms, reports, queries etc. in an...

AT

05-24-2006 06:16 AM
AT

Dear Friends, Please take a few minutes to complete our online Survey on Firebird, which explores trends in the usage of Firebird. Your opinions...

AT

05-24-2006 02:41 AM
AT

Archive-name: databases/approach-mailing-list-faq Posting-Frequency: weekly Last-modified: 1998/01/07 This document is a usenet pointer to...

AT

05-24-2006 12:22 AM
AT

And what if I just want to buy a sex slave? Opus "Knowledge" <knowledge (AT) world (DOT) net> wrote

Opus

05-20-2006 01:22 PM
Opus

Hi, I have a table, which stores entries of users. Each user is identified by a unique used id. Each entry contains the userid, a timestamp and...

AT

05-19-2006 01:29 PM
Ed Prochak

SQLeonardo a powerful and easy-to-use tool that lets you query databases. NEW: save and load queries. MetadataExplorer * browse database structure...

Staff

05-18-2006 03:48 PM
Staff

Hi, We are migrationg from approach to access. My basic underastanding of the procedure is that the data has to be migrated and all the...

Nuti

05-18-2006 06:27 AM
Nuti

Dear MySQL-ians, I perform a SELECT on my database, but it takes over a minute for every run. I have to run it over 10000 times (with different...

AT

05-18-2006 04:14 AM
AT

Hi I don't know if this is a good place to ask but I take my chances. I have small project on my hands. I have two databases. One containing data...

AT

05-17-2006 07:13 PM
Bill Karwin

Hi! I've created a mysql database (v4.1.9) with the default charset utf8 and I'm doing some web pages with PHP (v4.3.2) also using UTF-8. Database...

AT

05-17-2006 05:31 PM
AT

Hi, I have a MySql problem I hope someone can help me with. I'm trying to run an update on a linking table, the update is running into a Primary...

Jon Maz

05-17-2006 05:30 AM
Jon Maz

Archive-name: databases/approach-mailing-list-faq Posting-Frequency: weekly Last-modified: 1998/01/07 This document is a usenet pointer to...

AT

05-17-2006 12:21 AM
AT

Anyone have any definitive differences betweeen these two databases in terms of performance, scalability, ease of use, utilities, etc? I'm looking...

Jim Morrissey

05-16-2006 04:37 PM
Michael Zedeler

Dont know if this is a good place to ask this. I have a table that looks like this. orderid | orderdetailid | desc 0000 1 ...

AT

05-15-2006 11:51 PM
Lennart

Hello I'm designing a DB for HR department to maintain annual budgets. It should contain the personnel structure and budget items, but only related...

H5N1

05-15-2006 05:36 PM
Ed Prochak

I'm working on a dual entry bookkeeping system, and want to track transactions (not the db kind) occuring on accounts. I group these transactions in...

AT

05-15-2006 09:12 AM
Isak Hansen

Hi, Any one knows how this is taken care ie. how can we manage multiple solid servers simultaneously? The server port specification also matters...

mgp

05-15-2006 07:35 AM
mgp

I'm trying to set up a Session Initiation Protocol (SIP) server on Sun SPARC running Solaris 10 as detailed on Sun's web site...

Dave (from the UK)

05-14-2006 01:42 AM
Dave (from the UK)

Can anyone point me towards a source or sources that compare and contrast the different RDBMS's? So far I'm finding a TON of sales fluff online,...

tekctrl

05-13-2006 09:26 PM
Jerry Gitomer

Hi, We have been pondering the problem of how to cope with network failure within a network shared by many clients and one central database...

Steve

05-13-2006 09:17 PM
Jerry Gitomer

Hey, I am working on an calendar solution and my missing part is the support for infinite recurring events (as Google Calendar supports it). What is...

AT

05-12-2006 10:23 AM
AT

Hello, I'm searching for a tool to help translate databases or keep two databases in sync. I'd like for this to be an existing tool that can be...

David

05-11-2006 10:38 PM
David

Hi all, I have two .Erwin files each containing multiple data models under the subject area. My goal is to consolidate the contents of these two...

Raim

05-11-2006 02:05 PM
Raim

Hi every one! I've got a design question: Currently, we've got a table called "session" which contains all data regarding a production session. I...

Matthieu

05-11-2006 04:25 AM
Matthieu