ITECH1103-Tutorial02 portfolio.pdf 414 Federation UNIVERSITY AUSTRALIA Portfolio Questions 7. Given the following business rules, create an ER diagram for each of the specified relationships A company operates four departments .Each department employs staff .Each staff may work for one or more departments A staff may be supervised by another staff member .Each department has one manager ldentify the entities and the attributes 8. Design an ER diagram for an university registrar including the following entities Courses, including course number, title, credits, syllabus, and prerequisites .Course offerings, including course number, year and teaching period, instructors timings and classroom Students, including student-id, name, and program; and Instructors, including identification number, name, department, and title Furthermore, the enrolment of students in courses and grades awarded to students in each course they are enrolled in, must be appropriately modelled . Document all assumptions that you have made 9. Prepare an Entity Relationship Diagram (ERD) showing all primary and non-primary key attributes for the following description of a Property Rental System Properties are rented by tenants. Each tenant is assigned a unique number by the Agency. Data held about tenants include family name, given name, property rented, contact address - street, city, state, postcode & telephone number. A tenant may rent more than one property and many tenants may rent parts of the same property (eg. a large shopping complex) Properties are owned by owners. Each property is assigned a unique building number. The agency only recognises a single owner for any of the properties it handles. The owner, address, and value are recorded for each property. In addition the lease period and bond are recorded for each property or sub property rented. An owner may own several properties Properties are subject to damage and the agency records all instance of damage to its properties - property, date, type of damage and repair cost are recorded Repair costs are charged directly to tenants Normal property maintenance is also noted property, date, type of maintenance and cost are recorded. Maintenance costs are charged to the property owner Tenants pay accounts to the Agency - these consist of weekly rental payme bond payments (for new properties) and damage bills. The date of payment, tenant, property, type of account (Rental, Bond, Damage) and amount e recorded Page 4 of 4