question archive A UNIVERSITY A university consists of several faculties
A UNIVERSITY A university consists of several faculties
Subject:Computer SciencePrice: Bought3
A UNIVERSITY A university consists of several faculties. Within each faculty there are several departments. Each department may run a number of courses. All teaching staff are attached to departments, each staff member belonging to a unique department. (Note: see how many meanings you can assign to this ambiguous sentence). Every course is composed of subcourses. Some subcourses are part of more than one course. Staff may teach on many subcourses and each subcourse may be taught by a number of staff. Draw an entity-relationship model for this example. Show both cardinalities and optionalities. Put a question mark where the degree is not clear from the text. Don't assume anything; rather, write list of questions you would have to find answers to complete the model.
