“Databases are part of a larger picture of what is called information system. Da

Question

“Databases are part of a larger picture of what is called information system. Database designs that fail to acknowledge this fact are unlikely to be successful. Database designers must recognize that the database is a critical means to an end, and not an end in itself. Managers want the database to serve their management needs and help them to accomplish their duties and responsibilities. But too many databases seem to force managers to change their routines to fit the database requirements.” Coronel, Morris & Rob (2013).

(a) Compare and contrast the similarities and differences (if any) between information systems analysis, design, and development and database analysis design, and development.

(b) What process would you use to ensure that the database meets management decision making needs and helps them accomplish their duties and responsibilities?

(c) How to you ensure entity integrity, referential integrity, security and availability of the database?

Explanation / Answer

Information system:
It is a system which provides the conditions for data collection, retrieval facilitates the transformation of data into information. Information system is to facilitate good decision making by making relevantinformation available to the decision makers.

Database design:

Coming to databse design it is the process of producing a detailed data model. This data model contains logical and physical design and physical storage parameters, which used to create a database. A fully attributed data model contains detailed attributes for each entity.

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.