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!
An employee record has the following structure struct employee { int eno; char name[22]; float salary; char dept[10];};(i) Calculate the record size R in bytes.(ii) If the file has 500 records, calculate the blocking factor bfr and the number of blocks b, assuming an unspanned organization with block size B = 512 bytes.(iii) Describe the unused space in each block and in the last block?
Ans: (i) 2 + 22+ 4 + 10 =38 bytes (ii) bfr = floor( B/R) = [512/38] =13 Number of blocks b = ceiling (500/13) =39 (iii) Unused space in each block = 512 - 38 *13 = 512 - 494= 18 bytes Unused space in the last block = ( 39 *13 - 500) * 38 bytes = (507 -500) * 38 bytes = 7 * 38 =266 bytes
In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.
An example of a weak entity is Staff because the availabilityID cannot be uniquely identified unless it is used in conjunction with the foreign key known as availabilityID in the A
What are ways of finding out either an update is required or not for derived attributes? The ways to find out an update is required or, not are as: Explicit update
What is Asterisk in SQL? Asterisk (*): In SQL, the columns for all the tables and views in the FROM clause will be displayed.
What do you understand by RAID? Explain RAID Level 4 and Level5? RAID - It is stands for Redundant Array of Inexpensive Disks (as named by the inventor), or alternatively Re
Architectural standard: Designation : Architect , Consultant Job Profile : As a part of Oracle Fusion Middleware at Satyam, I am involved with Presales, Delivery, A
What are the objectives of query processing? Ans: The objectives of query processing is to transform a query written in a high level language into a accurate and efficien
Software failures : In such cases, a software error abruptly stops the implementation of the current transaction (or all transactions), therefore leading to losing the state of pr
Define NULL value NULL value NULL means something is unknown. It does NOT mean null (the digit 0). Null is as well employed as attribute value for a particular entity in which
E-R Model This data model is based on real world that consists of basic objects named entities and of relationship among these objects. Entities are illustrated in a database
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