13 Chapter 13: Designing Databases Systems Analysis and Design in a Changing World, 3rd Edition 13 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 Systems Analysis and Design in a Changing World, 3rd Edition 2 13 Learning Objectives (continued) Design a relational schema to implement a hybrid object-relational database Describe the different architectural models for distributed databases Systems Analysis and Design in a Changing World, 3rd Edition 3 13 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) Systems Analysis and Design in a Changing World, 3rd Edition 4 Databases and Database Management Systems 13 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 Systems Analysis and Design in a Changing World, 3rd Edition 5 13 Components of a DB and DBMS Systems Analysis and Design in a Changing World, 3rd Edition 6 13 DBMS Important Capabilities Simultaneous access by multiple users and applications Access to data without application programs (via a query language) Managing organizational data with uniform access and content controls Systems Analysis and Design in a Changing World, 3rd Edition 7 13 Database Models Impacted by technology changes since 1960s Model Types Hierarchical Network Relatio