 |  |  |  |  |  |  |  |
[B]What changes need to be made to the above database definition in order to solve al
 |
[B]What changes need to be made to the above database definition in order to solve al
0
#1 Apr 4th, 2005
Using access and visual basic
A company has been using a program written in VB using Access tables for sales order processing. The data model they have is as follows.
Customer customer No (PK), customer name, address etc
Order order No (PK), customer name (FK), date
Order_line (order No, stock No) compound PK, quantity
Stock stock No (PK). Price, description
The software uses a datagrid attached to the orderline table for data input. This has the effect of changing the sequence of the lines of the order as they are entered, as keys provide unique checks as well as changing the sequence of the data.
They wish to have the system modified to prevent this change in sequence but are interested in two other ideas. They currently hold entire orders in the warehouse until stock is available to meet each line of each order. They would like the computer to be used to keep track of the stock level and also permit partial delivey. This means that if a company wanted 10 widgets and only 6 were available, then those 6 should be sent and another 4 sent at a alater date. If only 3 were available at a later date, these should be sent and then the last 1 widget at a later date.
The other idea is that customers should be able to change their order before it has been printed on a picking list for the warehouse staff, but not after it has been printed.
The question is
What changes need to be made to the above database definition in order to solve all the problem?
A company has been using a program written in VB using Access tables for sales order processing. The data model they have is as follows.
Customer customer No (PK), customer name, address etc
Order order No (PK), customer name (FK), date
Order_line (order No, stock No) compound PK, quantity
Stock stock No (PK). Price, description
The software uses a datagrid attached to the orderline table for data input. This has the effect of changing the sequence of the lines of the order as they are entered, as keys provide unique checks as well as changing the sequence of the data.
They wish to have the system modified to prevent this change in sequence but are interested in two other ideas. They currently hold entire orders in the warehouse until stock is available to meet each line of each order. They would like the computer to be used to keep track of the stock level and also permit partial delivey. This means that if a company wanted 10 widgets and only 6 were available, then those 6 should be sent and another 4 sent at a alater date. If only 3 were available at a later date, these should be sent and then the last 1 widget at a later date.
The other idea is that customers should be able to change their order before it has been printed on a picking list for the warehouse staff, but not after it has been printed.
The question is
What changes need to be made to the above database definition in order to solve all the problem?
Re: [B]What changes need to be made to the above database definition in order to solve al
0
#2 Apr 4th, 2005
please help
Re: [B]What changes need to be made to the above database definition in order to solve al
0
#3 Apr 6th, 2005
i just want your views about it, and how you would answer it, which changes need to be made to the above database definition in order to solve all the problem?
•
•
Join Date: Dec 2004
Posts: 2,413
Reputation: 
Solved Threads: 211
Re: [B]What changes need to be made to the above database definition in order to solve al
0
#4 Apr 6th, 2005
I'm not sure about the entire question, but it would be simple to keep track of how many still need to be shipped. Just change the instances of order No so that it subtracts the amount sent, and rewrites it's value to new amount needed to send. I'm not sure about the rest of it though.
Re: [B]What changes need to be made to the above database definition in order to solve al
0
#5 Apr 6th, 2005
thank you very much, please if you think of anything else, please let me know, at least i have something to write about. once again thanks
|
Similar Threads
- very important please (C++)
- only sees 2gig of HD - Did all fixes ? Large disk Enabled (Windows 95 / 98 / Me)
- help with database assignment (Java)
- 35 processes, need to trim the fat (Viruses, Spyware and other Nasties)
- bridge.dll issue (Windows NT / 2000 / XP)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: ADO data control problem
- Next Thread: tables please help
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
