Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Businesses of every size organize data records into collections called databases

ID: 357040 • Letter: B

Question

Businesses of every size organize data records into collections called databases.

The purpose of a database is to keep track of things. At one extreme, small businesses use databases to keep track of customers; at the other extreme, huge corporations use databases to support complex sales, marketing, and operations activities.

Suppose that a county planning department wants to build a new database system to keep track of building permit applications for both residential and commercial projects. The database should be available to the applicants over the Internet. You have been hired as a consultant to recommend the best strategy for creating such a database.

In an essay, describe the work that must be accomplished for the four stages of development of this particular database system—requirements definition, data modeling, database design, and implementation. Identify the inputs and outputs for each stage of development.

Explanation / Answer

Database can be defined as an organized collection of interrelated data

so that our Data in the Database-

A Database management system(DBMS) is a collection of interrelated files and set of programs that allow users to access and modify these files. The primary goal of a DBMS is to provide a convenient and efficient way to store, retrieve and modify information. The Database are designed to:

For customer, product and purchase information in any industry RDBMS is more popular Relational database: any database in which data is logically organized based on relational models. RDBMS: It is a DBMS which manages the relational database. An RDBMS is a category of DBMS that stores data in related tables.

RDBMS is special system software that is used to manage the organization, storage, access, security and integrity of data.This specialized software allows application systems to focus on the user interface, data validation and screen navigation. When there is a need of any modification or to display data, the application system simply makes a "call" to the RDBMS

Stages of devloping a Database