tailieunhanh - Lecture Chapter 13: Designing databases

Lecture "Chapter 13: Designing databases" provides students with the knowledge: Learning objectives, databases and database management systems, components of a DB and DBMS, DBMS important capabilities, relational databases, partial display of relational database,. Invite you to consult. | Learning Objectives Chapter 13 Designing Databases Describe the differences and similarities between relational and object-oriented database management systems Systems Analysis and Design in a Changing World 3rd Edition 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 3 d Edition . _________________________ 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 3 d 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 Systems Analysis and Design in a Changing World 3 d 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 Systems Analysis and Design in a Changing World 3 d Edition 5 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 Database Models Impacted by technology changes since 1960s Model Types Hierarchical Network Relational Object-oriented Most current systems use relational or object-oriented .