SIT772 - Database Design And Implementation & Report Writing - IT Assignment Help

Assignment Task -                 
 

Learning Outcomes

ULO 2: Explain the concept of data modeling and use Entity-Relationship (ER) models to represent data.

ULO 3: Design and implement relational database systems through the use of SQL.

Purpose 

This task requires students to apply their understanding and ability to use Relational Database Management  Systems (RDBMS) as well as use SQL in the modeling of the physical world.

Question 1: 

We provide you with an Oracle sample database which is based on a global fictitious company that sells computer hardware including storage, motherboard, RAM, video card, and CPU. 

The company maintains the product information such as name, description standard cost, list price, and product line. It also tracks the inventory information for all products including warehouses where products are available.  Because the company operates globally, it has warehouses in various locations around the world. 

The company records all customer information including name, address, and website. Each customer has at least one contact person with detailed information including name, email, and phone. The company also places a credit limit on each customer to limit the amount that customer can owe. 

Whenever a customer issues a purchase order, a sales order is created in the database with the pending status.  When the company ships the order, the order status becomes shipped. In case the customer cancels an order,  the order status becomes cancelled. In addition to the sales information, the employee data is recorded with some basic information such as name,  email, phone, job title, manager, and hire date. 

The following illustrates the sample database diagram: 

Task 1.1: 

Write the SQL query to list the region names and the number of warehouses within the regions, group by  countries.  

Task 1.2: 

Write the SQL query to find all customers who have made orders from specific Employee List must include  the customer ID, customer name, and ordered by their ID values in descending. 

Task 1.3:

Write the SQL query to list all employees who have the sequential letters ‘co’ in the employee name and in his manager name, List must include the employee’ ID, names, manager name and ordered by their names in descending.  

Task 1.4:

Write the SQL query to list all products’ ID, Name and price available in warehouse of countries start with “A”.  The list must be ordered by the product price. 

Task 1.5: 

Write the SQL query to list all the warehouses, their location and total sold price of each warehouse. Here, given  a product, the total sold price of the product is calculated by the sold quantity of the product and its unit price.  The list must be ordered by the total sold price in the ascending.  

Note: One product_ID may link to more than one warehouses in the provided data. You can ignore this and just  count the sale of the product to all its linked to the warehouse. 

Task 1.6: 

Write the SQL query to list the of the customer and the amount they spent on orders. The output list must include customer ID, name, and the amount they have spent. The list must be sorted by the amount in descending order. 

This SIT772 - IT Assignment has been solved by our IT Experts at My Uni Paper. 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.