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!
Differentiate between various levels of data abstraction?
Data Abstraction - Abstraction is the procedure to hide the irrelevant things from the users and represent the relevant things to the user. Database systems are frequent used through non-computer professionals so in which the complexity must be hidden from database system users. This is done through defining levels of abstract as that the database may be viewed; there is logical view or external view, conceptual view and internal view or physical view.
1. External View - This is the highest level of abstraction as seen through a user. It describes only the part of whole database, that is relevant to a particular user.
2. Conceptual View - This is the next higher stages of abstraction that is the sum total of Database Management System user's views. It elaborates what data are in fact stored in the database. It contains information about whole database in terms of a small number of associatively easy structure.
3. Internal View - This is the lowest level of abstraction. It elaborates how the data are physically stored
Compare wait-die deadlock prevention scheme with wait-wound scheme Ans: Wait-Die Scheme a) Based upon a nonpreemptive technique. b) If Pi requests a resource present
Which is another name for weak entity? Child is another name of weak entity.
What is Candidate Key Super Key or Candidate Key: It is such an attribute of a table that can uniquely recognize a row in a table. Generally they have unique values and can n
Data independence seems that "the application is independent of the access strategy and storage structure of data". In other words, the ability to change the schema definition in o
Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined): Ans: The relational database schema f
What are the technique to define a schema completely ? A schema is completely define by DDL and DML query language.
Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult
Database Administrator One of the main perpose for having the database management system is to have control of both data or programs accessing that data. The person having li
Instructions: Follow the instructions below for completing this project: 1. Creating the Database: · Use the physical table descriptions given below to define and create each t
What is the difference among a primary index and a secondary index? Primary Index: A primary index is an ordered file whose records are of fixed length along with two fields.
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