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 design life cycle ppt

22/10/2021 Client: muhammad11 Deadline: 2 Day

Database 9 Assignment

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

Conceptual

Design

DBMS

Selection

Logical

Design

Physical

Design

Data analysis and requirements
Entity Relationship modeling and normalization
Data model verification
Distributed database design
Map conceptual model to logical model components
Validate logical model using normalization
Validate logical model integrity constraints
Validate logical model against user requirements
Define data storage organization
Define integrity and security measures
Determine performance measures
Select the DBMS

©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:

Study Master
Essay Writing Help
Custom Coursework Service
Assignment Hub
ECFX Market
Buy Coursework Help
Writer Writer Name Offer Chat
Study Master

ONLINE

Study Master

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$15 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$31 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$28 Chat With Writer
Assignment Hub

ONLINE

Assignment Hub

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.

$17 Chat With Writer
ECFX Market

ONLINE

ECFX Market

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$26 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$16 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

Decision making assignment - Work health and safety whs management plan - University health service monash - Business management - Nation to australia's north west - Kent law school admissions - Vi characteristics of germanium diode - How to install fence droppers - Indra nooyi interview questions and answers - Netop remote control download - Descriptive and inferential statistics - Health care finance basic tools for nonfinancial managers 5th edition - Apply 3.1 - Las posadas traditional songs - Valuing people now 2007 - 108.3 kg in stone - Topic 1 Week 5 - 1.06 macbeth character development - Count me in too online - Paladin tools 1573 manual - Becky frankiewicz net worth - 1 Page Essay about being an Athletic trainer - Why does st louis have colder winters than norfolk - Argumentative essay should college be free - Final Paper - Colin jensen brisbane city council - The beauty myth naomi wolf pdf español - Itt tech admission requirements - 213 bunche circle cowpens sc - Assignment 1.1 a changing world thesis and outline - Principles of incident response and disaster recovery, 2nd edition pdf download - Why would a good communicator combine ethics with responsibility - Organisational standards for creating business documents - 98 harewood avenue bournemouth - What did ed snowden do to break the law - Please read the case and answer the questions below. Your submission should be about 3-4 pages (double-spaced). Please use only the information in the case to complete this assignment. - Summary of the child is not dead by ingrid jonker - Health behavior theory third edition - Chemistry Signature Assignment - Probable signs of pregnancy hegar's sign - EDU - Voltage proportional to current - Create a local database entry for chap authentication - Discussion Social Problems - Ai weiwei school bags - Computer science illuminated chapter 4 answers - The cask of amontillado essay questions - Oaths affidavits and statutory declarations act - Moorebank sports club hammondville nsw - Mi abuela se jubiló y se mudó (moved) a viña del mar - Hobbit essay 2 page - Hnd business graded unit - Reading Summary - 7 Discussion Board: Evolution, Malaria, and Mosquitoes - Final - Homer tomorrow when the war began essay - Sc0-60 deluxe can opener - Economic 4 - Harvard Business Case - Logistics management assignment - Igolder encrypt - Aqua dragons male and female - Ford fiesta case study pdf - How to prepare a statement of retained earnings - Online job portal project documentation in php pdf - How to find the z score in excel - Terry hill framework operations strategy - Distinguish between absolute and comparative advantage - Headline bbp - Biology - Essay - Light bulb input energy - Reebok competitor rt 5.1 treadmill costco - Dartmouth high school nova scotia - Dr peter whang guilford ct - What is a secondment - Hockenberry family care funeral home in atlantic - Persuasive speech outline and speech - How to compute bmi in spss - Mezzo level of social work - Pitot tube traverse calculation - Essay - 3 types of financial management decisions - Answers to textbook questions and problems - Nova elements periodic table - The usual starting point for a master budget is - Learning or cognitive personality theories podcast - Macbeth characterization graphic organizer - Racemization organic chemistry - Corsham computer centre ufo - Economic value added advantages and disadvantages ppt - A street cat named bob sparknotes - Reporting - How to link a slide in google slides - The body shop stakeholders - 10 Pieces of Research - Galette des rois date - Electricity webquest answer key pdf - Pipe makers canning vale - Fe reference handbook 10 pdf