Databases | SQL | Oracle | MS Access Answers

1. Financial application: compute commission
Modify your find the sales amount program (Refer to Question 5, Lab 04).
This time, you need to write a method that computes the commission. The header of the method is as follows:
public static double computeCommission (double salesAmount)
Write a test program that displays the following table:
Sales Amount Commission
-----------------------------
10000 900.0
15000 1500.0
20000 2100.0
25000 2700.0
30000 3300.0
35000 3900.0
40000 4500.0
45000 5100.0
50000 5700.0
55000 6300.0
60000 6900.0
65000 7500.0
70000 8100.0
75000 8700.0
80000 9300.0
85000 9900.0
90000 10500.0
95000 11100.0
100000 11700.0

how much do you charge for doing two projects?

i have question please in database i want to insert a column with a value and i need this value to repeated many times how it will be inserted?

Create a view named BOOK_INVENTORY. It consists of the branch number and the total number of books on hand for each branch. Use Units as the name of the count of books on hand. Group and order the rows by branch number. Use the view to retrieve the branch number and units for each branch having more than 25 books on hand.

What is the SQL statement to gather the info after the View is created?

Hello, I want to monitor many pages and collect their updates for several options permanently and script must collect these updates and import to website and update info on my site permanently. I found several programs which monitor websites and send updates to email or we can export them to a file from program. but they are windows programs. How is this possible? At all i want to create an automatic monitoring website with php language which collects information from manual monitoring websites and shows them on my website. I want my script does this job itself full.what should we do?

Use the CREATE table statement to create a table for each entity for Huffman Trucking’s fleet truck maintenance database.
Use the INSERT statement to populate the tables with realistic sample data, demonstrating each relationship in your entity relationship diagram. Include at least two entries for each table.
Use the SELECT statement to create the following queries:
1. Create a simple query for each table that returns all of the
columns and all of the rows for each table.
2. Write a query that displays each part that has been purchased by Huffman Trucking Company. For each part, also retrieve its parts catalog information from the parts catalog table and vendor information from the vendor table.
3. Write a query that displays all of the rows in the vehicle maintenance table. For each vehicle maintenance row, join the corresponding information from the maintenance descriptions table and vehicles table.
4. Write a query that displays each row in the maintenance work order table. For each row in the maintenance work order table, join the corresponding information from the maintenance description table.
5. Write a query that counts the number of maintenance work orders for each vehicle in the maintenance work order table. Display the vehicle column and the corresponding count of work orders for each vehicle.

How can we create a table with fields "phy", "chm" and "total" such that field "total" is always the sum of other two fields in MYSQL ?

3. Assume the following indexes exist:
• A hash index with no overflow on the primary key attributes, roomNo/hotelNo in Room;
• A clustering index on the foreign key attribute hotelNo in Room;
• A B+-tree index on the price attribute in Room;
• A secondary index on the attribute type in room

 nTuples (Room) = 10,000 bFactor(Room) = 200
 ntuples(Hotel) = 50 bFactor9Hotel) = 40
 nTuples(Booking) = 100,000 bFactor(Booking) = 60
 nDistincthotelNo(Room) = 50
 nDistinctType(Room) =10
 nDistinctprice(Room) = 500
 minprice (Room) = 200 maxprice(Room) = 50
 nLevelshotelNo(I) = 2
 nLevelsprice(I) = 2 nLFBlocksprice(I) = 50
Calculate the cardinality and minimum cost for each of the following selection operations
S1:  roomNo = 1  hotelNo =’H001’(Room)
S2: type’D’ (Room)
S3: hotelNo’H002’(Room)
S4: price > 100 (Room)
S5: type’S’  hotelNo = ‘H003’(Room)
S6: type’S’ price < 100 (Room)

join between two table with one too many relationship is faster or join between two table without relationship is faster

Build a working sample of Huffman Trucking’s fleet truck maintenance database.

Use the CREATE table statement to create a table for each entity for Huffman Trucking’s fleet truck maintenance database.

Use the INSERT statement to populate the tables with realistic sample data, demonstrating each relationship in your entity relationship diagram. Include at least two entries for each table.

Use the SELECT statement to create the following queries:

• Create a simple query for each table that returns all of the columns and all of the rows for each table.

• Write a query that displays each part that has been purchased by Huffman Trucking Company. For each part, also retrieve its parts catalog information from the parts catalog table and vendor information from the vendor table.

• Write a query that displays all of the rows in the vehicle maintenance table. For each vehicle maintenance row, join the corresponding information from the maintenance descriptions table and vehicles table.

• Write a query that displays each row in the maintenance work order table. For each row in the maintenance work order table, join the corresponding information from the maintenance description table.

• Write a query that counts the number of maintenance work orders for each vehicle in the maintenance work order table. Display the vehicle column and the corresponding count of work orders for each vehicle.

Use Reporting Services to design and create a report on the parts purchasing history for Huffman Trucking Company. The report should display all parts purchasing history including manufacturer and vendor information, parts catalog information, and associated parts inventory issues, and all parts inventory purchases.

Format the report to present to senior management at Huffman Trucking.