$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

7003ICT Database Management

tag 0 Download2 Pages / 382 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

  1. Task 1: Create a text file named Create_<StudentID>.sql (for example, Create_s3087654.sql) that will contain SQL statements to:
    1. Create a database named BigM_<StudentID>.
    2. Create all of the tables for the database according to the Database schema given with this document (separately attached).
  1. Task 2: Create a text file named Insert_<StudentID>.sql that will contain SQL statements to:
    1. Insert at least five records in each of the tables. The test data inserted into the table must ensure that each of the queries, specified in Task 3, outputs at least one record.
  1. Task 3: Create a text file named Query_<StudentId>.sql that will contain all the queries to display the following
    1. List of names and complete postal address of all employees sorted by their salary.
    2. The date on which the most recent customer order has been The customer name and date of the order will be sufficient.
  • List of all the store names and their addresses, sorted in dictionary order of the store
  1. A list of all customers that have not placed an order Displaying customer number and name will be sufficient.
  2. A list containing the name of employees, which work as
  3. A list containing the total quantity on hand for each product (product number and description) regardless of
  • A list showing each product sold (picked) on or before May 20, Show product number, name and quantity sold, sorted by product number and then quantity sold.
  • A list of products (show product number, description and price) whose price is less than or equal to the average product
  1. Increase each employee’s salary by 5% and show the updated salary of all employees (name and salary).
  2. Show the pay information (employee name, hours paid, amount paid) of all employees in the most recent pay

Additional queries for 7003ICT students only:

  1. Make a list of all products of brand “Armani” and their price in ascending order of price. Show the product description and
  • A list of supervisors (employee id, name) and all of their subordinates (employee id, name).
  1. Task 4: Create a text file named Update_<StudentId>.sql that will perform the followings. Insert additional data in the tables appropriately if

A customer named Daniel Ortega, from 11 Fuller Road, Marsden QLD 4132 and having a mobile number 0431xxx668, orders two shirts of size “XL” of brand “Prada” on 6 Sep 2018. The full order is ready on 8 Sep 2018 for pickup, but the customer picks up on 10 Sep 2018. 

You should insert data into appropriate tables for the above order and make sure you update the data in the relevant tables after the order is picked up.

Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 2 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Database Management. Retrieved from https://myassignmenthelp.com/free-samples/7003ict-database-management/update-the-data.html.

My Assignment Help (2021) Database Management [Online]. Available from: https://myassignmenthelp.com/free-samples/7003ict-database-management/update-the-data.html
[Accessed 19 April 2021].

My Assignment Help. 'Database Management' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/7003ict-database-management/update-the-data.html> accessed 19 April 2021.

My Assignment Help. Database Management [Internet]. My Assignment Help. 2021 [cited 19 April 2021]. Available from: https://myassignmenthelp.com/free-samples/7003ict-database-management/update-the-data.html.


With time, MyAssignmenthelp.com has become one of the best college essay writing service. Our comprehensive coverage of essay topics coupled with logical synchronous paragraphs, sound grammar and punctuation, usage of recent facts and examples have helped many students score guaranteed As. Our services are quick and can satisfy any pressing deadline. Some of our most common essay services include college application essay, literature reviews, selecting essay research paper topics and more.

Latest Database Samples

ITECH3224 WWW Technology

Download : 0 | Page : 1

Answer: The database given was normalized to achieve a better database. Normalization of the database involved following the following steps; Ensuring no entity has any repeating groups to normalize the relations to 1NF. Ensuring all entities achieved as a result of normalization to 1NF have no partial dependencies thus normalizing them to 2NF. This involves making sure that an entity has only one candidate key that the other keys depend o...

Read More arrow

CSC72001 Database Systems

Download : 0 | Pages : 4

Answer:   The database should be able to store the details of all the courses in the system and each course in the system should be identified with a unique identity that would be helpful in distinguishing the different entries in the tables. The database should be able to store the details of all the students each data should be identified by a unique identification key. The database should be able to store the details of the enro...

Read More arrow

ENG4195 Systems Analysis And Design

Download : 0 | Pages : 6

Answer: Part 1: Use Case Realisation for the ‘Record New Tour’ Use Case 1.1 Analysis Class Diagram:  In the paradigm of software engineering, the class diagram is a part of UML that represents the static structure of an application. The class diagram, as the name suggests, represents the classes of the application. These classes has attributes and operations. The class diagram are mainly used for describing the element...

Read More arrow

ICT701 Relational Database Systems

Download : 0 | Pages : 2

Answer: Assumption: - A APPLIED_STAFF has many QUALIFICATION_DETAIL and a QUALIFICATION_DETAIL is related to many APPLIED_STAFF. Here many too many relationships occur. So I create a new table that is STAFF_QUALIFICATION. Here a staff has one or many STAFF_QUALIFICATION and each STAFF_QUALIFICATION is related to one and only one APPLIED_STAFF. A qualification is related to one or many STAFF_QUALIFICATION and each STAFF_QUALIFICATION is ...

Read More arrow

ARW350 Academic Research And Writing II

Download : 0 | Pages : 14

Answer: Introduction Racism and humiliation has been one of the biggest curses in the modern society. This has really become a widely spread problem in almost all the countries of the world. The children are not spared of it as well. The aim of the following essay will be develop an understanding of the impact of the racism and humiliation in the several schools of Canada. Canada has always been a multilingual country with great many people c...

Read More arrow
Next

Save Time & improve Grade

Just share requirement and get customized Solution.

watch
question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here

1,653,646

Orders

4.9/5

Overall Rating

5,121

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2632 Order Completed

100% Response Time

Albert Ambrosio

MSc in Nursing

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

154 Order Completed

97% Response Time

Harold Alderete

PhD in Economics

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1265 Order Completed

97% Response Time

James Cook

Masters in Management

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2279 Order Completed

97% Response Time

Zachary Perez

PhD in Computer Science and Information System

Washington, United States

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

It was perfect I don\'t have to get it redone really on point and very happy with it thanks so much. You guys are a lifesaver

flag

User Id: 205927 - 19 Apr 2021

Australia

student rating student rating student rating student rating student rating

Good work from them!! Great service!! They didn’t make me wait on my work I got it on time!!

flag

User Id: 669921 - 19 Apr 2021

Australia

student rating student rating student rating student rating student rating

a great work. to be honest i was\'t sure if the expert would get everything right, but it turned really well.

flag

User Id: 229166 - 19 Apr 2021

Australia

student rating student rating student rating student rating student rating

The work has been done properly, exactly as required. I\'m very happy with it. Thanks to the expert for such a masterpiece.

flag

User Id: 557066 - 19 Apr 2021

Australia

student rating student rating student rating student rating student rating

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?