GDB_CS403_1 Dated: Jul 09, 13
Please Note that GDB of CS403 will be launched on 15th of July 2013 (15-07-2013) and will last for 48 hours only.
The topic will be as follows:
A company is developing a database system containing information about cities, towns, and villages in the country. The number of cities, towns, and villages are in thousands and the database program should allow users to search a particular place by name. Users should also be able to search all places that match a particular value or range of values for attributes such as location or population size. This particular feature is known as a range query.
A reasonable database system must answer queries quickly enough to satisfy a typical user. For an exact-match query, a few seconds is satisfactory. If the database is meant to support range queries that can return many cities that match the query specification, the entire operation may be allowed to take longer. To meet this requirement, it will be necessary to support operations that process range queries efficiently by processing all cities in the range as a batch, rather than as a series of operations on individual cities.
Different indexing methods can be used to perform this operation. What will be your choice if:
a) database is created once and has no change over a period of time
b) database is created once and database is changed over a period of time
Justify your answer with appropriate logic.
Note: Try to provide precise, to the point answer and avoid irrelevant details.
Please Discuss here about this GDB.Thanks
Our main purpose here discussion not just Solution
We are here with you hands in hands to facilitate your learning and do not appreciate the idea of copying or replicating solutions.
sql not working
i try to do it but ........ fail..
please tell me another solution thanks a lots
open folder where your data base is. copy the full path and past in this window and try to connect it. try it
Its .\SQLExpress write like this it might solve your problem.
chk the drop down for other server names bcz it not seems to me the name of ur pc bcz by default ur local pc name is server name so plz ist chk ths b4 tryng othr optn
It will be solved with this
go to program of SQL Server 2005 and right click on it and start it as Admin. This issue will be solved hopefully.
dude you miss the instance name if you entered any instance name while installing SQLserver then enter this
"SHAHBAZ-PC\your instance name"
also you can check your instance name from services
start discussion pls
mugay gdb ki kuch samg nai a rai..
Mjy to smj e nai a rhi k GDB main wo pochna keya chah rahy hain./
agr kisi ko smj a gi hai to please share kar jald as jald k wo kehna keya chah rahy hain?