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!
Define the terms 1) physical schema 2) logical schema.
Physical schema: The physical schema explains the database design at the physical level, which is the lowest level of abstraction describing how the data are actually stored.
Logical schema: The logical schema explains the database design at the logical level, which explains what data are keeps in the database and what relationship exists between the data.
Types of data independence Data independence can be classified into the following two types: Physical Data Independence: This means that for any change made in the physi
What is called query processing? Query processing refers to the range of activities included in extracting data from a database.
Explain retrieval in QBE? Retrieval in QBE : A "GUI" for expressing queries. Based on the Domain Relational Calculus (DRC) Actually invented before GUIs. Very co
Problem 1 Why are the operational system keys not recommended for forming data warehouse primary keys? Give any two examples 2 Explain the following performance tuning techn
difference between internal schema and external schema in DBMS
What are the disadvantages of relational data ? Disadvantages • Performance - If the number of tables among that relationships to be established are large and the tables t
Why do you go for sorting your query results? SQL SELECT command to fetch data from MySQL table. Whenever you select rows, the MySQL server is free to return them in any order
Explain the Attribute inheritance Ans: Throughout the rendering of the objects in a view, attribute sets of objects higher in the view hierarchy are inherited via objects below
WHAT IS MEANT BY E-R MODEL
What is persistency? Persistency ensures which data is stored and that after the object is no longer available (program stops running) the data will be available to other users
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