CIS 3010

importance of a good database  the five stages of a database  requirements gathering implementation  it needs the special storage related constructs to house the end user  conceptual vs logical  enteties and atributes  relationship between each table with a primary key and a secondary/foreign key 

collaboration information system  an information system that supports collaboration 

why is the cloud the future for most organizations  the cloud  elastic leasing of pooled computer resources over the Internet  elastic  leased computing resources increased or decreased dynamically, programmatically, in a short span of time and organizations only pay for resources used  flexibility to meet unpredictable demand while limiting financial risks  pooled  cloud resources are pooled  many different organizations share same physical hardware through virtualization  benefit from economics of scale  average cost production decreases as size of operation increases  major cloud vendors  why is the cloud preferred to in-house hosting  control of data location  small capital requirements  in depth viability of security and disaster procedures  in depth viability of security and disaster preparedness no obsolescence industry-wide economics of scale;hence cheaper  know...

processing the database  four dbms operations ( oracle and access)   read  insert  modify  delete data  creating the database and its structure: Adding a new column to a table  processing the database  structure query language  international standard  used by most popular DBMS  how do database applications make databases  2 models  traditional  what is a NoSQL DBMS  NOSQL DBMS ( Not realtional DBMS supports very high transaction rates  relatively simple data structures  replicated on many servers in the cloud  NoSQL impact on the DBMS Product Market database software market experienced viable new entrants  more reliance on open source community  will DBMS vendors lose some of their market to NOSQL products and vendors? 

what is the purpose of a database organize and keep track of things table = file columns = field records = rows components of database tables or files and relationship among rows in tables and metadata = database field = primary key in one table and secondary key in another table what is database management system ( dbms) program used to create, process, and administer a database licensed from vendors such as IBM, Microsoft, oracle and others DB2 from IBM, access and SQL sever from Microsoft, oracle database from oracle corporation MySQL - open source, license- free for applications 3 types of database models relational data base student file student CIN last name middle initial and first name major address street city state zip code faculty file CIN last name middle initial first name department city state zip schedule of class class number class name section date time instructor object oriented database name of object = l...

own versus license license right to use specified number of copies limits vendors liability site license flat fee to install software product on all company computers or all computers at a specific site what do business professionals need to know about application software? categories of application programs Horizontal- market applications provide capabilities common across all organizations and industries vertical- market application serve the needs of a specific industry one-of-a-kind applications develop for a specific, unique need. what is firmware computer software installed on read-only memory is open source software a viable alternative GNU general public license agreement successful open source projects open office ( a Microsoft office look-alike) firefox a browser) my SQL ( a DBMS, see chapter 5) apache ( a web server, see chapter 6) ubnutu ( a windows-like desktop operating system) Cassandra (a NoSQL, DBMS, see chapter 5) hadoop ...

how can business processes modeling help all road?

strategy - long term plan  what five forces determine industry structure  competative forces  competition from vendors who manufacture substitutes  competition from new competitors  competition from existing rivals   bargaining power forces  bargaining power suppliers  bargaining power of customers   how does competative strategy determine value chain structure  create linkage between all activities  what is a competative strategy  porters four competitive strategies cost  differentiation  industry wide  focus    how do you value chains determine buisiness process and information systems  how do information systems provide competative advantages  product implementation s  create a new product or service  enhance products or services  differentiate products or services  process implementations  lock in custom...

what do business professionals need to know about computer hardware personal computer tablet smart phone server server farm 0 is power off 1 is power on volatile memory - only stored in the main memory and not the magnetic disk how does a computer work first you need the operating system main memory (RAM) program instructions operating system instructions operating system controls computer's resources and blocks of data provides services to application programs and users memory swapping when RAM too small to hold all open programs and data CPU loads new program segments into free memory if none available, operating system swaps out existing instructions, or data, to a disk and copies requested program, or data, to freed space swapping slows down computer why does a business professional care how a computer works simple tasks do not need a fast CPU 2 types of architecture client server architecture   peer to peer architecture open sour...

circle is a process star rectangle is an activity - whatever we do to accomplish a task a document is represented by  a parallegram a decision is represented by a diamond improving - incremental change encoding- make readable data unreadable how can information systems improve process quality dimensions of process quality effectiveness-enables an organization to accomplish its strategy efficiency - ratio of benefits to costs having two separate repositories is more likely to create process inefficiencies single repository is less costly, will generate fewer errors and just as effective what is information ? definitions vary knowledge derived from data, where data are recorded facts or figures data presented in a meaningful context \ processed data, or data processed by summing, ordering, averaging, grouping, comparing, or other similar operations a difference that makes a difference whar data characteristics are necessary for quality information acc...