Microsoft excel

Select the worksheet function that will return the largest number in a specified range of cells, the function should ignore text and logical values. Select the worksheet function that will return the smallest number (including numbers, logical values, and text,) in a specified range of cells These are the functions to pic ...continues

SQL Server 2000 DBA for an e-commerce project

Please discuss what you believe to be a good backup and crisis management strategy considering the following scenario. Provide a detailed explanation of your choices. You work for a small consulting firm with a sterling reputation for high-quality work and outstanding technical aptitude. You've been assigned as the SQL Serv ...continues

Assume a sequential file contains 20,000 records and 2 seconds are required to interrogate an entry. how long should we expect to wait when retrieving a record from the middle of the file?

Help in understanding how a sequential file is searched to get to the required record.

DB2 Datebase

Explain what is DB2 database and how it is used in technology?

Create E-R diagram

(See attached file for full problem description) --- Using the script file below to create an E-R diagram of the entities, attributes and relationship. # use the "my_database" database USE my_database; # create a table called "items" with 3 records CREATE TABLE IF NOT EXISTS items ( id INT PRIMARY KEY, ve ...continues

Multiple choice questions

Need answers to multiple choice practice test so that I can compare my answers. This is not a graded project. --- 1. What is the best way to store an individual's name in a table? (Points: 2) As three separate fields for first name, last name, and middle initial As two fields, one for the last name, and o ...continues

Trigger in Oracle

Trigger for comparing an employee's salary with that his or her supervisor. Explain why this Trigger is not work. CREATE TRIGGER INFORM_SUPERVISOR1 BEFORE INSERT OR UPDATE OF SALARY, SUPERVISOR_SSN ON EMPLOYEE FOR EACH ROW WHEN (NEW.SALARY > (SELECT SALARY FROM EMPLOYEE WHERE SSN=NEW.SUPERVISOR_SSN)) ...continues

Primary Keys

Read the article http://www.orafaq.com/articles/archives/000031.htm then answer the following questions: 1. Post a summary of the essential points in the article. 2. The author discusses "...three fundamental demands on the candidate keys that we must never deviate from, if it is to become the subject for a primary key." D ...continues

What is the primary key in this problem and the dependencies? I am trying to normalise the database.

The following business rules form the basis of the database design. · A member receives many invitations, and each invitation is sent to many members. · An invitation may be sent to different members on different dates. The date a member accepts an invitation is recorded. · Each invitation i ...continues

Relational Database concepts like Primary Key identication, Foreign Key identification, etc.

A1. Use the following partial database tables to answer the required questions below: Cash Table___________________________________________________________ Cash #________________ Type of Account_______________Bank Name____ 110146758 Regular Checking North First 1203948102 Payroll Checking Account Credi ...continues