Description Hierarchy Charts In this assignment, you will analyze a hierarchy chart and reason how they are structured. Download a hierarchy chart to learn more. Based on your observations, answer the following questions: For the given hierarchy chart, how would you modify the design to accommodate the process of a student cancelling a registration? How would you create a separate hierarchy chart to support the process of withdrawing from a class?
Description This assignment has two parts: Hands-on lab Course project Part I—Hands-on Lab For the hands-on lab, you will submit a Microsoft Access database and a Microsoft Word document with SQL statements for the following: Create a new Microsoft Access database named Travel. Note that Microsoft Access does not support the use of SQL scripts to create databases. In Microsoft Word, type the SQL script that you would have used to create the database. Now, add a table named Car_Rental to the Travel database. Make sure that you include the Car_Rental_ID field whose datatype is AutoNumber. In Microsoft Word, type the SQL script that you would have used to create the table. Include the following fields: Car_Rental_ID (AutoNumber, primary key, required) Agency (Text(25), required) Size (Text(25), required) Make (Text(12), required) Model (Text(25)) Daily_Cost (Currency) Write INSERT statements for adding the following data to the new table: Agency Size Make Model Daily_Cost Avis Mid Ford 89.95 Avis Full Ford Taurus 112.95 Hertz Comp Chev Cavalier 69.95 Hertz Mid Chev Malibu 84.99 Hertz Full Chev Impala 114.99 National Mid Chrys Stratus 77.95 National Full Chrys Intrepid 109.95 Verify the values inserted by using a query. Display each distinct agency (each agency only once). Display the average cost of a Chrysler rental. Display the total count of cars available. Display the highest-priced vehicle. Display each unique agency with the average car price for that agency. Part II—Course Project Course Project Part 4—Creating a Database Continuing with the project you worked on for Weeks 1, 2 and 3, this week, complete the following tasks: In Microsoft Access, create the database and tables that you identified in W3 Assignment 2. In Microsoft Word, write the SQL statements to create the database and tables. Write SQL statements to populate the tables. Run the SQL statements in Microsoft Access for populating the tables. Assignment Deliverable After you complete the lab and course project, collate the information from both in a 3- to 4-page report in a Microsoft Word document. Include the SQL scripts in the Microsoft Word document. Include the Travel database as a separate attachment. Submission Details Name your document SU_ITS3102_W4_A2_LastName_FirstInitial.doc. Name the Travel database SU_ITS3102_W4_A2_LastName_FirstInitial_Travel.accdb. Assignment 2 Grading Criteria Maximum Points Created a database named Travel and added a table named Car_Rental. Also added a column named Car_Rental_ID to the Car_Rental table and set its field type to AutoNumber. 5 Completed the INSERT statements for adding the given data to the Car_Rental table and verified the values inserted. 5 Wrote accurate SQL statements to: Display each distinct agency. Display the average cost of a Chrysler rental. Display the total count of cars available. Display the highest-priced vehicle. Display each unique agency with the average car price for that agency. 15
Description Activity 1: Monitor Parts This week, we will focus on identifying the parts of monitors. If you need more help see these resources: Watch How to pull apart a LCD monitor under 6mins Watch Taking Apart an Old Computer Monitor Activity 2: Troubleshooting Identify how to solve problems with monitors. Demonstrate what to do for each scenario. Problems: Screen, Icon, or Font Size Too Small or Too Big Blank Screen or No Video Fuzzy, Blurry, or Color Problems Brightness, Contrast, or Geometrical Problems
Description An application contains the Structure statement shown here. Structure MyFriend Public strName As String Public strBirthday As String End Structure Create a VB.Net Windows Form application named MyFriend_YourName. Change the name property of your form to frmMain. Add the MyFriend Structure to the public class frmMain. Create 2 text boxes txtName and txtBirthday, and a button with the name property changed to btnExecute and the text property changed to Execute. In the button click event, write a Dim statement that declares a five-element one-dimensional array of MyFriend variables. Name the array home. Then write an assignment statement that assigns the value in the txtName control to the strName member contained in the last array element. Write an assignment statement that assigns the value in the txtBirthday control to the strBirthday member contained in the last array element. Set a breakpoint next to you’re the Dim statement of your home array. See page 829 in your text for how to set breakpoints in VB.Net or search online. Run your form, add a name and date to the respective text boxes and click the Execute button. Execution should stop at the breakpoint. Use the Debug menu or shortcut keys to step through the code. All code should execute without error. Assignment Deliverables: The zip file containing the Visual Studio solution and project files.
Description Write a report on how to complete these tasks: Install a Sound Card Install a PC Video Camera Compare CD and DVD Technologies Install Dual Monitors in Windows 8 and 10 Activity 2: Supporting Printers and Scanners Install and Share a Printer; complete review questions. Then write a report on how to : Install a Network Printer Update Printer Drivers Install and Test a Scanner Printer Maintenance and Troubleshooting Activity 3: Installing a Printer Install a printer and at least one other peripheral device hardwired to the computer.
Description Your computer is running slow. Your have been advised to upgrade your memory. Search the internet to locate memory manufacturers or vendors. What memory type will you purchase to upgrade your computer and why? Are there any restrictions or restrict guidelines on the type of memory you can install to upgrade your memory? Provide the specification of the memory module or kit you are planning to purchase.
Description Demonstrate how to create 2 lines of code of comments with your Name and Date. What is the output produced by the following code? int result = 3 * 7 % 3 - 4 - 6; System.out.println("result is " + result); What is the meaning of the following line in a program? n1 = keyboard.nextInt(); What is the output produced by the following lines of program code? int quotient = 7 / 3; int remainder = 7 % 3; System.out.println("quotient = " + quotient); System.out.println("remainder = " + remainder); What is the output produced by the following lines of program code? char a, b; a = 'b'; System.out.println(a); b = 'c'; System.out.println(b); a = b; System.out.println(a); Which of the following may be used as variable names in Java? numberOfExecutions, file1, 1stDraft, myapp.java, short, TotalCount In your Words, explain what is a method? Is this an example of typecasting? i = (int) (10.3 * x) True False Complete the following code by completing the missing parts: import java.util.Scanner public class FirstProgram { public static void main(String[] args) { System.out.println("Hello out there."); System.out.println("I will add two numbers for you."); System.out.println("Enter two whole numbers on a line:"); int n1, n2; Scanner keyboard = new Scanner(System.in); n1 = keyboard.nextInt(); n2 = ______________; (1) System.out.print1n("The sum of those two numbers is"); System.out.print1n(_________); (2) } }
Description FIRST : Complete the Median challenge (Problem 4 on p. 568).PIC Attached ..... SECOND: Complete the World Series Champions challenge (Problem 8) on p. 627. Use the attached text files as the source.World Series Champions In the Chap9 folder of the student sample programs, you will find the following files: • Teams.txt—This file contains a list of several Major League baseball teams in alphabetical order. Each team listed in the file has won the World Series at least once. • WorldSeriesWinners.txt—This file contains a chronological list of the World Series’ winning teams from 1903 through 2012. (The first line in the file is the name of the team that won in 1903, and the last line is the name of the team that won in 2012. Note that the World Series was not played in 1904 or 1994.) Create an application that displays the contents of the Teams.txt file in a ListBox control. When the user selects a team in the ListBox, the application should display the number of times that team has won the World Series in the time period from 1903 through 2012. Teams.txt WorldSeriesWinners.txt
Description Program Development Please respond to ONE of the following discussion topics and submit them to the discussion forum as a single post. Your initial post should be 75-150 words in length. Then, make at least two thoughtful responses to your fellow students’ posts. If you haven’t recently, please review the Rules of Discussion. Question A Consider the various program development and design tools presented to you this week, which of these tools do you feel will be most beneficial and why? Discuss how you will use these development tools to develop a more robust program. Question B Consider the importance of program design in developing a program that interacts with the user. What considerations must you take into account regarding language, user instructions, visual cues and indicators, etc.