COMP 230

VBScript Database Query Lab Report

Task 4: Write and Run Database Query Program 1

In this scenario, we need to query the Computer database to determine which computers need to be replaced. Our decision will be based on the CPU speed, Number of Processors and the size of the Hard Drive.

In the space provided in your Lab Report document, paste your modified VBScript program and the RUN.

In the table cell below, paste your ComputerReplace.vbs Program

In the table cell below, paste the desktop RUN from your ComputerReplace.vbs Program

How many Computers will be replaced due only to CPU Speed < 2.1 GHz?

How many Computers will be replaced due only to Number of CPUs = 1?

How many Computers will be replaced due only to HDD Size < 300?

How many Computers will be replaced due to 2 or more reasons?

Task 5: Write and Run Database Query Program 2

In this scenario, we need to upgrade our company computers based on the Operating System and the amount of memory. We want to ensure that all Fedora 10 machines are upgrade to Fedora 14 and all Windows XP machines are upgraded to Windows 7. If we find any computers with only 2 GB of memory, we will upgrade the memory to 4 GB.

In the table cell below, paste the desktop RUN from your ComputerUpgrade.vbs Program

How many Fedora 10 Computers will be upgraded?
How many Window 7 Computers will be upgraded due to 2 GB memory?
How many Windows XP Computers will need a Memory and OS upgrade?