A special software program that helps users create and maintain a database (on a computer)
Database Management System
What can DBMS do?
Make it easy to manage large amounts of information
Handles Security
Backups
Importing/exporting data
Concurrency
Interacts with software applications (Programming Language)
What are functionality of DBMS Specify the data type, structure and constraints for the data to be stored.
Define
What functionality of DBMS does the process of storing data on some storage medium
Construct
What functionality of DBMS does the querying the database to retrieve specific data, updating database and generating reports.
Manipulate
What functionality of DBMS does allow multiple users and programs to access the database simultaneously.
Share
What are the examples of DBMS?
MySQL
PostgreSQL
Microsoft Access
SQL Server
FileMaker
Oracle
dBASE
Sybase
What are the advantages of DBMS
Redundancy problem can be solved.
Has a very high security level.
Support multiple users.
Shared data
Enforcement of standards
What are the disadvantages of DBMS
Complexity
Size
Maintaining currency
Higher impact of a failure
Cost of DBMS
you can develop a database by using the ____________, which contains multiple stages of development.
System Development Life Cycle
This top-down, systematic approach to database development transforms business information requirements into an operational database.
System Development Life Cycle
What are the steps in SDLC
Strategy and Analysis
Design
Build and Document
Transition
Production
Study and analyze the business requirements. Interview users and managers to identify the information requirements. Incorporate the enterprise and application mission statements as well as any future system specifications.
Strategy and Analysis
Build models of the system. Transfer the business narrative into a graphical representation of business information needs and rules. Confirm and refine the model with the analysts and experts.
Strategy and Analysis
Design the database based on the model developed in the strategy and analysis phase.
Design
Build the prototype system. Write and execute the commands to create the tables and supporting objects for the database.
Build and Document
Develop user documentation, Help text, and operations manuals to support the use and operation of the system.
Build and Document
Refine the prototype. Move an application into production with user acceptance testing, conversion of existing data, and parallel operations. Make any modifications required.
Transition
Roll out the system to the users. Operate the production system. Monitor its performance, and enhance and refine the system.
Production
