View Design

View Design from Natural Language requirements

Requirements for University Data Base

Rules for searching inaccuracies and ambiguities (1)

Rules for searching inaccuracies and ambiguities (2)

Rules for searching inaccuracies and ambiguities (3)

Rules for searching inaccuracies and ambiguities (4)

Ambiguous terms in requirements and possible corrections

Rewritten requirements

To do it we analise the text and decompose it into the set of sentences so that each set of sentences refers to the same concept
( partitioning sentences into gomogenous groups)

Initial Design

Checking and restructuring the first skeleton schema (introducing entity PERSON)

Schema Design

In order to proceed to the final refinements we may now focus on each concept of schema and check for completeness. Thus we define attributes for each entity or relationship and we specify identifiers and mappings.
We notice that textual requirements рооrlу expressed bу thе RELATED-TO relationship between STUDENT and COURSE. In fact, this relationship must bе refined bу introducing the following nеw relationships:
1. Тhе relationship PASSED, representing courses that the student passed, with two attributes: GRADE and DATE.
2. Тhе relationship ATTENDS, representing соursеs thе student currently attends.
3. Тhе relationship MEETS, beween COURSE and thе пеw entity DAY OF_THE_WEEK, reptesenting thе weekly schedule of classes attended bу students in thе сurrеnt year, with two attributes: ROOM and HOUR.
Wе complete the sсhеmа bу adding some other attributes, cardinalities of relationships, and identifiers.

Тhе final sсhеmа

View design starting from forms

Form structure
Certificating part
Extentional part
Intentional part
Descriptive part

Details of parts definition
Certification part contains information that certify existence

Income tax return form

View design from forms

Form analysis

Form Analysis for Income tax return form
become good candidates for decomposing design activity

Tree of areas of Income tax return form

Skeleton schema for income tax return form

Schema Design
Parametric Text. A parametric text is the text in the natural language with some empty fields that are to be filled with values taken from subtable domains/ This text is completed by additional indications about the values that are to be entered in the fields; both the text

View Designs Starting from record formats

Simple Fields

Subscripted (repetitive) fields

Field redefinition

Symbolic Pointers

Flags

Rules of field values