Database Systems: Design, Implementation, and Management

Database Systems Design Implementation And Management-ppt Download

  • Date:25 Jun 2020
  • Views:33
  • Downloads:0
  • Size:1.27 MB

Share Presentation : Database Systems Design Implementation And Management

Download and Preview : Database Systems Design Implementation And Management

Report CopyRight/DMCA Form For : Database Systems Design Implementation And Management


Transcription:

The University Lab ConceptualDesign Verification Logical Design and ImplementationHachim HaddoutiIn this chapter you will learn .
How the Lab Management System modules are defined and How attributes and domains are identified and defined foreach of the entities defined in the initial E R model How the database transactions are identified and definedwithin the system modules.
That the design verification process uses modeling andnormalization techniques concurrently to find and eliminatedata redundancies Review the steps of database implementation Review the steps of database testing and evaluation.
Review the steps of database operationHachim Haddouti and Rob Coronel Ch7 2Completing Conceptualand Logical Design Detail Matters .
Entity relationship modeling and normalization Data model verification Logical design Physical design Implementation.
Testing and Evaluation Operation Primary modules Lab Management System Inventory Management System.
Hachim Haddouti and Rob Coronel Ch7 3Entities IdentifiedHachim Haddouti and Rob Coronel Ch7 4Completion of Conceptual Design Refine module definition.
Entities Attributes Normalization process Discover new entities Revise attributes.
Hachim Haddouti and Rob Coronel Ch7 5 Lab Management System 8Module E R SegmentHachim Haddouti and Rob Coronel Ch7 6USER Entity.
Hachim Haddouti and Rob Coronel Ch7 7LOG EntityHachim Haddouti and Rob Coronel Ch7 8LAB ASSISTANT EntityHachim Haddouti and Rob Coronel Ch7 9.
WORK SCHEDULE EntityHachim Haddouti and Rob Coronel Ch7 10HOURS WORKED EntityHachim Haddouti and Rob Coronel Ch7 11RESERVATION Entity.
Hachim Haddouti and Rob Coronel Ch7 12Revised RESERVATION EntityHachim Haddouti and Rob Coronel Ch7 13RES SLOT Weak EntityHachim Haddouti and Rob Coronel Ch7 14.
Inventory Management 8Module E R SegmentHachim Haddouti and Rob Coronel Ch7 15INV Type EntityHachim Haddouti and Rob Coronel Ch7 16.
ITEM EntityHachim Haddouti and Rob Coronel Ch7 17STORAGE EntityHachim Haddouti and Rob Coronel Ch7 18LOCATION Entity.
Hachim Haddouti and Rob Coronel Ch7 19REPAIR EntityHachim Haddouti and Rob Coronel Ch7 20VENDOR EntityHachim Haddouti and Rob Coronel Ch7 21.
ORDER EntityHachim Haddouti and Rob Coronel Ch7 22ORDER ITEM EntityHachim Haddouti and Rob Coronel Ch7 23WITHDRAW Entity Revision.
Hachim Haddouti and Rob Coronel Ch7 24WITHDRAW Entity and RevisionHachim Haddouti and Rob Coronel Ch7 25WD ITEM Weak EntityHachim Haddouti and Rob Coronel Ch7 26.
CHECK OUT Design RevisionHachim Haddouti and Rob Coronel Ch7 27CHECK OUT EntityHachim Haddouti and Rob Coronel Ch7 28CHECK OUT ITEM Weak Entity.
Hachim Haddouti and Rob Coronel Ch7 29E R Model Verification Establishes Design reflects end user views of database Database transactions defined and modeled so design.
supports related requirements Design meets output requirements Design supports required input screens and data entry Design flexible to support future enhancements Verification identifies.
Central entity Each module and its components Each module transaction requirementHachim Haddouti and Rob Coronel Ch7 30Inventory Management.
Reporting Problems Generates three reports one is inventory movement Inventory movements spread across different entities Difficult to generate output and reduces performance Item quantity on hand updated with different.
inventory movements Purchase withdraw check out check in or inventoryadjustment Only withdrawals and check outs represented inHachim Haddouti and Rob Coronel Ch7 31.
Inventory ManagementReporting Problems Solution Create new entity as common movement entry INV TRANS created Standardizes inventory module interfaces.
Facilitates control and generation of requiredHachim Haddouti and Rob Coronel Ch7 32Inventory Transaction ProcessFigure 8 25Hachim Haddouti and Rob Coronel Ch7 33.
INV TRANS EntityTable 8 26Hachim Haddouti and Rob Coronel Ch7 34TR ITEM Weak EntityHachim Haddouti and Rob Coronel Ch7 35.
Revised University Computer Lab ERDHachim Haddouti and Rob Coronel Ch7 36Logical Design Translates conceptual model to format forselected DBMS.
Sets stage for creating table structures indexes Table structures can be created with CREATETABLE SQL commands Views created with CREATE VIEW SQL Indexes created with CREATE INDEX SQL.
Hachim Haddouti and Rob Coronel Ch7 37Physical Design Defines specific storage or access methodsused by database Includes estimate of storage space.
Characteristics are function of DBMS andoperating systemsHachim Haddouti and Rob Coronel Ch7 38Implementation Database administrator DBA .
Controls database management function Defines standards and procedures required to interact withthe database Adopts appropriate plan Plan elements.
Definitions of processes and standards Chronology of required activities Database creation Loading and Conversion Documentation standards.
Responsibilities for continued development and maintenanceHachim Haddouti and Rob Coronel Ch7 39Testing and Evaluation Determine how well database meets goals Ongoing process.
Considerations Performance measures Security Backup and recovery proceduresHachim Haddouti and Rob Coronel Ch7 40.
Provides support for daily operations Maintains operational procedures Database maintenance and evolution DBA performs technical and managerial duties toensure proper operation of database to support.
organizational missionHachim Haddouti and Rob Coronel Ch7 41The University Lab: Conceptual Design Verification, Logical Design, and Implementation Hachim Haddouti In this chapter, you will learn: How the Lab Management System modules are defined and refined How attributes and domains are identified and defined for each of the entities defined in the initial E-R model How the database transactions are identified and defined within the system modules ...

Related Presentations

Database Systems Design Implementation and Management

Chapter 2. Data Models ©2017 Cengage Learning®. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website or school-approved learning management system for classroom use.

48 Views0 Downloads

Database Systems Design Implementation and Management Ninth Edition

A relational database guarantees the ACID properties: A. tomicity, C. onsistency, I. solation, D. urability. In short, a set of SQL statements (called a transaction) will either completely work or completely fail—no half way success, and the result will not corrupt the database. A price to pay: results might be somewhat slow

2 Views0 Downloads

Database Design and Implementation 67 304

Arts, design, entertainment, and media occupations. MSA-level data is directly calculated. County-level data is estimated based on industry and occupation employment data from the Census. (R2 of estimation equation is above 0.98.) ... Database Design and Implementation (67-304) Last modified by: Kevin Stolarick Company:

9 Views0 Downloads

CSCI 4333 Database Design and Implementation Review for

CSCI 6315 Applied Database Systems Review for Final Exam. Xiang Lian. The University of Texas Rio Grande Valley. Edinburg, TX 78539. [email protected] Review. Chapters 5, 6-8, 14-15, and 22 in your textbook. ... CSCI 4333 Database Design and Implementation Review for Midterm Exam I

12 Views0 Downloads

Systems Design Implementation and Operation

File and database design . Input design (e.g., forms, computer screen input) Program design. Procedures design. Control design. 22-Program Design. Determine user needs. Create and document development plan. Write the computer code. ... Systems Design, Implementation, and Operation Last modified by:

10 Views0 Downloads

Services based Systems Architecture Design and Implementation

Services-based Systems Architecture, Design and Implementation B.Ramamurthy

9 Views0 Downloads

Design and Implementation of Speech Recognition Systems

Design and Implementation of Speech Recognition Systems. Spring 2011. Bhiksha Raj, Rita Singh. Class 1: Introduction. 19 Jan 2011

5 Views0 Downloads

Database Models Flat Files and the Relational Database

Database Models: Flat Files and the Relational Database Objectives: Understand the fundamental structure of the relational database model Learn the circumstances under which it is a better choice than the flat file

27 Views0 Downloads

Database systems design SUNY Oswego

Comparison of Logical and Physical Database Design. Sources of information for physical design process includes global logical data model and documentation that describes model. Conceptual and logical . database design . are . concerned with the . what, physical database design is concerned with the . how.

28 Views0 Downloads

Database systems design Oswego

Logical database design Process of constructing a model of information used in an enterprise based on a specific data model (e.g. relational), but independent of a particular DBMS and other physical considerations.

30 Views0 Downloads

Database systems design cs oswego edu

Fact-finding used throughout the database application lifecycle. Crucial to the early stages including database planning, system definition, and requirements collection and analysis stages. Enables developer to learn about the terminology, problems, opportunities, constraints, requirements, and priorities of the organization and the users of ...

8 Views0 Downloads

Database systems design

Secure a MySQL/PHP . application. Example. 12/3/2012. ISC329 Isabelle Bichindaritz . HTTP is a stateless protocol – it cannot maintain the state between two transactions. When a user requests a page following another one, HTTP does not track whether both pages come from the same user (they are independent).

10 Views0 Downloads