Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
explain weak and strong entity setsweak and strong entity sets a physically powerful entity set has a primary key all tuples in the group are
describe logical data independence logical data independence - it is the capacity to modify the conceptual schema without having to change external
describe physical data independence physical data independence - it is capacity to modify the internal schema without having to change conceptual
explain data independence data independence is the capacity to modify the schema at one stage of a database system without having to change the
explain foreign keyforeign key - let there are two relations tables r and s any candidate key of the relation r that is referred within the relation
explain alternate keyalternate key - all the candidate keys except primary key are known as alternate
explain candidate keycandidate key - a candidate key is a minimal superkey that can be used to uniquely identify a tuple in the
what is key key - a single attribute or a combination of two or more attributes of an entity set which is used to recognize one or more instances
consider the following relational schema person ss name address car registrationnumber year model accident date driver carregno owns ss
describe application programming interfaceapplication programming interface - commercial sql implementations take one of the two primary techniques
explain view in rdbmsview - a view is a relation virtual rather than base and could be used in query expressions which is queries can be written by
explain what is rdbms rdbms - rdbms is a database management system dbms which stores data within the form of relations relational databases are
explain cursors in sqlcursors in sql - an object used to store the output of a query for row-through-row processing through the application programs
what is nested queries explain in detailsnested queries - a select query could have subquerys in it while a select query having another select query
explain the integrity constraints not null unique primary key with an example each is the combination not null primary key a valid combination
describe a technique for direct search explain how data is stored within a file so which direct searching can be performedfor a file of unordered
explain sorted file with advantages sorted file the sort utility shall perform one of the subsequent functions1sort lines of all the named files
explain heap file with advantagesheap file is an unordered set or a group of records stored on a set of pages this class gives basic support for
the following information was obtained from a host computer 000517176507 74125228541270 gt 642541286625 s 268856040926885604090 win 16384 ltmss
acme corp is located in toledo ohio they would like to create a network and divide it into 3 subnets each subnet has 150 computers the it plan calls
ssk software corporation has opened an office in toledo ohio the office will have a wireless wi-fi wlan and a corporate wired ethernet lan
after powering up his pc bob notices the pc was not able to properly connect to network devices he obtained the following information from his
the following information was obtained from a hostip address205133127824default gateway 2051331271dns server13910011010hosts file entrys1311831040
when are they useful justify with an examplethe temporary tables are commonly used to support specialized rollups or exact application processing
what are temporary tables temporary tables exist solely for a particular session or whose data persists for the duration of the