IT 206 Week 6 Assignment Microsoft Access Exercise
December 24, 2015 | By 9ECDE559E8C |
For more course tutorials visit www.uophelp.com 1. Assignment: MS Access® Exercise – Due Day 7 • Complete the following tasks using Microsoft® Access®: o Create a database consisting of two tables. o Name both tables. o Create fields for each table. The first table must contain the following fields: • Student ID number
More from 9ECDE559E8C
For more course tutorials visit www.uophelp.com • Consolidate all the sections of the Currency Conversion development documentation: menu selection, requirements, design, and testing. • Incorporate any changes recommended by the instructor. • Post the assignment as an attachment.
For more course tutorials visit www.uophelp.com • Drawing upon your knowledge of software development, which process—requirements, design, coding, or testing—do you think has more impact on the overall success and quality of development? Explain your answer.
For more course tutorials visit www.uophelp.com 1. CheckPoint: Object-Oriented Data and Processes • Identify a task you perform regularly, such as cooking, mowing the lawn, or driving a car. • Write a short, structured design (pseudocode only) that accomplishes this task. • Think about this task in an object-oriented way, and identify the objects involved in the task. • Identify how you can encapsulate the data and processes you identified into an object-oriented design. • Describe the architectural differences between the object-oriented and structured designs. Which of the designs makes more sense to you? Why?
For more course tutorials visit www.uophelp.com 1. CheckPoint: Interfaces and Communication Messages Understanding object-oriented methodologies is often difficult. You already understand that object-oriented analysis and design emulates the way human beings tend to think and conceptualize problems in the everyday world. With a little practice, object-oriented programming will become second nature to you. As an example, consider a typical house in which there are several bedrooms, a kitchen, and a laundry room—each with a distinct function. You sleep in the bedroom, you wash clothes in the laundry room, and you cook in the kitchen. Each room encapsulates all the items needed to complete the necessary tasks. You do not have an oven in the laundry room or a washing machine in the kitchen. However, when you do the laundry, you do not just add clothes to the washer and wait in the laundry room; once the machine has started, you may go into the kitchen and start cooking dinner. But how do you know when to go back to check the laundry? When the washer buzzer sounds, a message is sent to alert you to go back into the laundry room to put in a new load. While you are folding clothes in the laundry room, the oven timer may ring to inform you that the meat loaf is done.
For more course tutorials visit www.uophelp.com 1. Assignment: Object-Oriented Design • Generate an object-oriented design for a system that keeps tracks of your CD and DVD collection. • Identify each of the classes, associated data, and operations for the classes. • Generate the pseudocode for each of the classes as demonstrated on p. 251. • Draw a GUI that will create the objects and provide access to each object’s processing methods. Note.Use the drawing tool in Microsoft®Word or in any other applicable drawing tool to complete this part of the assignment.
For more course tutorials visit www.uophelp.com 1. Exercise: Peer Reviews of Currency Conversion Test Procedure • Perform peer reviews of two classmates’ Currency Conversion Test Procedures, which your instructor will place in your Individual forum on Day 1. • Complete the Appendix K form for each of the peer reviews. • Post the completed Appendix K forms in your Individual forum as an attachment.
For more course tutorials visit www.uophelp.com • Under what circumstances would you use a sequential file over a database? Describe these circumstances. When would a database be more beneficial than a sequential file? Is it possible for the two types of permanent storage to be used interchangeably? Explain your answers. • What are some of the key differences between a flat file and relational database? Which of the two storage methods do you think is most useful in a real-world application?
For more course tutorials visit www.uophelp.com 1. CheckPoint: Chapter 5 Programming Problems • Complete Programming Problems 1 and 2. • Provide the analysis and pseudocode only (no diagrams are required).
For more course tutorials visit www.uophelp.com 1. CheckPoint: Algorithm Verification • Answer the following questions about the information in Appendix J: o What will be printed if the input is 0? o What will be printed if the input is 100?
For more course tutorials visit www.uophelp.com 1. Assignment: Currency Conversion Test Procedure • Generate a set of test inputs and expected results for the Currency Conversion program. • Post the test procedure as an attachment.
For more course tutorials visit www.uophelp.com • Identify at least two data structures that are used to organize a typical file cabinet. Why do you feel it is necessary to emulate these types of data structures in a computer program? For what kind of work project would you want to use this type of program? • Describe a programming project or situation in the workplace that would lend itself to array usage.
For more course tutorials visit www.uophelp.com 1. CheckPoint: Simple Array Process • Complete Ch. 6, Exercise 3, on p. 198. You are required to generate only the pseudocode, as described in the Week Two CheckPoint. No charting is required, but you may have to incorporate the bubble sort algorithm on pp. 172–174 to determine the number of salaries above and below the mean.
For more course tutorials visit www.uophelp.com 1. CheckPoint: Iteration Control Structure • Design a program that models the worm’s behavior in the following scenario: A worm is moving toward an apple. Each time it moves, the worm cuts the distance between itself and the apple by its own body length until the worm is close enough to
For more course tutorials visit www.uophelp.com 1. Assignment: Currency Conversion Design • Complete the hierarchy chart in Appendix H and the flowcharts in Appendix I, based on the Currency Conversion requirements and Input-Process-Output table you generated in Week Two. • Develop the pseudocode for the program design. • Post the assignment as an attachment.
For more course tutorials visit www.uophelp.com • Review the definition of control structure on p. 45 in Extended Prelude to Programming: Concepts and Design (2nded.). Then, think about the pseudocode algorithm you would write for a simple task, such as making a peanut butter sandwich, for example, as well as three simple control structures that could be used to create this algorithm. What do you think is the most difficult part of creating the algorithm? What can you do to make this process easier? • How do you use the three basic control structures—sequential, repetition, and selection—in your everyday problem solving? Do you think there are any other control structures that would make your problem-solving skills more efficient? If so, describe them.
For more course tutorials visit www.uophelp.com 1. CheckPoint: Sequential and Selection Processing Control Structure • Read the following scenario: You are an accountant setting up a payroll system for a small firm. Each line of the table in Appendix G indicates an employee’s salary range and corresponding base tax amount and tax percentage. Given a salary amount, the tax is calculated by adding the base tax for that salary range and the product of percentage of excess and the amount of salary over the minimum salary for that range. • Design a program that solves this problem. • Generate a set of input test values. • Perform a design walkthrough to verify your design.