DATA MODELING BASICS - Database Design and Development: An Essential Guide for IT Professionals - page 156

DATA VIEWS

PROCESSES

CourseNo
CourseName
SemesterHours
Credits
StudentNo
StudentName
Program
StudentMajor

DATABASE

Course
registration

COURSE

STUDENT

EXAMTYPE

Course No
StudentNo
StudentName
ExamType
ExamGrade
FinalGrade

GRADES

Assignment
of final
grades

Figure 5-12 Data views as windows into database.

DATA VIEWS

DATA
VIEW-1

INFORMATION
REQUIREMENTS

DATABASE

INFORMATION
ABOUT
real-world business
objects,
characteristics,
relationships,
business rules
……………

DATA
VIEW-2

DATA
STORED ABOUT
objects,
characteristics,
relationships, rules,
constraints
……………..

DATA
VIEW-3

DATA
VIEW-n

Figure 5-13 Data views: two perceptions.

Figure 5-12 illustrates this comparison of data views with windows into the uni-
versity database system. Notice the data elements for the two processes seen
through the two windows.

Data Views: Two Perceptions

You have now perceived data views from two sides of the entire database devel-
opment process. Let us summarize our discussion of data views so far using two
approaches. On one side, you have seen the real-world information requirements
as a collection of individual data views. From the other side, you have perceived
data views as windows into the completed database system. Figure 5-13 demon-
strates the two perceptions of data views from both sides.