Database Development
Database Development
Process
Process
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Database Development Process, Lecture notes of Database Management Systems (DBMS)
Database Development Process Database Development Process Database Development Process
Typology: Lecture notes
2021/2022
1 / 76
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Database Development Process and more Lecture notes Database Management Systems (DBMS) in PDF only on Docsity!
Database DevelopmentDatabase Development
Process Process
DatabaseDatabase
Carefully designed and constructedCarefully designed and constructed
repository of facts repository of facts
Fact repository is a part of largerFact repository is a part of larger
system called information system system called information system
Database is a part of an informationDatabase is a part of an information
system system
The Information The Information
System System
Information SystemInformation System
It has several components including:It has several components including:
- (^) PeoplePeople
- (^) HardwareHardware
- (^) SoftwareSoftware
- (^) DatabasesDatabases
- (^) Application programApplication program
- (^) proceduresprocedures
The Information The Information
System System
Building an information systemBuilding an information system
has two processes has two processes
Systems analysisSystems analysis
Systems developmentSystems development
The Information System The Information System
(Con’t.) (Con’t.)
Performance of an informationPerformance of an information
system depends on system depends on
Database design and implementationDatabase design and implementation
(it is called (it is called database developmentdatabase development))
Application design and implementationApplication design and implementation
Administrative proceduresAdministrative procedures
Both Systems analysis and systemsBoth Systems analysis and systems
development require much careful development require much careful
planning planning
The Information System The Information System
(Con’t.) (Con’t.)
Detailed procedure of how toDetailed procedure of how to
build an information system build an information system
Detailed procedure of how toDetailed procedure of how to
build database system build database system
Keep as general as possibleKeep as general as possible
The Information System The Information System
(Con’t.) (Con’t.)
Important to system designerImportant to system designer Big frame within which the databaseBig frame within which the database design and application development design and application development can be mapped out and evaluated can be mapped out and evaluated In other words, database design andIn other words, database design and application development take place application development take place within the confines of an information within the confines of an information system system
Systems Development Life Systems Development Life
Cycle (SDLC) Cycle (SDLC)
SDLC is divided into five phasesSDLC is divided into five phases based on time or procedure order based on time or procedure order PlanningPlanning AnalysisAnalysis Detailed systems designDetailed systems design ImplementationImplementation MaintenanceMaintenance
It is an iterative procedure rather thanIt is an iterative procedure rather than
sequential procedure (contains refining) sequential procedure (contains refining)
Systems Development Life Systems Development Life
Cycle (SDLC) Cycle (SDLC)
Figure 6.
Systems Development Systems Development
Life Cycle Life Cycle
SDLC’s planning phaseSDLC’s planning phase Study existing systemStudy existing system Explore alternative solutionsExplore alternative solutions Feasibility study:Feasibility study: Technical (Technical aspects of hardware andTechnical (Technical aspects of hardware and software requirement) software requirement) Financial (System cost, labor cost, …)Financial (System cost, labor cost, …)
Systems Development Life Systems Development Life
Cycle (SDLC) Cycle (SDLC)
SDLC’s analysis phaseSDLC’s analysis phase Great detail examination based on theGreat detail examination based on the previous phase (planning phase) previous phase (planning phase) Address both individual (user) needs orAddress both individual (user) needs or organizational needs organizational needs Existing hardware and software systemsExisting hardware and software systems are studied to find out current systems are studied to find out current systems performance, functionality, and potential performance, functionality, and potential problem, as well as future opportunities problem, as well as future opportunities
Systems Development Life Systems Development Life
Cycle (SDLC) Cycle (SDLC)
SDLC’s detailed system design phaseSDLC’s detailed system design phase Complete the design of the system processesComplete the design of the system processes (^) All technical specificationsAll technical specifications (^) MenusMenus ReportsReports DevicesDevices (^) Conversion from old systemConversion from old system TrainingTraining MethodologiesMethodologies
Systems Development Life Systems Development Life
Cycle (SDLC) Cycle (SDLC)
SDLC’s implementation phaseSDLC’s implementation phase Hardware, DBMS software, andHardware, DBMS software, and application programs are installed application programs are installed Database design is implementedDatabase design is implemented Actual database is createdActual database is created Tables, views, user authorizationTables, views, user authorization