Write benefits of using dbms to manage data in program

Assignment Help Database Management System

Reference no: EM1366877

POLYTECHNIC OF NAMIBIA
SCHOOL OF INFORMATION TECHNOLOGY
SOFTWARE ENGINEERING DEPARTMENT
Private Bag 13388, Windhoek, Namibia Phone: +264 (61) 207-2052
Fax: +264 (61) 207-2051 [email protected]

INTRODUCTION TO DATABASES (IDB210S)
Assignment 1
TOTAL: 50 Marks |__|__|35 |_____| %
Date: 7th March 2011

Due Date: Full-time Students: Monday 14th March during class (07:30), Part-time students: Thursday 17th M arch during class (17:15) - Hard copies only! Assignments sent by email will not be marked.

Instructions: Answer all the questions. No plagiarism will be tolerated! Work in a group with a maximum of 3 individuals (students and the minimum of 2 students ). When you answer questions, you should be led by the marks allocated for each question; keywords alone are not enough.

1. Explain briefly what the main benefits of using a DBMS to manage data in program applications involving extensive data access.
2. When would you store data in a DBMS instead of in operating system files and vice-versa? Motivate your answer.
3. Explain the advantages of using a query language instead of custom programs to process data. Motivate your answer.
4. What is a transaction?
5. What guarantees does a DBMS offer with respect to transactions? Motivate your answer.
6. Mr. Sylvester Shongani wants to store information (names, addresses, descriptions of exciting moments, etc) about the many people he interacts with. Not surprisingly, the volume of data compels him to buy a database system. To save money, he wants to buy one with the least possible features, and he plans to run it as stand-alone application on his PC. Of course, Mr. Shongani does not plan to share his list with anybody. Indicate why Mr. Shongani should or should not pay for the following features in the system he buys. Explain your answers briefly.

a. A security facility.
b. Concurrency control.
c. Crash recovery.
d. A view mechanism.
e. A query language

Reference no: EM1366877

Questions Cloud

What is the ciphertext generated by encryption of character : What is the ciphertext (in binary form) generated by the encryption of character D? How is plaintext for this encrypted D recovered?

Breastfeed without additional contraceptive protection : As her nurse, would you advocate for this mom to breastfeed without additional contraceptive protection or would you advocate for the mom to take the prescribed contraceptive method realizing that it may interfere with her milk production. Why?

Increase-decrease in money supply : Assume the Fed decides to buy $1 billion in Treasury bonds from the public. Suppose that the reserve requirement is 10%. What takes place to the interest rate and money supply?

Determine credit card balance after two years : Leslie receive $2000 a month and rents an apartment for $600 a month, and also has a credit card with an yearly interest rate of 7 percent and a balance of $1500.

Write benefits of using dbms to manage data in program : Describe briefly what are the main benefits of using DBMS to manage data in program applications involving extensive data access.

Educational deficit on the work environment : Impact of the problem, issue, or educational deficit on the work environment, the quality of care provided by staff, and patient outcomes.

Analysis of demand and supply-computing equilibrium price : In the absence of a quota, what is the equation for the total supply of wine? Show your work - what are the equilibrium price and quantity of wine? Show your work.

Compute the anticipated value of the dividends : Hunter Petroleum Company paid a $2 dividend last year. The dividend is expected to increase at a constant rate of 5% over the next 3-years. The required rate of return is 12%

Brief summary of economic costs : Give a brief summary of economic costs. In the short-run, why might a firm still operate even when there is a loss.

User Account

All Pages