Info graphics are a beautiful combination of maths, science, art and instruction, all rolled into one. I love the way these graphics convey often complex concepts in simple visual ways.
Relational (Tables) Database Fundamentals
* Information is everywhere in an organization
* Information is stored in databases
* Database – maintains information about
* various types of objects (inventory),
* events (transactions),
* people (employees),
* places (warehouses)
* Database models include:
* Hierarchical database model
* Network database model
* 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
* The rows in each table contain the entities
* In Figure 6.5 CUSTOMER includes Dave’s Sub Shop and Pizza Palace entities * Attribute (field, column) – characteristics or properties of an entity class
* The columns in each table contain the attributes
* In Figure 6.5 attributes for CUSTOMER include Customer ID, Customer Name, Contact Name
Keys and Relationships
Primary keys and foreign keys identify the various entities (tables) in the database
* Primary key – a field (or group of fields) that uniquely identifies a given entity in a table
* Foreign key – a primary key of one table that appears an attribute in another table and acts to provide a logical relationship among the two tables
Relational Database Advantages
* Increased flexibility
* Increased scalability and performance
* Reduced information redundancy
* Increased information integrity (quality) and information security
Generating revenue on the Internet
* Online ad (banner ad) - box running across a web page that contains advertisements
* Pop-up ad - a small web page containing an advertisement
* Associate program (affiliate program) - businesses generate commissions or royalties
* Viral marketing - a technique that induces websites or users to pass on a marketing message
* Mass customization - gives customers the opportunity to tailor products or services (Dell computers)
Online business payments include:
* Electronic data interchange (EDI)
* Value-added network (VAN)
* Financial EDI (financial electronic data interchange)
Measuring e-business success
* Most companies measure the traffic on a website as the primary determinant of the website’s success
* However, a large amount of website traffic does not necessarily equate to large sales
* Many organizations with high website traffic have low sales volumes
* Website traffic analysis can include: Cookie, Click-through, Banner ad, Interactivity