a) DarwinCom Pty Ltd is made up of a number of departments that manage none or more projects.
Each project is made up of none or more team members. Each team member belongs to one
department and zero to one project. One of the team members supervise the other team members
on the project.
b) A company has four departments. Each department has one manager. Each department employs
staff. Each staff may work for one or more departments. A staff may be supervised by another
staff at least.
c) A car insurance company whose customers own one or more cars each. Each car has associated
with it zero to many number of recorded accidents.
d) A university registrar has the following entities: Courses (including course number, title, credits,
syllabus, and prerequisites); Course offerings, (including course number, year, teaching period,
instructors, timings and classroom); Students (including student-id, name, and program); and
Instructors (including identification number, name, department, and title). The enrolment of
students in courses and grades awarded to students in each course they are enrolled for must be
appropriately modelled. An instructor could teach in only one course. Each course only runs in
one session
#Sales Offer!| Get upto 25% Off: