Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
List an illustration of a database and how you interact with that database. One illustration might be as a customer receiving monthly bills.
Suppose your database system has failed. Describe the database recovery process and the use of deferred-write and write-through techniques.
Explain the concept of physical data independence and its importance in database systems, List four significant differences between a file-processing system and a DBMS.
Draw the E/R diagram for given problem.the company needs to keep track of the date the service was performed, the date the bill is due, and the amount due.
Research and provide three to four paragraphs covering the following: What is a sub query, and what are its basic characteristics?
What is meant by distributed transaction model and describe the system structure and failure modes in detail. Explain the SQL server architecture in detail and write down its operation.
Explain about data fragmentation and its two different schemes for fragamenting a relation in detail.
Describe the ten golden rules to set up a KDD environment.
Explain on two-phase locking protocol and timestamp – based protocol.
Write down the limitations of E-R model? Describe how do you overcome this? What do you understand by Embedded SQL?
Describe about data marting in detail. Write down the guidelines in tuning the data warehouse.
Write down a program in DBASE III plus to find the biggest among 3 numbers using IF Statement.
Explain how the Relational Calculus is different from the Relational Algebra?
Write differences between the stored and the derived attributes.
Draw the ER diagram for a banking enterprise with the given specifications.
What do you mean by hashing? Describe the various Hashing methods in detail.
Describe in detail Organization and management of the Biochemical databases.
Write down the Quick Sort algorithm for MIMD machine and describe.
Write down an algorithm for the addition of n numbers on the Perfect Shuffle network. Illustrate its accuracy with an illustration.
Describe different forms of memory interleaving. List out all the merits and demerits of such schemes?
Write down the stages of migration from the corporate data model to the architected environment.
Explain why is metadata essential for using, for building and for administrating the data warehouse?
Describe at least four advantages of granularity of data in the warehouse design.
Describe the fragmentation transparency, replication transparency and location transparency in the distributed databases.
Describe the difference between the logical and physical data independence.