Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have been given a homework task where I am to create an ER model of a database from a set of client requirements. Another part of this task is to create a diagram that shows the scope and boundary of the database system I create. I am having problems creating a scope/boundary diagram as I have been unable to find any examples in my textbooks or on-line. Is anyone able to suggest or provide an example of how this could be done?

share|improve this question
add comment

1 Answer 1

up vote 0 down vote accepted

A system scope / boundary diagram is sometimes also called a level zero data flow diagram or a context diagram See here for the Wiki on DFDs and here for System Context Diagrams.

Whereas an ERD is a model of data at rest, DFDs are a model of data "moving" through processes. Before RDBMS was the predominant data storage mechanism, data was kept in files that were accessed sequentially and was processed a record at a time. Each time the data was processed it was written into a new file. In this way, you could think of data "flowing" from one place to another, transforming as it went. Each data store was shown - often as a rectangle. Processes were shown as circles ("bubbles") and flows were shown as lines or arrows.

The level zero DFD shows the whole system as a single bubble. Outside of the bubble are external actors (e.g. users of various types) other systems, and any other data sources and sinks that you might be concerned with.

The idea of a DFD is to incrementally decompose your system into smaller and smaller processes, until the whole system is described. The level 0/context diagram is the starting point and you drill into each bubble as deeply as necessary to develop a complete system description.

In modern systems, especially where data is stored in RDBMS, the data flow paradigm is not always an especially good fit. However, the context diagram, or level 0 DFD is still useful for describing the scope or boundary of the system in terms of data sources and sinks.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.