Skip to main content

MGT300 - Chapter 7: Viewing Database and Protecting Organizational Information

Relational Database Fundamental
-Information is everywhere in an organization
-Information is stored in databases
-Database: maintains information about various types of objects(inventory), events(transactions), people(employees), and places(warehouse)
-Database models include:
l  Hierarchical database model- information is organized into a tree-like structure (using parent/child relationship)in such a way that it cannot have too many relationship


 
l  Network database model- a flexible way of representing objects and their relationship




 
l  Relational database model- stores information in the form of logically related two-dimensional tables

 
v  Entities and Attributes
l  Entities- a person, place, thing, transaction, or event about which information is stored
l  Attributes' (fields, columns)- characteristic or properties of an entity class

Keys and Relationships
-Primary keys and foreign keys identify the various entity classes (tables) in the database
l  Primary key- a field (or group of fields) that uniquely identifies a given entity in a table
l  Foreign key- a primary key of one table that appears an attribute in amother table and acts to provide a logical relationship among the tables

Relational Database Advantages
-Database advantages from a business perspective include
i.          Increased flexibility- A well-designed database should:
*Handle changes quickly and easily
*Provide users with different views
*Have only one physical view
-physical view: deals with the physical storage of information on a storage device. Eg : hard disk
-Logical view: focuses on how users logically access information
ii.        Increased Scalability and Performance- A database must scale to meet increased demand, while maintaining acceptable performance levels
-Scalability- refers to how well a system can adapt to increased demands
-Performance- measures how quickly a system performs a certain process or transaction
 
  Database Management Systems (DBMS)
  • software through which users and application programs interact with a database



BI in a data-driven website


INTEGRATING INFORMATION AMONG MULTIPLE DATABASES
·         Integration – allows separate systems to communicate directly with each other
·         Forward integration – takes information entered into a given system and sends it automatically to all downstream systems and processes
·         Backward integration – takes information entered into a given system and sends it automatically to all upstream systems and processes

INTEGRATING INFORMATION AMONG MULTIPLE DATABASES
Forward integration and backward integration


INTEGRATING INFORMATION AMONG MULTIPLE DATABASES
Building a central repository specifically for integrated information



Comments

Popular posts from this blog

MGT300 - Chapter 11: Building Customer-Centric Organization: Customer Relationship Management

1)CUSTOMER RELATIONSHIP MANAGEMENT (CRM) ➨CRM enables an organization to : a)Provide better customer service because focus more to customer. b)Make call centers more efficient because did not have to pass phone to other. c)Cross sell products more effectively because many products. d)Help sales staff close deals faster so service will become more faster. e)Discover new customers. 2)Recency,Frequency ,and Monetary Value (RFM) ➤How recently a customer purchased items (Recency) .To recognize latest customer. ➤How frequently a customer purchased items (Frequency).To know regular customer. ➤How much a customer spends on each purchase (Monetary Value).To know who customer spend a lot. 3)The Evolution of CRM ⟹CRM reporting technology -help organizations identify their customers across other applications. ⟹CRM analysis technologies -help organizations segment their customers into categories such as best and worst customers. ⟹CRM predicting technologies-help or

MGT300 - Chapter 10: Supply Chain Management

SUPPLY CHAIN MANAGEMENT The average company spends nearly half of every dollar that it earns on production In the past,  companies focused primarily on manufacturing and quality improvement to influence their supply chains BASIC OF SUPPLY CHAIN The supply chain has three main links: 1. Material flow from suppliers and their “upstream” suppliers al all levels 2. Transformation of materials into semi finished and finished products through the organization’s own production process 3. Distribution of products to customers at all levels List and describe the components of a typical supply chain: • Supplier’s supplier, Supplier, Manufacturer, Distributor, Retailer, Customer, Customer’s Customer INFORMATION TECHNOLOGY’S ROLE IN THE SUPPLY CHAIN             As companies evolve into extended organizations, the roles of supply chain participants are changing. It is now common for suppliers to be involved in product development and for distributors t

MGT300 - Chapter 12: Integrating The Organization From The End To End - Enterprise Resource Planning

Enterprise Resource Planning (ERP) It serves as the organization’s backbone in providing fundamental decision making support. It enables people in different business areas to communicate.  ERP system helps an organization to obtain operational efficiencies, lower costs, improve supplier and customer relations, and increase revenues and market share. The heart of an ERP system is a central database that collects information from and feeds information into all the ERP system’s individual application components (called modules), supporting diverse business function such as accounting, manufacturing, marketing, and human resources.   ERP automates business processes such as order fulfillment- taking an order from a customer, shipping the purchase, and then billing for it.  ERP Integration Data Flow  ERP Process Flow  Bringing the Organization Together   ERP enables employees across the organization to share information across a single, centralized database. With exten