Servicematch is an upcoming company based in Melbourne. Their primary purpose of business is to provide a platform where clients can access services, needed on a regular basis, easily. These services include heavy goods transportation, domestic and commercial cleaning, landscape and lawn maintenance and design, plumbing works, electrical works, construction and many more. The business process starts with registered clients and service providers. Clients register with Servicematch using a simple registration form (Appendix A) and can then request for quotes on a service. From the perspective of the company, the clients are mainly classified as corporate and individual clients. Corporate clients are those who require services for professional purposes and individual clients are those who require services for personal or household purposes. For each of the registered clients, the company keeps record of their name, address, phone number and email address. Apart from this basic information, the company also keeps track of property ownership circumstances of the individual clients. They want to know whether a client is a property owner, or a tenant in a rental property. Servicematch uses the information for promotional purposes. For the corporate clients, the company also keeps track of the business information such as name of the corporation and business area. Similarly, service providers or businesses registers (Appendix B) with the company with their details and are approached by the company if there is any suitable work for them. For the registered businesses, the contact person name, phone number, email address, business address, suburb, and ABN number are recorded. Servicematch do not allow a business to register with them unless they have a valid Australian Business Number. Moreover, the businesses are mainly of two categories, i.e. corporate businesses, who are registered as a company, and freelancers who are registered as single person service providers. Servicematch keeps track of these two categories, as they offer the some of the freelancers, free career seminars for continuous service improvement and future business expansion. When a registered client requires assistance from Servicematch, the person creates a job request by filling up a job request form (Appendix C). Jobs can also be of two main categories. Casual jobs are only created by individual clients and are one-time events. On the other hand, contractual jobs are only created by corporate clients and have specific contract start and end date. Each job is assigned a unique job id, a job description, a level of urgency. Servicematch maintains a collection of suburbs. Each suburb has a name and postcode. They also store information about adjacent suburbs. A suburb can have more than one adjacent suburb. Every created job is related to one suburb. Additionally, each job belongs to one of the predefined job industries. Each industry has a unique id and a title. When a business (both corporate and freelancer) registers, they are also required to select one or more industries to be affiliated with. Once a job is created, based on the suburb, the nearby businesses who are affiliated with the same job industry, are notified. The interested businesses provide quotes for each job requests, based on the job description and urgency. A job can receive many quotes from different businesses. Similarly, a business can quote many jobs at the same time. The amount of money quoted by a business for a job, is also recorded. Once the client evaluates all the quotes, one business is assigned the job, and the information is recorded. The payment system of Servicematch is a very simple one. The invoice is generated against each job that has a unique invoice number and the amount to be paid by the client to the business. One job can have multiple invoices associated with it. The company further keeps track of the trade unions that represent some of the industries listed by Servicematch. The officials believe that if they have listed unions’ contact details, it might be helpful to communicate easily with the businesses on a mass level. A trade union can represent more than one industry, for example, Mowers Union represents Landscaping and Mowing industries. However, each industry is represented by at most one trade union. Servicematch allows the freelancers to become a part of elite members’ club. Additionally, it also allows the trade unions to become elite members. The perks of being an elite member is to get invitation to different career seminars which are free and beneficial for businesses to thrive. An elite member is a registered freelancer or a union representative but not all freelancers or unions are elite members unless they have registered to be one. The invitation to different career seminars is sent to the elite members periodically along with the seminar details, i.e. title, date and time, venue and so on. Many members can attend a seminar, but the company does not allow a seminar to take place if there are less than 5 attendees. This rule helps justifying the cost of arranging an expensive seminar. As the company is a newly formed enterprise, they do not have an online system yet, which is making things a lot harder for the employees. So, before moving to an online management system Servicematch wants a relational database system that can cater for their entire business process and emerging volume of data.

You are required to develop an EER model for the above problem description. The EER should contain all necessary information such as entities, attributes, primary keys, relationships (including specialization/union if any), cardinalities, and participation (including (min, max)). Any assumptions should also be stated clearly. If assumptions are made, it is important to make sure that the assumptions reflect possible real practice for a similar business and do not contradict with the problem description above. Assignment should be typed, not written/drawn by hand. Use any software to draw figures in your assignment. However, make sure to follow the notations introduced in this subject.