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!
Question 1 Indexes are ocasionally defines on a single field of a file called an indexing field. List and describe the different types of indexes
Question 2 Consider a book is written by a particular author. And you have to explain to someone about the relationship that exists between the author and the book. Normally you can draw a diagram and show the relation. These diagrams are called entity-relationship diagram in which book is one entity, author is one entity, and the relationship that exists between the two entities is written. Likewise explain the various notations used to represent the ER diagram.
Question 3 Consider a banking database (select the tables and fields of your choice). Now apply all the operations of relational algebra and find the result.
What is a function group? A function group is a collection of logically related modules that share global data with every other. All the modules in the group are contained in
What is a transaction ? The Transaction is a unit of data processing. For instance, many of the transactions at a bank may be withdrawal or deposit of money; transfer of money f
Which of the operations constitute a basic set of operations for manipulating relational data? Relational algebra operations constitute a basic set of operations for manipulati
What is 2NF? A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.
An ideal data dictionary should have everything a DBA wants to know about the database. 1 Conceptual, External, and internal database descriptions. 2. Descriptions of attr
What is view in SQL? How is it defined? Any relation that is not part of the logical model, but is made visible to a user as a virtual relation is known as a view. We descri
what is attribute is attribute inheritance in dbms?
DML Precompiler All the DBMS have two basic sets of Languages - Data Definition Language (DDL) that have the set of commands needed to define the format of the data that is b
What is meant by log-based recovery? The most widely used structures for recording database changes is the log. The log is a sequence of log records, recording all the update a
Explain the main advantages of DBMS over File Oriented System ?
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