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

Illustrate about the waterfall model, Waterfall Model It is the oldest...

Waterfall Model It is the oldest, simplest and most widely used process model. In waterfall model, every phase of the life cycle is finished before start of a new phase. It's

Draw an entity-relationship model, (a) Draw an Entity-Relationship model f...

(a) Draw an Entity-Relationship model for the relational schema given in the Appendix. Show all the entities, relationships, relationship names, and attributes and also underline

Name the commonly used architectural styles, Name the commonly used archite...

Name the commonly used architectural styles. i. Data centered architecture. ii. Data flow architecture. iii. Call and return architecture.

Goals of quality control, Describe how the goals of quality control (QC) fl...

Describe how the goals of quality control (QC) flexible manufacturing systems (FMS), design for assembly (DFA)and low overall costs can be best combined by computer integrated manu

Objectives of data dictionaries, Objectives of Data dictionaries:- 1)  ...

Objectives of Data dictionaries:- 1)  A standard definition of all terms in a system, that is every item of data is uniquely identified and described. 2)  Easy cross-referen

Final Year Project Help, I am currently working on a project and am far fro...

I am currently working on a project and am far from passing, I need help ASAP! The project task is to create a Decision support system for An Airline. It must predict and make de

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

What does a usecase diagram represent, Problem : (a) What does a UseCas...

Problem : (a) What does a UseCase Diagram represent? (b) Draw a UseCase Diagram for the above case study. (c) For any one use case give a detail use case specification.

What are the advantages of smoke testing, What are the benefits of smoke te...

What are the benefits of smoke testing? Integration risk is decreased. The quality of the end-product is getting better. Error diagnosis and correction are simplified. Assessme

Illustrate the example of data dictionary of payroll, Illustrate the exampl...

Illustrate the example of Data dictionary of payroll Data dictionary of payroll may include below fields: PAYROLL   = [Payroll Details] = @ employee name + employee + id

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