In a Microsoft Word document, research the library or internet to discuss the purpose of Data Manipulation
Question:
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.
Modern Systems Analysis And Design
ISBN: 9781292351629
9th Global Edition
Authors: Joe Valacich, Joey George