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

C++, how to save image of a dialog box by using c++

how to save image of a dialog box by using c++

Characteristics of an embedded system, Question: a) Draw a diagram show...

Question: a) Draw a diagram showing the parts of an embedded system. b) Give the definition of an Embedded Computer. c) Discuss the similarities and differences between a

What are quality reviews, What are Quality reviews? This is the princip...

What are Quality reviews? This is the principal method of validating the quality of a process or of a product. A group examines part or all of a process or system and its do

Explain defect, Explain Defect? Ans) 1) From the producer's viewpoint: a...

Explain Defect? Ans) 1) From the producer's viewpoint: a product needs that has not been met or a product attribute possessed by a product or a function perform by a product tha

Explain metric, Explain Metric? Ans) The measure of the extent or degree...

Explain Metric? Ans) The measure of the extent or degree to which a product possesses and exhibits a particular quality, property, or attribute.

What is boundary data- Test data, What is boundary data- Test data Ex...

What is boundary data- Test data Extreme/boundary data -  This is data at the limits of validity/acceptability (for instance, if a date is being input, two values at the

Simulate the operations of a scientific calculator, Q. A program is to be d...

Q. A program is to be developed to simulate the operations of a scientific calculator. List the facilities to be provided by this calculator. Analyze this using DFD? Level 0

What is cmmi framework, What is CMMI framework? The CMMI framework is t...

What is CMMI framework? The CMMI framework is the present stage of work on process assessment and improvement that started at the Software Engineering Institute in the 1980s.

XML, Ask Create an XML file with markup tags and some sample data to repres...

Ask Create an XML file with markup tags and some sample data to represent a list of invoices.

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