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!
Database Manager
It is the interface among low-level data, queries and application programs. Databases typically need a large amount of storage space. It is kept on disks, as the main memory of computers has not store this information. Data is moved among disk storage and main memory as needed. Hence the movement of data to and from disk is slow relative to the speed of the control processing unit of computers; it is essential that database system structure data so as to decrease the need to move data between main memory and disk.
A database manager is a program module liable for interfacing with the database file system to the user questions. In addition, the tasks of enforcing constraints to keep the consistency and integrity of the data as well as its security are also done by database manager. Synchronising the concurrent operations performed by concurrent users is under the control of the data manager. It also done backup and recovery operations. Let us summarise now the vital responsibilities of Database manager.
Homework chapter 10 no 3
State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record
This constraint shows that the key attribute value in each tuple must be unique, i.e., no two tuples have the similar value for the key attribute. This is because the value of the
What are the two types of blocks in the fixed -length representation? Define them. Anchor block: Have the first record of a chain. Overflow block: Have the records other tha
Explain Clustering file organization (i) Determine if a record of file is physically ordered on a nonkey field - that does not comprise a different value for each record - that
Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.
What are the several kinds of the update operations on relations? Also explain the constraints on these update operation. Give instance in support of your answer. There are th
What is the error handling Traditionally, bits have been sent over line lacking any error correcting scheme in physical layer. The presence of the CPU in each modem makes it po
Define instance and schema? Instance: Collection of data stored in the data base at a certain moment is Schema: The overall design of the data base is known as the data base
Define average seek time. The average seek time is the average of the seek times, calculated over a sequence of random requests.
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