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.

Nội dung trích xuất từ tài liệu:
Lecture Chapter 13: Designing databases 13 13 Learning Objectives Chapter 13:  Describe the differences and similarities between Designing Databases relational and object-oriented database management systems Systems Analysis and Design in a Changing  Design a relational database schema based on World, 3rd Edition 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 13 Learning Objectives (continued) Overview  Design a relational schema to implement a hybrid  This chapter describes design of relational and object-relational database OO data models  Developers transform conceptual data models into detailed database models  Describe the different architectural models for distributed databases  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 3 Systems Analysis and Design in a Changing World, 3rd Edition 4 13 13 Databases and Database Components of a DB and DBMS 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 controlsSystems Analysis and Design in a Changing World, 3rd Edition 5 Systems Analysis and Design in a Changing World, 3rd Edition 6 13 13 DBMS Important Capabilities Database Models  Simultaneous access by multiple users and  Impacted by technology changes since 1960s applications  Model Types  Hierarchical  Access to data without application programs (via  Network a query language)  Relational  Object-oriented  Managing organizational data with uniform  Most current systems use relational or object- access and content controls oriented data modelsSystems Analysis and Design in a Changing World, 3rd Edition 7 Sy ...