Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Use the library and the Web for articles on the data warehousing designs which use the Inmon's Corporate Information Factory design or the Kimball's Dimensional Modeling design.
Do you have a scenario which you can share where you believe a Database helped or could help improve a process at your work or at the other organization
After reading the article, 'Modeling for the Future', expand on the subject of Database Modeling.
There are three kinds of views. Pick one of them and give a definition, an illustration of that kind of view, and when you would use the view.
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.