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 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 user friendly software, A computer program is "user friendly", when...

A computer program is "user friendly", when it is designed with simple of use, as one of the primary purposes of its design.

Explain the reuse maintenance model, Explain the reuse maintenance model wi...

Explain the reuse maintenance model with the help of a diagram. Reuse maintenance model: This model is based on the principal  that maintenance could be viewed as an activity i

Explain about non-functional requirement for a software, Q. Explain about n...

Q. Explain about non-functional requirement for a software ? Ans) Nonfunctional requirements are the basic characteristics of the system which will not be expressed as function

Determine the level 4 of key process areas, Determine the Level 4 of key pr...

Determine the Level 4 of key process areas Level 4 KPAs: 1)      Quantitative Process Management (QP): It states quantitative standards for software process. 2)

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.

What is requirement traceability matrix, Requirement traceability matrix ...

Requirement traceability matrix RTM is a matrix tying up needs with the testcases. It is a way of making sure that each requirement has a corresponding testcase which will be t

Explain static analysis, Explain Static analysis? Ans) (1) Analysis of a...

Explain Static analysis? Ans) (1) Analysis of a program that is performed without implementing the program. (2)The process of assessing a system or component based on its for

Linearizability and sequential consistency, QUESTION - Fault Tolerance ...

QUESTION - Fault Tolerance (a) Three computers together provide a replicated service. The manufacturers claim that each computer has a mean time between failure of five days; a

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