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

#title.decision table, You are to create a decision table to help you decid...

You are to create a decision table to help you decide what to do for the day. If it is a weekday and it is not a holiday, then you go to work. However, if it is a weekday and it

Explain respiratory quotient, Explain Respiratory quotient? Ans) Respira...

Explain Respiratory quotient? Ans) Respiratory quotient is the ratio among the carbon-dioxide used in photosynthesis to the quantity of oxygen liberated in respiration.

State the categories of software maintenance, Categories of software mainte...

Categories of software maintenance There are three categories of maintenance:  i) Corrective Maintenance ii) Adaptive Maintenance iii) Perfective Maintenance

What is test scenario, The terms "test scenario" and "test case" are certai...

The terms "test scenario" and "test case" are certain used synonymously. Test scenarios are test cases or test scripts, and the series in which they are to be implemented. Test sce

What are quality factors, What are Quality factors? For large projects...

What are Quality factors? For large projects with 'average' capabilities, the development process verifies product quality. For small projects, the capabilities of the deve

What is the purpose of symbol table, Problem 1 . What is the purpose of Sym...

Problem 1 . What is the purpose of Symbol Table? Write a brief note on various Data structures used in implementing Symbol Tables Stating Purpose Writing note on various D

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 is stepwise refinement, What is stepwise refinement? Stepwise Ref...

What is stepwise refinement? Stepwise Refinement:- Stepwise Refinement is a top-down design method originally proposed by Niklaus Wirth. A program is developed by successively

Explain compatibility testing, Compatibility testing is testing how well so...

Compatibility testing is testing how well software performs in a certain operating system,hardware, software, or network environment.

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