Question

At University Hospital, the Database Management Systems (DBMS) administrator is responsible for creating and maintaining databases. Several departments have asked him to develop a process to keep track of all the data they document. In the past, they have had problems creating a system that modeled well and supported end-user access. The database administrator must create a way to track all the data in the organization.

What steps should the DBMS administrator take to ensure the information is organized and stored for easy access? Explain your steps.

Answer 1

DBMS refers to the technology of storing and retriving users data.To implement a right database management system you should

• Define your needs
• create a short cut
• evaluate your options
• implement a software
• Maintain your database

The DBMS should be designed to

• Determine your pupose of your database
• Organise your information required
• Divide the information into tables
• turn information items into columns
• specify primary keys
• set up table relationships
• refine your design
• Apply normalization norms