Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
What is the difference between serial and sequential files? How searching is applied on both?
Ans: A serial file is one where the records have been stored in the order where they have occurred. They have not been sorted into any specific order.
An instance of a serial file is an unsorted transaction file.
A shopping list is an instance of a non-computerised serial file. Items are appended to the list while that item runs low.
Serial files can be stored on tape, disc or in memory.
A sequential file is one where the records are stored in sorted order of one or more key fields.
An instance of a sequential file is a sorted transaction file.
A class register is an instance of a non-computerised sequential file sorted on surname
distributed quey processing
Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.
Cyber Transit Ltd keeps up-to-date information on the processing and current position of each dispatched item. Dispatched items are the main concern of the Cyber Transit product tr
Draw an E_R Model for the following: An organization uses number of items of a equipment to generates goods. Each item is at one LOCATION, of one TYPE and has a DETAILED_DISCRI
WHAT IS DSS? WRITE ITS REQUIREMENTS.
What is the use of rename operation? Rename operation is used to rename both relations and an attributes. It uses the as clause, taking the form: Old-name as new-name.
What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is
What are the ways in which the variable-length records arise in database systems? Storage of many record types in a file. Record types that permit variable lengths for one o
Discuss the differences among the candidate keys and the primary key of a relation. Give instance to describe your answer? A candidate key is one that can be used as primary ke
Concurrency Identification While designing analysis, model we map real world model into our analytical model. Real life objects are simultaneous in nature, but all the design
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd