Question
Turner Construction company was founded in New York in 1902 and its first project was a reinforced concrete cooper shop for the manufacturer J.B King
Turner Construction company was founded in New York in 1902 and its first project was a reinforced concrete cooper shop for the manufacturer J.B King & Company. The company negotiates contracts with several suppliers for the supply of various amounts of selected item kinds at a price that forms part of the contract. Orders are placed against any of the negotiated contracts for the supply of items at the price quoted in the contract. The price of an item quoted in a contract is called CONTRACT-PRICE. An order can consist of any amount of those items that are in that contract. The quantity of an item in an order is called ORDER-QTY. Any number of orders can be made against a contract. However, the sum of any given item kind in all orders against one contract cannot exceed the amount of that item kind quoted in that contract. This is called CONTRACT-AMOUNT in the database. An inquiry would be made to establish if a sufficient quantity of an item is available before an order for that item is placed. All the items in an order must be supplied as part of the same contract. Each order is placed only against one contract and is made on behalf of one project. An order is made for one or more item kinds in that contract. DATE-REQUIRED specifies the date of an order which is placed and DATE-COMPLETED specifies the date of an order which is filled. The access requirements for this system are given as follows:
On-line transactions: 10. Find a particular contract together with its supplier (20/day) 11. Find the quantity of a given item still available under a given contract (100/day) Detailed pseudocode of the access requirement is: Find the CONTRACT-AMOUNT for the ITEM-NO in the CONTRACT-NO Amount-available = CONTRACT-AMOUNT For all orders in the contract Begin If the order contains the given ITEM-NO Then amount-available = amount-available ORDER-QTY End Output amount-available
Batch Requirement: 1. Summarize the purchases by CONTRACT-NO of all items ordered in ITEM-NO order. Produce the summary with ITEM-NO listed within CONTRACT-NO (weekly) For each CONTRACT-NO For each ORDER-NO in CONTRACT For each ITEM-NO in ORDER Create
The data item sizes are given as follows: 1. SUPPLIER-NO 6 2. SUPPLIER-ADDRESS 30 3. SUPPLIER-NAME 20 4. CONTRACT-NO 6 5. DATE-OF-CONTRACT 6 6. ITEM-NO 8 7. ITEM-DESCRIPTION 20 8. CONTRACT-PRICE 8 9. CONTRACT-AMOUNT 6 10. ORDER-NO 6 11. DATE-REQUIRED 6 12. DATE-COMPLETED 6 13. ORDER-QTY 6 14. PROJECT-DATA 20 15. PROJECT-NO 6
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started