WVU Bcor 330 exam #2
what is the entity-relationship data model
*entities- something to track: oder, customer, salesperson, item, volunteer, donations *attributes- describe characterisitics of entity: ordernumber, customer number, volunteername, phone number *identifier-unique identifies one entity instance from other instances -student id number
Key
- a column or group of columns that identities a UNIQUE row in a table.
which process could the hospitial adapt so that the kitchen is more efficient about the people already discharged?
- an enterprise process
ad advantage of inherent processes over in-house business process reengineering?
- inherent processes save organizations from expensive business process of reengineering
Query structured query lanaguage-SQL
- is a request that is executed to retrieve data from a database, makes databases more useful by search using values provided by user. -international standard -used by nearly all DBMS ex. insert into student! ([Student Number], [Student Name], HW1, HW2, MidTerm) VALUES (1000, 'Franklin, Benjamin', 90, 95, 100);
DSL
- is operates on the same line as voice telephones, but it doesn't interfere with telephone service
which of the following is chara. of an enterprise information system?
- it eliminates work group data duplication
which of the following statements is true of enterprise app integration (EAI)
- it enables exisiting app. to communicate and share data.
content data
- made up of data and responses to data that are contributed by users and social media sponsors
the letter "K" is the abbreviation used for which communication speed?
-1,000
in the hype-social organization consumers become
-HUMANS -market segments: tribes -channels: networks -Structure and control: messiness
amazon.con MySQL- EC2-
-Iaas -PaaS -PaaS
PaaS
-MySQL DBMS
In-memory DBMS using SQl extension
-SAP HANA, tableau -high volume ACID transaction support with complex relational query processing.
an advantage of database management systems (DBMS) over traditional file system?
-a DBMS uncouples programs and data, enables (allows) data to stand on its own -program to create, process, administer a database -licensed from vendors: IBM, Microsoft, Oracle, and others -DB2, Access, SQL Server, Oracle Database Open source: MySQL- license-free form most applications
primary key:
-a column or group of columns that identifies a UNIQUE row in a table
user communities
-a group of people who form because of mutual interest and who transcend familial, geographic, and organizational boundaries
N:M 1:N
-advisor and student, an advisor may have many students and one student may have many advisers -department and advisor department has many advisors, and an advisor may advise for more than one department (crow's foot) -adviser and student, a student has only one advisor, but an adviser may advise many students -department and adviser, one department may have many advisers, but an adviser may be in only one department
ACID transactions
-atomic, consistent, isolated, durable transactions -critical to traditional commercial applications new internet applications (twitter) don't need ACID
true of the components of an entity(object)-relationship data model?
-attributes describe the characteristics of entities
XML
-can be slower than JSON, use JSON to store data efficiently because it doesn't use as much space XMl can provide a better way for complex query
reports
-can be used to compute values as they present data -structured presentation of data using sorting, grouping, filtering, and other operations
database management system differs from a tradition file system in that a database management system
-can centralize data
NoSQL databases
-can handle high volumes -handle any format of data -can be distributed -can be duplicated
challenges of an enterprise information system
-communicating to employees that changes are necessary
triggers
-computer programs stored with in the databases that run to keep the database consistent when certain conditions arise.
LAN local
-connect computers that reside in a single geographic location on the premises of the company
what are the axes that determine Porter 4 generic competitive strategies?
-cost vs. quality -market-wide vs. niche
metadata
-describes the structure of a database
which operates on the same line as voice line telephones?
-digital subscriber line (DSL) -cablelines -wireless
rules of social media engagement
-disclose,protect, and use common sense -cover your area of expertise -sell your products, but don't point out your own interest
information silos have......
-disjointed processes
MIS
-information systems -development and use -strategies Not: information technology
primary purpose of ERP (enterprise resource planning)
-integration of functional systems with in an organization.
inter-enterprise information system
-it can resolve problems of duplicated enterprise data
Data model
-it describes the data and relationships that will be stored in the database.
accurate description of the DATA MODEL
-it is a logical representation of the data in a database that describes the data and relationships that will be stored in the database
steps required in transforming a data model into a relationship database-
-normalize tables as necessary so easy has one theme. -represent each entity with a table -represent relationships
What is the purpose of a database?
-organize and keep track of things, of multiple themes -single them: store is a spreadsheet -multiple themes- use a database.
statement best describes inherent process?
-predesigned procedures for using software products -mostly provided by vendors rather than in-house resource
measures how well a process achieves an organizational strategy?
-process effectiveness
NewSQL DBMS
-process very high evels of transactions, like NoSQL DBMS, but provide ACID support. - may or may not support relational model -current hotbed of development
PaaS
-provides hosted computers, an operating system, and possibly DBMS
example of a SaaS?
-salesforce.com -OFFICE365 -Icloud
encryption
-secures VPN communication messages over a public internet database
administering the database
-set up security system, user accounts, passwords, permission limits users permissions -back up database improve performance of database application, remove unwanted data.
Which of the following is a characteristic of a structured process?
-standardized
NoSQLs DBMS
-supports very high transaction rates, processing relatively simple data structures -replicated on many servers in the cloud, without ACID transaction support. -mongoDB, cassandra, bigtable, and dynamo
Distributed application
-they integrate isolated data created by information systems at the enterprise level into inter-enterprise systems.
in the hyper-social organization market segments become
-tribes
2026?
-volume of database continues to grow -cheap, unlimited storage, greater processing speeds do in relational databases -security becomes more important -many NoSQL, NewSQL, and in-memory databases exist in commerce.
workers in 2024
-will be able to carry mobile devices that can be used to access information from work in any location
m: G: mbps:
1,000,000 1,000,000,000 100,000,000 bits per second
DBMS Process Operations
1.Read 2.insert 3.modify 4.delete dare
abstract reasoning
5-component model
what is on the computer cake
DBMS
A EAI is a piece of software that offers to MULTIPLE applications ti users across a company
False
inherent processes
Predesigned procedures for using software products are best describe as inherent processes
CH.6 which of the following shouldn't use the cloud?
a company that needs to control the data
example of an inter-enterprise?
a prescription application that enables hospitals, doctors, and pharmacists to share patient data.
characteristic of a dynamic process?
an adaptive process that changes rapidly
distributed system
application that are processed and distributed across multiple computing devices
enterprise resource planning (ERP) systems?
application that integrate business activities across departmental boundaries
tables
are stored in one or more data files(physical structure associated with only one table space)
in a relational database, can be represented as
as an extra column in a table -a storing several value in a cell
human capital
as the investment in human knowledge and skills for future profit
deleting legitimate neg. comments can result in strong user...
backlash
Ch.7 Which of the following is a similarity between customer relationship management software and enterprise software
both are business-process-driven software
which of these is not needed to qualify as an ERP?
business intelligence business intelligence
in a database =
bytes are groups into COLUMNS bytes or characters Rows or records (vertical) colums or fields (horizontal) table or file
Database Tier
consists of computers that run on DBMS that processes request to retrieve and store data
User tier
consists of computers, phones, and other mobile devices that have browsers that request and process web pages
tables that are not normalized will likely have problems related to...
data integrity (problems) -incorrect or inconsistent information -users lose confidence information -system gets a poor reputation -can only occur if data are duplicated
the strength of a relationship
determines whether a person or organization in a relationship will do something to benefit the organization
pay-per-click revenue model-
displays ads to potential customers form free and payment occurs only when customer clicks on ad.
the fact that a process produces the outcomes that you expected means that the process is
effective
Theme-
ex. student grades, emails, and office visits
most basic cloud offering
infrastructure as a service
database
is a collection of data organized to serve many applications efficiently by centralizing the data and controlling redundant (unnecessary) data -keeping track of data is the primary reason
database application
is a collection of forms, reports, queries and programs that processes a database.
JSON
is a markup language that contains little metadata and is perferred for transmitting volumes of data
web-server
is a program that runs on a server-tier computer and manages traffic by sending and receiving web pages to and from clients
workgroup info system
is an information system that facilitates the activities of a group of people
defender of belief
is one who shares a common belief and forms a hive around that belief
private cloud
is owned and operated by an organization for its own benefit
active lurker
is someone who reads, consumes, and observes activity ins social media and then broad casts it in some other medium.
business process re-engineering
is the activity of altering existing and designing new business processes to take advantage of new information systems
any hyper social organization should take-
is to develop and publicize social media policy- states that the delineates employee's rights and responsibilities
Information silos
isolated decisions
VPN
it encrypts messages to ensures secure transmissions
true about business process reengineering?
it is difficult, slow, and exceeding expensive
dynamic processes
less specific informal, and exceptions that are frequently and expected
why are cloud resources pooled thru virtualization
many organizations use the same physical hardware that they share through virtualization
Web 2.0
mashups, pay-per click, and "software as a service"
compared to in-house hosting, cloud-based hosting-
minimizes the risk of investing in technology that will soon become obsolete
When representing a logical schema with ERD, do we take a specific database technology in consideration?
no
how is a data model transformed into database design?
normalization- converting each poorly structured table into two or more well-structured tables. Goal- construct tables with single them or entity purpose- minimize data integrity problems
a digital subscriber line
operates on the same line as voice telephones, but it doesn't interfere with voice telephone services (DSL)
in cloud computing resources are said to be pooled because
organizations use the same physical hardware though virtualization
Important action to ensure mistakes aren't made in the development of database-
perform user reviews
a public IP address is assigned by an agency/known as ICANN
private IP -> local LAN
types of internet adresses is assigned within a LAN?
private IP address
file transfer protocol (FTP)
protocol is used to move files over the internet
Augmenting( make something greater) a human who is performing an activity
reflects the type of improvement the managers are choosing to implement
a statement that delineates employees right and responsibilities is a-
social media policy
structured process
standardized
which SEAMS process activity involves publicizing community success?
story tell
components of a database
table or files + relationships among rows in tables +metadata= database
VPN
technology used to provide secure communication over the internet
in a hyper-social organization the vendor lose-
the control of the customer relationship
conversion rate measure
the frequency that someone clicks on an ad makes a purchase, "likes" a site, or takes some other action desired by the advertiser
capital
the investment of resources for future profit
what is net neutrality?
the principle that says all data are treated equally
efficiency measures process?
the ratio of process outputs to inputs
Social media
the use of information technology to support the sharing of content among networks of users
When enterprise 2.0 workers want content pushed to them...
they want to be SIGNALED, slates
how to recognize and minimize bias (data)?
use non-routine cognitive skills
disadvantages of the cloud?
vendor dependence
forms
views data, insert new, update existing, delete existing data provides security, data consistency, special purpose processing ex. handle out of stock situations
in the cloud, pooled resources are shared through
virtualization
can an order be assigned to multiple routes
yes yessssss
