Premium Essay

Assignment 5

In:

Submitted By junkemailbox
Words 1460
Pages 6
This assignment helps you understand what table columns deserve an index through a series of exercises on a database schema. You do not type SQL in this assignment, but rather identify which columns deserve indexes, the type of index it deserves, and why. Correct placement of indexes is absolutely critical to database performance. All but the smallest of databases would have terrible performance if no indexes were assigned to any of its table columns.

An index is a physical construct that serves two purposes – speeding up data retrieval and enforcing uniqueness. Indexes are not modeled in logical entity-relationship diagrams, because indexes do not operate at the logical level of abstraction, as do tables and table columns. While the primary purpose of creating an index is to speed up data access, modern relational DBMS also support a type of index that additionally enforces a uniqueness constraint. A uniqueness constraint can be assigned to a table column directly, or is indirectly assigned to a table column when it is assigned a primary key constraint. While a uniqueness constraint is a logical construct, many modern relational DBMS physically implement this constraint through an index.

You might reasonably ask the question, “Why not simply add indexes to every column in the schema?” After all, then we would not need to concern ourselves with index placement. The primary reason is that while indexes speed up reading from the database, indexes slow down writing to the database. Indexes associated with a table slow down writes to that table, because every time data is added to, modified, or deleted from the table, the indexes referencing the data must be modified. A secondary reason is that indexes increase the size of our database, and that not only affects storage requirements, but also affects database performance since the buffer cache will need to handle

Similar Documents

Free Essay

Week 5 Assignment

...Janell Taylor 10/23/12 Implicit Test I found the test to be very interesting and I don’t like timed tests because I need time to think about my answer to be sure and confident about my choice. I don’t agree with the results because they said I made too many errors and I don’t understand that because that was just one part where I was making too many errors. It has helped me out in those areas of different topics, but I just wish I had more time. I guess I would say that the answers wasn’t valid enough for me because it didn’t really give me a score because I made too many errors, so I don’t agree with that too much. I believe prejudice is difficult to measure because I don’t agree with it and don’t like the fact that it’s very big and can get worse if we don’t come together to get in one accord to help each other and make the world better to live in dealing with different people and feelings. I think measuring prejudice can be a tough thing to deal with and handle because of the many people that are prejudice, which are hurting and harming many situations and people that’s trying to make it while being equal to everyone regardless of what. I would have to take the test over to get a better score because I felt that wasn’t fair because I made too many errors to get a...

Words: 252 - Pages: 2

Free Essay

Unit 5 Assignment 1 Cabling Factors and Tolls Discussion

...Unit 5 Assignment 1 Cabling Factors and Tolls Discussion Flexibility What type of install is the cable going into? Is everything in a fixed position? If you have an install where items are moved around without being disconnected, using highly flexible cable is necessary. Cables in these scenarios need to be flexible to meet those demands of mobility, and also for the life of the wire so that it does not crack, break, fray or short. We had a job at a university where we moved flat panels on a track system to create different screen sizes, and for that we had to make sure the cable would meet the demand. Capacitance Cat 6 is not always better than Cat 5. If a video extender is made for Cat 5e, using Cat 6 may cause you a problem. The electrical properties are different, and the circuitry inside may not be able to reconcile the increased capacitance. You should confirm with the manufacturer before making a substitute in a Category cable. Jacket What type of jacket does your cable need? You have plenum, riser, PVC/non-plenum and direct burial. Plenum cable is often required in commercial work, especially in buildings where there are open-air returns; it is essential to meeting code. Integrators will often use riser grade at the riser, and then transfer to plenum in the plenum space. This saves some cost, but I recommend you second-guess saving that few cents per foot in most cases. The chances of mixing up a box of cable and pulling riser in the plenum space may increase...

Words: 318 - Pages: 2

Free Essay

Mobile Service Provider

...and the result is the value of the argument. Example:- If a=5 then +a means 5 If a=0 then +a means 0. If a=-4 then +a means -4. Ternary operator:- It precedes an operand. The operand of the unary operator must have arithmetic type and the result is the negation of the operand’s value. Example:- If a=5 then –a means -5 If a=0 then –a means 0 If a=-4 then –a means 4. (b) Assignment and equalto operator Assignment operator:- Equal to operator: An assignment operator assigns value In this we put the To a variable. value as it is. Example – Example- a*=5 means a=5*5. Int a; a=5 means a is initialized with 5 if(a==5) { return true; } return false; (c) Expression and statement Expression:- An expression is any valid combination of operators , constants , and variables. Example:- for(i=0;i=10&&qual==1) sal=15000; else if((g==’m’&&yos>=10&&qual==0)||(g==’m’&&yos=10&&qual=0) sal=9000; else if(g==’f’&&yos25) printf(“driver is insured”); else printf(“driver is not insured”); }}} 4. Ans:- 5. Ans:- #include #include void main() ...

Words: 399 - Pages: 2

Premium Essay

Student

...sources where appropriate. 1 This will apply to all assignments in this class. Answer the following questions: Chapter 2 1. Short Answers [1 point each, 2 points total] 1. What does a professional programmer usually do first to gain an understanding of a problem? The first thing that a professional programmer usually do first to gain an understanding of a program is to closely relate customer (Interview ) to inquire or gather information about the problem. 2. What two things must you normally specify in a variable declaration? The two things normally specified in a variable declaration are the variable type and identifier. 2. Algorithms / Pseudocode [1 point each, 5 points total] 1. Design an algorithm that prompts the user to enter his or her height and stores the user’s input in a variable named height. Declare height Display “Enter Your Height” Input Height Display “Height” 2. Write assignment statements that perform the following operations with the variables a and b. - Adds 2 to a and stores the result in b. - Subtracts 8 from b and stores the result in a Set b=2+a Set a=b-8 3. Write a pseudocode statement that declares the variable cost so it can hold real numbers. Floating Point-Variable 4. Write a pseudocode statement that assigns the value 27 to the variable count. Count:=27 5. If the following pseudocode were an actual program, what would it display? Declare Integer a = 5 Declare Integer b = 2 Declare Integer c = 3 ...

Words: 1823 - Pages: 8

Free Essay

Prg/211 Calorie Count Tool

...Team B Calorie Count Tool PRG/211 May 5, 2014 Team B Calorie Count Tool PROBLEM STATEMENT Team B was asked to develop a program which would calculate the user’s daily intake of calories and measure those calories against the overall calories expended. The core purpose of this program will do two primary functions. First, it will record the user intake of calories as acquired through meals throughout the day. Second, the user will record caloric output associated with physical activity. This information will be calculated together to determine the caloric surplus or deficit for the user. In order for the program to execute accurately, and provide customized results, the user will be required to input personal data to include gender, age, weight, and height. This additional information is essential to determine the user’s default caloric burn rate, otherwise known as the basal metabolic rate (BMR). The BMR and the calories burned as a result of physical activity will be calculated against the intake of calories to determine the overall success for the user. As the program is executed it must: * Record user name, age, height, weight to enable more accurate calculations * Record the users specific caloric values entered for each meal * Record the user activity and caloric burn values for that activity * Calculate the basal metabolic rate (BMR) for the individual * Subtotal the total caloric values for the day * Combine the physical activity and...

Words: 1524 - Pages: 7

Premium Essay

Week 2 Assigment

...Week 2 Assignment: Understanding Effective Money Management Assessment A, Part 1: Creating a Personal Financial Statement - Assets | 1 point | Car: Bluebook value $1250.00Cash: $378.00Savings Accounts: $826.00 | Assessment A, Part 2: Creating a Personal Financial Statement - Debts | 1 point | Rent: $750.00Electric/ Gas bill: $131.75Cable/ internet/ Phone bill: $80.42Credit Card: $31.00Cell phone bill: $72.37 | Assessment A, Part 3: Identify Money Management Tool | 1 point | Explain to Monica how the money management tools were identified. | Students should explain how they evaluated various cash management products and services. | Assessment A, Part 4: Creating a Personal Financial Statement – Steps | 1 point | Drag the steps listed on the right into their correct sequences on the left. When done click the Send button | Step 1: I got all my financial stuff together – bills, loans, bank statements, etc. | Step 2: I balance my checkbook. | Step 3: I decided what were my assets and what were my debts. | Step 4: I enter my assets in the program. | Step 5: I enter my debts in the program. | Step 6: The program gave me a Net worth figure at the end. | Assessment B: Creating a Monthly Cash Flow Statement ...

Words: 255 - Pages: 2

Free Essay

Management Accounting

...Management Accounting Individual Assignment 1. Variable manufacturing cost per unit = (323,000,000-160,000,000-24,000,000-100,000,000) 850,000 = $45.88 per unit Fixed manufacturing cost per unit = $100,000,000 850,000units = $117.65 per unit Total manufacturing cost per unit= 45.88+117.65 = $163.53per unit 2. Fixed overhead rate= $100,000,000 800,000units =$125 per unit Production volume variance= (850,000 X 125)-(800,000 X 125) =$106,250,000-$100,000,000 = $6,250,000 Favourable 3. Absorption costing. | $ | $ | SalesLess: Cost of goods soldOpening inventoryProduction(850,000 X (255+125))(-)Ending inventory(30,000 X 405)Gross MarginAdjustments for production variance(850,000-800,000)x125Operating Income | 0323,000,000(11,400,000) | 450,000,000(311,600,000) | | | | | | 138,400,0006,250,000F | | | 144,650,000 | Income Statement for the year ended 31December 2012 4. Variable Costing Income Statement for the year ended 31 December 2012 | $ | $ | SalesOpening inventoryProduction(850,000 X 255)(-)Ending inventoryContribution MarginFixed factory overheadOperating income | 0216,750,000(7650,000) | 450,000,000(209,100,000) | | | 240,900,000(100,000,000) | | | 140,900, 000 | 5. Based on the calculations of absorption costing and variable costing for the year 2012,it would be better to calculate and measure using the absorption costing...

Words: 288 - Pages: 2

Premium Essay

Sfds

...ASSIGNMENT - 3 Answers 1 Answer 2 Answer 3 4. For what types of workloads does SJF deliver the same turnaround times as FIFO? ANSWER: - In the above case if the jobs are same in size or the jobs periodically applied (i.e. first shortest job then later second shortest job and continues) then the turnaround time of SJF is same as FIFO. 5. For what types of workloads and quantum lengths does SJF deliver the same response times as RR? ANSWER: - The response time delivered by SJF is equal to the response time of RR but this happens only when all the jobs arrived are at the point when the planning quantum of RR is bigger than the bigger occupation to be administrations in order of increasing size. 6. What happens to response time with SJF as job lengths increase? Can you use the simulator to demonstrate the trend? ANSWER: - If you suppose the length of the job increases then average response time varies (increases).If every job is sorted in increasing job order than the last job response time will be equal to the sum of current job and previous (n-1) jobs. In this way if the size of the job increases the response time will also increases for all larger jobs. 7. What happens to response time with RR as quantum lengths increase? Can you write an equation that gives the worst-case response time, given N jobs? ANSWER: - In the case of RR, the response time increases as the quantum lengths increases. This happens because the waiting time of a process for its turn to...

Words: 286 - Pages: 2

Free Essay

Misconceptions of Algebra

...learn the equality symbol misconception when they begin learning mathematics. Rather than understanding that the equal sign indicates equivalence between the expressions on the left side and the right side of an equation, students interpret the equal sign as meaning “do something” or the sign before the answer. This problem is exacerbated by many adults solving problems in the following way: 5 × 4 + 3 = ? 5 × 4 = 20 + 3 = 23 Students may also have difficulty understanding statements like 7 = 3 + 4 or 5 = 5, since these do not involve a problem on the left and an answer on the right. Falkner presented the following problem to 6th grade classes: 8 + 4 = [] + 5 All 145 students gave the answer of 12 or 17. It can be assumed that students got 12 since 8 + 4 = 12. The 17 may be from those who continued the problem: 12 + 5 = 17. Students with this misconception may also have difficulty with the idea that adding or subtracting the same amount from both sides of an equation maintains equality. Kieran gives this example: Solve for x: 2x + 3 = 5 + x 2x + 3 – 3 = 5 + x 2x = 5 + x – x – 3 2x – x = 5 – 3 x = 2 The answer is correct, but several steps of the solution contain incorrect equations. In summary, a student with this misconception will: Assume the solution to a problem is the number after the...

Words: 797 - Pages: 4

Free Essay

Book Report

...value (positive or negative), the condition is considered as a “true” condition and the statement following the if is executed; otherwise this statement is not executed. Relational Operators In C Relational operator | Meaning | Example | < | Less than | age < 30 | > | Greater than | height > 6.2 | <= | Less than or equal to | taxable <= 200000 | >= | Greater than or equal to | temp >= 98.6 | == | Equal to | grade == 100 | != | Not equal to | number !=250 | In creating relational expressions, the relational operators must be typed exactly as given in the above table. Thus, although the following relational expressions are all valid: age > 40 length <= 50 temp >= 98.6 3 < 4 flag == done day != 5 The following are invalid: length =< 50 /* operator out of order*/ 2.0 >> 3.3 /*invalid operator*/ flag = = done /*spaces are not allowed*/ Relational expressions are also known as conditions. The if and if-else Statements The simplest C selection statement is the one-way if statement having the syntax if ( expression ) statement; In this construction, the statement following the if (expression ) is only executed if the...

Words: 1617 - Pages: 7

Premium Essay

Delegation

....4 Conclusion……………………………………………………………….4 References/Work Cited…………………………………………………5 Introduction TV personality Anthea Turner once said, “The first rule of management is delegation. Don't try and do everything yourself because you can't.” (Delegation Quotes) Business owners, such as the owner of a Chick-fil-A restaurant located in Marlton, NJ, have to be willing to delegate tasks to their employees and trust that the assigned employee is going to complete the tasks adequately so he can be freed up to take care of other things associated with their business and to avoid unnecessary stress. What is Delegation? A Latin term originating sometime between 1605 and 1615, the term “delegation” is the act of giving control, authority, a job, a duty, etc., to another person. There are three basic elements of delegation: the assignment of duties, granting of authority to enable the subordinates to perform the duties assigned, and the creation of obligation on the part of subordinate to perform duties in an orderly manner. The process of delegation involves four steps. The first step is the assignment of duties to subordinates which entails the owner to decide exactly what duties he wants the subordinate to complete. The second step is the transfer of authority to perform the duty which entails giving the subordinate the power to complete the assigned tasks. The third step is the acceptance of the assignment which entails the subordinate agreeing to complete the assigned tasks. The final...

Words: 509 - Pages: 3

Free Essay

123456789

...Assignment: Define CSS? -Cascading Style Sheets, a new feature being added to HTML that gives both Web site developers and users more control over how pages are displayed. With CSS, designers and users can create style sheets that define how different elements, such as headers and links, appear. These style sheets can then be applied to any Web page. What are the three types of style in CSS? There are three types of CSS styles: * inline styles Inline styles are styles that are written directly in the tag on the document. Inline styles affect only the tag they are applied to. <a href="" style="text-decoration: none;"> ex. * embedded styles Embedded styles are styles that are embedded in the head of the document. Embedded styles affect only the tags on the page they are embedded in. ex. <style type="text/css"> p { color: #00f; } </style> * external styles External styles are styles that are written in a separate document and then attached to various Web documents. External style sheets can affect any document they are attached to. ex. <link rel="stylesheet" type="text/css" href="styles.css" /> Define JavaScript? -JavaScript is an interpreted programming or script language from Netscape. It is somewhat similar in capability to Microsoft'sVisual Basic, Sun's Tcl, the UNIX-derived Perl, and IBM'sREXX. In general, script languages are easier and faster to code in than the more structured and compiled languages...

Words: 393 - Pages: 2

Free Essay

Cards on My Head

...Strayer University | Assignment 2 | Cards on my Head | Professor KagenMath 104 | Joshua White | 12/20/2012 | [Type the abstract of the document here. The abstract is typically a short summary of the contents of the document. Type the abstract of the document here. The abstract is typically a short summary of the contents of the document.] | Andy, Carol, Belle and I are playing guess my cards. Each player draws three cards out of a deck and each card has a number between 1 and 9. Each player must place their cards on their heads without looking at your cards. Every other player can see your cards and you cans see the others cards. Every person draws a set of questions to ask of the other players. You use the answer to the questions to gain clues about the cards you have. The objective is to guess what cards you have stuck to your head. I can see Belles, Andy’s, and Carol’s cards. Belle’s cards are 3, 4, and 7. The sum of Belle’s cards equal to 14. Carol has 4, 6, and 8. The sum of her cards equal to 18. Andy has 1, 3, and 7. His cards equal to 11. I ask Andy if he can see 2 or more player whose cards sum to the same value? His reply was “yes”. That tells me that the sum of my cards come up to either 14 or 18. I can see Belle has a total of 14 and Carol has a total of 18. Andy can’t see his cards. I than ask Belle of the 5 different odd #’s how many do you see? Belle tells me that she can see all of them. Andy has a 1, 3, and 7, which are all odd numbers...

Words: 434 - Pages: 2

Free Essay

Mat222 Week 1 Assignment

...size of the sample. The ratio of originally tagged bears to the whole population is 50X The ration of recaptured tagged bears to the sample size is 2100 50X=2100 This is the proportion set up and ready to solve. I will cross multiply setting the extremes equal to the means. 10050=2x 100and 50 are the extremes, while X and 2 are the means. 50002=2x2 Divide both sides by 2 X = 2500 The bear population on the Keweenaw Peninsula is around 2500 bears. The second problem for assignment one week one I am asked to solve the below equation for y. The first thing I notice is that a single fraction (ratio) on both sides of the equal sign so basically it is a proportion which can be solved by cross multiplying the extremes and the means. y-1x+3=-34 Is the equation I am asked to solve. 3y-1=-3x-4 The result of the cross multiplying. 3y-3=-3x+12 Distribute 3 on the left side and -3 on the right. 3y-3+3=-3x+12+3 Subtract 3 from both sides. 3y=-3x+15 3y3=-3x3+153 Divide both sides by 3 y=-x+5 This is a linear equation in the form of y=mx+b. This equation is in its simplest form. I like how we can take just a couple of numbers from a word equation and put it in an order that will help us solve many estimates we may come...

Words: 340 - Pages: 2

Free Essay

Boolean Assignment

...TR PT1420 5/13/14 Unit Assignment 4 l. What is the general fom1at of the statement used to code decisions in an application? A power full asset of the computer is its ability to make decisions and to take alternate course of action based on the outcome. 2. What is a Boolean expression? a logical statement that is either TRUE or FALSE. 3 . Explain the purpose of comparison operators and logical operators. The purpose of a comparison operator is to test some kind of relationship between two entities examples are >, <, ==, !=, etc 4. How does a comparison performed on numeric data differ from a comparison performed on string data? There are commonly used interchangeably, and the distinction between them is a small one. Comparison to" should be used when comparison is made between specific people, things, or other instances. 5. How does Visual Basic compare the Text property of a text box? When you compare the Text property of a text box with another value the Text property behaves like a variant. Visual Basic compares one text box to another as strings and compares a text box to a numeric variable or constant with a numeric compare. You can force a numeric comparison on a Text property by using the Val function. 6 . Why would it be useful to include the ToUpper method in a comparison? When comparing strings, the case of the characters is important. An uppercase “Y” does not compare equal to a lowercase “y”. Since the user may type a name or word in either...

Words: 902 - Pages: 4