Businesses of every size organize data records into collections called databases
ID: 3845044 • 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
Please find the solution as per your requirements.
If you have any doubt, please get back to me.
Any explanations needed, please get back to me. Thank You!
Solution:
The Database is an organized collection of interrelated data.
It can be integrated, can be shared, and can be concurrently accessed.
Database system development:
The objectives of the database system development are:
It defines the aim, the purpose, the supported tasks and the resources of the database system.
There are four stages of the database system development. They are:
Stage 1: Requirements Definition:
The requirements definition is the planning phase of the system.
End-user requirements:
Input phase:
Output phase:
Operational metrics:
For instance, the online application that allows the user to fill out all the relevant information such as diagrams, specifications, layouts, and blueprints.
Stage 2: Database Modeling:
Database modeling defines how these data sets will work with each other.
There are the different set of levels in the database development system:
Conceptual Level:
Logical Level:
Physical Level:
Inputs:
Outputs:
For instance, the output is an ER diagram or Entity Relationship Diagram. The ER diagram with the sets of data of the sequential representation of data variable and the entity relationship in the database development system.
Stage 3: Database Design:
Database design identifies the data to be stored and communicated to whom in the database development system.
Input phase:
Output phase:
For instance, the design specifications can be given in terms of abstract programs with embedded sequences of DML statements, using the DML of the data model. External Schemata based on the Logical Access Path Schema.
Internal Schema constituting an optimized Logical Access Path Schema.
Stage 4: Implementation:
SQL or Structured Query Language can be used to implement the database design.
The purpose of this phase is to translate the conceptual schema and the task design specifications into actual schema definitions and application program modules.
This is the programming phase of the system development.
Input phase:
It contains the compiled data.
Output phase:
For instance, use SQL to implement the database.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.