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 Categories
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 ; m
in practice it may list depending on
> selected Zone)
>
>
> The example Schema is interesting, but is there another way of storing all
> links
> in one table and join them to Category and SubCat tables ?
> An example of the ER Diagram would also be helpful to me.
helpful to me.
cheers
- Original Message -
From: "John Meyer"
To: "BobSharp"
Cc:
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
to store URLs related to Tenpin Bowling
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 sub-
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 Col
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 - unders
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, Javascript/VBs
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]
Sent: Wednesday, 18 March 2009 3:13 AM
To: mysql@lists.mysql.com
Cc: wi...@list
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 Employee
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
