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 are the disadvantages of file-processing system?
Ans: The Disadvantages of File-Processing System
a. Data redundancy and inconsistency - Data redundancy means not necessary duplication of data. In file processing systems, the information might be duplicated in various places (files) because of the different structure. This duplicity leads to higher storage access cost. Additionally, it may lead to data inconsistency, means the several copies of similar
b. Difficulty in accessing data - The conventional file-processing environments does not permit required data to be retrieved in convenient and well-organized manner
c. Data isolation - As data are scattered in several files and may be in dissimilar formats, writing new program to retrieve the suitable data is difficult.
d. Security problem - In file processing system. Enforcing security constraints is hard.
Evaluate: a.When transactions T1 and T2 are in a deadlock, one of the transactions will eventually implement to completion and let the other one continue implementation. b.
Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000. CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA
Update Anomaly : This anomaly is occurred due to data redundancy. Redundant information makes updates more complex since, for example, varying the name of the instructor of MCS-014
Have a look around the site, and at some of the sites they have featured. These are all examples of bad design, and also offer an explanation about why they fall into this category
What are stored and derived attributes? Stored attributes: The attributes keeps in a data base are known as stored attributes. Derived attributes: The attributes that are de
Differentiate between join and outer join? Outer joins return all rows from at least one of the tables or views mentioned within the FROM clause, as long as those rows get toge
Question: i) Explain the terms data warehousing and data mining. ii) Discuss the importance of the following security principles that a digital firm should amongst others, n
Describe the various types of Online Analytical Processing (OLAP) tools and briefly discuss how the support common analytical operations.
Oracle Fusion Middleware: Key Skills: Consulting,Architect, Oracle Fusion Middleware,ECM, UCM, Stellent,Identity Management, SOA Suites, BPEL, ESB,OAM,OIM,J2ee, Java, Livelink
write short note on mobile database
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