Search results for 'DBM 502 wEEK 4 DATA WAREHOUSES BI Presentation'

Programming Logic and Design Eight Edition Chapter 10 Exercise 4 Automobile Class

Design a class named Automobile that holds the vehicle identification number, make, model, and color of an automobile. Include methods to set the values for each data field, and include a method that displays all the values for each field. Create the class diagram and write the pseudocode that defines the class.

Programming Logic and Design Eight Edition Chapter 4 Exercise 5 A

ShoppingBay is an online auction service that requires several reports. Data for each item up for auction includes ID number, item description, length of auction in days, and minimum required bid. Design for the following:

a. A program that accepts data for one auctioned item. Display data for an auction only if the minimum required bid is over $100.00.

Programming Logic and Design Eight Edition Chapter 9 Exercise 4

Create the logic for a program that accepts an annual salary as input. Pass the salary to a method that calculates the highest monthly housing payment the user can afford, assuming that the year's total payment is no more than 25 percent of the annual salary.

CMIS 102 Assignment 1 Usable Area of house
In this assignment, you will design a program to perform the following task:
Calculate the usable area in square feet of house. Assume that the house has a maximum of four rooms, and that each room is rectangular

1. Using a similar approach as example 2.3 (textbook page 75): "Finding the Sale Price of Items in a Department Store", provide your analysis for the following problem statement:
You need to write a program that will calculate the number of square feet (living space) in a 4-room house. Your analysis should be clearly written and demonstrate your thought process and steps used to analyze the problem. Be sure to include what is the required output? What is the necessary input and how you will obtain the required output from the given input? Also, include your variable names and definitions. Be sure to describe the necessary formulas and sample calculations that might be needed.

2. Using a similar approach as the example provided in section 2.2(textbook page 78) for "The Sale Price Program continued", provide your program design for the program you analyzed for calculating the number of square feet in a house. Be sure to describe the fundamental tasks needed to solve the problem so you can use a modular design. Provide pseudocode of your overall design that includes the Main module and the order of the module calls (see page 82 for an example). Finally, list all of your pseudocode for each module (See example 2.6 on page 83 as an example).
Include header and step comments in your pseudocode, using a similar approach as the example provided in section 2.3 (textbook page 86). See example 2.8 on pages 87-88).

3. Prepare at least 3 sets of input data (Test data) along with their expected output for testing your program. Your test data can be presented in the form of a table as follows (note: feel free to adapt to your design)

Chocolate Delights Candy Company Pseudocode Flowchart

Chocolate Delights Candy Company manufactures several types of candy. Design a flowchart, pseudocode, data dictionary and hierarchy chart for the following:
A program that accepts a candy name (for example, "chocolate-covered blueberries"), price per pound, and number of pounds sold in the average month, and displays the item's data only if it is a best-selling item. Best-selling items are those that sell more than 2000 pounds per month.

CMIS 102 Final Project Average age of your family and members living in Tennessee

Your final project will be to analyze, design, and document a simple program that utilizes a good design process and incorporates sequential, selection and repetitive programming statements as well as at least one function call and the use of at least one array. The specific problem you need to solve for the final project is:
Design a program that will allow a user to Input a list of your family members along with their age and state where they reside. Determine and print the average age of your family and print the names of anyone who lives in Tennessee.

There are 4 components of your submission including:
Program Description - A detailed, clear description of the program you are building.
Analysis - Demonstrates your thought process and steps used to analyze the problem. Be sure to include the required input and output and how you will obtain the required output from the given input? Also, include your variable names and definitions. Be sure to describe the necessary formulas and sample calculations that might be needed. Talk about the functions you plan to use and how you will use arrays. Be sure to talk about the types of programming statements that will be used on why.
Test plan - Prepare at least 3 sets of input data (Test data) along with their expected output for testing your program. Your test data can be presented in the form of a table as follows (note: feel free to adapt to your design)
Pseudocode - Provide pseudocode of your overall design that fulfills the requirements of the project

All of these components should be placed in word document for submission.

Additional details about the program you need to write:
Family sizes vary, however you should design to be able to enter at least 50 Family members.
Your test cases should have at least 5 family members.
Be sure to separate some functionality into functions or submodules. Having all functionality in the main module is not a good design.
Your design should consider how to indicate the family member entry is complete.
Carefully consider the best data type for each of your variables. (e.g. when to use Float versus Integers versus Strings)

Assignment 1 Fran’s Virtual Fruit Stand, Part 1

Fran’s Virtual Fruit Stand is an online store that sells several types of dried fruit. Based on the needs of Fran’s Virtual Fruit stand, you must design a flowchart using Visual Logic. The flowchart must also be a fully functional program which follows the design requirements below.

Note: This program does not require the use of arrays. The program will prompt for data on a single item, process that data, display any relevant messages as described below, and then move on to the next item. Use the “console” option in the output command to display the output in a single window. Displaying the output can be accomplished with as few as three (3) variables that simply get overwritten each time the loop repeats.

Using Visual Logic, design a flowchart that is also a fully functional program. According to your design, the program must:

Continually accept data regarding the purchase of fruit until a sentinel value is entered.

Prompt the user for each item, and accept the name of the fruit (e.g., “dried apples”), the price per pound, and the number of pounds sold in a month.

Display a clear message for items that are considered:

Best-selling items
Note: Best-selling items are identified as those that sell 5,000 or more pounds per month on average. For example, an acceptable message may read, “Yellow raisins are a best-selling item.”

Big-ticket items
Note: Big-ticket items are identified as those that are best-selling items and also cost $4 per pound or more. For example, an acceptable message may read, “Freeze-dried blueberries are a big-ticket item.”

High-priced items
Note:High-priced items are identified as those that sell for $7 per pound or more. For example, an acceptable message may read, “Dried mangos are a high-priced item.”

Lowest-selling items
Note: Lowest-selling items are identified as those that sell 500 pounds or less per month on average. For example, an acceptable message may read, “Dried Ugli Fruit is a lowest-selling item.”

High-income generating items
Note: High-income generating items are identified as those that generate $7,000 or more per month on average. To determine the income generated per item, multiply the price per pound by the number of pounds sold per month. If the item generates $7,000 or more per month, an acceptable message may read, “Dried pineapple chunks are a high-income generating item.”

Loop through all of the above steps until the user types the sentinel value when prompted. Display the sentinel value so that the user may ultimately be able to demonstrate an understanding of the way in which to end the program. Note: An acceptable message may read “Type n to end the program.”, where “n” is the sentinel value.

Your Visual Logic program must follow these formatting requirements:

Be accomplished in a single Visual Logic program.

Be submitted as a single file with the “.vls” file extension.

Be fully functional in order to receive full credit.

The specific course learning outcomes associated with this assignment are:
Demonstrate the use of algorithms and pseudocoding to the problem-solving process.
Distinguish among the basic types, steps, and properties of programming.
Apply the techniques of functional decomposition, modularization techniques, and debugging strategies into program design.
Describe the features and fundamental data structures of programming design.
Select and create the appropriate conditional and iteration constructs for a given programming task.

Assignment 2 Fran’s Virtual Fruit Stand, Part 2

Use the concepts and scenario from Assignment 1 to help Fran’s Virtual Fruit Stand increase the functionality of its online shopping cart. When a customer checks out, the shopping cart must store the required data pertaining to each item the customer is buying. Your job is to design a program that will prompt the user for the required data and then store it. The required data includes the item name, the price per pound, and the number of pounds of that item being purchased. When complete, your program should include three (3) arrays, two (2) loops, one (1) and / or conditional statement, and one (1) variable.

Using Visual Logic, design a flowchart that is also a fully functional program to add functionality to the online shopping cart. According to your design, the program must:

Continually accept data regarding the purchase of fruit as specified below until the user enters a sentinel value, or until five (5) items are entered, whichever comes first.
Prompt the user for each item and accept the name of the fruit (e.g., “dried apples”), the price per pound, and the number of pounds sold in a month.
Store the required data in three (3) arrays (e.g., one (1) for the item name, one (1) for the price per pound, and one (1) for the number of pounds being purchased) with corresponding index values. Note: For example, index value 3, when applied to the “itemName” array, would give us the name of the third item that the customer is buying. That same index value of 3, when applied to the “pricePerPound” array, would give us the price per pound of that same third item that the customer is buying.
Store up to five (5) values in each of the three (3) arrays.
Provide functionality in which the user ends the program by typing a sentinel value, and the program tells the user what the sentinel value is. Note: An acceptable message may read “Type n to end the program.”, where “n” is the sentinel value. If the user does not end the program in this way, then the program ends when it has collected the data for five (5) items.
Print an itemized receipt with the following data after the last item in the purchase has been saved to the array.
Item name
Price per pound of each item
Number of pounds purchased of each item
Subtotal price for each item, calculated as price per pound multiplied by the number of pounds
Total weight of the entire order (in pounds)
The cost of shipping which is based on the total weight of the entire order, calculated as 50 cents per pound. Note: For example, if the entire order weighs seven (7) pounds, the cost of shipping would be $3.50.
Grand total price of all items and shipping.

Note: Use the “console” option in the output command to accomplish this task. An example of an acceptable output has been provided below:

CMIS 102 Final Project Average age of your family

Your final project will be to analyze, design, and document a simple program that utilizes a good design process and incorporates sequential, selection and repetitive programming statements as well as at least one function call and the use of at least one array. The specific problem you need to solve for the final project is: Design a program that will allow a user to Input a list of your family members along with their age and state where they reside. Determine and print the average age of your family and print the names of anyone who live in Texas.

Final Project Deliverables:
There are two deliveries for this project. The first delivery is the project plan which provides your problem statements, problem analysis, and how it will comply with the project specifications. The project plan is worth 10% of your grade. The final delivery will be your completed project design along with your code comments and comprehensive test plan. The final delivery is worth 20% of your grade.

Your project plan is due in week 7 by midnight EST, on the specific date posted in the class schedule. The final delivery is due no later than the last day of class. Your instructor’s policy on late projects applies to this project.

Example Project Plan and Final Project template files, containing the required sections are included in the available resources. You should use this document to start your writing and fill in all of the details required.

Format:
Project plan format and length:
The documentation describing your analysis and test plan should be written using Microsoft Word. The font size should be 12 point. The page margins should be 1 inch. The paragraphs should be formatted with double line or single line spacing. Any figures, tables, equations should be neatly labeled. All references should use APA style.