Anyone have a recommendation for a good inexpensive or free utility for
developing table schemas.
27  2157 
A utility to develop table schemas?
If ou are looking for suggestions on how to design schemas for a variety of
needs, this might be useful: http://www.databaseanswers.com/data_models/index.htm
In general, though, you only go go the trouble of creating a custom database
if there is no off-the-shelf solution. Therefore the bespoke Access
databases you create all have unique needs, and cannot be designed by a
utility.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Neil" <no****@nospam. netwrote in message
news:4j******** ********@newsre ad4.news.pas.ea rthlink.net...
Anyone have a recommendation for a good inexpensive or free utility for
developing table schemas.
what do you want to do.. print schemas?
export schemas to word?
I would reccomend keeping an eye on www.gliffy.com it is a free online
visio-killer
Neil wrote:
Anyone have a recommendation for a good inexpensive or free utility for
developing table schemas.
When I have seen questions concerning complex logic on newsgroups I have
wished for a sketchpad where I could draw a flowchart. Other times I have
longed to be able to share a relationship diagram. This looks like a
possible answer. I would like to hear more expert views on this.
<su******@hotma il.comwrote in message
news:11******** *************@i 42g2000cwa.goog legroups.com...
what do you want to do.. print schemas?
export schemas to word?
I would reccomend keeping an eye on www.gliffy.com it is a free online
visio-killer
Neil wrote:
>Anyone have a recommendation for a good inexpensive or free utility for
developing table schemas.
"David F Cox" <no****@please. comwrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..
When I have seen questions concerning complex logic on newsgroups I have
wished for a sketchpad where I could draw a flowchart. Other times I have
longed to be able to share a relationship diagram. This looks like a
possible answer. I would like to hear more expert views on this.
How would that be displayed in a non HTML reader like OE? I think I'd be
tempted to upload my sketch to a web space and provide a link to it.
Regards,
Keith. www.keithwilby.com
Keith Wilby wrote:
How would that be displayed in a non HTML reader like OE?
Outlook Express is a non-HTML reader?
I meant just a tool for playing with table designs and providing a graphical
interface/printing utility, not one that would do the designing work for me.
I want to be able to design the tables manually, set up relationships, and
print the schemas, without creating the tables, and then create the tables
once I'm done with all the design work. Seems that such a utility exists.
"Allen Browne" <Al*********@Se eSig.Invalidwro te in message
news:O4******** ******@TK2MSFTN GP03.phx.gbl...
>A utility to develop table schemas?
If ou are looking for suggestions on how to design schemas for a variety
of needs, this might be useful:
http://www.databaseanswers.com/data_models/index.htm
In general, though, you only go go the trouble of creating a custom
database if there is no off-the-shelf solution. Therefore the bespoke
Access databases you create all have unique needs, and cannot be designed
by a utility.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Neil" <no****@nospam. netwrote in message
news:4j******** ********@newsre ad4.news.pas.ea rthlink.net...
>Anyone have a recommendation for a good inexpensive or free utility for
developing table schemas.
Neil wrote:
I meant just a tool for playing with table designs and providing a graphical
interface/printing utility, not one that would do the designing work for me.
I want to be able to design the tables manually, set up relationships, and
print the schemas, without creating the tables, and then create the tables
once I'm done with all the design work. Seems that such a utility exists.
Might be, but I find small yellow stickies (post it notes) work great
when conceptualizing a design. It's certainly possible I'm in the dark
ages, though.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
"Lyle Fairfield" <ly***********@ aim.comwrote in message
news:11******** **************@ b28g2000cwb.goo glegroups.com.. .
Keith Wilby wrote:
>How would that be displayed in a non HTML reader like OE?
Outlook Express is a non-HTML reader?
OK fair enough, but it's generally "accepted" practice to post in plain text
isn't it?
I believe Microsoft's Visio might do what you want.
"Tim Marshall" <TI****@PurpleP andaChasers.Moe rtheriumwrote in message
news:ei******** **@coranto.ucs. mun.ca...
Neil wrote:
>I meant just a tool for playing with table designs and providing a
graphical interface/printing utility, not one that would do the designing
work for me. I want to be able to design the tables manually, set up
relationship s, and print the schemas, without creating the tables, and
then create the tables once I'm done with all the design work. Seems that
such a utility exists.
Might be, but I find small yellow stickies (post it notes) work great when
conceptualizing a design. It's certainly possible I'm in the dark ages,
though.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Hoang |
last post by:
does anyone know how to dump the table structure and data from a mysql
database? I am connected to the database externally so "SELECT * FROM
database INTO OUTFILE file" doesn't work for me. However, external tools
have been able to do it (Mascon). I presume this might be a common thing
where people need to backup their databases programatically from MySQLdb.
Hoang Do
http://jotsite.com
|
by: Rajesh Kapur |
last post by:
Does anyone have or know of a utility that will generate SQL to upgrade one
MySQL database to look like another?
For example 'dbdiff db1 db2' generates the SQL statements that can be
applied to db1 to look just like db2.
Any suggestions short of comparing the database schemas line by line?
Thanks.
|
by: Damien |
last post by:
I have a table in my database called Users:
CREATE TABLE (
NOT NULL CONSTRAINT
DEFAULT (newid()),
(20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
(40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
(100) COLLATE SQL_Latin1_General_CP1_CI_AS
|
by: Jeff Boes |
last post by:
I'm sure this is a concept that's been explored here. I have a table
(fairly simple, just two columns, one of which is a 32-digit checksum)
with several million rows (currently, about 7 million). About a million
times a day we do
select * from my_table where md5 = ?
to verify presence or absence of the row, and base further processing on
that information.
|
by: Jeff |
last post by:
We are using .Net and the wsdl Utility to generate proxies to consume
web services built using the BEA toolset.
The data architects on the BEA side create XML schemas with various
entities in separate files for ease of maintainability. These schemas
are all part of the same namespace.
When defining a web service that access more than one of these
entities, the wsdl file generated by BEA contains multiple schema
elements with the same...
| | |
by: outstretchedarm |
last post by:
I'm extremely new to javascript and to programming in general.
I am trying to create an interactive table. I have already created the
table with constants, in the key of C (it is for music). what I would
like to do is to create a dropdown box that would enable the user to
select all 12 keys, then based on that choice, have the whole table
re-calculate, basically transposing all the data up or down.
how would I go about doing this.
|
by: huyuhui |
last post by:
The following is a question of LOAD utility.
Question:
How does the DB2 enforce table check constraints for data added to
table with the LOAD utility?
A. With the BUILD phase of LOAD
B. With the SET INTEGRITY statement
C. With the DELETE phase of the LOAD
D. With the UPDATE CONSTRAINTS statement
Answer is A
|
by: M6C |
last post by:
Hello,
I'm trying to import a Xml file in a table.
It's working find, but when the data are inserted, my trigger on this
table doesn't work ?
I put my code below.
Best regards
Thank's
|
by: nilaangel78 |
last post by:
Hi All,
I have SQL 2005 table with columns TypeId(int) & Description(ntext datatype).
The Description column has XML file content as value in the table.
Now i want to read the data into a dataset in VB.Net. How to do it in VB.Net. I am using Winforms and VB.Net in VS 2005.
Below i have given the xml file content.
<?xml version="1.0" encoding="Windows-1252" ?>
- <SummaryPageComponent...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
