Computers and Technology, 15.11.2019 01:31 KariSupreme

Exercise 20.6 consider the following bcnf relations, which describe employees and the departments they work in: emp (eid, sal, did) dept (did, location, budget)you are told that the following queries are extremely important: i find the location where a user-speciﬁed employee works. i check whether the budget of a department is greater than the salary of each employee in that department.1. describe the physical design you would choose for this relation. that is, what kind of a file structure would you choosefor these relations, and what indexes would you create? 2. suppose that your customers subsequently complain that performance is still not satisfactory (given the indexes and fileorganization that you chose for the relations in response to the previous question). since you cannot afford to buy newhardware or software, you have to consider a schema redesign. explain how you would try to obtain better performanceby describing the schema for the relation(s) that you would use and your choice of file organizations and indexes on theserelations.3. suppose that your database system has very inefficient implementations of index structures. what kind of a designwould you try in this case?

Answers: 2

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 07:20, Hcalhoun21

Write a pseudocode solution for each of these problems. 1. design a while loop that lets that user enter a number. the number should be multiplied by 10, and the result stored in a variable named product. the loop should iterate as long as product contains a value less than 100. 2. design a do-while loop that asks the user to enter two numbers. the numbers should be added and the sum displayed. the loop should ask the user whether he or she wishes to perform the operation again. if so, the loop should repeat; otherwise it should terminate. 3. design a for loop that displays the following set of numbers: 0, 10, 20, 30, 40, 50 100. 4. design a nested loop that displays 10 rows of # characters. there should be 15 # characters in each row. 5. convert this for loop to a while loop. declare integer count for count = 1 to 50 display count end for 6. find the error in the following pseudocode. declare boolean finished = false declare integer value, cube while not finished display “enter a value to be cubed.” input value; set cube = value ^ 3 display value, “ cubed is “, cube end while

Answers: 2

continue

Computers and Technology, 22.06.2019 17:00, shimmerandshine1

Aisha has finished working on a word processing document that contains 15 pages. she has added some special elements in the first three pages, page 9 and 10, and page 15 from the document. she wants to print only these pages to see how they look. which option is the correct way to represent (in the print dialog box) the pages that aisha wants to print

Answers: 3

continue

Computers and Technology, 23.06.2019 09:50, tatumleigh04

Allison and her group have completed the data entry for their spreadsheet project. they are in the process of formatting the data to make it easier to read and understand. the title is located in cell a5. the group has decided to merge cells a3: a7 to attempt to center the title over the data. after the merge, allison points out that it is not centered and looks bad. where would the title appear if allison unmerged the cells in an attempt to fix the title problem?

Answers: 2

continue

Computers and Technology, 24.06.2019 04:30, juliemiddleton05

1. web and mobile applications allow users to be actively engaged in an online activity. a true b false 2. some examples of business applications purposes are to collaborate, share files, meet virtually in real-time, and accept payments. a true b false 3. an education application would most likely do which of the following? a allow users to watch popular movies and tv shows b connect users with social and business contacts c confirm users' travel plans d teach users a new language 4. a uniform resource locator (url) is how the internet knows where to take users when an address is typed into a browser. a true b false 5. deon is required to provide the citation information for his sources. what type of information should he collect from his sources? a author name, title, date of publication, date of access, url b connections to background information c interesting facts and statistics d notes on important information

Answers: 1

continue

You know the right answer?

Exercise 20.6 consider the following bcnf relations, which describe employees and the departments th...