tailieunhanh - Lecture Business driven technology (Technology plug-in): Chapter 5 - Paige Baltzan, Amy Phillips

Chapter 5 - Designing database applications. Learning objectives of this chapter include: Describe the purpose of the relational database model in a database management system, list the relational database model’s basic components, describe why entities and attributes are organized into tables, describe how data redundancy is handled in the relational database model, | TECHNOLOGY PLUG-IN T5 Designing Database Applications LEARNING OUTCOMES Describe the purpose of the relational database model in a database management system List the relational database model’s basic components Describe why entities and attributes are organized into tables Describe how data redundancy is handled in the relational database model LEARNING OUTCOMES Explain the need for an entity-relationship Diagram in a database management system Describe the Chen model symbols used in entity-relationship modeling Explain the purpose of normalization Describe the first three normal forms typically used in normalization INTRODUCTION The core chapters introduced: Database - maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) Database management system (DBMS) - software through which users and application programs interact with a database Relational database model - a type of database that stores | TECHNOLOGY PLUG-IN T5 Designing Database Applications LEARNING OUTCOMES Describe the purpose of the relational database model in a database management system List the relational database model’s basic components Describe why entities and attributes are organized into tables Describe how data redundancy is handled in the relational database model LEARNING OUTCOMES Explain the need for an entity-relationship Diagram in a database management system Describe the Chen model symbols used in entity-relationship modeling Explain the purpose of normalization Describe the first three normal forms typically used in normalization INTRODUCTION The core chapters introduced: Database - maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) Database management system (DBMS) - software through which users and application programs interact with a database Relational database model - a type of database that stores its information in the form of logically-related two-dimensional tables ENTITIES AND DATA RELATIONSHIPS Data model - a formal way to express data relationships to a database management system (DBMS) The underlying relationships in a database environment are: Independent of the data model Independent of the DBMS that is being used Before designing a database for any data model, data relationships need to be defined Entity-relationship diagram (ERD) - a technique for documenting the relationships between entities in a database environment Entities And Their Attributes Entity - also called a table, is a person, place, thing, transaction, or event about which information is stored A customer is an entity, as is a merchandise item Attributes, also called fields or columns, are characteristics or properties of an entity class Example: A CUSTOMER entity can be described by a Customer Number, First Name, Last Name, Street, City, State, Zip Code, Phone Number, Credit Card No, and Credit Card .

• Quản trị kinh doanh
• Business driven technology
• Lecture Business driven technology
• Technology plug in
• Business plug ins
• Designing database applications
• Database management system
• Business process
• Business process improvement
• Mobile technology
• Personal digital assistants
• Business basics
• Financial statement
• Business intelligence
• Data mining
• Global information systems
• Cultural business challenges
• Creating strong passwords
• Monitor your accounts
• Creating conditional formatting
• Using autofilter
• Goal Seek Command
• Decision making using excel
• Microsoft Access
• New blank database
• Simple query wizard
• Advanced queries
• Form wizard in access
• Report wizard
• Designing web pages
• World wide web
• Hypertext Markup Language
• Improving readability
• Navigating in dreamweaver
• Dreamweaver setup
• Gantt chart
• Creating gantt charts with excel
• Central processing unit
• Primary storage
• Enterprise architectures
• Disaster recovery
• Network basics
• Server network
• Information security
• Information security policies
• Information privacy policy
• Ethical computer use policy
• Supply chain management
• Supply chain drivers
• Customer relationship management
• Operational CRM
• Enterprise resource management
• Core ERP component
• Ebusiness model
• Accessing internet information