Find Jobs
Hire Freelancers

data management and security -- 2

$50-55 AUD

Completed
Posted over 3 years ago

$50-55 AUD

Paid on delivery
NOTE: Please see the attached file and you have to complete all 5 tasks that are described in the file !!! An objective if this task is to use a backup file and recovery feature of a database system to find historical information from a sample database. On 31 May 2015 a database administrator created a backup of a relational table DRIVER and saved a backup in a file old_driver.bak. Then to make your task easier, a database administrator updated the file such that it can be restored into a relational table OLD_DRIVER. Implement a script file [login to view URL] that performs the following actions. (1) Create a relational table OLD_DRIVER that has the same columns as a relational table DRIVER. Enforce appropriate consistency constraints for a relational table OLD_DRIVER. (2) Use a backup file [login to view URL] to load the old pre 31 May 2015 contents of a relational table DRIVER into a relational table OLD_DRIVER. (3) Use SELECT statements to list the employee numbers and driving license numbers of drivers and who left the transportation company after 31 May 2015. (4) Use SELECT statements to list the employee numbers, driving license numbers, first name and last name of drivers and joined the transportation company after 31 May 2015. Before processing of a script file [login to view URL] it is strongly recommended to connect to MySQL either through command line interface mysql or graphical user interface MySQL Workbench and process a script file [login to view URL] and immediately after that the scripts [login to view URL] and [login to view URL] to refresh a sample database. When ready connect as csit115 user, process a script file [login to view URL], and save a report from processing in a file solution3.rpt. To create a report from processing of a file [login to view URL] open a Terminal window and start the command line interface mysql in the following way: mysql -u csit115 -p -v -c Next, process SQL script [login to view URL] and save a report in a file solution3.rpt. Note, that when started with the options -v and -c the command line interface includes both listing of SQL statements processed, and the comments included in the original version of a file solution3.sql. Deliverables A file [login to view URL] with a report from processing of SQL script solution3.sql. The report must be created with the command line interface mysql, the report MUST NOT include any errors, and the report must list all SQL statements processed and all comments included in the original (downloaded) version of solution3.sql. Marks will be deducted for the missing comments. Submission of a file with a different name and/or different extension and/or different type scores no marks.
Project ID: 27531531

About the project

6 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I have experties in data science and Python. I will be able to resolve your project as per your requirement. If you hire me I will be able to do all your assigned tasks as per your expectations. In case of any concerns please feel free to discuss. Regards
$53 AUD in 1 day
4.8 (7 reviews)
3.3
3.3
6 freelancers are bidding on average $158 AUD for this job
User Avatar
Hi, Please see my previous projects done in Database category. I read all your requirements and have some questions about main Driver table and it's data. Please start a chat on PMB if you are interested with my offer. Hope to hearing from you. Regards, Ramin.
$55 AUD in 2 days
4.5 (43 reviews)
5.2
5.2
User Avatar
I read attached documents and considered that there are a lot of work. That is why my bid is such as defined. I am Senior SQL Developer with more than 10 years of database development experience and I can effectively solve each of required task and deliver results in a most qualitative way.
$550 AUD in 7 days
5.0 (17 reviews)
3.7
3.7
User Avatar
Hi I can get the job done, I have been developing relational databases for more than three years, I developed apps using php, please consider me Thank you
$53 AUD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
MARSFIELD, Australia
5.0
11
Payment method verified
Member since Sep 19, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.