DPIT115 : Data Management and Security – Implementation of Simple SELECT Statements – Management Assignment Help

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

Assignment Task :

Scope  

This assignment is related to implementation of simple SELECT statements, SELECT  statement with GROUP BY and HAVING clauses, SELECT statements that join and antijoin  relational tables, nested SELECT statements with set membership operation, and nested  SELECT statements with EXISTS/NOT EXISTS clauses

 

It is expected that all tasks included in Assignment 2 will be solved individually without any  cooperation with the other students. If you have any doubts, questions, etc. please consult  your lecturer or tutor during lab classes.  

If it is suspected that you have received assistance from another person to complete the tasks,  the matter will be investigated as an alleged breach of the UOW College Academic Integrity  and Student Conduct Policy, in accordance with the Procedure for Managing Alleged Student  Misconduct. As part of this investigation, you may be required to undergo an oral examination  to verify your understanding of the assessment content.  

  

 

Prologue  

In this assignment you must use a virtual machine with MySQL. All technical details on how  to start and how to use a virtual machine have been explained and practiced in Laboratory 1,  task 2 and task 3.  

Connect to Moodle and download the Sample database(Sample_database.zip) on  Moodle. Extract the files dbcreate.sql, dbdrop.sql, dbload.sql, dbcount.sql,  and dbschema.bmp. 

SQL script dbcreate.sql can be used to create the relational tables of a sample database.  SQL script dbdrop.sql can be used to drop the tables of a sample database. SQL script  dbload.sql can be used to load data into a sample database. SQL script dbcount.sql can be used to display the total number of rows in each table included in a sample database.  Finally, a file dbschema.bmp contains a conceptual schema of a sample database.  

Connect to MySQL database server either through command line interface mysql or graphical  user interface MySQL Workbench.  

When connected, select a database csit115 with a command use csit115.  To create the relational tables of a sample database, process SQL script dbcreate.sql.  

To load data into the relational tables created in the previous step process SQL script  dbload.sql.  

To list the names of relational tables created, use a command show tables.  

To list a structure of a relational table use a command describe  .  

To list the total number of rows in each relational table process a script dbcount.sql.  

Use a pdf viewer to open a file dbschema.pdf with a conceptual schema of the sample  database.  

No report is expected from the implementation of the actions listed above.   

 

Tasks  

Task 1 

Download a file solution1.sql and insert into the file the implementations of the  following queries as SELECT statements of SQL.  

(1) Find the first and last names of employees who live in NSW, Hurstville, Victoria St. or  NSW, Pennant Hills.  

(2) Find the registration numbers, capacities, and statuses of all truck whose capacity is in  range between 2000 and 4000 both inclusive.  

(3) Find the first and last names of employees who did not provide information about initials  and who provided information about a date of birth.  

(4) Find the first and last names of all employees born either in 1980, or 1992 or 1992 It is  your task to find an appropriate standard function that can be used to extract a year from a  date.  

 

This Management Assignment has been solved by our Management Experts at TVAssignmentHelp. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services