Fermé

Data Management and Security -- 2

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.

Compétences : SQL, MySQL, Programmation de bases de données, Administration de Bases de données, PHP

en voir plus : data governance model, data security management, types of data security, data security, data security examples, data governance institute, data security measures, data security pdf, help music data management system, kinds data management, data management excel macro, master data management six sigma, master data management sigma project, resource data management pro 333, medical transcription data management, brio data management, satyam data management bidding csc, data management visual, empaxis data management, nazushan hassenglobal data management

Concernant l'employeur :
( 12 commentaires ) MARSFIELD, Australia

Nº du projet : #27526539

5 freelances font une offre moyenne de 99 $ pour ce travail

(5 Commentaires)
4.2
malotmeena

Dear Greetings of the day I have gone through your requirements and attached document. Please PM me to start the work... I will give you quality work. Thanks & Regards Meena Malot

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
rimkarbouldgru

bonjour j'ai fait plusieurs plateformes avec php et mysql comme [login to view URL] je peut créer ,modifier et faire des recherches sur la base , je suis doué , je manipule la base avec des requêtes complexes , je fa Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
robertmbogni7

Hello, I would love the opportunity to bring my skills as a detail-oriented leader to your business.. Best regards

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
nadewn

Dear Hiring manager I will work your data management and security job and proved you with clear, concise reports. I am senior Computer Science professional with 10 years of experience. I have worked on several similar Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(0 Commentaires)
0.0