{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

W11MGT475Program5(1) - H Klein MGT475 Winter 2011 MGT475...

Info icon This preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
H. Klein MGT475 Winter 2011 MGT475 Program 5 (Z iii _P5_City) Produce the output shown below using SELECTs as discussed in class and the commands you have read about in the text. In particular you will have to make use of string commands described in Chapter 5 and logical expressions and flow control commands described in Chapter 10. You should not use VIEWS, but SELECTs exclusively. You should copy Z475F_City and Z475F_State to your own versions of these tables (Ziii_P5City and Ziii_P5State) to try out your program. Make sure you activate them after copying them. You will have to add some data to these tables so that you can test your program to see if it works. Only add a small amount of data to test your program. It does not have to be real, but should test the conditions in your program. I will make it possible to test using real data in the future. But first, add data to test your program to make sure it works. We will discuss this in class. In addition, I want you to predict your results using the Predicted Results Template provided on Blackboard. You should upload your predicted results to Blackboard by the due date. You will be graded on achieving the correct output under the constraints described above (60 of 100 points), having created predicted results using the template (15%) and having written an elegant program (25 out of 100 points; see the guidelines on this posted on Blackboard).
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern