TAILIEUCHUNG - Lecture Database management systems - Chapter 2: Entity relationship model

Lecture Database management systems - Chapter 2: Entity relationship model. This chapter includes contents: Introduction, overview of database design, ER model basics, symbols used in ER diagram, attribute classification, ER diagram, relationship degree, relationship classification,. | Chapter 2 Entity Relationship Model Introduction Modeling databases using a graphical technique is proposed so that humans can relate to easily. ER Model is based on a perception of a real world that consists of collection of basic objects called entities and relationships among these objects. Overview of Database Design Conceptual design: (ER Model is used at this stage.) A database “schema” in the ER Model can be represented pictorially (ER diagrams). The next step in DB design is the actual implementation of the database, using a commercial DBMS By using the DBMS, conceptual design from high-level data model will be transformed into the implementation data model. COMPANY example The COMPANY database keeps track of company’s employee, departments, and projects Suppose that after the requirement collection and analysis phase, the database designers provide the following description: COMPANY example The company is organized into DEPARTMENTs. Each department has a name, number and an employee who manages the department. The start date of the department manager will be kept track. A department may have several locations. Each department controls a number of PROJECTs. Each project has a unique name, unique number and is located at a single .

• Cơ sở dữ liệu
• Database management systems
• Lecture Database management systems
• Entity relationship model
• Database design
• ER Diagram
• ER model
• Lecture Database Systems
• Database systems
• Database systems concepts
• Database systems architecture
• Database languages
• Data management systems framework
• File based system
• Characteristics of the database
• Data dictionary
• Fundamentals of database management systems
• Logical database design
• Physical database design
• Object oriented database management
• Data administration
• Bài giảng Hệ quản trị cơ sở dữ liệu
• Operating systems
• Attribute alias
• Relational database design
• EER to relational mapping
• Mapping EER model
• Regular entity types
• Database application development process
• Data flow diagrams
• Lecture Distributed Database Management Systems
• Distributed Database Management Systems
• Bài giảng Hệ quản trị cơ sở dữ liệu phân tán
• Transaction management
• Database consistency
• Database development
• Relational databases
• Database environments
• Object database management systems
• Object database
• Distributed database systems
• Principles of distributed database systems
• Cơ sở dữ liệu phân tán
• Peer to peer data management
• Peer reference architecture
• Web data management
• Web models
• Relational model
• Relational data model
• Relational database
• Relation schema
• Database definition
• Commercial applications
• File processing system
• Database architecture
• Data independence
• Conceptual schema
• Physical implementation of the database
• Physical data independence
• Cross reference matrix
• Database modeling
• Entity relationship data model
• Semantic data model
• Conceptual database design
• Data flow diagram
• E R data model
• E R database design
• Mathematical relations
• Normalization summary
• Data processing
• Consistent state of the database
• Transaction terminates
• Transaction boundaries
• Traditional file processing system
• Database approach
• Distributed computing system
• Fragmentation transparency
• Operating system
• Data modeling
• Relational data retrieval
• Relational database model
• Introduction to MIS
• Management Information Systems
• Information systems
• Database applications