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!
List any two significant differences between a file processing system and a DBMS. File Processing System vs. DBMS
Data Independence - Data independence is the capacity to modify the schema at one stage of a database system without having to modify the schema at the further level. In file processing systems the data and applications are commonly interdependent, but DBMS gives the feature of data independence.
Data Redundancy - Data redundancy means needless duplication of data. In file processing systems there is redundancy of data, but in DBMS we can decrease data redundancy through means of normalization procedure without affecting the original data. If we do so in file processing system, it becomes too complex.
What disadvantage of ODBC does OLE DB overcome? By breaking the features and the methods of a DBMS into COM objects, OLE DB characteristic overcomes a main disadvantage of ODBC
Distributed query and transaction processing a. Construct a query around any one of the functional divisions you made in 4a such that if executed in the distributed design of 4
Is it mandatory to declare all the tables in Report by the key word tables for all the tables that exist in the structure of LDB, and are being explained in the Database part of LD
PART MARKING: For this section, we will use part marking. This means we will supply model answers to all questions but we will only mark six questions. We will choose these randoml
Define entity integrity and referential integrity. How does SQL allow specification of these? Ans: Entity Integrity Rule- If the attribute A of relation R is a prime attribut
1. Item based services will be charged fixed prices, and time-based will be charged variably depending on time. Such as per hour. Item-based: Fixed, pedicure, waxing, threading, fa
How to reduce data redundency
What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and
what is data link layer
What is database utility? Database utility is the interface among the ABAP/4 Dictionary and the underlying the SAP system.
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