Ed and the total line p r ice p r odu ct p r oduct

This preview shows page 1 - 5 out of 6 pages.

ed and the total line pricePRODUCT -product number, product description and product unit price An initial ERDusing Lucidchart forthisscenario would be:
CRICOS ProviderNo. 00103DITECH1006/ 5006Laboratory 2
ThisERDonly showsthe primary keysofeach ofthe entities, sometimesan ERDisdrawnsuch that it will showall the non-primary key attributesforthe model. In such a complete ERDyou mustnotshoworlabelforeignkeys, the use offoreign keysindicatesthat you are looking at a logical model where a choice hasbeen made to use a relational database, ratherthan a conceptual model.Prepare the ERDshown above using yourchoice ofdrawing tool and then create a copy ofthisinitial model and add all the non-primary key attributeslisted in the scenario above to yourcopy.Answer-
4. Use the above diagram and the businessrulesbelow, create an Entity Relationship Diagramusing Crow’sFoot notations.oInclude:all appropriate connectivities, all cardinalitiesandat least the minimum numberofattributesrequired to implement the model oBusinessRules:Adepartment employsmany employees, but each employee isemployed by one department.Some employees, known as"rovers,"are not assigned to any department.Adivision operatesmany departments, but each department isoperated by one divisionAn employee may be assigned to many projects, and a project may have many employeesassigned to it.Aproject must have at least one employee assigned to it.One ofthe employeesmanageseach department, and each department ismanaged by one employeeOne ofthe employeesrunseach division, and each division isrun by one employee.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture