1 / 26

Database Development Cycle

Database Development Cycle. Track 3: Managing Information Using Database. Objectives. Database planning System Definition Requirements collection and analysis Database design DBMS selection Application design Prototyping Implementation Data Conversion and loading Testing

mara-peters
Download Presentation

Database Development Cycle

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Development Cycle Track 3: Managing Information Using Database

  2. Objectives • Database planning • System Definition • Requirements collection and analysis • Database design • DBMSselection • Application design • Prototyping • Implementation • Data Conversion and loading • Testing • Operational Maintenance

  3. Database Planning Systems Definition Requirements Collection and analysis Database Design Application Design DBMS Selection Implementation Data Conversion and loading Testing Evaluation & Maintenance Prototyping Life Cycle Source: http://www.cs/ucf.edu/courses/cgs2545/CH02/index.htm

  4. Current systems evaluation Development of Standards Technological feasability Operational feasability Economical feasability Database Planning

  5. Systems definition Requirements Collection and Analysis Metadata Data dictionary • identifying management information requirements, • determining information requirements by functional area, • and establishing hardware and software requirements

  6. Database Design Conceptual design Logical design Physical design

  7. DBMS Selection • Costs • Features and Tools • Underlying model • Portability • DBMS hardware requirements

  8. Application design • Application program design • User Interface design

  9. Develop the working model Build the prototype Use and Test the prototype Review the prototype Abandon application Implement Application Redevelop Application Begin new prototype Decision Prototyping

  10. Implementation • The physical realisation of the database and application designs • the detailed model is converted to the appropriate implementation model, the data dictionary is built, the database is populated, application programs are developed and users are trained

  11. Data Conversion and Loading & Testing • Transferring any existing data into the new database and converting any existing applications to run on the new database • Finding errors

  12. Database Evaluation • Interviewing and polling users to determine whether any data needs are unmet.

  13. Operational maintenance • preventive maintenance (backup) • corrective maintenance (recovery)1 • adaptive maintenance • assignment of access • regular monitoring & periodical check up

  14. Data & Database administration • Data administration is the management of the data resources • Database administration is the management of physical realisation of the database application

  15. Database design methodology • A structured approach that uses procedures, techniques, tools, and documentation aids to support and facilitate the process of design. • Conceptual database design • Logical database design • Physical database design

  16. Passport Passport No Exp.Data Client Itinerary Name Address Postcode Date City Contact Entity, Attribute, Relationship Entity Attribute Relationship

  17. Conceptual Design Phase

  18. is married to HUSBAND WIFE is married to has TRACK PARTICIPANTS belongs to Basic relationships • One-to-One • One-to-many • Many to many holds Trainer Track is helds in

  19. Logical design phase Conceptual E.A.R Model 1. REFINE THE CONCEPTUAL MODEL Refined Conceptual Model 2.APPLY THE RULES OF NORMALIZATION Logical Data Model

  20. Refining the Conceptual model • Refine the attributes • example: • Synonyms • Hononyms

  21. Physical Database Design Logical Data Model Logical Process Model Country Track 01 TR Database creation Physical CREATE DATABASE Implementation CREATE TABLE Process LOAD

  22. Critical Success Factors in Database Design • Work interactively with the users as much as possible. • Follow a structured methodology throughout the data modelling process. • Incorporate structural and integrity considerations into the data models. • Combine conceptualisation, normalisation, and transaction validation techniques into the data modelling methodology.

  23. Exercise (Conceptual design) Create a conceptual E.A.R model of the database for the following lists. (List up the necessary DATA ITEMS, set up ENTITIES and their ATTRIBUTES, and identify the relationship among the entities ) List 1 Track No: 1 Track name: Managing information using Database Participant code Participant name Age Position Country Address List 1 is the list of participants’ information by track List 2 Country code Country name Participant code Participant name Track name List 2 is the list of participants’ information by countries

  24. Answer Just one One or many Zero one or many Just one

  25. Exercise: Primary and Foreign Key Please identify primary and foreign key. Participant code Participant name Age Position Address Country code Participant code Track code Track name Country code Country name Primary key Foreign key

  26. Answer Participant code Participant name Age Position Address Country code Participant code Track code Track name Country code Country name

More Related