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!
Explain the difference between the three storage types - volatile, non volatile and stable.
Ans: Volatile storage: if storage media loses data while power goes off, it is termed as volatile storage media for example RAM. It is the fastest among the three in terms of data access time.
Non-volatile storage: If storage media retains data even while power goes off, it is termed as non-volatile storage media. For example: hard disk. It is faster than stable storage but slower as compared to volatile storage.
Stable Storage:Information that is residing in stable storage is certainly not lost (theoretically). A natural catastrophe may result in a loss if not the probability of data loss is negligible. For example by using multiple hard disks as in the case of RAID technology. This is the slowest of all storage media mentioned above.
Define Aggregate functions and what aggregate functions supported by the MySQL To calculate a summary value from a set of individual values and uses one of the functions known
Data Redundancy -A lot of information is being repeated in the relation. For instance, the information that MCS-014 is named SSAD is repetitive, address of Rahul is "D- 27, Main ro
System R was developed and designed over a period of 1974-79 at IBM San Jose Research Company. Its purpose was to illustrate that it is possible to create a Relational System tha
Develop a database broker framework to implement a persistence mechanism for the domain objects involved in the use case dealt with in Question 2. a. Specify the attribute type
Rules Of Data Normalisation Let us now summarise Normalisation with the help of various clean rules. The following are the necessary rules for the Normalisation process: 1.
Speedup Query Processing: A query that includes data at various sites can be split into sub-queries. These sub- queries can be implemented in parallel by various sites. Such parall
Explain the database Planning Project ?
Create table employee and enter employee data in SQL? Consider the following relational schemas: EMPLOYEE (EMPLOYEE_NAME, STREET, CITY) WORKS (EMPLOYEE_NAME, COMPANYNAME, SAL
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
a) Distinguish between ‘database' and ‘Database Management Systems (DBMS)'. b) List and briefly describe five potential benefits of the database approach compared to conventio
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