Need help to model a system
Posted by: Magne Davidsen
Date: February 27, 2007 04:40PM

I have a problem, which I can't seem to find a GOOD solution to. In the system I am creating I have an Article(ArtID, Artname) table. Register, alter and delete articles are the easy parts. Now, her comes the tricky part:

For every article it must be possible to "place an order" (really just a number, saying how many of that article you want delivered that week) for every week, four weeks from today.

Example of the webbased form, when it is week 2:

ArtID (112233), Artname (Article1), Week3( ), Week4( ), Week5( ), Week6( )

When I fill out the orders in the empty ( ), and clicks the submit button, the orders goes into the system. And I must be able to do a query to get the orders like this:

ArtID (112233), Artname (Article1), Week3(5), Week4(0), Week5(9), Week6(3)


Getting the ArtID and Artname from Article, of course is easy. But how can I, as smooth as possible, model the DB so that the updating of the weekorders is easy?

Thank you very much!!

Options: ReplyQuote


Subject
Written By
Posted
Need help to model a system
February 27, 2007 04:40PM
February 28, 2007 04:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.