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!
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 no exacting order. The operations we can do on the records are retrieve, insert and delete. The types of the heap file or the pile file Organisation are:
Example -Find the employee name, salary, department number and average salary of his/her department, for those employees whose salary is more than the average salary of that depart
Flights(FlightNo, DeptDateTime, Origin, ArrivalDateTime, Destination, Capacity, SoldSeats) Tickets(FlightNo, Seat, CustID) Where - flightNo is the PK of the flights table - DeptDa
Explain the two types of participation constraint. Total: The participation of an entity set E in a relationship set R is said to be total if each entity in E participates i
Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.
Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them? Generalization: Consider extending the entity set account throug
Explain the rules for creating a labelled precedence graph for testing view serializability. Ans: A schedule S is view serializable if it is view equivalent to a ser
Give a sample of the Dynamic Model. The sample of dynamic model is given below: Dynamic model for the car: Brake and Accelerator Brake or Applies Accelerator
In which format database schema is written ? Data base schema is written in the DDL format.
What is Primary key? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.
Explain differance between Primary and secondary storage ? Primary and secondary storage Computer storage is classified within primary(main) memory and secondary(per
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