ECO 372 Week 3 Assignment Aggregate Demand and Supply Models

Search for more tutorials here – http://homework-tutorials.com/product/eco-372-week-3-assignment-aggregate-demand-and-supply-models/

For this assignment, you will choose from the following options:
Option 1: Economic Advisement Paper
Option 2: Economic Critique
Read the instructions in the University of Phoenix Material: Aggregate Demand and Supply Models located on the student website and select one option to complete the assignment.
Write an APA formatted 700- to 1,500-word paper summarizing the results.  All borrowed material must be cited.  Use of graphs, analytical tables and other statistics is encouraged.

Make sure that you take your own notes, as your friends may not have the information you need. You might think it is okay to use notes from another student, but you can not be sure they are as diligent as you. This can leave you with only half the lecture to study from.

DBM 405 Lab 3: Procedures and Functions

To get this material copy and paste link to browser – http://homework-tutorials.com/product/dbm-405-lab-3-procedures-and-functions/

DBM 405 Lab 3: Procedures and Functions
Step 1: Creating the First Procedure
Your first procedure is to be named MOVIE_RENTAL_SP and is going to provide functionality to process movie rentals. Based on data that will represent the movie ID, member ID, and payment method your procedure will need to generate a rental ID and then insert a new row of data into the mm_rental table. The process will also need to update the quantity column in the mm_movie table to reflect that there is one less copy of the rented movie in stock. Along with the processing, you will also need to define some user-defined exception handlers that will be used in validating the input data. Since you may need to recreate your procedure several times during the debugging process, it is suggested that you use the CREATE OR REPLACE syntax at the beginning of the CREATE statement.
The following steps will help you in setting up your code.
1.  You will need to define three parameters, one each for movie ID, member ID, and payment method. Make sure that each one matches the data type of the associated column in the database tables.
2.  You will have several other variables that will need to be identified and defined. It might be easier to read through the rest of the specs before you start trying to define these (look for hints in the specifications).
3.  You will need to define four user-defined exceptions; one for unknown movies, one for unknown member, one for unknown payment method, and one for if a movie is unavailable.
4.  You will need to validate each of the three pieces of data passed to the procedure. One easy way to do this might be to use a SELECT statement with the COUNT function to return a value into a variable based on a match in the database table against the piece of data that you are validating. If the query returns a zero then there is no match and the data is invalid; any value greater than zero means a match was found and thus the data is valid. You will need the following validations.
1.  Validate the movie ID to make sure it is valid. If not then raise the unknown movie exception.
2.  Validate the member ID to make sure one exists for that ID. If not then raise the unknown member exception.
3.  Validate the payment method to make sure it exists. If not then raise the unknown payment method exception.
4.  Check the movie quantity to make sure that there is a movie to be rented for the movie ID. If not then raise the unavailable movie exception.
5.  If all the data passes validation then you will need to create a new rental ID. This process should be in a nested block with its own EXCEPTION section to catch a NO_DATA_FOUND exception if one should happen. You can generate a new rental ID by finding the largest rental ID value in the mm_rental table (Hint: MAX function) and then increasing that value by one. The NO_DATA_FOUND exception would only be raised if there were no rental IDs in the table.
6.  Now you are ready to insert a new row of data into the mm_rental table. Use the SYSDATE function for the checkout date and NULL for the check-in date.
7.  Now, update the mm_movie table to reflect one less movie for the associated movie ID.
8.  Finally, you will need to set up an EXCEPTION section for all of your exception handling. For each exception output, you want to state what the problem is, the invalid data value, and a note that the rental cannot proceed. For example, for an invalid movie ID number, you might say, “There is no movie with id: 13 – Cannot proceed with rental”. You also want to include a WHEN OTHERS exception handler.
Compile and check your code. If you get a PROCEDURE CREATED WITH COMPILATION ERRORS message then type in SHOW ERRORS and look in your code for the line noted in the error messages (be sure to compile your code with the session command SET ECHO ON). Once you have a clean compile then your are ready to test.
Step 2: Testing the First Procedure
You will need to test for scenarios that will allow both a clean movie rental and test each exception. This means that you will need to run at least five test cases. One each for the following:
1.  No movie for the ID supplied (use 13, 10, and 2 for the parameters).
2.  No member for the ID supplied (use 10, 20, and 2 for the parameters).
3.  No payment method for the ID supplied (use 10, 10, and 7 for the parameters).
4.  A successful rental (use 5, 10, and 2 for the parameters).
5.  No movie available for the ID supplied (use 5, 11, and 2 for the parameters). Since there is only one movie available for ID 5, you will get this exception.
Your output from the testing should look similar to (this would be the output for the first test above):
exec movie_rent_sp(13, 10, 2);
Output:
There is no movie with id: 13 
Cannot proceed with rental 
PL/SQL procedure successfully completed.
Be sure that when you have verified that everything works, you run your testing in a spools session and save the file to be turned in.
Step 3: Creating the Second Procedure
Your second procedure should be named MOVIE_RETURN_SP and should facilitate the process of checking a movie rental back in. For this procedure, you will only need to pass one piece of data to the procedure; the rental ID. You will need two user-defined exceptions; one for no rental record and one for already returned. You will be able to use several of the same techniques you used in the first procedure for your validation.
The following steps will help in setting up your code.
You will need to define only one parameter for the rental ID number. Make sure that it matches the data type of the associated column in the database table.

You will have several other variables that will need to be identified and defined. It might be easier to read through the rest of the specs before you start trying to define these (look for hints in the specifications).

You will need to define the two user-defined exceptions mentioned above.

You will need to validate the rental ID that is passed to the procedure. If it is not a valid one then raise the associated exception.

If it is valid then get the movie ID and check-in date from the mm_rental table.

Now, check the check-in date to make sure that it is NULL. If it is not then raise the associated exception.

If everything checks out then update the mm_rental table for the rental ID you have and use the SYSDATE function for the check-in date.

Now, you can update the quantity in the mm_movie table for the associated movie ID to reflect that the movie is back in stock.

Last, set up your exception section using appropriate error message text and data.
Compile and check your code. If you get a PROCEDURE CREATED WITH COMPILATION ERRORS message then type in SHOW ERRORS and look in your code for the line noted in the error messages (be sure to compile your code with the session command SET ECHO ON). Once you have a clean compile then your are ready to test.
Step 4: Testing the Second Procedure
You will need to test for scenarios that will allow both a clean rental return and test each exception. This means that you will need to run at least three test cases. One each for the following:
No rental for the ID supplied (use 20 for the parameter).

A successful rental return (use 1 for the parameter).

Try to return the same rental in Step 2.
You output from the testing should look similar to (this would be the output for the first test above):
exec movie_return_sp(20);
Output:
There is no rental record with id: 20 
Cannot proceed with return 
PL/SQL procedure successfully completed.
Be sure that when you have verified that everything works, you run your testing in a spools session and save the file to be turned in.
Step 5: Creating the Function
Your function should be named MOVIE_STOCK_SF and will be used to return a message telling the user whether a movie title is available or not based on the movie ID passed to the function. The exception handling that will be needed is for NO_DATA_FOUND but we are going to set it up as a RA

Become a morning person. There is a lot of socializing in college, and if you are serious about your studying, that socializing can make it tough to concentrate in your dorm at night. Instead, try getting up bright and early before everyone else so that you can study in peace.

ASHFORD ANT 101 Week 4 DQ 1 Monumental Architecture

Follow the link Now for full guide – http://homework-tutorials.com/product/ashford-ant-101-week-4-dq-1-monumental-architecture/

Monumental Architecture. What does monumental architecture imply about the cultural values and the socio-economic-political organization of the society that created it?
Do a bit of Internet research on religious or secular monuments, statues, and architectural wonders in your city, state, country, or internationally. Choose a monument (or set of monuments), describe its main features, discuss any symbolism it has, and analyze the messages it sends to its intended audience(s). Provide a link to an image of the monument itself for the rest of us to see.
Bring in what you have read on leadership and political and religious organization in band, tribes, and states up to now in developing your answer. Build on the ideas and terminology in the text and your own ideas to support your claims. Your initial response should be at least 150 words in length. Respond to at least two of your classmates’ posts by Day 7.

When you are creating your schedule of classes, try not to pack too many classes into one semester. Too many classes can overwhelm you and create stress. It is easy to burn yourself out and not do well at any of them. Take one or two classes that you consider hard and then a few that are easier.

CIS363B Week 5 iLab 5

To download more course tutorials visit – http://homework-tutorials.com/product/cis363b-week-5-ilab-5/

CIS363B Week 5 iLab 5 

Now that you’ve read this battery of tips, you should be less fearful of attending college. As you can see, anyone can successfully graduate with the right tools and the right planning. You can use these tips to do your best in college. With hard work and dedication, your future is bright.