CH13 - Systems Analysis and Design in a Changing World...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
13 Chapter 12: Designing Databases Systems Analysis and Design in a Changing World, Fourth Edition
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
13 Systems Analysis and Design in a Changing World, 5th Edition 2 Learning Objectives Describe the differences and similarities between relational and object-oriented database management systems Design a relational database schema based on an entity-relationship diagram Design an object database schema based on a class diagram Design a relational schema to implement a hybrid object-relational database Describe the different architectural models for distributed databases
Background image of page 2
13 Systems Analysis and Design in a Changing World, 5th Edition 3 Overview This chapter describes design of relational and OO data models Developers transform conceptual data models into detailed database models Entity-relationship diagrams (ERDs) for traditional analysis Class diagrams for object-oriented (OO) analysis Detailed database models are implemented with database management system (DBMS) d
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
13 Systems Analysis and Design in a Changing World, 5th Edition 4 Databases and Database Management Systems Databases (DB) – integrated collections of stored data that are centrally managed and controlled Database management system (DBMS) – system software that manages and controls access to database Databases described by a schema – description of structure, content, and access controls
Background image of page 4
13 Systems Analysis and Design in a Changing World, 5th Edition 5 Components of a DB and DBMS Figure 13-1
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
13 Systems Analysis and Design in a Changing World, 5th Edition 6 Important DBMS Capabilities Simultaneous access by multiple users and applications Access to data without application programs (via a query language) q Organizational data management with uniform access and content controls
Background image of page 6
13 Systems Analysis and Design in a Changing World, 5th Edition 7 Database Models Impacted by technology changes since 1960s Model types Hierarchical Network Relational Object-oriented Most current systems use relational or object- oriented data models
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
13 Systems Analysis and Design in a Changing World, 5th Edition 8 Relational Databases Relational database management system (RDBMS) organizes data into tables or relations Tables are two dimensional data structures Tuples – rows or records Fields – columns or attributes Tables have primary key field(s) that can be used to identify unique records Keys relate tables to each other
Background image of page 8
13 Systems Analysis and Design in a Changing World, 5th Edition 9 Partial Display of Relational Database Table Figure 13-2
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
13 Systems Analysis and Design in a Changing World, 5th Edition 10 Designing Relational Databases Create table for each entity type Choose or invent primary key for each table Add foreign keys to represent one-to-many relationships Create new tables to represent many-to-many relationships
Background image of page 10
13 Systems Analysis and Design in a Changing World, 5th Edition
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/08/2010 for the course BUSINESS 4456 taught by Professor Blackwell during the Spring '10 term at West Liberty.

Page1 / 54

CH13 - Systems Analysis and Design in a Changing World...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online