Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Database development life cycle ppt

26/11/2021 Client: muhammad11 Deadline: 2 Day

Database Systems Design, Implementation, and Management

Coronel | Morris

11e

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Chapter 9

Database Design

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Learning Objectives

In this chapter, you will learn:
That successful database design must reflect the information system of which the database is a part
That successful information systems are developed within a framework known as the Systems Development Life Cycle (SDLC)
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Learning Objectives

In this chapter, you will learn:
That within the information system, the most successful databases are subject to frequent evaluation and revision within a framework known as the Database Life Cycle (DBLC)
How to conduct evaluation and revision within the SDLC and DBLC frameworks
About database design strategies: top-down vs. bottom-up design and centralized vs. decentralized design
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

The Information System

Provides for data collection, storage, and retrieval
Composed of:
People, hardware, software
Database(s), application programs, procedures
Systems analysis: Process that establishes need for and extent of information system
Systems development: Process of creating information system
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Performance Factors of an Information System

Database design and implementation
Application design and implementation
Administrative procedures
Database development: Process of database design and its implementation
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Systems Development Life Cycle (SDLC)

Traces history of an information system
Provides a picture within which database design and application development are mapped out and evaluated
Iterative rather than sequential process
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Figure 9.2 - The Systems Development Life Cycle (SDLC)

Cengage Learning © 2015

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Computer-Aided Systems Engineering (CASE)

Tool that produces:
Time and cost effective systems
Structured, documented, and standardized applications
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Figure 9.3 - The Database Life Cycle (DBLC)

Cengage Learning © 2015

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Purpose of Database Initial Study

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Figure 9.4 - A Summary of Activities in the Database Initial Study

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Database Design

Supports company’s operations and objectives
Checks the ultimate final product from all perspectives
Pointers for examining completion procedures
Data component is an element of whole system
System analysts/programmers design procedures to convert data into information
Database design is an iterative process
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Figure 9.5 - Two Views of Data: Business Manager and Database Designer

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Database Design Process

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Implementation and Loading

Install the DBMS
Virtualization: Creates logical representations of computing resources independent of underlying physical computing resources
Create the databases
Requires the creation of special storage-related constructs to house the end-user tables
Load or convert the data
Requires aggregating data from multiple sources
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Testing Factors

Physical security
Password security
Access rights
Audit trails
Data encryption
Diskless workstations
Optimization
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Levels of Database Backups

Full backup/dump: All database objects are backed up in their entirety
Differential backup: Only modified/updated objects since last full backup are backed up
Transaction log backup: Only the transaction log operations that are not reflected in a previous backup are backed up
Backups are provided with high security
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Sources of Database Failure

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Periodic Maintenance Activities

Preventive maintenance (backup)
Corrective maintenance (recovery)
Adaptive maintenance
Assignment of access permissions and their maintenance for new and old users
Generation of database access statistics
Periodic security audits
Periodic system-usage summaries
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Figure 9.8 - Parallel Activities in the DBLC and the SDLC

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Conceptual Design

Designs a database independent of database software and physical details
Conceptual data model - Describes main data entities, attributes, relationships, and constrains
Designed as software and hardware independent
Minimum data rule: All that is needed is there, and all that is there is needed
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Table 9.2 - Conceptual Design Steps

Cengage Learning © 2015

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Description of Operations

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Table 9.3 - Developing the Conceptual Model Using ER Diagrams

Cengage Learning © 2015

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Figure 9.10 - ER Modeling is an Iterative Process Based on Many Activities
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Figure 9.11 - Conceptual Design Tools and Information Sources

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Data Model Verification

Verified against proposed system processes
Revision of original design
Careful reevaluation of entities
Detailed examination of attributes describing entities
Module: Information system component that handles specific business function
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Table 9.5 - The ER Model Verification Process

Cengage Learning © 2015

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Figure 9.12 - Iterative ER Model Verification Process

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Cohesivity and Module Coupling

Cohesivity: Strength of the relationships among the module’s entities
Module coupling: Extent to which modules are independent to one another
Low coupling decreases unnecessary intermodule dependencies
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Distributed Database Design

Portions of database may reside in different physical locations
Database fragment: Subset of a database stored at a given location
Ensures database integrity, security, and performance
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Factors Affecting Software Purchasing Decision

Cost
DBMS features and tools
Underlying model
Portability
DBMS hardware requirements
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Logical and Physical Design

Logical design: Designs an enterprise-wide database that is based on a specific data model but independent of physical-level details
Validates logical model:
Using normalization
Integrity constraints
Against user requirements
Physical design: Process of data storage organization and data access characteristics of the database
*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Table 9.6 - Logical Design Steps

Cengage Learning © 2015

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Table 9.7 - Mapping the Conceptual Model to the Relational Model

Cengage Learning © 2015

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Table 9.8 - Physical Design Steps

Cengage Learning © 2015

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Clustered Tables

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Database Role

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Figure 9.14 - Top-down vs. Bottom-up Design Sequencing

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Figure 9.15 - Centralized Design

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Figure 9.16 - Decentralized Design

*

©2015 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.

Figure 9.17 - Summary of Aggregation Problems

*

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Homework Tutor
Top Class Engineers
Engineering Mentor
Helping Hand
Fatimah Syeda
Innovative Writer
Writer Writer Name Offer Chat
Homework Tutor

ONLINE

Homework Tutor

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$41 Chat With Writer
Top Class Engineers

ONLINE

Top Class Engineers

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$45 Chat With Writer
Engineering Mentor

ONLINE

Engineering Mentor

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$20 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$50 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$32 Chat With Writer
Innovative Writer

ONLINE

Innovative Writer

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$36 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

The water level in a vertical glass tube - What is an isobar - Gopro innovation case study - Diagnostic formative and summative assessment - What time is 12 55 am - On the willows godspell karaoke - A new soft drink is being market tested - Warning avoid feeling ordinary while rocking these threads hoodie - Case study 5.1 predicting harry's work effort - Networker 19 compatibility matrix - Kingdom hearts 1.5 deep jungle recipe cards - Magnesium chloride hydrate empirical formula - Cell structure and function lab answers - Discussion - Jeannette rankin peace center - St george mortgage centre - COLLABORATIVE LEARNING COMMUNITY - We real cool summary - Suppose that omar's marginal utility for cups - One sample hypothesis testing cases speedx - Why is antarctica so cold - Evidence Table for the follwoing PICOTS questions - Which sentence in the passage contains an allusion - Psychology Paper - Benchmark - Community Teaching Plan: Community Teaching Work Plan Proposal - Rock around the clock line dance steps - Shadow health musculoskeletal tina jones - Helmer blood bank refrigerator service manual - Edit My Paper Narrative Paper - Analyse hsc verb scaffold - New york mets epithet nyt crossword - Laurence shames the more factor - Questions - Module 6 Project Deliverables: Waste Walk & Root Cause Analysis - Brehm v eisner case brief - Lace presentation - Pet shop mt colah - Untouched serve in tennis - Neeraj kanwar net worth - Magnetic field midway between two parallel wires - Uno card game java source code - Midshires College of Midwifery and Nursing - Rehabilitation counselling courses in australia - Energy dissipation in hydraulic jump - Models for writers answer key - Woolworths car insurance offer - Introduction to parallel computing 2nd edition pdf free download - Cloud Computing - Health informatics an interprofessional approach - Teachers registration board sa - Pablo picasso seated woman holding a fan - Goldratt simulator params 310 solution - Ict customer support officer anzsco - Business analytics by camm et al 3rd edition cengage - One page - Http www businessballs com howardgardnermultipleintelligences htm - Still alive ruth kluger chapter summaries - Seen from the northern latitudes the star polaris - Cost of Capital - Mabel park high school - Operational Excellence - Dosing syphon wastewater treatment works - An accusation of sexual harassment in pro sports - Assignment - Why does paris attack romeo at the tomb - Flemings trees crepe myrtle - River north wine fest groupon - Steve biko academic hospital occupational therapy pretoria - Wheelen and hunger strategic management pdf - Http digital wwnorton com movies5 - Menschen a1 coursebook pdf - Discussion, APA 6, 2 References, Similarities Less 5% - Piedmont airlines flight attendant contract - The apprenticeship of duddy kravitz quotes - Genetically modified foods harmful or helpful deborah b whitman - Rochester midland corporation uk - Millipore billerica ma usa - Innovation in Leadership - Assume that sparks uses a perpetual specific identification inventory system - Cognos impromptu end of life - BE- Case Study 4 - Hw module session 1 0 - Frontiers in ecology and the environment - Document analysis questions answers - Co nh3 5 h2o cl3 - Florentines saratoga menu - Buff beatnik project juice calories - SOCS185N: Culture and Society - Al zahra funeral services - Arroz con pollo café con leche cereales espárragos huevos refresco sándwich de jamón entremeses - Introduction to accounting wahseem soobratty - Research Paper - Stephens ink thermometer for sale - PHIL 330 Ethics - Hotel on the corner of bitter and sweet sparknotes - Toby lane tower hamlets - What is fartlek training - Hyde park neighborhood kansas city - Coastal tyres direct urangan - Klip lok classic 700