Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 15th, 2004, 07:49 AM
Registered User
 
Join Date: Aug 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Design help

I want to design a database for a business that
manufactures UPVC windows and doors. My initial problem
is that each product (especially the windows)can be made
in various set sizes with set prices dependent on height
and width.

I know creating a separate table for each product is
ridiculous, epecially when products will also most
certainly be added or removed and the prices may change
over any period of time.

A more reasonable solution is to create one table with
each product's height and width matched with it's price,
but this also seems a bit much when lets say you there's
100 products with 100 different set sizes and costs.

I can accept that my thinking is probaly niave as I'm
fairly new to database design, so any ideas on how to
approach the problem would be appriciated.

thanks John


 
Old August 16th, 2004, 07:34 AM
Authorized User
 
Join Date: Jun 2004
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi - This sounds like a pretty big project that may be better suited to an actual full blown application rather than an access database. If you want to, you can look at a software package called windowmaker www.windowmaker.com - it does what you want and more (for a price) and all the application data can be manipulated with access or SQL depending on user numbers. If not then let me know more specifically what you want to do and i'll think about a simple dbase.

William
 
Old August 16th, 2004, 10:01 AM
Registered User
 
Join Date: Aug 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm hoping that I can create this system using Access as I have had a little experience with this application, A full blown application seems a little out of my league at this moment in time. I also have a good grounding in VBA which I hope will aid in the development of the system.

Perhaps I have over stated the the size of the application I am trying to develope, as the client I'm developing this for is a single user on a stand-alone PC. at present My client has around 50 products (window styles) all of which can have anything from 20 - 100 variable sizes.

At present I am toying with the idea of have two tables to deal with the windows problem.

So...

One table to deal with the the product styles

PRODUCTS

Product_ID (PRIMARY KEY)
Prod_Name
Prod_Description
etc...

Then

A table to deal with the Various sizes of the products

PRODUCT_SIZES

Size_ID (Primary Key)
Product_ID (Foreign KEY)
Height
Width
Price
etc...

A simple solution, my only worry is that my client will have the laborious task of inputting all the various sizes for each product manually every time a new product style is required.

Another solution I have pondered is to have four tables

Hence

PRODUCTS (The same as before)

PRODUCT_SIZE (With all possible variable sizes)
Size _ID
Height
Width
etc...

PRODUCT_PRICE
Price_id
price
etc...

And a final table to link the other three tables

So

PRODUCT_LINK
Product_link_ID (PK)
product_ID (FK)
Size_ID (FK)
Price_ID (FK)

Now the user can update a new product and its various sizes with a specifically designed form.

or do you think this is a bit too much

Please let me know what you think

Thanks again John









Similar Threads
Thread Thread Starter Forum Replies Last Post
IS-A , not CONTAINS-A design possible? LawrenceHickey XML 3 May 16th, 2007 03:34 PM
Design issue DeborahP Access 1 March 24th, 2007 08:57 AM
Design patterns for web design ceadge HTML Code Clinic 0 June 19th, 2006 11:26 AM
How to design the following? gilgalbiblewheel HTML Code Clinic 0 January 14th, 2005 02:02 PM
Java Design issue with UML and Design Patterns the_logical_way Apache Tomcat 0 May 31st, 2004 04:02 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.