{"id":435993,"date":"2018-06-28T12:25:22","date_gmt":"2018-06-28T12:25:22","guid":{"rendered":"https:\/\/essaypaper.org\/?p=29909"},"modified":"2018-10-24T08:55:57","modified_gmt":"2018-10-24T08:55:57","slug":"computer-science-sales-order-database","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/computer-science-sales-order-database\/","title":{"rendered":"Computer Science-Sales Order Database"},"content":{"rendered":"<h2>Sales Order Database<\/h2>\n<div class=\"container\">\n<section class=\"contentWide\">\n<div class=\"content baseWidthCenter\">\n<section class=\"orderContent\">\n<div class=\"panel panel-default orderForm\">\n<div class=\"panel-body\">\n<form class=\"form-horizontal\">\n<div class=\"row\">\n<div class=\"col-lg-10 col-md-9 col-sm-16\">\n<p>Project 1 Instructions<br \/>\nYou need the salesordersexample database accompanied with the textbook to complete this project&#8230;.attached.. If you have not installed the database in MySQL, please refer to the \u201cIII. Structured Query Language (SQL) Software Step-by-Step Preparation\u201d instructions on eCollege to set up the database&#8230;..attached.<br \/>\n1. Use the customers table inside of the salesordersexample database, and write a query statement to show all data records of the customers table.<br \/>\n2. Use the customers table inside of the salesordersexample database, and write a query statement to show data records from the CustFirstName, CustLastName, and CustCity columns.<br \/>\n3. Use the employees table inside of the salesordersexample database, and write a query statement to show the employee\u2019s EmployeeID, EmpFirstName, EmpLastName, and EmpPhoneNumber, if she\u2019s living in the area with 98413 as the zip code.<br \/>\n4. Use the employees table inside of the salesordersexample database, and write a query statement to show each employee\u2019s EmployeeID, EmpFirstName, and EmpLastName. Also, in the report, create a new column called EmpAge, in which you use a date expression to calculate and show the employee\u2019s age today.<\/p>\n<p>Please save the query statements for questions above into a Word document. Also, get a screen capture of the data report after you execute each query in MySQL, and save the screen captures into the Word document as well. Please name the Word document as \u201cMyProject1\u201d.<\/p>\n<p>Note: pages may be more due to the screen captures.<\/p>\n<\/div>\n<\/div>\n<\/form>\n<\/div>\n<\/div>\n<\/section>\n<div class=\"clearfix\"><\/div>\n<\/div>\n<\/section>\n<\/div>\n<footer class=\"footerWide\">\n<div class=\"footer baseWidthCenter\"><\/div>\n<\/footer>\n","protected":false},"excerpt":{"rendered":"<p>Sales Order Database Project 1 Instructions You need the salesordersexample database accompanied with the textbook to complete this project&#8230;.attached.. If you have not installed the database in MySQL, please refer to the \u201cIII. Structured Query Language (SQL) Software Step-by-Step Preparation\u201d <a href=\"https:\/\/www.benedictsol.com\/blogs\/computer-science-sales-order-database\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-435993","post","type-post","status-publish","format-standard","hentry","category-essay-paper-writing"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/435993","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=435993"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/435993\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=435993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=435993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=435993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}