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

60.1K

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