Studierende stehen vor dem LC und blicken lächelnd einer Kollegin mit einer Mappe in der Hand nach.

Exercise No. 46: Lecture at the Boston University (dfm)

The fol­lo­wing E/R sche­ma de­scri­bes a lec­tu­re at the Bos­ton Uni­ver­si­ty.

Lec­tu­res are hold by a lec­tu­rer. This per­son is of a cer­tain type (pro­fes­sor, as­si­stant) and be­longs to a cer­tain de­part­ment (par­al­lel hier­ar­chy). Stu­dents who are of a cer­tain type at­tend a lec­tu­re. A lec­tu­re has a cer­tain sub­ject which be­longs to a cer­tain sub­ject group and takes place in a cer­tain lec­tu­re hall. This hall is part of a uni­ver­si­ty buil­ding. The time di­men­si­on con­sists of day and week.

Fi­gu­re D.E.30.1 - a lec­tu­re at the Bos­ton Uni­ver­si­ty

Plea­se iden­ti­fy the fact of in­te­rest and build the at­tri­bu­te tree. Some at­tri­bu­tes can­not be used for ag­gre­ga­ti­on in a me­a­ning­ful way. Those should be tag­ged as non-​dimension at­tri­bu­tes in the fact sche­ma.

Then de­ri­ve the fact sche­ma from the tree by de­fi­ning di­men­si­ons, fact at­tri­bu­tes and hier­ar­chies and build a glos­sa­ry for the fact at­tri­bu­tes if there are any.

Plea­se in­clu­de an ad­di­tio­nal fact at­tri­bu­te coun­ting the num­ber of lec­tu­res.

So­lu­ti­on

Ex­er­ci­s­es List