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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

For each of the following, specify if a reaction does or does not occur when the...

Chemistry
Q

Consider a series of 8 flips of a fair coin. Calculate the probabilities for obtaining 0-8 heads. We...

Physics
Q

Where can DNA be found in eukaryotic cells Nucleus Chloroplast O Mitochondria All of the...

Biology
Q

Kele has been offered a job to paint the outside of a barn If one...

Geometry
Q

20 log 100 y 1 10 100

Basic Math
Q

Next Problem 1 point The polynomial of degree 3 P x has a root of...

Basic Math
Q

10 Solve for x 2x 6 x 11 Solve for x 5x 8 1 6

Algebra
Q

Can I have a simple, clear , correct answer to Q 14 and 15 plz...

Accounting
Q

100 Cash at Dank 110 Accounts receivable 120 Inventory 130 Prepaid insurance 171 Shop equipment...

Accounting
Q

The following information pertains to property tax transactions in GF of SB City during the...

Accounting
Q

Part N29 is used by Farman Corporation to make one of its products. A total...

Accounting
Q

Lynch, Inc, is a hardware store operating in Boulder, Colorado. Management recently made some poor...

Accounting