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!
Advantages of Database management system
Let us summarize the advantages.
Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy is the problem of storing the similar data item in more one place. Redundancy makes several problems like requiring extra storage space, entering similar data more than once during data insertion, and deleting data from more than one place during deletion. Anomalies may happen in the database if insertion, deletion etc are not done properly.
Sharing of Data: In a paper-based record keeping, data cannot be shared between many users. But in computerized DBMS, lots of users can share the similar database if they are connected via a network.
Data Integrity: We can handle data integrity by specifying integrity constrains, which are rules and restrictions about what type of data may be entered or manipulated within the database. This enhances the reliability of the database as it can be guaranteed that no wrong data can exist within the database at any point of time.
Data security: We can restrict certain people from accessing the database or permit them to see certain portion of the database whereas blocking sensitive information. This is not possible very simply in a paper-based record keeping.
Explain the uses of deadlock It will lead to deadlock since this is the only place where incoming acknowledgements are processed. Without this code, sender will keep timing ou
What is a primary index? A primary index is an index whose search key also explains the sequential order of the file.
Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4
Describe the two types of methods for retrieving rows in Python? Fetchone()- Returns the next row as a sequence Fetch all()- Returns the entire result set like a strin
Benefits: It limits data access. It makes difficult queries look easy. It permits data independence. It presents dissimilar views of the similar data.
Types of Locks There are two necessary types of locks: Binary lock : This locking mechanism has two states for to a data item: locked or unlocked Multiple-mode loc
You are required to implement integrity constraints within the database to enforce the following requirements: For Projects: Start date must be supplied. Start date cannot be i
Example -Find the employee name, salary, department number and average salary of his/her department, for those employees whose salary is more than the average salary of that depart
What is a SELECT operation? The select operation selects tuples that please a given predicate. We use the lowercase letter σ to denote selection.
Speedup Query Processing: A query that includes data at various sites can be split into sub-queries. These sub- queries can be implemented in parallel by various sites. Such parall
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd