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 differance between Primary and secondary storage ?
Computer storage is classified within primary(main) memory and secondary(peripheral) storage.a) Primary storage is commonly RAM; ~10ns access timeb) Secondary storage is commonly hard disk drives; ~10ms access timec) Secondary storage is a lot cheaper than primary, 3¢/Mb vs.$1/Mb.
a) Databases are stored in secondary memory, and large databases are manipulated in secondary storage.b) We required minimising disk accesses while accessing and manipulating databases.
Briefly explain each of the following database terms. Use no more than 2-3 lines for each term. 1. DBMS 2. Update Anomaly 3. Alias (referring to tables in SQL queries)
Define Cascading rollback The phenomenon where a single transaction failure leads to a series of transaction rollbacks is known as Cascading rollback.
Increased overheads on update : On the drawbacks side, it will need the system to ensure that all replicas of a relation are consistent. This shows that all the replicas of the rel
What is a candidate key? Minimal super keys are known as candidate keys.
Describe the responsibilities of the DBA and the database designer ? The responsibilities of DBA and database designer are: 1. Planning for the database's future storage needs
what is correlation in nested query
Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.
Read the description below and draw an Entity-Relationship diagram for it. You must use the symbols described in the course materials. This database will help the Parents Assocc
Explain Recursive relationship type? Recursive relationship type: A recursive relationship is one in that the similar entity participates more than once in the relationship
What do you mean by an execution plan? Why is it used? How will you view it? a.) An execution plan can be known as a road map which textually or graphically illustrates the dat
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