Explore BrainMass

Explore BrainMass


    BrainMass Solutions Available for Instant Download

    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

    Vertex - Cover

    Please show me the detailed solution to the attached file, thank you.

    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

    Stacked Column Charts

    I am having a difficult time with stacked column charts - if anyone can assist, I would be grateful. a. Create a stacked column chart that shows the total number of admissions for each region and the contribution of each region within each quarter. Create this chart in its own chart sheet with an appropriate name. b. Crea

    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

    Data Normalisation Relationship Described

    1. In a car garage, how would you describe the relationship between vehicles and service, MOT or repairs. Is it one to many or many to many? 2. Same question for car parts and repairs. 3. How about repairs and accidents. Can one say it is a one to one relationship?

    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

    Answer in Hex Notation

    NOTE: For 5a, adding bits stuffing to the bit pattern below 0 1 1 0 1 1 1 1 1 1 0 0 1 1 1 1 1 0 0 1 1 For 5b, perform byte stuffing for the two bytes below 0 1 1 1 1 1 1 0 (0x 7E) and 0 1 1 1 1 1 0 1 (0x 7D) Answer in Hex notation Problem 5. a. Add framing bits and bit stuffing to the following bit pattern: 0 1 1 0 1

    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


    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