Create a z schema that adequately describes the wtc system

Assignment Help Other Subject
Reference no: EM131058255

Wheat Truck Control System (WTC) A new computerized system is to be developed for the storage and handling of accounts for wheat farmers and truck deliveries to Mahsroh Wheat Board silos. Detailed below are the major objects to be considered in the system: silos, ships, trucks and farmers. This system could be quite complicated. However, to simplify the system for this assignment we will be content to include the following in our proposed system:

Silos
The Board currently has ten (10) wheat silos around the country but the system must be written to seamlessly handle at least twice that number. Each silo has a unique name and storage capacity (in tonnes) that must be stored in the proposed system. In addition the system must maintain the current amount of wheat stored in the silo. Obviously when the silo is full no further deliveries of wheat can be made to that silo before some is offloaded onto a ship for export overseas. Similarly a silo cannot off-load more wheat onto a ship than is currently stored. We will assume that when off-loading to a ship, no trucks can unload due to operational and safety considerations. Only one ship can be handled at a time at each silo. We will assume that only one truck can unload into a particular silo at any one time. Therefore during busy times each silo also maintains a queue of trucks waiting to unload. Trucks should only be entered into the waiting queue when there is sufficient room for the wheat that the truck holds, i.e. you need to know that the current storage plus all the loads currently in the queue will not exceed the silos capacity.

Ships
The system will keep a record of all ships that have been registered to transport wheat overseas for the Wheat Board. The ships name, nationality and capacity (in tonnes) will be stored. The ship's captain can specify the amount of wheat to be off-loaded into the ship as long as it is less than the ships capacity and also the silos CRICOS Provider No. 00103D ITECH7410 Software Methodologies - Assignment 2 Page 2 of 4 current amount in storage. The system will keep a record of the amount of wheat off-loaded to the ship and adjust the current storage appropriately.

Trucks
As each loaded truck arrives at the silo, it is weighed to ascertain the amount of wheat in the truck. The system maintains a list of registered trucks and their empty weight (in tonnes). Therefore, a single weighing is sufficient to determine the wheat load. If there is sufficient room in the silo then the wheat is off-loaded into the silo and a record is kept of the amount off-loaded against both the truck registration number and the farmer providing the wheat.

Date and Time
Normally we would maintain the date and time of each operation (truck delivery or ship off-loading) however to simplify this assignment we will ignore those aspects. Instead, we will keep a sequential count of each operation for each silo. Therefore, we will have a history of the order of truck unloading and ship off-loading operations that take place for each silo. The system would be able to say for example, that silo HORSHAM_1, operation number 999 involved 25 tonne of wheat delivered by the truck registered TONKA owned by Jack Black from farmer Bob Smith. Then operation 1000 was an off-loading operation of 125,000 tonnes to the ship "Southern Aurora". There is also a need to keep track of the operation order between silos, therefore we will keep a global sequential count of the operations at silos as well. See the following table for an example:

Global No Silo count Operation Vechicle Name Tonnes Farmer
...





12336
999 Load TONKA 25 Smith, Bob
12337 MELBOURNE 555 Load DUPLO 20 Jones, Mark
12338 HORSHAM_1 1000 Off-Load Southern Aurora 125,000
12339 MELBOURNE 556 Load LEGGO 50 Simons, Jill 
12340 HORSHAM _1 1001 Load TONKA 25 Jones, Mark

Farmers

The system will maintain a record of each farmer supplying wheat to the silo. Details to be kept include the farmer's name, address and phone number.

Z Schema Operations

You are to create a Z schema that adequately describes the WTC system. It should include at least one state space and the following operations:

- An initialization operation called Init.

- An operation Enter new_silo that an operator uses to enter the details of a new silo into the system. Assume the new silo is currently empty.

- An operation Accept delivery that an operator uses to signal the system to begin off-loading x tonne of wheat from a truck. Note that the system must do a check to see if that storage capacity is available in the silo, if not then an error message must be output and no truck unloading done. Additional information needed by this routine is the truck registration and the farmer's name. If successful this operation stores all necessary details into the system for that delivery. If a truck is already unloading then this new truck will be placed in a queue waiting for its turn to unload.

- An operation Leave_quene. This operation is run by the system operator each time there is a queue for a silo and the driver of a specified truck decides that the anticipated waiting time is too long and leaves the queue. The operation outputs to the operator the list of trucks in the queue alter the specified truck is removed or if none in the queue a reasonable error message.

- An operation Silo account that outputs the total amount of wheat in tonnes delivered to a particular silo by ALL farmers in a specified time period (note that means between two global operations numbers in our simplified system). In other words between global operations 10000 and 10500 for example.

- An operation Ships_total_account that outputs the total amount of wheat that a particular ship has taken from ALL silos in the total history of the system.

- An operation Farmers_account that outputs the total amount of wheat delivered to ALL silos in between two specified global operation numbers (e.g. 10000 and 10500).

You should provide robust versions of each operation that are capable of handling any possible error conditions. For example, if the ship or truck is not correctly registered in the system an appropriate error message must be given.

Reference no: EM131058255

Questions Cloud

Dividend discount model-what should be price of this stock : Assume that Monsanto s last dividend was $3.75 per share. You expect dividends to grow at a content rate of 6.5% per year forever. Investors' required rate of return is 13%. According to the Dividend Discount Model, what should be the price of this s..
What is the minimum cash flow-project acceptable : What is the minimum cash flow that can be received at the end of the last two years (year 9 and 10) to make the following project "acceptable?" Initial Cost= $100,000; Cash Flows at the end of years one through four= $10,000; Cash Flows at the end of..
Charge of commercial real estate development for your firm : You are in charge of commercial real estate development for your firm. you are considering developing a property that will cost $35 million to construct. The target return is 5.5% and the lease will be for 20 years and market rents suggest you will r..
Calculate best-case and worst-case npv figures : We are evaluating a project that costs $816,000, has a 12-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 83,000 units per year. Price per unit is $40, variab..
Create a z schema that adequately describes the wtc system : Provide robust versions of each operation that are capable of handling any possible error conditions - create a Z schema that adequately describes the WTC system.
Law of conservation of mass states : The Law of Conservation of Mass states that matter is neither created nor destroyed in a chemical reaction. How do you explain iron nails getting heavier as they rust?
Law of conservation of mass states : The Law of Conservation of Mass states that matter is neither created nor destroyed in a chemical reaction. How do you explain iron nails getting heavier as they rust?
Write an opinion about rising costs of us income inequality : Write an opinion about this two reports- The Rising Costs of U.S. Income Inequality and Trying to Solve the Great Wage Slowdown
Find the probability that a student who has earned a c grade : It is known that 70% of the students follow the study program. Find the probability that a student who has earned a C or better grade, followed the program.

Reviews

Write a Review

Other Subject Questions & Answers

  Write a professional memorandum outlining

Write a professional memorandum outlining and explaining how you will handle this situation. What recommendations would you make?

  Innate factors-impact on motivation than learned factors

Do innate factors have more of an impact on motivation than learned factors? Why or why not?

  Provide the title of the article you selected

Using the site, select an article related to personal biases, gender and culture in leadership, or social and emotional intelligence. Provide the title of the article you selected

  Use of economic and financial information.

Determine which classification of accounting is most concerned with the use of economic and financial information to plan and control many of the activities of the entity.

  Technical writing is the practice of explaining technical

1. technical writing is the practice of explaining technical issues in ways that non-technical people can understand.

  How should region address e.coli problem in river system

How should the region address the E.coli problem in this river system? Should the region and the nation expend funds to remove this enviromental hazard, a liability to economic development? explain

  What is feminism

What is feminism (define)? From your own experience, provide any 2 examples of gender messages you find in ads (one for men and one for women). What are they promoting and why?

  Every dodecahedron is as large as every cube

Every dodecahedron is as large as every cube. [Hint: Since we do not have anything corresponding to as large as (by which we mean at least as large as) in our lanuage, you will first need to paraphrase this predicate using larger than or same size..

  Formulate a multiple regression model

Formulate a multiple regression model from the following data and explain what does the R-Squared, and other statistics that you think is important tells you.

  Compare margaret mead''s ethnography of samoa

Compare Margaret Mead's ethnography of Samoa to Evans-Pritchard's ethnography of the Nuer. How do the styles differ?

  What ethical responsibilities do you have

Are your actions due to your free will or are they predetermined? Lay out your arguments for your position. Give your conclusion to the first question. What ethical responsibilities do you have

  Discuss how conductor can harness also blend all of gifts

discuss how conductor can harness also blend all of gifts that orchestra possesses to ensure that orchestra is able to play all of their songs correctly.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd