Exam (elaborations)
MISY 261 final Questions and Answers 2024
- Course
- Institution
Exam of 7 pages for the course MISY at MISY (MISY 261 final)
[Show more]
Content preview
MISY 261 finaltransactional database - answer can effectively save all the data required to support the
business process of a company, lies at the heart of a transactional enterprise system, in
general - takes the form of a relational database
relational database - answer collection of data logically organized, contains a series of
tables, most common way in which transactional enterprises organize and store their
data
primary key - answer attribute or combination of attributes that identify in a unique way
each row in a table- can't be empty
foreign key - answer attribute of a table that can be composed that is a primary key of
the table to which it is linked
referential integrity - answerall the values of a foreign key attribute in a table exist in the
table where this attribute is a primary key
queries - answermechanisms by which we retrieve information from a database,
generate partial views of the data in a database
-a list of instructions on how to manipulate, reclassify, and aggregate data from the
relational database
logical data model - answer-way of representing the structure and business logic of a
relational database
-represents relationships between the tables with primary keys and foreign keys
-allows us to be able to build queries
-if you don't understand this model of a database you won't be able to extract
meaningful information from it
-offers a comprehensive plan on all the tables and attributes needed to create the
relational database
field - answeran attribute of the object (no client, customer name, customer type),
columns in the tables, describe the stable structure of the database
record - answereach row of a table, can be as many lines as necessary, allows for the
evolution of the table
metadata - answerdata about data, corresponds to the information about the data in the
fields of the tables, describes the list of tables, attributes, format, the restrictions on the
data, and type of relations
, Business process - answer-logically related activity or group of activities that takes
input, processes it to increase value, and provides output
-objective is to ensure that the organization has in place all the processes it requires to
successfully run that business and doesn't spend time/money on processes which it has
no need
-represents the relationship between the various activities of a process
business process model and notation (BPMN) - answergraphical representation for
specifying business process model
1. first element helps to describe the context and the function of the process (grid)
2. next element of formalism corresponds to the activities of the process (manual
activity, human machine activity, computerized activity, inspection)
process diagrams - answertell us in a detailed manner how work is carried out in an
organization
transformational potential of business processes - answerpremise of added value can
be used to identify and evaluate this, analysis is to help companies focus on activities
that add value to either the customer of the company, while minimizing those activities
that are only a source of costs
real added value activity (RAV) - answeractivity that creates value for the end customer,
activities that contribute to meet the needs of the end customer
business added value activity (BAV) - answerdoesn't create value for the customer but
are necessary for the business objective go the company, ensures that the company
makes a profit
non added value activity (NAV) - answeractivities that don't create value for the end
customer, nor help attaining business objectives, only a source of cost and should be
eliminated
business process reengineering (BPR) - answerapproach that helps organizations
rethink how to carry out their work and restructure themselves in order to achieve
operational excellence
-necessary to achieve business process integration
-represents a fundamental rethinking of the companies current way of doing business
business process activities - answerone person performs all the steps in a process
which translates into organizing the persons work around an objective/outcome, instead
of a single task
-organizing the process so the individual who needs the result of a process can do it
themselves
-organizing the work so that people who do the work should make the decisions and the
process itself can have built in controls
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller julianah420. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $16.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
67866 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now