Answer 5 d e s ign an er diag r am f o r a ca r in s

This preview shows page 3 - 9 out of 10 pages.

Answer-
5. Design an ER diagram fora carinsurance company whose customersown one ormore caeach. Each carhasassociated with it zero to many numberofrecorded accidentsrs.Answer-6. Acme 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. Each team member belongs to zero to one project.One of the team members supervise the other team members on the project.Answer-
7. Given the following business rules, create an ER diagram for each of the specified relatonships:A company operates four departmentsEach department employs staffEach staff may work for one or more departmentsA staff may be supervised by another staffEach department has one manager.Identfy the entites and the attributesAnswer-
8. Design an ER diagram for university registrar including the following entties:Courses, including course number, ttle, credits, syllabus, and prerequisites;Course offerings, including course number, year and teaching period, instructors, tmings and classroomStudents, including student-id, name, and program; andInstructors, including identificaton number, name, department, and title.Further, the enrolment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modelled.Document all assumptions that you have madeAnswer-
Background image
9. Prepare an Entity Relationship Diagram (ERD)showing all primary and non-primary keyattributesforthe following description ofa Property Rental System:Propertiesare rented by tenants. Each tenant isassigned a unique numberby the Agency. Data held about tenantsinclude family name, given name, property rented, contact addre-street, city, state, postcode & telephone number. Atenant may rent more than one properand many tenantsmay rent partsofthe same property (eg. a large shopping complexPropertiesarssty ).

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture