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!
Draw and explain the three level architecture of the database system?
A DBMS gives three levels of data is said to follow three-level architecture. The trget of the three-schema architecture is to divide the user applications and the physical database. The view at each of these stages is described through a schema. The processes of transforming requests and results among levels are known as mappings. In this architecture, schemas can be described at the subsequent three stages:
External Level or Subschema - It is the highest level of database abstraction whereas only those portions of the database of concern to a user or application program are involved. Any number of user views (some of which may be identical) might exist for a given global or conceptual view. Each external view is described through means of a schema known as an external schema or subschema.
Conceptual Level or Conceptual Schema - At these stages of database abstraction all the database entities and the relationships between them are included. One conceptual view represents the whole database. This conceptual view is described through the conceptual schema. There is only one conceptual schema per database. The description of data at that level is in a format independent of its physical representation. It also involves features which specify the checks to retain data consistency and integrity.
Internal Level or Physical Schema - It is closest to the physical storage technique used. It denotes how the data will be stored and elaborates the data structures and access techniques to be used through the database. The internal view is expressed through the internal schema.
Define seek time. The time for repositioning the arm is known as the seek time and it enhances with the distance that the arm is known as the seek time.
Scenario 1: Power goes out after the first instruction. What happens?
What are the features of embedded SQL? Explain. Embedded SQL - SQL could be implemented within two ways. It can be used interactively or embedded in a host language or throu
Determine the language that needs a user to specify the data to be retrieved with no specifying exactly how to get it is Ans: Non-Procedural DML
One-way Associations If an association is only traversed in single direction, then it is known as one-way association. It is implemented as a pointer or an attribute which con
What is Message switching Message switching transmits data units which can be arbitrarily long. Packet switching has a utmost packet size, if any message longer than that, it s
Explain the Management of Data Store Every system irrespective of its nature of application requires storing permanent data for consequent use in problem solving. Some objects
What is NULL? Simply NULL means not in value.
State the Design of Associations Before designing associations, it is essential to know the way they are used. For this, analysis of association traversals is required. It is
Question 1 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? Question 2 With a necessary example explain (i)
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