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!
The File Based System
File based systems are an early attempt to computerise the manual filing system. For example, a manual file can be set up to hold all the correspondence relating to an exacting matter as a project, product, task, employee or client. In an organisation there could be a lot of such files which may be stored and labelled. The same could be done at homes where file relating to tax payments, bank statements, receipts, etc., could be maintained.
What do we do to search information from these files? For finding of information, the entries could be searched in sequence. Alternatively, an indexing system could be used to situate the information.
The manual filing system works well when the amount of items to be stored is small. It even works fairly well when the number of items stored is fairly large and they are only needed to be retrieved and stored. Though, a manual file system crashes when processing of information and cross-referencing in the files is carried out. For instance, in a university a number of students are enrolled who have the options of doing many courses. The university may have divide files for the personal details of students, fees paid by students, the number and details of the courses taught, the number and details of each faculty member in many departments. Consider the effort to answer the following queries.
The solutions to all the questions above would be time consuming in the file based system and cumbersome.
Explain cursors in SQL? Cursors in SQL - An object used to store the output of a query for row-through-row processing through the application programs. Cursors are constructs
How does Tuple-oriented relational calculus vary from domain-oriented relational calculus? The tuple-oriented calculus uses a tuple variables i.e., variable whose only allowed
What are the ways of obtaining the connection parameters? Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters
What subschema expresses ? A subschema expresses the external view. (External schemas are called also called as subschemas)
Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)
I need a professional to prepare a database to collect and store basic information. The information can be basic info such as contact details etc. One requirement i have is f
Using a labelled diagram explain the operation of the Data Warehouse, define the basic architectural components and outline the main functionalities. Briefly explain the role an op
A database has been designed for this beauty parlour in order for the staff to manage specific things such as bookings made by clients, payments, staff availability, level of exper
Multiple-mode locks : It offers two locks: exclusive locks and shared locks. But why do we require these two locks? There are a lot of transactions in the database system that neve
Define Single Value and Multivalued attribute Single value attribute comprise a single atomic value for an entity and multivalued attribute may have much more than one value f
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