6 employee manipulates with customer assignment 4

This preview shows page 3 - 8 out of 15 pages.

6. EMPLOYEE manipulates with CUSTOMER.
Assignment 4: Database Modeling and Normalization 4 After determining the relationships, it must draw them with all the lines between the entities and the relationships, by the ERM: (Relationship by the Diamond figure). Fig (2): Entities with the relationships 3. Determine the relationship type (1:1), (1: M), or (M: N). Every relationship type has a specific symbol to implement it .
Assignment 4: Database Modeling and Normalization 5 Fig (3): Symbols and their meanings For Example One manager manages many employees: (1: M): We can implement this relationship as the following: One and only one manager can manage one or many employees. Fig(4): Entities with relationships types 4. In the end, we must identify the entity attributes and then check the result. ( infocom.cqu.edu.au, 2006). The end figure as the following:
Assignment 4: Database Modeling and Normalization 6 Fig (5): The End Figure (Entities, relationships types, and the attributes) The risks that can occur if any of the developmental or iterative steps of creating an ERM Diagram are not performed: Any organization has the following components: Entities, Attributes, Relationships, and Constraints. The Org. Entities are the main things by it the database model is built. The attributes are the features of the Entities, and the relationships are the describing of the set of correlation
Assignment 4: Database Modeling and Normalization 7 among the entities. While the constraint is the limitation of the relationship, and it is very important to ensure the database integrity. ( Carlos Coronel, et al., 2013). There is no standard modeling that is suitable for all the system types, but every model must align the organization requirements. Every organization has its specific components; therefore, it must have the specific model for its system. These system components are the collection of to implement the system model; therefore, all of it must be founded. If any one of the system components is missed, then the modeling design didn't implement the system requirements, many risks must be faced. Also, the database model may fail. ( McDonald, Caroline, 2004). Entities that would be required for the development of the data repositories: There are various effective entities in the government companies that is required for the development of the data repositories. The entities are implemented by the departments in the companies, the tasks that are performed in this company, and other. The very important entities are the management, department (such as planning, training, security, hiring, etc.), employee, salary, and the customer entity. (Caroline Gilbert, 2011).

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture