CIS 336 Lab Forum Week 7

$4.75

CIS 336 Lab Forum Week 7
This area is used to discuss the lab assignments and techniques. Please post any questions you have…

SKU: CIS 336 Lab Forum Week 7 Categories: , Tags: , , ,

Description

CIS 336 Lab Forum Week 7

CIS 336 Lab Forum Week 7

Discussions Week 7 All Students Posts 39 Pages 

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab.

Looking back on last week’s lab, some of the queries required you to join at least four tables. How would a view make it easier to retrieve this same information? What MySQL string function should you use to list the first three characters of a company’s EMP_LNAME values? Give an example, using a table named EMPLOYEE. Why is it a good idea to remove a view prior to recreating it? What is the purpose for the following MySQL statement? What is dynamic SQL and how does it differ from static SQL? Consider the data in any Human Resource database, if you had a “user front-end” (GUI) for this database, what would be some common types of information that you might want to display on one page? How would you do this with a view? Why/why not?…