Computer Science

Solution Library


Efficient Evaluation Plan for a Query and Estimation of its Cost in Pages

Question Consider relation Executives(ename, title, dname, address), where all attributes have the same length and ename is a candidate key. The relation contains 12; 000 pages and the buffer has 10 pages. Assume that 10% tuples satisfy the following query. Select E.title, Count(*) From Executi ... Read More

Reads ( 127 )
Price: Original Price: $9.00 Now at: $3.00     Add to Cart

Drawing Initial and Optimized Data Tree

Question Consider the database schema emp(eid, did, sal, hobby) dept(did, dname, floor, phone) finance(did, budget, sales, expenses) and the following query. Select D.dname, F.budget From emp E, dept D, finance F Where E.did=D.did and D.did=F.did and D.floor=1 and E.sal>=49000 and E.hobb ... Read More

Reads ( 131 )
Price: Original Price: $13.00 Now at: $6.00     Add to Cart

Join Algorithm, Initial and Optimized Query Tree

Question Consider the following two scenarios in a k-way merge sort of a file. _ The file has 20,000 pages and the buffer has 7 available frames. _ The file has 2,000,000 pages and buffer has 15 available frames. For each of the above scenario, answer the following questions assuming the bes ... Read More

Reads ( 111 )
Price: Original Price: $22.00 Now at: $14.00     Add to Cart

Program for Calculating Weighted Average

Question Write a program to calculate a weighted average for a course. Your input form should allow the user to enter their name, and the appropriate grades. Style your input form into three columns. CALCULATIONS: Exams are worth 80%, participation is worth 5%, and homeworks are 15% Summary This ... Read More

Reads ( 119 )
Price: Original Price: $9.00 Now at: $4.00     Add to Cart

Converting C Program to MIPS Assembly Procedure

Question Convert the following C function to the corresponding MIPS assembly procedure:    int count(int Model[], Color[], Year[], int n, int x,y,z) {   int res = 0;                      ... Read More

Reads ( 123 )
Price: Original Price: $6.00 Now at: $3.00     Add to Cart

MIPS Assembly for a Car-Finding System

Question Write a MIPS assembly program that will make use of the function count above as follows:   Let’s assume you are asked to code a car-finding system for a local parking lot:  You are provided with the location of all the cars in the parking lot. The information is give ... Read More

Reads ( 117 )
Price: Original Price: $10.00 Now at: $5.00     Add to Cart

Information Security Tool to Countermeasure Against Security Threats

Question Identify an information security tool that you are interested in based on your hands-on experience and learning from this class or research, such as a vulnerability scanning and assessment tool, a firewall product, a network monitoring or analyzing tool, a penetration testing tool, or an i ... Read More

Reads ( 124 )
Price: Original Price: $45.00 Now at: $33.00     Add to Cart

Programming to Solve Einstein Riddle

Question Write a program to solve the classic “Einstein Riddle”. You can use Java, Python, R, C/C++. Einstein’s Riddle This classic riddle is claimed to have been written by Einstein but it is sometimes also attributed to Lewis Carrol, although there's no evi ... Read More

Reads ( 226 )
Price: Original Price: $13.00 Now at: $8.00     Add to Cart

IT Topology Solution

Question: Essay on Topology - What is Topology and Different Types of topology? Solution: Table of Contents 1.Introduction 2. Bus topology 2.1 Bus topology Functionality2.2. Advantages 2.3. Disadvantages 3. Ring Topology 3.1. Advantages 3.2. Disadvantages 4. St ... Read More

Reads ( 321 )
Price: Original Price: $9.00 Now at: $0.00     Add to Cart

Tracking the Progress of a Program During Execution-Multiple Choice Question

Question Which of the following tracks the progress of a program during execution? A) Process management B) Memory management C) Multi programming D) Time sharing E) CPU scheduling     ... Read More

Reads ( 471 )
Price: Original Price: $2.00 Now at: $1.00     Add to Cart

Technique for Keeping More than One Process in Memory at the Same Time-Multiple Choice Question

Question Which of the following is a technique for keeping more than one process in memory at the same time? A) Process management B) Memory management C) Multi programming D) Time sharing E) CPU scheduling     ... Read More

Reads ( 416 )
Price: Original Price: $2.00 Now at: $1.00     Add to Cart

Functions that Shares the CPU Timing Among Multiple Processes-Multiple Choice Question

Question Which of the following shares CPU time among multiple processes to create the illusion that each user has a dedicated machine? A) Process management B) Memory management  C) Multi programming  D) Time sharing E) CPU scheduling     ... Read More

Reads ( 428 )
Price: Original Price: $2.00 Now at: $1.00     Add to Cart