Search results for 'My'

Murach's MySQL My Guitar Shop Database Chapter 13

QUESTION  1
Write a script that creates and calls a stored procedure named test. This stored procedure should declare a variable and set it to the count of all products in the Products table. If the count is greater than or equal to 7, the stored procedure should display a message that says, “The number of products is greater than or equal to 7”. Otherwise, it should say, “The number of products is less than 7”.

QUESTION  2
Write a script that creates and calls a stored procedure named test. This stored procedure should use two variables to store (1) the count of all of the products in the Products table and (2) the average list price for those products. If the product count is greater than or equal to 7, the stored procedure should display a result set that displays the values of both variables. Otherwise, the procedure should display a result set that displays a message that says, “The number of products is less than 7”.

QUESTION  3
Write a script that creates and calls a stored procedure named test. This procedure should calculate the common factors between 10 and 20. To find a common factor, you can use the modulo operator (%) to check whether a number can be evenly divided into both numbers. Then, this procedure should display a string that displays the common factors like this:
Common factors of 10 and 20: 1 2 5

QUESTION  4
Write a script that creates and calls a stored procedure named test. This stored procedure should create a cursor for a result set that consists of the product_name and list_price columns for each product with a list price that’s greater than $700. The rows in this result set should be sorted in descending sequence by list price. Then, the procedure should display a string variable that includes the product_name and list price for each product so it looks something like this:
"Gibson SG","2517.00"|"Gibson Les Paul","1199.00"|
Here, each value is enclosed in double quotes ("), each column is separated by a comma (,) and each row is separated by a pipe character (|).

QUESTION  5
 Write a script that creates and calls a stored procedure named test. This procedure should attempt to insert a new category named “Guitars” into the Categories table. If the insert is successful, the procedure should display this message:
1 row was inserted.
If the update is unsuccessful, the procedure should display this message:
Row was not inserted - duplicate entry.

Student Database Design in Access

Using the student database designed from Chapter 2, create a simple Access Database with a minimum of 15 students, 4 classes each, 5 different instructors, in four different classroom buildings.

For example, Jennifer Smith has Math 101, Biology 201, Chemistry 100, and Speech 101. She has instructor Kelli Jones, Tom Tinker, Bryan Solider, Tiger Woods. Her building would include Silly Science, The Pond building, Mighty Duck, and Jimmy Carter. In your database design forms and queries.

MS Access Advanced: VBA code Week 6 assignment

You will be modifying the frmMainMenu to call the caption of each button from the table MainMenu and form or the report.
1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run.

2) Your code (for the button) will dynamically read the caption from the table and assign it to the button.
HINT: Variables (table name) in other areas of the code should not be "hard-coded". If for example a Table name changes in the database it should be reflected in the menu. I do not need to go into the code and look for all entries for the hard-coded name of the table. Dynamic caption means should the name of any table change – the caption on the button for that table must change as well. Test it out …

3) Your code (for the button) will dynamically read the form/report name and will run when you press the button.
HINT: Like the hint for #2 above do the same for the reports. No names should be hard-coded. This prevents errors in the long run which often break a program, and maintenance does not become a nightmare!! This approach is a widely utilized practice amongst professional developers in support of friendly user experience enhancements! Our users want to be able to press buttons that are logical, practical, and smart

**My professor said that this assignment has to use the "DLookup" element in VBA.**

CIS 373-30 SQL 1 EXERCISE
What to do:
Problem: ConstructionCo, pp. 278 – 282, Do problems 1 to 12 from page 278-280
You are given a partially correct Oracle script file: Ch07_ConstructCo_ORA.sql (posted in the same folder).  The script is incomplete because they did not define primary keys and foreign keys when creating the tables.  As shown in class (and also in my video capture), you will create your own script file based on this one by defining the primary keys and foreign keys (refer to the text book for the ERD).
To make it easier for you, I added several SQL Plus commands to redirect the output.  At the beginning of the Ch07_ConstructCo_ORA.sql ,  I added:

spool j:\scripts\SQL1.lst
set pagesize 24
set pause on
set linesize 60
and at the very end, I added:
Spool out

The Spool command will redirect the output, in my case, to the J: drive in the scripts folder and the file will be called SQL1.lst  (lst = listing, typical extension for output list).  Make sure you know the path name to redirect the output to.  I would recommend you to use the USB drive; make your path name shorter to avoid typos.  Please also noted that I set the pause ON. It means that you have to hit “Enter” to move to the next page.
How to do:
(1)    Start your Notepad, copy the necessary statements from Ch07_ConstructCo_ORA.sql  with the proper PKs and FKs, save it as  Ch07_SQL_1_Answers.sql.
(2)    Log in Oracle 11g XE
(3)    Start SQL Command Line (SQL Plus) program.
(4)    In SQL Plus, load and execute  Ch07_SQL_1_Answers.sql  (by using the start command in SQL Plus.)
(5)    To answer the questions, you can type your SQL statement directly in SQL Plus.  If it works, copy and paste the statement in your script file Ch07_SQL_1_Answers.sql.  Use comment, e.g. --, or /* …. */ to separate the questions.  The following is the skeleton of your script file:

spool j:\scripts\SQL1.lst
set pagesize 24
set pause on
set linesize 60

-- Name:  <Your Name>  SQL 1 Homework, pp. 278-280
--
<<<< Based on Ch07_SQL_1_Answers.sql, create the tables with proper PKs and FKs.  Copy all  INSERT statements to populate the tables.  Then you can start answering the questions.  Make sure you have created and populated  the tables correctly before moving forward.  Do it incrementally like I demonstrated in the videos. >>>>

-- Problem 1:
select name from student where student_ID = 1234;

--
-- Problem 2:
insert into Student Values (13567, “Doe”, “John”, “CIS”);
: : : : :

--  Problem 12:
UPDATE EMP_2
SET …….
WHERE EMP_HIREDATE ….
AND JOB_CODE >= ….. ;

Spool out

After you have finished all problems and created the script file, run the script file in its entirety one last time. When you are finished, submit both Ch07_SQL_1_Answers.sql and the output file SQL1.lst in Blackboard.

IT358 Unit 7 Synonyms Index and Sequence

Outcomes addressed in this activity:
Describe how the schema objects work
Describe how sequences and indexes are created, modified, and removed within Oracle
Describe when to use an Index
Utilize Synonyms

Project requirements:
In this project, you will create a view, synonym, and index:
1. Answer the Review Questions #1–5 from Chapter 6.
2. Complete Hands-on Assignments #1-10.

Oracle 11G SQL Chapter 6 Hands-On assignment Solution
1. Create a sequence to use for populating the Customer# column of the CUSTOMERS table. When setting the start and the increment values, keep in mind that data already exists in this table. The options should be set to not cycle the values, not cache any values, and no minimum or maximum values should be declared.
2. Add a new customer row using the sequence created in Question 1. The only data currently available for the customer is as follows: last name = Shoulders, first name = Frank, and zip = 23567.
3. Create a sequence that will generate integers starting with the value 5. Each value should be three less than the previous value generated.The lowest possible value should be 0, and the sequence should not be allowed to cycle. Name the sequence MY_FIRST_SEQ.
4. Issue a SELECT statement that will display NEXTVAL for MY_FIRST_SEQ three times. Because the value is not being placed in a table, use the DUAL table in the FROM clause of the SELECT statement. What causes the error on the last SELECT?
5. Change the setting of MY_FIRST_SEQ so the minimum value that can be generated is –1000.
6. Create a private synonym that will allow you to reference the MY_FIRST_SEQ object as NUMGEN.
7. Use a SELECT statement to view the CURRVAL of NUMGEN. Delete the NUMGEN synonym and MY_FIRST_SEQ.
8. Create a Bitmap index on the CUSTOMERS table to speed up queries that search for customers based on their state of residence. Verify that the index exists, and then delete the index.
9. Create a B-tree index on the customer’s Last Name column. Verify that the index exists by querying the data dictionary. Remove the index from the database.
10. Many queries search by the number of days to ship (number of days between the order and shipping dates). Create an appropriate index that might improve the performance of these queries.

CIS355A iLab 5 GuessGame and Text File I/O Java Programs

In this lab you will create a single program that creates and reads a sequential file. All outputs must be GUI-based without using JOptionPane.

Deliverables
Program files for each of the following two programs
1. GuessGame
2. Text File I/O

iLAB STEPS
STEP 1: GuessGame
Write a program named GuessGame.java that plays the game “guess the number” as follows: Your program chooses the number to be guessed by selecting an integer at random in the range 1–1000. The program then displays the following in a label.
I have a number between 1 and 1000 -- can you guess my number?
Please enter your guess: ____________________
A JTextField should be used to input the guess. A JButton must be provided to allow the user to press each time a guess is entered. As each guess is input, the background color should change to either red or blue. Red indicates that the user is getting warmer, and blue indicates that the user is getting colder. A JLabel should display either Too High or Too Low to help the user zero in on the correct answer. When the user gets the correct answer, Correct! should be displayed, and the JTextField used for input should be cleared and changed to be uneditable. Also, a JButton should be provided to allow the user to play the game again. When the New Game JButton is clicked, a new random number should be generated and the input JTextField changed to be editable. A JButton must be provided to allow the user to exit the application. Also provide a count of the number of guesses the user entered when the correct number is guessed.

STEP 2: Text File I/O (20 points)
Write a program called TextFileIO.java to create a file named numbers.dat. Then create an algorithm that writes all even numbered integers from 1 to 100, separated by a comma. After the file has been created, close and reopen the file and display the results to the screen. After the results have been displayed append the odd number integers from 1 to 100, separated by a comma to the end of the file. Reopen the file and display the results. The contents of the file should be the even numbers from 1 to 100 separated by a comma followed by the odd number from 1 to 100 separated by a comma. The output of this program would be something like the following
2,4,6,8,10,12,14,……,98,100
2,4,6,8,10,12,14,……,98,100,1,3,5,7,9,……..97,99

CMIS 141 Project 3 Stringed Musical Instrument Java Class and UML class diagram

This project focuses on demonstrating your understanding of classes and objects. Before attempting this project, be sure you have completed all of the reading assignments listed in the syllabus to date, participated in the weekly conferences, and thoroughly understand the examples throughout the chapters. The project requirements include:

1. Design and implement a stringed musical instrument class using the following guidelines:
a. Data fields for your instrument should include number of strings, an array of string names representing string names (e.g. E,A,D,G), and boolean fields to determine if the instrument is tuned, and if the instrument is currently playing. You are welcome to add additional data fields if you like.
b. A constructor method that set the tuned and currently playing fields to false.
c. Other methods 1) to tune the instrument, 2) to start the instrument playing, and 3) to stop the instrument from playing.
d. Other methods as you see fit (Add at least one unique method).

2. Create a UML class diagram using a diagram tool (e.g. PPT, Visio) of your choice. Prepare the diagrams and place them in a word document along with a brief description of each of your classes.

3. Create Java classes for your instruments. Be sure that your code matches your design specifications and some minimal functionality is included. For example, if you called the violin.play() method, you should at least print that the violin is playing. Similar functionality should be supplied when you stop playing, tune or call any of your methods. For example:

public void playviolin() {
System.out.println("The violin is now playing.");
}

4. Write the output from your Instrument class methods to a text file that a user entered from the command line arguments (e.g. java Mynamep3tst myfilename.txt). This allows your program to accept filenames from the user via a command line argument.

5. Finally, create a Java test class that simulates using your instrument class. In your test class be you should at a minimum: a) Construct 10 instances of your instrument, b) tune your instruments, c) Start playing your instrument, d) Call your unique method, and e) Stop playing your instruments. (Hint: Arrays and Loops will make your job easier and result in more efficient code!)

6. Your programs should compile and run without errors.

7. Be sure to test your program carefully. Provide a list of comprehensive test cases used to validate your application and include these test cases in your word document containing your UML diagrams and descriptions. Similar to Project 1, your test data can be shown in a table that includes input data, expected output, actual output and pass/fail results from the test.

Dreams Travel Agency Java GUI Both parts

Field of Dreams Travel Agency has begun offering travel packages to baseball fans wanting to attend major league baseball games. The company offers a package allowing a fan to attend games in four cities of his or her choice, including transportation by car, tickets, lodging, and food. Assume that the fan lives in the city hosting one of the 30 major league baseball teams. The fan will travel from his or her home to the city of one of the teams of his choice, then will proceed to the city of one of the other teams and so on until all teams have been visited. Then, the fan will return home. Create a Java program that will compute the minimum cost of the trip. Your cost will be the cost of transportation (fuel cost per gallon/ miles per gallon * number of miles between ballparks), cost of tickets, cost of lodging, and cost of food. Ask the user his home city, which cities he wants to visit, the price of fuel, the fuel economy of his vehicle, the cost of lodging per day and the cost of food per day.  Your program will compute the costs of all 24 possible routings and choose the minimum cost route. Mark up the minimum cost by 20% to arrive at the cost that will be quoted to the customer.
For this week, you need only to create the GUI using Java Swing and create the basic classes that will accept the inputs from the user. We will create the functionality of these classes in the second assignment.
We will discuss strategies for preparing this program in the first week of class and you can create the program in the second week of class. That is done and I have a program with no function so here is the second part: Expand the model classes you created in the first assignment. Implement the functionality that will use the inputs offered by the user and prepare a quote for the customer according to the requirements specified in the first assignment. Upon clicking a Quote button on the GUI, the program should post a dialog box with the quote. Upon clicking the Print Quote button, write the quote out to a text file. This program was built on NETBEANS

Game of Guessing Numbers Java Program

In a game of guessing numbers, one person says "I am thinking of a number between 1 and 100". The second person guesses "50". The first person says "No it is less". The second person guesses "20". The first person says "No it is greater". This continues until the second person guesses the number. Write a program that plays this game. The computer knows the number (a random number between 1 and 100). The user (the second person) is the guesser. At the end of the program, the computer must displays the number of guesses it took the user to guess the number.
The program must include:
A main class
A loop (for, while or do-while)
An if or if – else statement
Must accept input from the keyboard
Must have a prompting statement
A separate class with a constructor
At least one method that performs an operation required by the main program

HERE IS AN ALGORITHM, PLEASE MAKE IT AS SIMPLE AS YOU CAN AND STILL INCLUDE THE NECESSARY RULES.
• Prompt
• Generate a random number (1-100)
Computer = gen random # (1-100)
Do (input number (kb Reader)
Stop = false;
{
If (myNum = computeNum
Stop = true
{
(System.out.println(“You win!”);
}
Else
If (myNum>computeNum)
{
System.out.println(“Your number is too high);
}
Else
If (myNum<computeNum)
{
System.out.println(“Your number is too low”);
}
}