ER Model for Truelancer

Assignment 1: ER Model for Truelancer


Don't use plagiarized sources. Get Your Custom Essay on
ER Model for Truelancer
Just from $13/Page
Order Essay


About Truelancer:

Truelancer is an online platform for employers hire professionals to get their work done. Freelancers, a term used for those who provide services, can sell services, and find projects to work on based on their skills & expertise. Clients can buy freelance services and post project to hire freelancers. Projects – a term used for the task posted by Client – can be placed in various categories like IT & Programming, Graphic Design, Content Writing, Data Entry, Finance, Sales, Marketing, and many more. The URL for the website is

Assignment Summary:

You have to create a database in MySQL for Truelancer. A database design project generally starts with requirements – you analyze the requirements to identify the business rules, entities, and relationships to form an ERD and then convert it into a database. In this case, however, we are using snapshots from a functional website ( to understand the entities and business rules so that we can reverse engineer the database design. This document provides snapshots from the website for your reference. However, I recommend that you should go through the truelancer website to understand the Freelancer and Client workflows.


The scope of this assignment is limited to bids and reviews. Like other bidding systems, a client/employer can post projects on the website and freelancers can bid on the project(s). The client selects one of the bids at his/her discretion for the work to start. Your design should capture the bids received, the selected bid along with the amount and duration of the project. The payment schedule for the selected bid is out of scope for the assignment. Similarly, the sales of non-project related tasks (things that do not go through the bidding process) is out of scope for the assignment. Moreover, we can assume that the employer/client cannot be a freelancer. As for the reviews, we will assume that the client/employer to leave reviews for the selected bidder (freelancer) and the selected bidder (freelancer) can also leave reviews about the client/employer.



  • A freelancer/client can sign up via email and create an account.
  • A client cannot be a freelancer.
  • Client can leave reviews for the approved bidder and the approved bidder can leave reviews for the client. The reviews will only appear on the website after the completion of the project. (Hint: this has no implication on capturing the reviews in the database. The visibility of the review on the website is managed via coding).
  • The system should keep track of the approved bids.

Other functionality not mentioned in the assumptions section can be considered out of scope.

Hint: How to get started:

  • Finalizing your design on paper before implementing it in MySQL will help you understand the relationships better.
  • Go through the snapshots provided to understand how the website works. You might want to go through the freelancer registration process (do not submit) to understand it better.
  • Identify the entities that you must have and ones that you might need.
  • Capture attributes for each entity and determine the functional dependencies.
  • Determine the relationships between entitie Hint: When forming the relationship statement, start the sentence with one/each. For example: one/each department has many employees; one/each employee works for one department.
  • Identify cardinalities. You don’t need to worry too much about minimum cardinalities.
  • Implement the ER model in MySQL Workbench.
  • Create the physical database by using the forward engineering feature in MySQL Workbench.
  • Populate at least five records in each table. This is needed for the third assignment.


Naming Convention for tables:

  • Use your first name and last initial as a suffix for your table nam For example, I will name the Sales table as Sales_KashifS. Not following the naming convention will result in a 5-point reduction in your grade.

What and how to submit your assignment

You are required to submit the assignment on Canvas. Emailed assignments are not accepted. Please submit a zip file containing:


  1. 1. MySQL file (for the model)
  2. 2. An MS Word document containing the snapshots of the ERD and the physical tables created in MySQL with data


Note that you will need this database for future assignments.


Approximate Work Effort

An estimated work effort for completing the assignment is 8-12 hours. Please do not wait till the last minute to a) install the tools, and b) start the assignment. The TA will not entertain any queries about tool installation after September 8th. Moreover, the TA will not be answering any question about the assignment post September 17th. You’re allowed to discuss any technical issues and/or questions about the assignment on Canvas by posting a discussion. Other discussions outside of Canvas with the class mates regarding the assignment are considered an act of plaigiarism.


Website snapshots:

Process to become a Freelancer/ Client:

  1. Sign up GMAIL or any email address.



  1. Navigate to servicesàsell service and provide the basic information



  1. Navigate to servicesàBuy services. Search for services you are looking for


  1. Click on any service and find details such as Overview, Description, Reviews, Similar services.

Click the seller’s name in the top right to check the seller’s profile

  1. Read customer reviews before buying the service


  1. Client/Buyer can customize their project by clicking post project.

Note: Don’t click on ‘submit project’ button


  1. Freelancer/Seller can find new projects to work on

Navigate to Find jobsàRecommended jobs and click View and apply.

Note: Don’t click on ‘Send proposal’ button



Academic Heros
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

Our writers are encouraged to read and research widely to have rich information before writing clients’ papers. Therefore, be it high school or PhD level paper, it will always be a well-researched work handled by experts.

Professional and Experienced Academic Writers

For one to become part of our team, thorough interview and vetting is undertaken to make sure their academic level and experience are beyond reproach, hence enabling us give our clients top quality work.

Free Unlimited Revisions

Once you have received your paper and feel that some issues have been missed, just request for revision and it will be done. In addition, you can present your work to the tutor and he/she asks for improvement/changes, we are always ready to assist.

Prompt Delivery and 100% Money-Back-Guarantee

All our papers are sent to the clients before the deadline to allow them time to review the work before presenting to the tutor. If for some reason we feel our writers cannot meet the deadline, we will contact you to ask for more time. If this is not possible, then the paid amount will be refunded.

Original & Confidential

Our writers have been trained to ensure work produced is free of plagiarism. Software to check originality are also applied. Our clients’ information is highly guarded from third parties to ensure confidentiality is maintained.

24/7 Customer Support

Our support team is available 24 hours, 7 days a week. You can reach the team via live chat, email or phone call. You can always get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

You have had a hectic day, and still need to complete your assignment, yet it is late at night. No need to panic. Place your order with us, retire to bed, and once you wake up, the paper will be ready.


Essay Writing Service

It does not matter the urgency of your paper, or the academic level, our team is ready to help you 24/7. Just contact us and all your academic needs will be sorted.


Admission Essays & Business Writing Help

A student is often required to write an admission letter requesting to be admitted in a certain institution. For you to be gain that admission in your dream institution, you must write a convincing letter. You can depend on our team for the best admission letters.


Editing Support

Academic writing is not just about getting information and throwing it all over. Our team will ensure you have a polished paper that is coherent and has a good flow of information. We also ensure the paper follows the correct formatting styles like APA, Harvard, MLA, Chicago/Turabian.


Revision Support

If our writers write a paper but you are not satisfied in one way or another, you can always ask for revision. This is totally free. Our writers and editors will revise your paper untill you are be totally satisfied. We as well offer revision for papers not done by our writers at a small fee.