A join operation:
brings together data from two different fields.
causes two tables with a common domain to be combined into a single table or view.
causes two disparate tables to be combined into a single table or view.
is used to combi
Homework 1: S307
Your name: _
Draw an EER diagram for each of the following descriptions below. State any of your assumptions clearly.
Design an EER diagram for symphony orchestra: (3 points)
CONCERT SEASON: The season during which a series of concert
Modern Database Management
Chapter 1 The Database Environment and Development Process
1) One application of data warehouses is:
A) shipping of information.
B) order processing.
C) decision support.
D) file updating.
Diff: 3 Page Ref: 4
What The Bagel Man Saw
By STEPHEN J. DUBNER and STEVEN D. LEVITT
JUNE 6, 2004
Once upon a time, Paul F. dreamed big dreams. While studying agricultural
economics at Cornell, he wanted to end world hunger. Instead, after doctoral work
at M.I.T., h
286 Teaching Business Ethics: 7 he Principles Approach
3.1. Principle 1 : Refrain from Physical Coercion
The rst principle instructs business people to refrain from using physical
coercion and the threat of physical harm to attain their business objective
Requirements Documentation Exercise
You are an employee at Spoon-Corp which is a really big multi-thousand dollar company that sells
spoons (sterling silver, stainless steel, formal, contemporary, plastic, etc.). Everybody needs spoons!
Rights - Ethical Decision Making - Ethics Resources - Markkula Center for Applied Ethics - Santa Clara University
8/16/16, 3:53 PM
MARKKULA CENTER FOR APPLIED ETHICS
Home Markkula Center for Applied Ethics Ethics Resources Ethical Decision Making R
AN ETHJCA]. DJLEMMA*
Stacy, a recently hired employee of a growing local
CPA firm called Dewey, Cheatume, and Howe, just
passed all four parts of the CPA exam. The University
of Virginia prepped her well for her new job, and the
partners had high expectat
Justice & Fairness
Manuel Velasquez, Claire Andre, Thomas Shanks, S.J., and Michael J. Meyer
This article appeared originally in Issues in Ethics V3 N2 (Spring 1990).
Many public policy arguments focus on fairness. Is affirmative action fair? Are
3.2. Principle 2: Refrain from Fraud and Improper Deceptive Practices
The second principle may be seen as a corollary of the rst. It instructs business
people to refrain from using fraud or improper deceptive practices9 to attain ones
The Shortest Case in any Undergraduate
or MBA Program I
Clarence Walton was the Dean of General Studies at Columbia University for a
number of years, and then President of the Catholic College of America. He was also
widely respected because he te
The first step in database development is database analy
sis, in which we determine user requirements for data
and develop data models to represent those requirements.
The two chapters in Part II describe in deptii the de facto
standard for conceptual dat
Strategic alignment: Leveraging information technology for transforming organizations
Henderson, J C;Venkatraman, H
IBM Systems Journal; 1999; 38, 2/3; ABI/INFORM Complete
Reproduced with permission of the copyright owner. Further reproduction pro
The Database Environment and Development Process
1 DATABASE SYSTEM .1
1.1 DATABASE. 1
1.2 HARDWARE . 1
1.3 DATABASE MANAGEMENT SYSTEMS (DBMS) . 2
1.4 PEOPLE. 2
2 PHASES OF DATABASE DESIGN.2
3 DATABASE VS. FILE SYSTEM .3
3.1 FILE SYSTEM .
S307 Class Work I: ER Model
Your Name (please print):
Draw an ER diagram for the following situation:
1. A company has a number of employees. The attributes of the EMPLOYEE include Employee_ID (identifier), Name, Address, and
Birth Date. The com
Robert B. Cialdini, Petia K. Petrova and Noah J. Goldstein
The Hidden Costs of
Please note that gray areas reflect artwork that has
been intentionally removed. The substantive co
their differences, utilitarianism and Kantian ethics both address the question, What
actions are right? Virtue ethics asks instead, what kind of person should we be? Moral character
rather than right action is fundamental in this ethical trad
ETHICS AND BUSINESS 23
Business Ethics and Corporate Social Responsibility
Business ethics is sometimes confused with corporate social responsibility or
CSR. Although the two are related, they are not quite the same. It is important 2
1. The common types of entities are:
all of the above.
2. In an E-R diagram, there are _ business rule(s) for every relationship.
3. A business rule:
defines or constrains some aspec
Data that describes the characteristics of other data is called:
A database is an organized collection of_related data.
Disadvantages of flat file processing systems inc
S307: Midterm Review
Updated for Spring 2016
Problems with File-Based Systems
Limited data sharing
Duplication of data
Lengthy development times
Excessive program maintenance
Updated for Spring
S307: Data Management
Modeling Data in Organizations III
Enhanced ER Model
Enhanced ER Model
Hardware: Processor+Storage Device (Primary: Cache and main memory; Secondary: Non-volatile like
magnetic disks; Tertiary: non-volatile and store large amounts of data, used for backup, slowest)
DBMS: Software used to difine,
Mid-Term Exam Review
S307 (Spring 2017)
(Review Hoffer et. al textbook)
Database Environment (Chapter 1)
Four components of Database Systems: Database, Hardware, DBMS and People (see notes)
Basic concepts and definitions: Data, Information and Metadata