Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. 1.6. discuss the capabilities that should be provi

1.6. Discuss the capabilities that should be provided by a DBMS. 1.7. Discuss the differences between database...

60.2K

Verified Solution

Question

Programming

1.6. Discuss the capabilities that should be provided by aDBMS.

1.7. Discuss the differences between database systems andinformation retrieval systems.

Answer & Explanation Solved by verified expert
4.2 Ratings (885 Votes)
16 Discuss the capabilities that should be provided by a DBMS AnswerA DBMS should be equipped with the following capabilities 1A DBMS should provide a secure and survivable medium for the storage of dataThe primary concern of todays erawhere there are multiple raising layers of threat to users data privacyit becomes very pivotal that a good database management system should provide a safe and secure platform for the storage of data so that the data stored in the database is not compromised at any point 2A database management system should be able to self describe all its features A database management system should contain a complete description of databases structure and all the constrains defined in itThis data about data should be stored in a system catalogwhich contains a description of the structure of each filethe type and storage format of each fieldand the various constraints on the data 3DBMS provides Insulation between Programs and DataData abstractionIn traditional file processing systemthe structure of the data files accessed by an application is hardcoded in its source codeIf we change the structure of the dataevery application in which a description of that files structure is hardcoded must be changedHoweverin contrastthe DBMS provides a conceptual or logical view of the data to the application programsso the underlying implementation may be changed without the actual program being modified 4DBMS should provide multiple views of the dataDifferent users have different views or perspective on the databaseFor example in an educational organizationsay a college an account department will not have access to the faculty data including anything about which courses he taught    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

x 2 2 y 2 a Sketch the curve represented by the parametric equations y...

Basic Math
Q

Business law: Goods were displayed in the shop for sale with price tags attached to each article...

Operations Management
Q

Consider the Arrhenius equation. K= Ae-Ea/RT Discuss the effect of changing the basicity of the nucleophile would have...

Chemistry
Q

3. Discuss, what are the potential advantages/disadvantages of appointing international directors? [20 Marks]

General Management
Q

mework Question 23 6 2 95 HW Score 56 76 21 of 37 points O...

Basic Math
Q

In this example, we should not report all the digits fromthe final calculation. By including...

Basic Math
Q

Which of the following statements are true concerning the mean of the differences between two...

Statistics
Q

4 20 points Let L be the line given by the span of 7 in...

Algebra
Q

1. To concatenate two strings without using any built-in function 2. Check whether two strings...

Algebra
Q

Riley Company began operations on August 1, 2026 and entered into the following transactions during...

Accounting
Q

Goldberg Company is a retail sporting goods store that uses an accrual accounting system. Facts...

Accounting
Q

Guy Holcomb owns and operates Oasis Goodtime Emporium, an adult entertainment establishment. Holcomb wanted to...

Finance