CHAPTER 7 (MGT300)

Storing Organizational Information- Databases
  • ·       Database- maintains information about various types of objects, events, people and places
  • ·       Database models include:

-        Hierarchical database model- information is organized into tree-like structure


-        Network database model- a flexible way of repsenting objects and their relationships 


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



Entities and Attributes
  • ·       Entity- a person, place, thing, transaction or event about which information is stored
  • ·       Attributes (fields, columns)- characteristics or properties of an entity class

Keys and Relationships
  • ·       Primary keys and foreign keys identify the various entity classes (tables) in the database

-        Primary key- a field that uniquely identifies a given entity in a table
-        Foreign key- a primary key of one table that appears an attributes in another table and acts to provide a logical relationship among the two tables
-        Gambar
  • ·       Database advantages from a business perspectives include

-        Increased flexibility
-        Increased scalability and performance
-        Reduced information redundancy
-        Increased information integrity
-        Increased information security

Database Management Systems




DATA-DRIVEN WEB SITES
  • ·       An interactive web site kept constantly updated and relevant to the needs of its customers through the use of a database
  • ·       Data-Driven Web Site Business Advantage:

-        Development
-        Content management
-        Future expandability
-        Minimizing human error
-        Cutting production and update cost
-        More efficient
-        Improved Stability

Data-Driven Business Intelligence



Integrating Information among Multiple Databases
  • ·       Integration- allows separate systems to communicate directly with each other

-        Forward integration- all information flows forward along the business process 
-        Backward integration- all information flows backward along the business process
  • ·       Without integration, an organization will:

-        Spend considerable time entering the same info in multiple system

-        Suffer from the low quality and inconsistency typically embedded in redundant info. 

Comments

Post a Comment

Popular posts from this blog

CHAPTER 2 (MGT300)

Image
IDENTIFYING COMPETITIVE ADVANTAGE Definition : A product or service that an organization's customers place a greater value on than similar offerings from a competitor. PORTER'S FIVE FORCES MODEL Definition : Usefool tool to aid organization in challenging decision whether to join a new industry or industry segment.  1. Buyer Power High- when buyers have many choices of whom to buy. Low- when their choices are few. Ways to reduce buyer power - loyalty programs 2. Supplier Power High- when buyers have few choices of whom to buy from.  Low- when their choices are many The suppliers ability to influence the prices they charge for suppliers (including materials, labor and services).  3. Threat of Substitue products & services High- when there are many alternatives to a product or service. Low- when there are few alternatives from which to choose.  Ideally, an organization would like to be on a market in which there are few substitu
Read more

CHAPTER 3 (MGT300)

Image
Strategic Initiatives for Implementing Competitive Advantages Organizations can undertake high-profile strategic initiatives including: Supply Chain Management (SCM) Customer Relationship Management (CRM) Business Process Reengineering (BPR) Enterprise Resource Planning (ERP) Supply Chain Management - involves the management of information flows between and among stages in a supply chain to maximize total supply chain effectiveness and profitability.  Four basic components of supply chain management include: Supply chain strategy - strategy for managing all resources to meet customer demand Supply chain partner - partners throughout the supply chain that deliver finished products, raw materials and services Supply chain operation - schedule for production activities Supply chain logistics - product delivery process Customer Relationship Management - involves managing all aspects of a customer's relationship with an organization to increase cu
Read more