• Subject Name : IT Computer Science

Service Match Database System

This is the enhanced entity relation diagram. Client, business, jobs, servicematch, registration form are various entities. Each entity has different attributes. The client is a specialized form and there are two generalized for of the client, that is, the corporate client and the individual client. Likewise, the business is also of two types that is corporate business and freelance business. If any client wants to join the service match then client has to fill a registration form then the client become registered client. The information that client has to fill are, name, address, suburb, state, phone, email, the type of client; if corporate client or individual client. If the client is individual client then client has to specify whether the client is an owner of the property or the tenant of a rental property. If the client is corporate client than client has to specify the business area and name of corporation. The primary key of the client relation is client number. Each client receives an individual and unique client number. This is the primary key which is unique and it can never be null. Client number is the unique number and this is assigned by the office only.

Business registration form is an entity and the unique and primary key of the registration form is ABN which is Australian business number, this number is unique. In Australia, if a person wants to start the business, each one gets this number, ABN from the government side. This help in identifying the business. If a client wants to open a business then then client has to fill the business registered form. So business registered form is the entity and name, ABN, address, postcode, state, phone, email, category of business , the corporate one or the freelance one and the business type i.e. cleaning, heavy goods transportation, landscape, lawn and backyard mowing, plumbing, electrical work, roof restoration, demolition and rubbish removal are all the attributes of the business.

In the EER diagram service match is the entity that helps in giving the jobs to the client, and clients have to fill the job request form to apply to the job. Client number and client name are the attributes of the job request form in which client number is the primary key, job description is also there on the job request form.

Every client has to do registration for the business, so client and business are the entities and registration is the relationship between them. Business provides job, so business and jobs are the entities and provides is the relationship among them. Jobs can be categorised in two forms, first is casual jobs and second is contractual jobs. These are the specialized form of the generalized term jobs. Hence this EER diagram shows all the relationship between the entities and the attributes of all the entities.

It is necessary to have the primary key in a table to identify the table. For example, there are so many clients who want to apply then how to identify the clients, the clients can be identified with the help of unique client number. Similarly, Australian Business number is the unique number so identify the business.

the type of client; if corporate client or individual client. If the client is individual client then client has to specify whether the client is an owner of the property or the tenant of a rental property. If the client is corporate client than client has to specify the business area and name of corporation. The primary key of the client relation is client number. Each client receives an individual and unique client number. This is the primary key which is unique and it can never be null. Client number is the unique number and this is assigned by the office only.

Business registration form is an entity and the unique and primary key of the registration form is ABN which is Australian business number, this number is unique. In Australia, if a person wants to start the business, each one gets this number, ABN from the government side. This help in identifying the business. If a client wants to open a business then then client has to fill the business registered form. So business registered form is the entity and name, ABN, address, postcode, state, phone, email, category of business , the corporate one or the freelance one and the business type i.e. cleaning, heavy goods transportation, landscape, lawn and backyard mowing, plumbing, electrical work, roof restoration, demolition and rubbish removal are all the attributes of the business.

In the EER diagram service match is the entity that helps in giving the jobs to the client, and clients have to fill the job request form to apply to the job. Client number and client name are the attributes of the job request form in which client number is the primary key, job description is also there on the job request form.

Every client has to do registration for the business, so client and business are the entities and registration is the relationship between them. Business provides job, so business and jobs are the entities and provides is the relationship among them. Jobs can be categorised in two forms, first is casual jobs and second is contractual jobs. These are the specialized form of the generalized term jobs. Hence this EER diagram shows all the relationship between the entities and the attributes of all the entities.

It is necessary to have the primary key in a table to identify the table. For example, there are so many clients who want to apply then how to identify the clients, the clients can be identified with the help of unique client number. Similarly, Australian Business number is the unique number so identify the business.

Remember, at the center of any academic work, lies clarity and evidence. Should you need further assistance, do look up to our Computer Science Assignment Help

Get It Done! Today

Upload your assignment
  • 1,212,718Orders

  • 4.9/5Rating

  • 5,063Experts

Highlights

  • 21 Step Quality Check
  • 2000+ Ph.D Experts
  • Live Expert Sessions
  • Dedicated App
  • Earn while you Learn with us
  • Confidentiality Agreement
  • Money Back Guarantee
  • Customer Feedback

Just Pay for your Assignment

  • Turnitin Report

    $10.00
  • Proofreading and Editing

    $9.00Per Page
  • Consultation with Expert

    $35.00Per Hour
  • Live Session 1-on-1

    $40.00Per 30 min.
  • Quality Check

    $25.00
  • Total

    Free
  • Let's Start

Browse across 1 Million Assignment Samples for Free

Explore MASS
Order Now

My Assignment Services- Whatsapp Tap to ChatGet instant assignment help

refresh