Essay on A Role Playing Simulation On Database Design

Words: 1308
Pages: 6
Open Document
Feedback on Your Choices in Volunteer Now: A Role-Playing Simulation on Database Design

Name: Madisyn Olguin
1. Entity Choices
Points: 9 out of 9
Your choices for the entities are listed below, along with correct answers:

Your Choices

Correct Choices

Points Earned

Organizations

Volunteers

0

Volunteers

Organizations

0

VolunteerActivities

VolunteerActivities

3

Total Points

9

Well done!
2. Should activities be attributes in the Volunteers table?
Points: 5 out of 5
You selected No. Good choice! Volunteers and VolunteerActivities represent a one to many relationship, so each volunteer can have 0 to more activities. VolunteerActivities should thus be a separate table, that can be linked with a foreign key (VolunteerID) to …show more content…
How would you modify the database schema so that this information could be included?
I would modify the database schema to include an attribute under the entities represented by the organization. For example, the volunteer-activities attribute we chose, we could have an activity comment be the fact the volunteer must affirm they are not allergic to dogs or cats for the animal shelter opportunity. We could also make it a primary key for that specific organization. A primary key makes the record unique in the table, and that is certainly a unique attribute that the animal shelter needs to be aware of.
2. One volunteer contacted Star and said he could no longer volunteer because he was moving away from the area, but would still like to receive email when opportunities arise so he can pass them along to his friends. Can the database handle this? If not, how would you change the schema to track a request like this?
As of right now the database can not handle this, so one way we can change the schema to track a request like this is putting in a foreign key. Foreign keys are a connection of entities to one another in meaningful ways. One foreign key we could put in is between the volunteer's ID and the a volunteering activity. We can have these connected, so when a new volunteering activity is made available, it is made known to the volunteer ID via email.
This would allow that volunteer to still be in the loop with volunteering opportunities.
3.
Show More

Related Documents: Essay on A Role Playing Simulation On Database Design

ITM 207 Review Essay

Chapter 12 Information system Software that helps the user organize and analyze data Electronic spreadsheets and database management systems Software tools that allow the user to organize, manage, and analyze data in various ways Spreadsheet A software application that allows the user to organize and analyze data using a grid of labeled cells – A cell can contain data or a formula that is used to calculate a value – Data stored in a cell can be text, numbers, or “special” data such as dates – Spreadsheet…

Words 5402 - Pages 22

regulatory finance Essay

shown to provide conflicting and inconsistent forecasts of individual clients' creditworthiness. They are unregulated and the quality of their risk estimates is largely unobservable. • Operational risk modelling is not possible given current databases and technology even if a meaningful definition of this risk were to be provided by Basel. No convincing argument for the need of regulation in this area has yet been made. • Financial regulation is inherently procyclical. Our view is that this…

Words 6911 - Pages 28

Learning Theories Essay

Learning Theories • The Technological Revolution • The Spectrum of Learning Theories • Behaviorism • Constructivism • Fitting the Other Theories into the Spectrum • Theory of Multiple Intelligence • Learning Theories and the Brain • Brain Structures • Implications for Learning Theory • Implications for Multimedia • References By Darren Forrester & Noel Jantzie Kilde: http://www.acs.ucalgary.ca/%7Egnjantzi/learning_theories.htm This…

Words 6208 - Pages 25

Managing Information Technology (7th Edition) Essay

CONTENTS: CASE STUDIES CASE STUDY 1 Midsouth Chamber of Commerce (A): The Role of the Operating Manager in Information Systems CASE STUDY I-1 IMT Custom Machine Company, Inc.: Selection of an Information Technology Platform CASE STUDY I-2 VoIP2.biz, Inc.: Deciding on the Next Steps for a VoIP Supplier CASE STUDY I-3 The VoIP Adoption at Butler University CASE STUDY I-4 Supporting Mobile Health Clinics: The Children’s Health Fund of New York City CASE STUDY I-5…

Words 239873 - Pages 960

Gathers Data Processes Data Into Information

NOTES DESC- CHAPTER 2,3,4,5,6 Chapter 2 Gathers data, processes data into information, outputs data and information and stores data and information. Data: fact, figure or idea. Ex: the names Zoe and Richardson, the number 7784947 Information: data that has been organized in a meaningful fashion. Ex: Zoe Richardson can be reached by phone at 7784947. Info suddenly becomes useful. Binary language: consists of two digits: 0 and 1. Each one is a called a bit. 8 bits = 1 byte (one character of data)…

Words 4640 - Pages 19

Human Resource Development at 3m Essay

HUMAN RESOURCE DEVELOPMENT TERM REPORT ON 3M COMPANY LIMITED SUMBITTED TO: SIR MUHAMMAD AHMED BUTT CLASS: MBA GROUP MEMBERS: FAZEELA KHAN KANWAL SAFDAR SUMAN KUMARI DATE OF SUBMISSION: 3rd MAY 2013 TABLE OF CONTENTS 1. Introduction to company 6 2. Analysis of the study 7 3. Strategic analysis 9 4. HRD need assessment 11 5. Designing HRD programs 12 6. Methods to deliver training…

Words 8013 - Pages 33

Managerial Process Essay

Project Management, Second Edition Schroeder, Goldstein, Rungtusanatham, Operations Management: Contemporary Concepts and Cases, Sixth Edition Seppanen, Kumar, and Chandra, Process Analysis and Improvement, First Edition Ulrich and Eppinger, Product Design and Development, Fourth Edition Zipkin, Foundations of Inventory Management, First Edition QUANTITATIVE METHODS AND MANAGEMENT SCIENCE Hillier and Hillier, Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets…

Words 5952 - Pages 24

Essay on Information Technology Project Management Appendix Answers

can they help project managers understand the organizational context for their projects? The four frames of organizations are summarized below: • Structural: deal with how the organization is structures and focus on roles and responsibilities. It’s important to understand these roles and responsibilities when dealing with project stakeholders, especially in procuring resources. • Human resources: focuses on meeting the needs of the organization and its people. Project managers must understand various…

Words 19470 - Pages 78

Essay about Baldrige National Quality Program

Privatesector support for the Program in the form of funds, volunteer efforts, and participation in information transfer continues to grow. To ensure the continued growth and success of these partnerships, each of the following organizations plays an important role. board is appointed by the Secretary of Commerce and consists of distinguished leaders from…

Words 45998 - Pages 184

Study Guide Essay

BAM 411 Human Resource Management Text: A Framework for Human Resource Management ISBN-13: 978-0-13-257614-7 Author(s): Gary Dessler Publisher: Pearson 925 North Spurgeon Street, Santa Ana, CA 92701 Phone: 714-547-9625 Fax: 714-547-5777 www.calcoast.edu 10/14 Study Guide Seventh Edition, 2013 BAM 411 Human Resource Management Message From the President W elcome to California Coast University. I hope you will find this course interesting and useful throughout your career. This course…

Words 25132 - Pages 101