Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL File structures and indexes
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


John adams
File structures and indexes
0 Answer(s)      2 years ago
Posted in : SQL


for the following BCNF relations that describe departments in a company and employees

Dept(did,dname,location,managerid) Emp(eid,sal)

Now for this system the following queries are important: List the names and ids of managers for each department in a user-specified location and in alphabetical order by department name. find the average salary of employees who manage departments in a user specified location. no one manages more than one department

Now what do you think is the best file structure and indexes to use? Now since i realised that updates will be very frequent indexes will prob have high overhead is there any other way other than using indexes to improve performance


Advertisement
View Answers

Related Tutorials/Questions & Answers:
File structures and indexes
File structures and indexes  for the following BCNF relations... one department Now what do you think is the best file structure and indexes to use? Now since i realised that updates will be very frequent indexes will prob
Structures and unions
Structures and unions  union{ struct{ int i1; char c1; }s1; struct{ int i2; char c2; }s2; }u1; what will be the value of (int)u1.s1.i1-(int)u1.s2.i2 and (int)&u1.s1-(char)u1.s1.c2
Advertisements
looping structures in JavaScript
looping structures in JavaScript  What looping structures are there in JavaScript
use strings as array indexes using JavaScript
use strings as array indexes using JavaScript  How to use strings as array indexes using JavaScript
Creating Database Tables and Indexes
Creating Database Tables and Indexes       In this section you will learn about describing the allowable syntax for identifiers in MySQL. The identifiers are Database, table, index
data structures - Java Beginners
data structures  I have got a project of the subject 'data structures and C++' and the topic is 'types of graphs'. please guide me on this topic and help me finding material of this topic
Two Indexes in For Loop
Two Indexes in For Loop     ... use two indexes in a for loop. We can solve this problem by using for loop... two index of type int inside a for loop, the indexes are FIndex and otherIndex
Data structures and algorithmms - Java Server Faces Questions
Data structures and algorithmms  Could u provide me with a solution to assignment COS212Assignment2008.doc on http://www.cs.up.ac.za
SQL Indexes
SQL Indexes       SQL uses index to find records quickly when a query is processed. Using Index can... The Tutorial illustrate an example from SQL Indexes. To understand and grasp
File
File  How to create .Exe file in jana
file
file  how can copy the information in the file to the string?   Store file data into String
file
file  Could anyone please help me to write a code that does the following: Opens a file named MyName.txt, reads the first line from the file and displays it, and then closes the file. Thank you so much
file
file  Hi,what can delet some of the information of the file
file
file  Hi,how can delet some of the information of the file
file
file  how can add the information to the graphic file
FILE
FILE  There is a file named Name.txt that contains information related to appliances.I want to read the contents of this file and I used the code... args[]) { try { File file=new File("Name.txt"); FileReader f=new FileReader(file
File
File   How to find all files in our local computer using java
file
file  hi i want read special line of file. what am i doing ? I write... read data from file. please help me! void maketree(BtNode root,int i) throws... at the following link: Read specific line from file
Data Structures in Java
Data Structures in Java In this Section, you will learn the data structure... Data structures which are very efficient and provide us a wide variety of function.  These data structures are defined in interface and classes which
Introduction to Data Structures
, Stacks, Queues, Trees, and Graphs which are related with the data structures
File path for jar file
File path for jar file  Hi Experts, I have created one eclipse... jar file of that application, unfortunately it is giving the error that resource not found for the template file. Also I had tried to get that path from user
EAR file
EAR file   What is the EAR file
String file in to word file in java
String file in to word file in java  How to convert a String format notepad file into Ms word file in java
Convesion of txt file to doc file.??????
Convesion of txt file to doc file.??????  how to convert text file to doc file using java
File manipulations
File manipulations  how to read input to a file from console
File manipulations
File manipulations  how to count number of words in a file
File manipulations
File manipulations  how to read the contents from one file and move the contents to another file
 

 

 

DMCA.com