..instead of a Table Relationship Diagram? This concerns SQL...
123973
You ask a very good quesion.  I will try my best to answer.\n\nOne definition of entity is something that exists (living or non-living).  An ERD is a high-level abstraction.  A table on the other hand, is a coded structure within an RDBMS.\n\nThinking about it in terms of modeling, an actual abstracted entity, might be represented by one or more implemented tables.  For instance, We might have two ERD entities "Customer" and "Product", but in an actual normalized implementation, "Customer" might in practice consist of two very different tables like "Customer-Corporation" and "Customer-Human".\n\nFrom a strict database perspective I suppose your term is more precise.  From a philosophical perspective, entities/tables are unchanging, it is their relationships that give them life.\n\nHope this helps.
659153
don't do it! many-to-many tables are a train wreck, and will clog up your database's pipeline like nobody's business.
576091
That will not be a database program because no database is involved!\n\nWhat language is the answer to be coded in?\n\nHow will the data be organised?\nOne line per data item?  \nThis will need x reads per property.  Will also leave blank lines where items missing.\n\nOne line per property.  Will there be fixed size data items or will you have a seperator? The seperator cannot be used in the data item!
19768
No, the structure actually is defined in the .dtd file.\nYour .xml file contains only the data. If the data u give in .xml doesn't match ut .dtd, the database wont be a valid one. So, if u want to know all important columns of the database, see the .dtd file. That gives u the exact structure.
196196
If you have the ability to enter a direct SQL statement into UltraDev when you are binding this data, your SQL statement would look something like this:\n\nSELECT a.*, b.* FROM troubleshootingtable a INNER JOIN servertable b ON a.servernamecolumn = b.servernamecolumn WHERE a.recordidcolumn= 'recordid'\n\nIn the statement above:\n\nReplace "troubleshootingtable" with the name of the troubleshooting table\n\nReplace "servertable" with the name of the table that holds your server info\n\nReplace "servernamecolumn" with the names of the columns that hold your server names. For example, if that's called server in the troubleshooting table, then a.servernamecolumn would be changed to a.server; if it's called servername in the servers table, you'd change b.servernamecolumn to b.servername\n\nReplace "recordidcolumn" with the name of the primary key column in your troubleshooting table.\n\nReplace "recordid" with the name of the variable you will be using to get the right record.\n\nIf this doesn't help, follow up and I will try to clarify.
225133
Can u elaborate the problem, The MS-Access has it own built in SQL building routine, if this is not solving your problem, then please explian the kind of connectivity or query u are passing so that i can understand it better..!
483330
xml & mysql were built with the same idea... simple tables with rows and fields.... \n\nI wrote one this program long ago... and I can't find it anymore but...\n\nI googled for "mysql xml import" and found thousands of examples and simple programs!\n\nenjoy!
57300
Create a new database, using the Database Wizard.  There, it will give you different samples.  There is probably several ready-to-run examples there to use...
159331
check the following site\n\nhttp://www.schools.ash.org.au/olshc/infotech/dbdesign.htm\n\nif you want more search in google "database design".
541419
Best way is to have 2 tables.  A header and details table.\n\nThe header table will have one row per sale.  Key field would be invoice number.\n\nThe detail table will have details of each sale.  One row per item.  Key field would be invoice number and item number\n\nJoin field would be invoice number.
463128
Not sure what you are trying to do. Email me @ lee.sanchez@gmail.com with some context please.  I know sql and access very well.  So let me know.\n\nYou have subqueries or dlookups as an option\n\nselect (select [field1] from table1 where field1>0) as field2
455312
It is sufficient, but it is not optimal.  Calculations of distance (for instance) in a GIS require formulas to be written within the SQL.  A QL that has these calculations supplied is better.
156631
You can do this with ASP>net and SQl connection object.\nYou can also use Jav and JDBC
244479
huh? what is your question?  Table level keys can include primary and foreign.  Primary keys are column(s) that identify a row uniquely. Foreign keys relate one table to another. I've never heard of a "table all key"
386885
you dont need to add two foreignkey in to other tables.always. you can add just primary key into other tables. only primary key can be foreign key into other tables.
581284
Check out Microsoft\n\nOr just Google database design or database normalization.
583504
That being a microsoft program u can use a ligter version which i beleive is free too... it's called SQL 2005 Express Edition... if you want something fully robust and not deal with the high cost, I would personally recommend MySQL. I have used it in all my softwares and we currently use it in our main datacenter to handle all our data from our 35 remote offices world wide... it is extremely fast... we handle over a million transactions a day... give it a try.