OverviewModule 2 Assignment 2 features designing the logic for a simple program using pseudocode and then writing the program in Python. Each lab asks you to write pseudocode that plans the program’s logic before you write the program in Python and to turn in three things: 1) the pseudocode, 2) a screenshot of the IDLE console’s results, and 3) the Python program.InstructionsPseudocode and Python Program Design RequirementsDesign the pseudocode and a Python program that asks customers for their name, where they want to go, how long they plan to stay, and calculate how much it will cost by multiplying the days by $100 per day. Confirm the information that the user provided.In a welcome message, tell the customer that she/he won a free vacation with airfare and hotel expenses paid.Ask for the customer’s name.Ask the user “where do you want to go for vacation? Display the location on screen.How many days will he or she spend on vacation, 4 or 7 days?Calculate the cost by multiplying the number of days by 100.Display the total expenses for food and entertainment.Module 2 Assignment 2: Post Your Pseudocode & Python Program:Write your pseudocode using English-like program statements. Save it as a Word .docx file or .rtf file.Create a New File in IDLE and Save the file with your initials. [example for someone with the initials cc: M2Lab2cc.py]At the top of your program, add a comment using the # sign, add your name and the assignment M2Lab2.Write your program following the steps in the Instructions.Save your new Python program, run it and test it.Tip: If you see the # of days repeat 100 times, you are multiplying a string. Look up how to input an integer for the # of days.Take a screenshot of your program output in the Python console window [Alt Key + PrntScreen].Right click and Paste the screenshot into the same Word document with your pseudocode. Upload to M2 Assignment 2 Pseudocode & Python Assignment Submission Folder. Output screenshot with your pseudocodePython program See the Schedule in the Syllabus Module for due dates. Review the Rubric attached to the Assignment Submission Folder for grading information.

Download, unzip, and attach the sample database ITCO630_A from the link below. The sample database represents an educational institution with students and different schools. Each student goes to just one school. The students have various roles in different assignments and may work on more than one assignment at a time.Download the database for this assignment.The following are the tables and data in the ITCO630_A database:Using the sample database, write the scripts in a file called ITCO630_P3.SQL to create the following views. Remember to include a USES clause at the top of the script file to use the ITCO630_A database. Also include code that checks if the view already exists. If it does, it should be dropped and recreated.Create a view named v_worker showing the student number, assignment number, and start date where the role is "worker."Create a view called v_no_points with all the columns of the assignment table except the points column.Create a view called v_count that shows the number of students working on each assignment. The view should have columns for the assignment number and the count.

Using the project you started in Week 2 Individual Project, verify the business logic layer (middle tier) is working correctly and make the connection to the database, implementing the logic in the data layer provided to manipulate the data stored in the database portion of the n-tier system.Assignment GuidelinesAdd the following to the Phase 2 individual project:Add a new Windows Communication Foundation (WCF) service library project to the Phase 2 individual project to communicate with the Data Access tier.Add the necessary queries and methods to the table adapters that will return, add, edit, and delete the data from the tables specified in Phase 2.Add references in the Data Service to the Data tier and Data Access tier projects.Add methods to the Data Service class created in Step 1 that will call into the Data Access tier.Make sure that separate tiers are created for each layer by verifying that separate class libraries were created and the necessary references to the project were added.