A Method for Data Warehouse Design - Data Warehouse Systems: Design and Implementation - page 416

(0,n) (3,n)

AcademicStaff InvestigatesIn ResearchCenter

EmployeeNo
Name
Address
Rank
E-mail
Homepage

ResCenterId
ResCenterName
Director

StartDate
EndDate
WorkingTime

(0,n)

(0,n) (1,n)

Participates

Belongs
ResCent

Start date
End date
Salary
Week hours

(1,n)

(0,1)

(1,n)

Teaches

Project

Semester
Year
WeekHours

ProjectId
ProjectAcronym
ProjectName
Description
StartDate
EndDate
Budget
FundingAgency
International
Discipline

(1,n) (5,n)

WorksIn

StartDate
EndDate
Percentage
Salary
WorkingTime

Course

CourseId
CourseName
Level
Homepage

(1,1)

Registered

(0,1)

(1,n)

(1,n)

BelongsDep

Department (0,n)

CourseDegree

DepartmentId
DepartmentName
Chairman

BelongsFac

(1,n)

(1,1)

(1,n)

AcademicDegree

(1,n) Faculty

DegreeId
DegreeName
Description
Responsible

(1,n)

FacultyId
FacultyName
Dean

Organized

Fig. 10.13 Excerpt from the ER schema of the operational database in the university
application

relationship schema of the operational database in Fig. 10.13 .For
this, you must

￿ Explain how the facts, measures, dimensions, and hierarchies are
derived.
￿ Summarize in a table the information obtained.

(e) Produce a conceptual schema using the source-driven approach ,
deriving the schema from the one in Fig. 10.13 . Validate the
conceptual schema with the users, indicating if the schema includes
less, more, or the exact information needed to solve our case.