Write a valid schema for the container, Software Engineering

Assignment Help:

A storage tank has a container to keep a certain amount of fuel and it also has an indicator to inform about the level of fuel inside the container.

The container cannot exceed the maximum capacity of the tank and the indicator is represented by a light with states on and off. Also the indicator reads the level of fuel inside the tank and it signals when the level has reached the maximum by switching to state 'off', that is it is on during the fill operation. Assume the maximum capacity of the tank to be 5000 and the indicator to signal a danger level when capacity of the tank reaches 50.

(a) Write a valid schema for the container.

(b) Write a valid schema for the indicator.

(c) Write a schema for the storage tank by combining both of the above schemas.

(d) Write a schema for the fill operation.

(e) Write a schema to represent the state when the tank is overfilled.


Related Discussions:- Write a valid schema for the container

Explain the design principles, Explain the design principles. The d...

Explain the design principles. The design process should not endure from tunnel vision. The design should be traceable to the analysis model. Design should not re

What is architectural evolution, What is architectural evolution? Archi...

What is architectural evolution? Architectural evolution is the method of changing a system from a centralized architecture to a distributed architecture as client server.

Explain the iterative model, Explain the Iterative Model Every release ...

Explain the Iterative Model Every release of Iterative Model is developed in a specific, fixed time period known as iteration. Each iteration focuses on a certain set of requir

Differentiate between failures and faults, Differentiate between failures a...

Differentiate between failures and faults.   Failure:- Failure is the departure of external results of program operation from requirements. So failure is dynamic. Failure can

Software project planning entails what activities, Software project plannin...

Software project planning entails what activities? Software project planning entails the many activities: -  Estimation:  o Effort, , resource, cost and project duratio

Explain throw-away prototyping, Throw-Away Prototyping: Also known as clos...

Throw-Away Prototyping: Also known as close ended prototyping. Throwaway or Rapid Prototyping refers to the formation of a model that will eventually be discarded rather than beco

Explain the purpose of an outer join, (a) What is a view? (b) What is ...

(a) What is a view? (b) What is the implication of creating a view with the select * statement in the view definition? (c) Make reference to the relational schema given in

What are the umbrella activities of a software process, What are the umbrel...

What are the umbrella activities of a software process? Software project tracking and control. Risk management. Software Quality Assurance. Formal Technical Reviews.

Nature of roots of a quadratic equation, Consider a program for the purpose...

Consider a program for the purpose of the nature of roots of a quadratic equation. Its input is the triple of positive integers say a, b, c as well as values in the interval [0,100

Write Your Message!

Captcha
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