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 15 - Outsourcing

Outsourcing Project Insourcing (in-house-development)  – A common approach using the professional expertise within an organization to develop and maintain the organization’s information technology systems Outsourcing  – An arrangement by which one organization provides a service or services for another organization that chooses not to perform them in-house Onshore outsourcing  – engaging another company within the same country for services Near shore outsourcing  – contracting an outsourcing arrangement with a company in a nearby country Offshore outsourcing  – using organizations from developing countries to write code and develop systems Big selling point for offshore outsourcing “inexpensive good work” Factors driving outsourcing growth include; Core competencies Financial savings Rapid growth Industry changes The Internet Globalization According to PricewaterhouseCoopers “Businesses that outsource are grow...

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 14 - Creating Collaborative Partnerships

TEAMS, PARTNERSHIPS AND ALLIANCES Organizations create and use teams, partnerships, and alliances to: undertake new initiatives, address both minor and major problems and capitalize on significant opportunities. Organizations create teams, partnership, and alliances both internally with employees and externally with other organizations Organizations from alliances and partnerships with other organizations based on their core competency. Core competency- an organization’s key strength, a business function that it does better than any of its competitors Core competency strategy- organization chooses to focus specifically on its core competency and forms partnerships with other organizations to handle nonstrategic business processes. TEAMS, PARTNERSHIPS AND ALLIANCES Information technology can make a business partnership easier to establish and manage Information partnership - occurs when two or more organizations cooperate by integrating their IT system, there...