The ABC Manufacturing company has a completely automated application system. The system, however, resides on index files and doe
s not allow for decision support at all. In order to move to ad hoc queries, and "what if" queries, the company has decided to convert the existing system to a database.
Initially, the only criterion for the application is to replace the existing system with a database system. No ad hoc screen or reports have been anticipated. You will see the reports and screens that exist currently.
Use this case to perform the task that the module has asked of you.
Customer Order and Product Application Considerations
1. Each customer must be on file before an order can be placed. The name, address(s), phone number(s), and credit limit must be recorded. All other data items are optional. If there is no shipping address, then the mailing address is used instead. Since customers can have identical names, a customer id has been assigned to each customer.
2. Each order will have a computer generated id number. The order can have up to 10 line items. Discounts can be given to preferred customers and this discount amount will be recorded on the customer's record. Customers without a discount amount will not be given a discount.
3. Each product listed on the order will show the standard price for that product. Discounts will be shown at the bottom of the order form.
4. Orders that can be filled or partially filled are shipped immediately, and the product data is updated accordingly. Orders, or partial orders that cannot be filled will be backordered.
5. As products are manufactured the product data is updated accordingly along with the part inventory data.
6. A customer can place numerous orders. Products can be ordered by many different customers. The same part can be used in numerous products. (eg. a screw can be used in a chair, bar stool etc.)
Initially, the only criterion for the application is to replace the existing system with a database system. No ad hoc screen or reports have been anticipated. You will see the reports and screens that exist currently.
Use this case to perform the task that the module has asked of you.
Customer Order and Product Application Considerations
1. Each customer must be on file before an order can be placed. The name, address(s), phone number(s), and credit limit must be recorded. All other data items are optional. If there is no shipping address, then the mailing address is used instead. Since customers can have identical names, a customer id has been assigned to each customer.
2. Each order will have a computer generated id number. The order can have up to 10 line items. Discounts can be given to preferred customers and this discount amount will be recorded on the customer's record. Customers without a discount amount will not be given a discount.
3. Each product listed on the order will show the standard price for that product. Discounts will be shown at the bottom of the order form.
4. Orders that can be filled or partially filled are shipped immediately, and the product data is updated accordingly. Orders, or partial orders that cannot be filled will be backordered.
5. As products are manufactured the product data is updated accordingly along with the part inventory data.
6. A customer can place numerous orders. Products can be ordered by many different customers. The same part can be used in numerous products. (eg. a screw can be used in a chair, bar stool etc.)
2 answers:
You might be interested in
Answer:
<u>The total time elapsed from the time a bit is created (from the original analog signal at Host A) until the bit is decoded (as part of the analog signal at Host B is </u><u>25.11 ms</u>
Explanation:
Host A first converts the analog signal to a digital 64kbps stream and then groups it into 56-byte packets. The time taken for this can be calculated as:
time taken 1=
= (56 x 8) bits / 64 x 10³ bits/s
= 7 x 10⁻³s
time taken 1= 7 ms
The transmission rate of the packet from Host A to Host B is 4 Mbps. The time taken to transfer the packets can be calculated as:
time taken 2= (56 x 8) bits / 4 x 10⁶ bits/s
= 1.12 x 10⁻⁴ s
time taken 2= 112 μs
The propagation delay is 18 ms.
To calculate the total time elapsed, we need to add up all the time taken at each individual stage.
<u /><u> = Time taken 1 + Time taken 2 + Propagation Delay</u>
= 7 ms + 112 μs + 18 ms
= 0.025112 s
= 25.11 ms