Customer Priority.
The customer database is essential in any entity in finding out which customer of customer group is essential and that gives much revenue as far as the services are concerned. The customer database reveals much information regarding the customers in terms of residence, type of services rendered, and the cost of the rendered services. For flexible, reliance, and efficient databases, there is a need for the right information system that will make the users of the database make critical decisions on the firm’s way forward. The UML system has two models the class model and the relational model that are allowed to run in real-time to give information about the objects of operation in the database.
The class model:
This is the entity model where the objects are allowed to run in real-time. The class model is an object-oriented model that relies solely on the functions of the object (UML, 2017).
This will look at the object itself in line with persistence, behavior, and identity. This is used as a software model to produce a logical structure behavior of the object. It looks at the object behavior in line with the data required in a domain.
In UML, it is the fundamental logical entity simply meaning that in the creation of the database for the clients, then the firm will start with the class model to include the particulars of the objects or customers. The clients’ data are registered here at the class model, and the behavior of the whole structure is also checked.
Dynamic diagrams are usually used to show the collaboration of objects inside a class and the interactions. In other words, the client’s information in the database is used in collaboration with the other objects in the database to show how often they interact with each other to develop the model that defines their behavior and the interactions.
The class’s behavior aspect is usually in three ways: it can be for the whole public, private or limited to children. In a firm’s database, information might be limited only to the management that the employees should not access. Some are open to everyone and the customers; again, there are those for the internal use only that firms use for internal purposes (UML, 2017). The database interfaces all this information and allows only the information relevant to the specific groups to function.
Therefore, the behavior of the database is purely dependent on the designer who can make it highly interactive and allows for modification or can make it complicated and complex, not allowing change. The better of the two, though, is the one that allows for changes in future development.
The relationship and identity:
The classes of different categories must be brought together to see the relationship between the different classes.
There is a need to bring different classes to the point that the relationship will be identified. For example, the relationship between the class of clients and the service providers’ similar services is significant as there must be the relationship that brings these classes together. The cost of the service offered and the number of times that the service has been offered also needs to be reflected in the database. The must be the information that the different classes are connected in one way or another, that one class knows the existence of the other and that their functions are either dependent on the other or independent from the other.
There must be an aggregate where a class is connected to the other. For example, the clients must be connected to the service providers in one way or the other.
These objects must always be in a position to identify themselves during the run-time. Computer programming languages like C++ to be used to make sure that each object. In a class identifies itself with ease (Rybola, & Pergl, 2020).
An inheritance language can also be used to group the objects with similar characteristics; for example, different clients looking for the same service can be grouped using the inheritance language in the database.
This model shows the relationship between tables and columns. The relationship tables contain more than one column. Each column must have a different name from the other. Every column must have some necessary data like the text, number, or binary (Rybola, & Pergl, 2020). All these are data information that is used in the public data point of access. The model has a table definition that is a template for creating table rows.
The behavior of the tables is pegged on the business or the rules commanded on the entity. The constraints of relation integrity use the allowable values and data types. Triggers identify new behavior from the entity, majorly used before or after deletes, inserts, and updates.
The database procedures extend database functionality. The extension language is used in making functional units. The SQL primary language selects rows and finds out instances for a set in the table. The unique identification is formed by the use of the primary key, which is two types:
A table made up of data and columns that are identified by the essential keys the next is an abstract identifier made of counter values with no business meaning. To note is that the essential keys have business meaning that makes it relevant in identifying the information on the customers and the services rendered to them.
From the above illustrations, it can be defined that if the company wants to create the client database to know which clients are essential in the industry, then there is need to use the UML model that has the tables and the columns that give the table’s logical structure and the behavior using the indexes, keys, procedure and the triggers to represent the behavior of the columns as an ordinary operation. There must be defined possible behavior in terms of primary vital constraints (PK), foreign key constrains (FK), an index constraint (index), a trigger, a unique constraint, a stored procedure, and the validity check. When using these, it is possible to come up with a Database Management System that relates all these into a data processing information system that can give the desired information by the management.
This is the dependency between two tables of any kind. It defines the relationship between the primary constraints and foreign constraints. The relationship must define the parent and the child and bring the relationship between the two (Rybola, & Pergl, 2020). The parents here define the primary key while the child defines the foreign key. The PK-FK to be modeled to show association roles.
We are mapping the class model and the relational model.
In order, the firm to keep track of their customers there is a need to come up with a UML system the will integrate the firm and the clients where the firm is going to be the primary constraint and the clients being the foreign constraints both being affected by particular factors but are related in the service provided and the cost of the service. The class that contains the client’s information and that of the firm are written differently. However, a relationship model is made between them.
Conclusion
In order to identify the clients that are beneficial to the firm using the UML system, there is a need to follow the following; first model a class, form a schema of the relationship database from the class model. Second, identify the persistent objects. Form the class model and come up with elements that will always be used and those that will not be used. For example, only the class being made persistent. Third, make a relationship table and assume each persistent class maps on it. The relationship might not be full, but even a partial relationship is acceptable. It should be that a single object or part of it maps a table (Ciccozzi, Malavolta, & Selic, 2019). The next it to select an inheritance strategy, from the relationship, the inheritance strategy is developed where each class behavior has a corresponding table that contains inherited characteristics. It is the unity of every class. The next is that each class must have a table with only its hierarchy containing even the inheritable ones. The last is that each class will have to have a table containing attributes of only the generation.
This is the way the client’s database will be designed to get to identify the group of customers that are very beneficial to the firm (Ciccozzi, Malavolta, & Selic, 2019).
Being that prime services has all the information it needs, it only needs to engage the UML system by following the steps that have been illustrated to come up with the database of all its customers and their profitability to know which of their clients are more relevant and most beneficial. The integration of the company and its clients is significant that it needs to bring the right information to the customers (Rybola, & Pergl, 2020). Having the customer details and identifiers makes their work even more straightforward as the only work that now remains is only to create a UML model that will reveal to them the relationship that they desire to know in line with the customer base. The identifiers are to be used in the place of the user. At the same time, the information on the services rendered is the system.
References
Ciccozzi, F., Malavolta, I., & Selic, B. (2019). Execution of UML models: a systematic review of research and practice. Software & Systems Modeling, 18(3), 2313-2360.
Rybola, Z., & Pergl, R. (2020). Towards OntoUML for Software Engineering: Transformation of Anti-rigid Sortal Types into Relational Databases. Retrieved 4 June 2020, from.
UML, O. (2017). OMG (2017) Unified Modeling Language®(OMG UML®) Version 2.5. One https://www. omg. org/spec. UML.