Search results for 'SELECT'

DAT/305 Week 3 Challenge Activities 3.6.1: Hash tables with modulo hash function

CHALLENGE ACTIVITY 1

A hash table with non-negative integer keys has a modulo hash function of key % 20.

Hash function index range: 0 to

Item 128 will go in bucket

CHALLENGE ACTIVITY 2

An ordinary array contains items with keys: 30, 22, 6, 34, 2, 10,13
A hash table has 15 buckets with hash function key % 15.
The hash table contains the same items as the array.

How many elements are checked when searching for each of the following items?

CHALLENGE ACTIVITY 3

An empty hash table hashTable has 5 buckets and a hash function of key % 5.
The following operations are performed in order.
Select which operations cause a collision.
Hashinsert(hash Table, 2)
Hashinsert(hashTable, 12)
Hashinsert(hashTable, 0)
Hashinsert(hashTable, 5)
Hashinsert(hash Table, 15)

DAT/380 Week 4 LAB 4.7 - Select number of movies grouped by year

The Movie table has the following columns:
ID - integer, primary key
Title - variable-length string
Genre - variable-length string
RatingCode - variable-length string
Year - integer

Write a SELECT statement to select the year and the total number of movies for that year.

Hint: Use the COUNT() function and GROUP BY clause

DAT/380 Week 4 LAB 4.6 - Select lesson schedule with inner join

The database has three tables for tracking horse-riding lessons:
Horse with columns:
ID - primary key
RegisteredName
Breed
Height
BirthDate

Student with columns:
ID - primary key
FirstName
LastName
Street
City
State
Zip
Phone
EmailAddress

LessonSchedule with columns:
HorseID - partial primary key, foreign key references Horse(ID)
StudentID - foreign key references Student(ID)
LessonDateTime - partial primary key

Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule.

Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs.

DAT/380 Week 3 LAB 3.16 - Select horses with logical operators

The Horse table has the following columns:
ID - integer, primary key
RegisteredName - variable-length string
Breed - variable-length string
Height - decimal number
BirthDate - date

Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.

DAT/380 Week 2 LAB 2.10 - Select employees and managers with inner join

The Employee table has the following columns:
ID - integer, primary key
FirstName - variable-length string
LastName - variable-length string
ManagerID - integer
Write a SELECT statement to show a list of all employees' first names and their managers' first names. List only employees that have a manager. Order the results by Employee first name. Use aliases to give the result columns distinctly different names, like "Employee" and "Manager".

Hint: Join the Employee table to itself using INNER JOIN.

DAT/380 Week 2 LAB 2.9 - Select movie ratings with left join

The Movie table has the following columns:
ID - integer, primary key
Title - variable-length string
Genre - variable-length string
RatingCode - variable-length string
Year - integer
The Rating table has the following columns:

Code - variable-length string, primary key
Description - variable-length string
Write a SELECT statement to select the Title, Year, and rating Description. Display all movies, whether or not a RatingCode is available.

Hint: Perform a LEFT JOIN on the Movie and Rating tables, matching the RatingCode and Code columns.

PRG/421 Week 5 Java 5.20 LAB: Descending selection sort with output during execution

Write a void method selectionSortDescendTrace() that takes an integer array, and sorts the array into descending order. The method should use nested loops and output the array after each iteration of the outer loop, thus outputting the array N-1 times (where N is the size). Complete the main() to read in a list of up to 10 positive integers (ending in -1) and then call the selectionSortDescendTrace() method.

If the input is:
20 10 30 40 -1

then the output is:
40 10 30 20
40 30 10 20
40 30 20 10

ITSD424 Unit 3 Famous Favorite Subs

Continuing from the last assignment.
Assignment Details

Part 1
Modify your Java application so that it is an easy-to-use GUI application where all of the interaction is performed on one screen. You will now take the individual components and translate them to a single interactive GUI interface using the following GUI components, container, the event listeners, and event subclasses to enhance your application as a more GUI-appropriate interface:
• GUI components
• Container
• Event listeners
• Event subclasses (at least 3–4 utilized)
o ActionEvent
o ItemEvent
o FocusEvent
o KeyEvent
o MouseEvent
o WindowEvent
• ActionPerformed Method

Part 2
For this assignment, you are being asked to make sure you are exception handling by verifying that all of the customer-entered information is valid before the order is submitted to ensure order accuracy.
The customer information that the customer must now enter that should be validated includes the following:
• Entered username (must fill in a name)
• Entered at least one sub to order
• Selected all three attributes for sub (such as bread type, sub type, and sub size)
• Entered delivery address that includes street, city, state, and zip code
• Entered telephone number xxx-xxx-xxxx
In this assignment, you are adding in error handling to make sure the customer is filling in all of the required information.
To accomplish this task, you will be utilizing the following Java classes:
• Methods in the character class and StringBuilder class to validate and manipulate characters in a string
• Try.. Catch for the exception handling of all input fields

ITSD424 Unit 1 Famous Favorite Subs

We are developing this application
1. User will choose from menu item
2. User will review ordered items
3. Each item will have a unit price
4. Order details will show unit price plus total price
5. Use will Press order button to place order

For this Unit
Assignment Description
At this point, you are ready to start developing Java code to ask questions on customer information and the sub sandwich that customers want to order. You are only concerned with the functionality to request and provide feedback on what the customer entered.
Your main focus is on defining your classes and abstract classes and utilizing the concept of inheritance and polymorphism for the final sub the customer orders. You will first prompt for the customer name and delivery address, like in this sample that prompts for the customer name:

Then, you will prompt for the beverage, sub bread, sub type, and sub size.
You should present a message echoing back all of the information that the customer entered, similar to the following example presenting the customer’s name with a message:

Make sure you prompt for the four attributes (beverage, bread, type, and size) that you will need to request from the customer to define for the final sub and beverage selection. Also, be sure to comment all of your code to demonstrate that you understand what the code is doing.