Share
Explore BrainMass

Data

SQL Statements to Move the Foreign Key to T1

Assume that tables T1 and T2 have a 1:1 relationship. Assume that T2 has the foreign key. Show the SQL statements necessary to move the foreign key to T1. Make up your own names for primary and foreign keys.

Object-oriented data-model

Draw an object-oriented data-model, with all appropriate notation, to represent the following situation. In a particular region there are a number of gardens. One attribute of GARDEN is its LOCATION. A method must be included in GARDEN to calculate its acreage (CalculateAcreage). Each garden is a collection (or assembly) of plan

Business Rules and Crow's Foot ERD

Use the attachment to complete the problem. 1. Identify each relationship type and write all of the business rules. 2.Create the basic Crow's Foot ERD. Examples here: http://faculty.washington.edu/blabob/sysan_w08/Docs/Data%20Models%20-%20Data%20Modeling.pdf

Types of Data Collection

1. Describe 5 data collection techniques in your own words. Be sure to cite any sources you used. 2. Explain why the examination of collected data is so important.

Constructing a Good Form Design

Speedy Spuds is a fast-food restaurant offering all kinds of potatoes. The manager has a 30-second rule for serving customers. Servers at the counter say they could achieve that rule if the form they must fill out and give to the kitchen crew were simplified. The information from the completed form is keyed into the computer sys

Internet Terminology Confusions/Network

1. Why does the Internet need HTTP, TCP, IP and DNS? Why isn't the Internet Protocol (IP) enough to do the job? Please reply to these specific points of confusion. 2. Another thing that puzzles me is that sometimes when I type a uniform resource locator (URL), I was told that the host named in the URL does not exist. Yet often

Calculate Diffie-Hellman Symmetric Key, R1, and R2

(2) In the Diffie-Helman protocol, g=7, p=23, x=3, and y=5. a) What is the value of the symmetric key? b) What is the value of R1 and R2? Possible Variations of the initial data 1) g=5, p=19, x=7, and y=3 2) g=11, p=31, x=3, and y=9 3) g=7, p=43, x=5, and y=7

Communication recovery plan

Consider a natural or man-made disaster, and discuss how a communications network could be recovered from such a disaster. Refer to communication issues experienced during and after the tsunami in December of 2004 or similar issues experienced in the aftermath of Hurricane Katrina in August of 2005. Provide at least one resource

Network Protocols

Why are network protocols needed? How do you decide which protocol is more suitable for a network implementation?

Web Applications

Why do vclidation controls improve the performance of a web application?

Microsoft Excel Functions

For the data attached is it possible to make excel highlight (Yellow) rows of results that are over 500. I would like this to happen every time I enter a value > 500. I would also like a count at the top of the spreadsheet to display the number of times this happens for a Pre-op and an Operational.

Hard Disk Capacity/Access Time

Assume the specification of a hard disk drive shows the following characteristics: 16 surfaces 1024 tracks per surface 256 sectors per track 512 bytes/sector Track-to-Track seek time of 10 milliseconds Rotational speed 3,000 rpm (a). What is the capacity (in MB) of the hard disk drive? (b). What is the access time (in

Computer Applications

A workbook can contain more than one worksheet. Give an example of a spreadsheet application where it would be necessary to have more than one worksheet and explain

calculate(formula) the following

I would like to know how to calculate(formula) the following. There are 20 gigabyte of space on a computer's hard disk. I transfer data via a telephone line (connection) at the rate of 14,400 bits per second. At this rate how long will it take to fill the available storage space?

Data Warehousing

You have been asked to design a star schema for a large hotel chain. Review the information package given for a hotel chain in Figure 5-6 in the attached file. Use this information package to design the STAR schema. Problem: - Draw the star schema. - List the attributes for each table. - Designate a primary key for ea

Data Flow Chart

Draw a Data Flow Chart and then develop an application that allows a user to enter a stock transaction and determine the stockbroker's commission. Each transaction includes the following data: the stock name, price per share, number of shares involved, and the stockbroker's name. Assume price per share = P. The stockbrokers co

Vlookup

I'm trying to setup a vlookup. Basically, if I have a dollar amount for my ticket ie: $5012 and I'm going to location 3, I want it to call on the table in the second tab, and pull data from cell E5 (and tell me the premium)... and so on for the other numbers. The dollar amount is to be in a range, the location is an exact

Create a Visual Studio Application

Individual Project Deliverable Length: One Visual Studio.NET project Details: Create a Visual Studio.NET 2005 web application with one aspx form. Place a CheckBoxList, TextBox, Button, and Label control on the form. Use a RequiredFieldValidator control that verifies the user entered a string in the Textbox control. W

Hard Disk Access

A certain hard disk has 480 cylinders, 16 tracks, and 32 sectors of 512 bytes each. It spins at 4800 revolutions per minute, and has an adjacent cylinder seek time of 80 msec, and a max seek time of 100 msec. Switching between tracks in the same cylinder is instantaneous. Use this information to answer the following 4 questions.

Edges and Graphs Cut Offs

The solution below got cut off. Please let me know what is the total solution: <b>problem:</b> The number of strongly connected components in a graph G is k. By how much can this number change if we add a new edge? <b>solution:</b> If we add an edge to a biconnected graph with k strongly connected components, then the

UML notation solutions

1. The package on the left contains the classes in a payroll system. The package on the right is a payroll tax subsystem. a. What technique would you use to integrate the tax subsystem into the payroll system? b. Show how you would solve the problem. c. Show what modifications you would make to the existing classes or what

Excel S4-R1 Copy Worksheet

Excel S4-R1 Copy the Week 2 worksheet, positioning the new sheet after Week 3. 2. Rename the Week2 (2) worksheet as Week 4. 3. Delete the Week 3 worksheet 4. Copy the Week 2 worksheet, positioning the new sheet between Week 2 and Week 4. 5. Rename the Week2 (2) worksheet as Week3. 6. Insert a new worksheet positioned bef