Assignment 1: ER Model for 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 https://www.truelancer.com/
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 (https://www.truelancer.com/) 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.
Other functionality not mentioned in the assumptions section can be considered out of scope.
Hint: How to get started:
Naming Convention for tables:
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:
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.
Process to become a Freelancer/ Client:
Click the seller’s name in the top right to check the seller’s profile
Note: Don’t click on ‘submit project’ button
Navigate to Find jobsàRecommended jobs and click View and apply.
Note: Don’t click on ‘Send proposal’ button
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!
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.
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.
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.
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.
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.