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!
What are the Constituents of File? Also elaborates all the possible file operations?
A file is organised logically as sequence of record. These records are mapped onto disk blocks. Although blocks are of fixed size denoted through the physical properties of the disk and through the operating system, record sizes vary. In a relational database, tuples of distinct relations are commonly of different sizes.
Possible operations on a file: (i) Create: a file can be created (ii) Delete: a file can be deleted (iii) Changing attributes of a file: The attributes of a file say read only, author's name etc. can be changed. (iv) Contents of the file can be altered.
What kind of advantages to copying records from one table to another? -) When an algorithm that modifies a table is used after that it's safer to work with the copy -) When
Database Administrator One of the main perpose for having the database management system is to have control of both data or programs accessing that data. The person having li
Heap files (unordered file) Mostly these files are unordered files. It is the easiest and most basic type. These files having of randomly ordered records. The records will have
vertical fragmentation
Creating a view: A query can be embedded within the CREATE VIEW STATEMENT A query can have complex select statements containing join, groups and sub- queries A quer
Explain the cartesian product in Database Management System
What is average response time? The average response time is that the average time for a transaction to be done after it has been submitted.
State the Component Diagram A component diagram represents a set of component and relationships among them. In a dynamic model, component diagram is used to model physical com
Consider the following relational schema: PERSON (SS#, NAME, ADDRESS) CAR (REGISTRATION_NUMBER, YEAR, MODEL) ACCIDENT (DATE, DRIVER, CAR_REG_NO) OWNS (SS#, LICENSE) Constru
How are tables stored on Disk? We realise that every record of a table can have different amounts of data. This is due to in some records; some attribute values may be "zero".
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