Learning objectives in this chapter: 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,. | Chapter 13: Designing Databases Systems Analysis and Design in a Changing World, 3rd Edition 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 Learning Objectives (continued) Design a relational schema to implement a hybrid object-relational database Describe the different architectural models for distributed databases 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) 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 Components of a DB and DBMS 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 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 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) which can be used to identify unique records Keys relate tables to each other Partial Display of . | Chapter 13: Designing Databases Systems Analysis and Design in a Changing World, 3rd Edition 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 Learning Objectives (continued) Design a relational schema to implement a hybrid object-relational database Describe the different architectural models for distributed databases 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) Databases and Database Management Systems Databases (DB) – integrated collections of stored data that are centrally
