Order from us for quality, customized work in due time of your choice.
Assignment Requirements
In a Microsoft Word document, research the library or in
Assignment Requirements
In a Microsoft Word document, research the library or internet to discuss the purpose of Data Manipulation Language (DML) with the use of table joins including the inner, left, right, and full joins. There also exist self joins and cross joins and coverage of these joins are optional but encouraged. The paper should be in the range of 500 words. When concluding your paper, lead these conclusions into your proposed and written out DML code for the task below.
Using Data Manipulation Language (DML):
Suggest and provide DML code to show a bikes product name based on its assocation to the brand Electra. This query will use the products and brands tables and should be sorted in ascending order by the product name.
Suggest and provide DML code that will show all bikes costing $500 or less. When thinking about this query, show the product name, brand name, and list price using the products and brands tables. Sort records by list price in ascending order.
Suggest and provide DML code that will show product name, category name, and list price greater than $5000.00. This query will use the products and categories tables. Sort the record output by product name.
Suggest and provide DML code that will show product name and order identification for the purpose to show only those products that do not have any sales. In this case, consider a left join to show all product names from the products table and then any matched records from the order items table. Then use the appropriate code to only show those products having no evidence of appearing on any sales reports. Also sort data output by order identification in ascending order.
Suggest and provide DML code that will show product name and order identification for the purpose to show only those products that have an order identification equal to 2. In this case, consider a right join to show all product names from the orders items table and then any matched records from the products table. Then use the appropriate code to only show those products appearing on sales reports having an order identification equal to 2.
Important Note: All proposed code for the retail store that sells bikes should be nicely prepared and presented in a Microsoft Word document holding your written paper on table joins and then submitted for grading and assessment.
REFERENCES
Title: Database systems: design, implementation, and Management
Author: Carlos Coronel, Steven Morris
ISBN-13: 9780357673034
Publisher: Cengage
Edition: Fourteenth
Adoption: Required
Order from us for quality, customized work in due time of your choice.