Again, please forgive my total ignorance.
My ERD shows that the web links (URL table) are connected, via the
sub-categories (SubCat table),
to the main categories (Categories table). Is this correct for what I
am trying to achieve ?
Or should I also link the URL table to the
of the ER Diagram would also be helpful to me.
cheers
- Original Message -
From: John Meyer john.l.me...@gmail.com
To: BobSharp bobsh...@ntlworld.com
Cc: mysql@lists.mysql.com
Sent: Monday, August 31, 2009 4:56 PM
Subject: Re: Database design - help
Please forgive my total ignorance.
URL-Category linking ... with Foriegn Keys or Primary Keys ?
Have been trying to create the ER Diagram with MySQL Workbench,
and getting very frustrated.
cheers
- Original Message -
From: Martin Gainty
To: bobsh...@ntlworld.com ;
be helpful to me.
cheers
- Original Message -
From: John Meyer john.l.me...@gmail.com
To: BobSharp bobsh...@ntlworld.com
Cc: mysql@lists.mysql.com
Sent: Monday, August 31, 2009 4:56 PM
Subject: Re: Database design - help
BobSharp wrote:
As a complete newbie in MySQL, I need a database
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling.
There are several Categories ... Equipment Manufacturers, Organistations,
(UK) ProShops, (UK) Bowling Centres, Personal Websites, Misc., Coaching
Instructional websites, etc.
There will be some
I have written a .cfm to output a listing of columns with Name, Format, Size,
NULL, KEY, etc.
One thing I need to include is whether the Primary Key is AUTO_INCREMENT
That element does not appear to be in the same SCHEMA table.
Where is it ? and How can I use it with this Query ... ?
Picture does not seem to have been carried in the message, posts with
attachment did not seem to get through either.
So hope the link works.
Below is the ER diagram in an exercise I am trying to do.
http://www.probowluk.co.uk/images/er_ECA_001.jpg
It's been going well so far, and several
Below is the ER diagram in an exercise I am trying to do.
It's been going well so far, and several ColdFusion pages written already.
Need to do one for a Purchase Order Report for ...
- given SupplierCode
- given StartDate and EndDate of Orders
My problem is in the CFquery -
Need some facts for a Report ...
For a hypothetical Kitchen Company's shopping Catalogue.
a.. What advantages does a database have over flat-file systems ?
b.. Are there any disadvantages in switching to a database solution ?
c.. What is MySQL, and how does it relate to ASP,
3 tables are related by one-many links.
Employees Assets Maintenance
Employees can be assigned = 0 Assets
Assets can have = 0 occurances of Maintenance.
Assets table contains EmployeeIDs and MaintenanceIDs,
but no Foreign Key contraints.
Queries ...
1) which Employees
rows from the Employees table
regardless of whether anything matches in the assets table. By selecting
only rows where the foreign key field in the assets table is null gives
you the employees having no assets.
John Bonnett
-Original Message-
From: BobSharp [mailto:bobsh...@ntlworld.com
This links to an ERD diagram that illustrates a MySQL database
schema.
www.ProBowlUK.co.uk\images\ERD_001.jpg
They are MyISAM tables, with no Foreign Key contraints
(the fk suffix is not used in the actual database).
I need to provide MySQLSELECT statements, with various
combinations
12 matches
Mail list logo