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 1 ( MGT300)

Image
BUSINESS DRIVEN TECHNOLOGY Information technology is everwhere in business Information Technology's Impact on Business Operations Operations typically operate by functional areas or functional silos ( it is an individual business function which is divided into sub groups and has its own strategies and works parallel with other organizations) Functional areas are interdependent ( two or more people; dependent on each other) Information Technology Basics Information Technology (IT) - a field concerned with the use of technology in managing and processing information . Management information systems (MIS) - a general name for the business function and academic discipline covering the application of people, technologies, and procedures to solve business problems. It is important to understand: - Data, information, business intelligence, knowledge and IT cultures. Information Data   - raw facts that describe the characteristics
Read more

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 11 (MGT300)

Image
Building a Customer-Centric Organization- Customer Relationship Management Customer Relationship Management (CRM) ·        CRM enables an organization to: -         Provide better customer service -         Make call centers more efficient -         Cross sell products effectively -         Help sales staff close deals faster -         Simplify marketing and sales processes -         Discover new customers -         Increase customer revenues Recency, Frequency and Monetary value ·        Organizations can find their most valuable customers through “RFM” – Recency, Frequency and Monetary value The Evolution of CRM ·        CRM reporting technology - help organizations identity 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 organizations make predictions regarding customer behavi
Read more