Describe the three levels of data abstraction with diagram.

Describe the three levels of data abstraction with diagram. 
by

1 Answer

Answer :

Three levels of data abstraction are: 

Physical level: This is the lowest level of data abstraction. It describes how data is actually stored in database. The complex data structure details is described at this level. 

Logical level: This is the middle level of 3-level data abstraction architecture. It describes what data is stored in database and the relationships among the data. 

View level: This is highest level of data abstraction. This level describes the user interaction with database system.

image

by

Related questions

Define (i) Data Abstraction, (ii) Data Redundancy.

Description : Define (i) Data Abstraction, (ii) Data Redundancy.

Last Answer : Data abstraction is defined as  *Suppression of details of data organization and storage  *Highlighting of the essential features for an improved understanding of data  *The characteristic that allow ... of data abstraction. This level describes the user interaction with database system. 

Describe the three levels of data abstraction?

Description : Describe the three levels of data abstraction?

Last Answer : There are three levels of abstraction: ∙ Physical level: The lowest level of abstraction describes how data are stored. ∙ Logical level: The next higher level of abstraction, describes what data are ... data. ∙ View level: The highest level of abstraction describes only part of entire database.

Explain three tier architecture of database with the help of diagram.

Description : Explain three tier architecture of database with the help of diagram.

Last Answer : Application server or Web server *Adds intermediate layer between client and the database server *Runs application programs and stores business rules Clients contain GUI interfaces and ... GUI format. Thus the user interfaces, application rules and the database acts as three tier. 

Describe following terms: Inheritance, data abstraction, data encapsulation, dynamic binding.

Description : Describe following terms: Inheritance, data abstraction, data encapsulation, dynamic binding.

Last Answer : Inheritance: 1. Inheritance is the process by which objects of one class acquire the properties of objects of another class. 2. It supports the concept of hierarchical classification. It also provides the ... with a given procedure call is not known until the time of the call at run-time.

Describe object-oriented data models.

Description : Describe object-oriented data models.

Last Answer : Object Oriented Model : Object oriented models were introduced to overcome the shortcomings of conventional models like Relational, Hierarchical and network model. An object-oriented database is collection of objects whose ... with other objects. It is also said to be semantic data model.

Explain different types of attribute with example and their symbols used in ER diagram.

Description : Explain different types of attribute with example and their symbols used in ER diagram.

Last Answer : Different types of attributes are: 1. Simple attribute: A simple attributes are those which cannot be subdivided. Eg:Rollno-  symbol 2. Composite attribute: a composite attribute is ... value can be calculated or determined from another attribute Eg: age from dateofbirth  Symbol

Describe centralized database system with example.

Description : Describe centralized database system with example. 

Last Answer : Centralized Database System: 1. A centralized database consists of a single data server into which all data are stored and from which all data are retrieved. All the data reside at a single location and ... is cheaper than other types of databases as it requires less power and maintenance. 

Describe enhanced ER model with the help of example.

Description : Describe enhanced ER model with the help of example. 

Last Answer : Enhanced ER is a high-level data model that incorporates the extensions to the original ER model. It is created to design more accurate database schemas. EER reflects data properties and constraints more precisely ... example: Square, Circle, Triangle are the sub class of Shape super class. 

Describe benefits and drawbook of denormalization.

Description : Describe benefits and drawbook of denormalization.

Last Answer : Benefits of denormalization: * Reduce number of relations: It reduce the number of relations because it combines two relations into one new relation. * Reduce number of foreign keys: It reduce number ... : It is always application-specific and needs to be re-evaluated if the application changes. 

Describe client server system with example.

Description : Describe client server system with example.

Last Answer : Client server system consists of two logical components. One is Client and the other one is Server . Clients are those who send the request to perform a specific task to the server. ... client's CPU and memory. But server runs a database management system which manages the whole database.

The process of removing detail from a given state representation is called ______ a) Extraction b) Abstraction c) Information Retrieval d) Mining of data

Description : The process of removing detail from a given state representation is called ______ a) Extraction b) Abstraction c) Information Retrieval d) Mining of data

Last Answer : b) Abstraction

What is Data Abstraction? How is it implemented in Java?

Description : What is Data Abstraction? How is it implemented in Java?

Last Answer : A: Act of representing only essential features without including its background details is called Abstraction. Data Abstraction can also be defined as the process of hiding the implementation details and showing ... Java, it is implemented by the use of interfaces or by making the class abstract.

Explain data encapsulation and data abstraction.

Description : Explain data encapsulation and data abstraction.

Last Answer : Data encapsulation: The wrapping up of data and function into a single unit (called class) is known as encapsulation. The data is not accessible to the outside world, and only those functions ... as they hold information. The functions that operate on these data are called as member functions.

Define the following terms: (i) Data abstraction (ii) Class (iii) Dynamic binding (iv) Polymorphism

Description : Define the following terms: (i) Data abstraction (ii) Class (iii) Dynamic binding (iv) Polymorphism

Last Answer : (i) Data abstraction: Abstraction refers to the act of representing essential features without including the background details or explanation. Data abstraction is the process of defining a data type, often ... more than one form at different instances depending on the type or number of arguments. 

Define the term Data Model.

Description : Define the term Data Model.

Last Answer : Underlying structure of the database is called as data model. It is a collection of conceptual tools for describing data, data relationships, data semantics and consistency constraints. Data models define how data is connected to each other and how they are processed and stored inside the system.

Define Data and instance.

Description : Define Data and instance.

Last Answer : Data: Data can be defined as facts or information that can be recorded and have an implicit meaning.  Instance: The collection of information stored in the database at a particular moment is called an instance of the database.

Explain three level architecture of Database

Description : Explain three level architecture of Database

Last Answer : There are following three levels or layers of DBMS architecture: External Level : Describes part of the database that a particular user group is interested in. Conceptual Level: Describes structure of ... is the one that concerns the way the data are physically stored on the hardware.

Why abstraction in java is called as a mathematical entity?

Description : Why abstraction in java is called as a mathematical entity?

Last Answer : answer:Abstract data classes are analogous to mathematical constructions. In Euclidean geometry, for example, the axioms would be like the methods in an abstract Java class. Since the terms in the axioms ... allow you to work with types that really are undefined and that have to be instantiated.

The seals, cords, labels and bags required to be preserved in connection with investigation into a case of loss or abstraction in the RMS should be preserved in the personal custody of the: (A) Head Sorting Assistant (B) Record Officer (C) Office Supervisor of the Superintendent’s office

Description : The seals, cords, labels and bags required to be preserved in connection with investigation into a case of loss or abstraction in the RMS should be preserved in the personal custody of the: (A) Head Sorting Assistant (B) Record Officer (C) Office Supervisor of the Superintendent’s office

Last Answer : (B) Record Officer

Which of the following is a tool in design phase ? Abstraction Refinement Information Hiding All of Above

Description : Which of the following is a tool in design phase ? Abstraction Refinement Information Hiding All of Above

Last Answer : All of Above

Point out the wrong statement. a) Abstraction enables the key benefit of cloud computing: shared, ubiquitous access b) Virtualization assigns a logical name for a physical resource and then provides a pointer to that physical resource when a request is made c) All cloud computing applications combine their resources into pools that can be assigned on demand to users d) All of the mentioned

Description : Point out the wrong statement. a) Abstraction enables the key benefit of cloud computing: shared, ubiquitous access b) Virtualization assigns a logical name for a physical resource and then provides a ... their resources into pools that can be assigned on demand to users d) All of the mentioned

Last Answer : All cloud computing applications combine their resources into pools that can be assigned on demand to users

Cloud computing is an abstraction based on the notion of pooling physical resources and presenting them as a ________ resource. a) real b) virtual c) cloud d) none of the mentioned

Description : Cloud computing is an abstraction based on the notion of pooling physical resources and presenting them as a ________ resource. a) real b) virtual c) cloud d) none of the mentioned

Last Answer : virtual

Which of the following cloud concept is related to pooling and sharing of resources? a) Polymorphism b) Abstraction c) Virtualization d) None of the mentioned

Description : Which of the following cloud concept is related to pooling and sharing of resources? a) Polymorphism b) Abstraction c) Virtualization d) None of the mentioned

Last Answer : Virtualization

Which of the following is essential concept related to Cloud? a) Reliability b) Productivityc) Abstraction d) All of the mentioned

Description : Which of the following is essential concept related to Cloud? a) Reliability b) Productivityc) Abstraction d) All of the mentioned

Last Answer : Abstraction

The program which provide partitioning, isolation or abstraction is called? A. virtualization hypervisor B. software hypervisor C. hardware hypervisor D. system hypervisor

Description : The program which provide partitioning, isolation or abstraction is called? A. virtualization hypervisor B. software hypervisor C. hardware hypervisor D. system hypervisor

Last Answer : virtualization hypervisor

Which of the following should be replaced with the question mark in the following figure? a) Abstraction b) Virtualization c) Mobility Pattern d) All of the mentioned

Description : Which of the following should be replaced with the question mark in the following figure? a) Abstraction b) Virtualization c) Mobility Pattern d) All of the mentioned

Last Answer : Virtualization

Point out the wrong statement. a) Abstraction enables the key benefit of cloud computing: shared, ubiquitous access b) Virtualization assigns a logical name for a physical resource and then provides a pointer to that physical resource when a request is made c) All cloud computing applications combine their resources into pools that can be assigned on demand to users d) All of the mentioned

Description : Point out the wrong statement. a) Abstraction enables the key benefit of cloud computing: shared, ubiquitous access b) Virtualization assigns a logical name for a physical resource and then provides a ... their resources into pools that can be assigned on demand to users d) All of the mentioned

Last Answer : All cloud computing applications combine their resources into pools that can be assigned on demand to users

Which of the following should be replaced with the question mark in the following figure? a) Abstraction b) Virtualization c) Mobility Pattern d) All of the mentioned

Description : Which of the following should be replaced with the question mark in the following figure? a) Abstraction b) Virtualization c) Mobility Pattern d) All of the mentioned

Last Answer : Virtualization

Point out the wrong statement. a) Abstraction enables the key benefit of cloud computing: shared, ubiquitous access b) Virtualization assigns a logical name for a physical resource and then provides a pointer to that physical resource when a request is made c) All cloud computing applications combine their resources into pools that can be assigned on demand to users d) All of the mentioned

Description : Point out the wrong statement. a) Abstraction enables the key benefit of cloud computing: shared, ubiquitous access b) Virtualization assigns a logical name for a physical resource and then provides a ... their resources into pools that can be assigned on demand to users d) All of the mentioned

Last Answer : All cloud computing applications combine their resources into pools that can be assigned on demand to users

Cloud computing is an abstraction based on the notion of pooling physical resources and presenting them as a ________ resource. a) real b) virtual c) cloud d) none of the mentioned

Description : Cloud computing is an abstraction based on the notion of pooling physical resources and presenting them as a ________ resource. a) real b) virtual c) cloud d) none of the mentioned

Last Answer : virtual

Which of the following cloud concept is related to pooling and sharing of resources? a) Polymorphism b) Abstraction c) Virtualization d) None of the mentioned

Description : Which of the following cloud concept is related to pooling and sharing of resources? a) Polymorphism b) Abstraction c) Virtualization d) None of the mentioned

Last Answer : Virtualization

Which of the following should be replaced with the question mark in the following figure? a) Abstraction b) Virtualization c) Mobility Pattern d) All of the mentioned

Description : Which of the following should be replaced with the question mark in the following figure? a) Abstraction b) Virtualization c) Mobility Pattern d) All of the mentioned

Last Answer : Virtualization

Point out the wrong statement. a) Abstraction enables the key benefit of cloud computing: shared, ubiquitous access b) Virtualization assigns a logical name for a physical resource and then provides a pointer to that physical resource when a request is made c) All cloud computing applications combine their resources into pools that can be assigned on demand to users d) All of the mentioned

Description : Point out the wrong statement. a) Abstraction enables the key benefit of cloud computing: shared, ubiquitous access b) Virtualization assigns a logical name for a physical resource and then provides a ... their resources into pools that can be assigned on demand to users d) All of the mentioned

Last Answer : All cloud computing applications combine their resources into pools that can be assigned on demand to users

_______ is the essential concept related to cloud? a) Reliability b) Abstraction c) Productivity d) None of the above

Description : _______ is the essential concept related to cloud? a) Reliability b) Abstraction c) Productivity d) None of the above

Last Answer : Abstraction

Which of the following cloud concept is related to pooling and sharing of resources? a) Polymorphism b) Abstraction c) Virtualization d) None of the mentioned

Description : Which of the following cloud concept is related to pooling and sharing of resources? a) Polymorphism b) Abstraction c) Virtualization d) None of the mentioned

Last Answer : Virtualization

What is difference between Encapsulation And Abstraction?

Description : What is difference between Encapsulation And Abstraction?

Last Answer : Ans. 1.Abstraction solves the problem at design level while encapsulation solves the problem at implementation level 2.Abstraction is used for hiding the unwanted data and giving relevant data. ... and Display Screen are connect with each other using different circuits , it explains Encapsulation.

Define abstraction.

Description : Define abstraction.

Last Answer : Ans. Abstraction means displaying only essential information and hiding the background details of the implementation. Real Life Example of Abstraction in Java. Abstraction shows only important things to the user and ... how it work? And also we do not know the internal functionality of a bike.

What is abstraction?

Description : What is abstraction?

Last Answer : Abstraction is of the process of hiding unwanted details from the user.

Which phase is not available in software life cycle? (A) Coding (B) Testing (C) Maintenance (D) Abstraction

Description : Which phase is not available in software life cycle? (A) Coding (B) Testing (C) Maintenance (D) Abstraction

Last Answer : (D) Abstraction

In windows 2000 operating system all the processor-dependent code is isolated in a dynamic link library called (A) NTFS file system (B) Hardware abstraction layer (C) Microkernel (D) Process Manager

Description : In windows 2000 operating system all the processor-dependent code is isolated in a dynamic link library called (A) NTFS file system (B) Hardware abstraction layer (C) Microkernel (D) Process Manager

Last Answer : (B) Hardware abstraction layer

A Design concept Refinement is a: (A) Top-down Approach (B) Complementary of Abstraction concept (C) Process of elaboration (D) All of the above

Description : A Design concept Refinement is a: (A) Top-down Approach (B) Complementary of Abstraction concept (C) Process of elaboration (D) All of the above

Last Answer : (D) All of the above

Module design is used to maximize cohesion and minimize coupling. Which of the following is the key to implement this rule? (A) Inheritance (B) Polymorphism (C) Encapsulation (D) Abstraction

Description : Module design is used to maximize cohesion and minimize coupling. Which of the following is the key to implement this rule? (A) Inheritance (B) Polymorphism (C) Encapsulation (D) Abstraction

Last Answer : (C) Encapsulation

Cohesion is an extension of: (A) Abstraction concept (B) Refinement concept (C) Information hiding concept (D) Modularity

Description : Cohesion is an extension of: (A) Abstraction concept (B) Refinement concept (C) Information hiding concept (D) Modularity

Last Answer : (C) Information hiding concept 

Abstraction and encapsulation are fundamental principles that underlie the object oriented approach to software development. What can you say about the following two statements? I. Abstraction allows us to focus on what something does without considering the complexities of how it works. II. Encapsulation allows us to consider complex ideas while ignoring irrelevant detail that would confuse us. (1) Neither I nor II is correct. (2) Both I and II are correct. (3) Only II is correct. (4) Only I is correct.

Description : Abstraction and encapsulation are fundamental principles that underlie the object oriented approach to software development. What can you say about the following two statements? I. Abstraction allows us to focus on what something ... and II are correct. (3) Only II is correct. (4) Only I is correct.

Last Answer : (1) Neither I nor II is correct.

Explain various types of Relational constraints.

Description : Explain various types of Relational constraints.

Last Answer : Relational Constraints Relational constraints are a set of rules. It is used to maintain the quality of information. Integrity constraints ensure that the data insertion, updating, and other ... - It establishes parent child relationship between two tables. For example :Foreign key constraints 

Explain advantages of centralized and distributed databases.

Description : Explain advantages of centralized and distributed databases.

Last Answer : Advantage of Centralized databases   * Data integrity is maximized -Data integrity is maximized and data redundancy is minimized because data is stored at a single place.  * Easier Database Administration - ... data is distributed, a group of users can easily share and use data of different sites

Distinguish between file processing system and DBMS.

Description : Distinguish between file processing system and DBMS.

Last Answer : Database Management system File processing system 1. Presence of Self-describing nature of a database system and Metadata. 1. File processing don't contain any self describing feature and ... to use DBMS 5. Controlling Redundancy is one of most important feature to use DBMS

State characteristics of Database.

Description : State characteristics of Database.

Last Answer : The Characteristics of Database are: 1. Persistent Data 2. Meta Data and Self-describing nature of a DB 3. Insulation between programs and data (Data Independence) 4. Support ... Sharing of data and multiuser transaction processing 6. Access flexibility and Security. 7. Controlled Redundancy

Define the term Foreign Key.

Description : Define the term Foreign Key. 

Last Answer : A FOREIGN KEY is a key used to link two tables together. A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table. It ... between tables because it references the primary key of another table, thereby establishing a link between them.

List types of Database languages.

Description : List types of Database languages.

Last Answer : Four types of database languages are: 1. DDL (Data Definition Language) 2. DML (Data Manipulation Language) 3. DDL (Data Control Language) 4. TCL (Transaction control language)