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 Discuss about second normal form and third normal form
Question 2 Write short note on 1) Data Manipulation Language 2) Data Definition Language
Question 3 Define the following terms 2) Entity 2) Keys
Question 4 Write down the characteristics of different types of storage devices. List (Cache, Main memory, Flash memory, Magnetic-disk storage, Optical storage, Tape storage)
Question 5 Differentiate between 1) Relational Data Model 2) Hierarchical Model
Question 6 What is Normalization? Explain different types of normal form
Higher Normal Forms Is there more normal forms beyond BCNF? Yes, though, these normal forms are not based on the concept of functional dependence. More normalisation is needed if
One-way Associations When an association is traversed only in the one direction, then it is implemented as a pointer i.e.an attribute which contains an object reference. If mu
What are the three data anomalies that are likely to occur as a result of data redundancy? Can data redundancy be completely eliminated in database approach? Why or why not? A
Column Constraints: NOT NULL, UNIQUE, CHECK, PRIMARY KEY, DEFAULT, REFERENCES, On delete Cascade : Using this key whenever a parent row is removed in a referenced
what is physical data structure
Define blocks? The database system resides eternally on non-volatile storage, and is into fixed-length storage units known as blocks.
What functions does a data dictionary perform? In a (DBMS)data management system, the principal functions performed by the data dictionary are Management of data defini
What are the different approaches for database design? There are two basic approaches for database design which are as follows: Attribute driven: It compiles a list of att
Components of database manager The above functions are reached by the database manager. The major elements of a database manager are: Authorisation control: This mod
Describe Embedded Query Language? Embedded Query Language - A query language (e.g., SQL) can be implemented in two ways. It can be used interactively or embedded within a host
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