Free Essay

Acme Erd

In: Computers and Technology

Submitted By kennir
Words 332
Pages 2
ACME University Information Systems Department
Service Request

Requested By: Hiram Lutz
Department: Student Community Services
Contact: Phone: 7634 E-mail: hiram@acme.edu
Request Type: __(__ New System ____ Enhancement ____ Error Correction
Description:
The Office of Student Community Services (OSCS) provides assistance to non-profit agencies in the community. OSCS serves as a facilitator that matches students that wish to perform community service with agencies that need labor for their events.

Typically, agencies will conduct numerous events during the academic year and need multiple people to participate in each event. Likewise, a student, who may belong to one or more student organizations, will usually engage in several events from different agencies throughout the year, and could work on multiple occasions at the same event. However, a student will only work at a specific event once on a single day. A given event is sponsored by only one agency.

Currently all OSCS records on these activities are kept in Excel spreadsheets, but this approach has become unwieldy as the popularity of OSCS’s services has increased among agencies and student organizations. At this point we need to better automate this record keeping. As the first phase of this task we would like to have a database created that will allow us to store all of the relevant data on the student organizations, students, agencies, events, and match-ups that our office coordinates.

The following are lists of the data that we would like to store:

For Student Organizations • ID • Name

For Students • ID • Name (First, MI, Last) • Local Address (Street, City, State, Zip) • Phone • E-mail address (and an indication if the student prefers to receive communications via email) • The term the student entered ACME

For Agencies • ID • Name • Address (Street, City, State, Zip) • Contact Name • Contact Phone • Contact E-mail address (and an indication if the contact prefers to receive communications via email)

For Agency Events • ID • Description

For Student Participation in Each Agency Event • Date • Hours Served • Description of Participation

Similar Documents

Premium Essay

John

...Cover Letter: Before & After “Before” Letter Jane Doe 123 Apple Way New York, NY 10000 October 23, 2011 Acme Corporation 100 Main Street New York, NY 10000 RE: Marketing Manager Position Weak, qualifying language. Dear Hiring Manager: After reading the job description for the Marketing Manager position at Acme, I believe I would be a great fit in this role. I currently work in an environmental 501(c) communicating sustainability messages to corporations, non-profits, and government agencies. I have partnered with a diverse group of companies educating students, supply chains, and corporate staff on relevant sustainability issues. This organization has reinforced my understanding about the amount of positive influence corporations can have. I would like to work for a firm motivated by operationalizing sustainability principles with the reputation and audience to do so. I believe I have all the attributes and characteristics to be a successful Marketing Manager at Acme. I am extremely organized in all aspects of my work both critically and logistically. I excel at planning long-term projects through my detail-oriented plans that are efficient in their use of resources and flexible in accommodating unforeseen variables. I believe this is the fundamental foundation to be an outstanding Marketing Manager. These characteristics intertwined with teamwork, passion, and drive equate to successful sustainability results. I hope to be part of Acme’s......

Words: 1003 - Pages: 5

Free Essay

Research

...Screws 1 1 SCREWS Threaded fasteners as screws, nuts and bolts are important components of mechanical structures, and machines. Screws may be used as removable fasteners or as devices for moving loads. 1.1 Screw thread The basic arrangement of a helical thread wound around a cylinder is illustrated in Fig 1.1. The terminology of an external screw threads is, Fig. 1.1: • pitch denoted by p is the distance, parallel to the screw axis, between corresponding points on adjacent thread forms having uniform spacing; • major diameter denoted by d is the largest (outside) diameter of a screw thread. • minor diameter denoted by dr or d1 , is the smallest diameter of a screw thread. • pitch diameter denoted by dm or d2 is the imaginary diameter for which the width of the threads and the grooves are equal. Screws 2 The standard geometry of a basic profile of an external threads is shown in Fig. 1.2, and it is basically the same for both Unified (inch series) and ISO (International Standards Organization, metric) threads. The lead denoted by l is the distance the nut moves parallel to the screw axis when the nut is given one turn. A screw with two or more threads cut beside each other is called multiple-threaded screw. The lead is equal to twice the pitch for a double-threaded screw, and to 3 times the pitch for a triple-threaded screw. The pitch p, lead l, and lead angle λ are represented in Fig. 1.3. Figure 1.3(a) shows a single thread right hand screw and......

Words: 1810 - Pages: 8

Premium Essay

Accessing Oracle

...ACME Global Consulting Brenda Lucas Entity relationship modeling is extremely valuable in a complex data environment. In relational database management system, entity relationship modeling becomes essential when dealing with a large number of entities and/or complex relationships. In addition, some entities that have many different relationships, or even multiple relationships with a single entity, can be difficult to conceptualize without the assistance of a well-thought-out model. As pointed out by Allen (2005), entity relationship modeling provides a highly intuitive reference for developers of a database system. ACME Global Consulting is an organization that services a vast number of clients across many domains. They deal with thousands of orders and products on a daily basis. From their customer service department to their order fulfillment department, the need for an efficient, accurate information system is self-evident. However, when dealing with so much information in such a complex system, the importance of proper planning and design cannot be overstated. There is no area of the system development lifecycle more critical than planning and design. The purpose of the entity relationship model to be developed for ACME Global Consulting is to visualize the entities and relationships that will exist within the relational database. As is discussed by Chilton (2006), it can be difficult to wrap one’s mind around the concept of relational databases at first. It...

Words: 953 - Pages: 4

Premium Essay

Benefits of Relational Models

...Benefits of Relational Models to ACME Global Consulting Geoff Roberts Professor Rahat Zafar Intro to Relational Database Management Systems 1/16/13 Businesses thrive on information. To succeed, you must have the most current knowledge to stay competitive in a rapidly changing industry, such as Information Technology. The trick is, not only knowing where to find the information, but how and where to secure it. Databases are the keystones to any business looking for organization and quality management. They will allow your company to track expenses, market trends, employees, equipment, and most importantly, clients. The question? How do I deploy an efficient database? In order to implement a database, it should be planned out to ensure it meets all requirements of the organization. Consider your own company’s needs for a moment. Organizational charts, certifications, client accounts, investments. How are these examples mapped so that the information is readily accessible in an efficient way? The answer, employ Relational Models from which a functional database that meets all level requirements can derive from. This is a major step in becoming a prepared, well organized, and respected consulting firm. A Relational model or entity-relationship diagram (ERD) is a data modeling technique that creates a graphical representation of the entities, and the relationships between entities, within an information system (http://searchcrm.techtarget.com). Relational models help...

Words: 624 - Pages: 3

Free Essay

Ceh Test Questions

...Exam : 312-50 Title : Ethical Hacker Certified Ver : 02-23-2009 312-50 QUESTION 1: What is the essential difference between an 'Ethical Hacker' and a 'Cracker'? A. The ethical hacker does not use the same techniques or skills as a cracker. B. The ethical hacker does it strictly for financial motives unlike a cracker. C. The ethical hacker has authorization from the owner of the target. D. The ethical hacker is just a cracker who is getting paid. Answer: C Explanation: The ethical hacker uses the same techniques and skills as a cracker and the motive is to find the security breaches before a cracker does. There is nothing that says that a cracker does not get paid for the work he does, a ethical hacker has the owners authorization and will get paid even if he does not succeed to penetrate the target. QUESTION 2: What does the term "Ethical Hacking" mean? A. Someone who is hacking for ethical reasons. B. Someone who is using his/her skills for ethical reasons. C. Someone who is using his/her skills for defensive purposes. D. Someone who is using his/her skills for offensive purposes. Answer: C Explanation: Ethical hacking is only about defending your self or your employer against malicious persons by using the same techniques and skills. QUESTION 3: Who is an Ethical Hacker? A. A person whohacksfor ethical reasons B. A person whohacksfor an ethical cause C. A person whohacksfor defensive purposes D. A person whohacksfor offensive......

Words: 34575 - Pages: 139

Premium Essay

Information Processing

...DATABASE MODELING AND DESIGN The Morgan Kaufmann Series in Data Management Systems (Selected Titles) Joe Celko’s Data, Measurements and Standards in SQL Joe Celko Information Modeling and Relational Databases, 2nd Edition Terry Halpin, Tony Morgan Joe Celko’s Thinking in Sets Joe Celko Business Metadata Bill Inmon, Bonnie O’Neil, Lowell Fryman Unleashing Web 2.0 Gottfried Vossen, Stephan Hagemann Enterprise Knowledge Management David Loshin Business Process Change, 2nd Edition Paul Harmon IT Manager’s Handbook, 2nd Edition Bill Holtsnider & Brian Jaffe Joe Celko’s Puzzles and Answers, 2 Joe Celko nd Location-Based Services ` Jochen Schiller and Agnes Voisard Managing Time in Relational Databases: How to Design, Update and Query Temporal Data Tom Johnston and Randall Weis Database Modeling with MicrosoftW Visio for Enterprise Architects Terry Halpin, Ken Evans, Patrick Hallock, Bill Maclean Designing Data-Intensive Web Applications Stephano Ceri, Piero Fraternali, Aldo Bongio, Marco Brambilla, Sara Comai, Maristella Matera Mining the Web: Discovering Knowledge from Hypertext Data Soumen Chakrabarti Advanced SQL: 1999—Understanding Object-Relational and Other Advanced Features Jim Melton Database Tuning: Principles, Experiments, and Troubleshooting Techniques Dennis Shasha, Philippe Bonnet SQL: 1999—Understanding Relational Language Components Jim Melton, Alan R. Simon Information Visualization in Data Mining and Knowledge Discovery Edited by Usama Fayyad, Georges G.......

Words: 89336 - Pages: 358

Free Essay

There Once Was a Young Wild Pony

...a b c d e f g h i j k l m n o p q r s t u v w x y z aa ab ac ad ae af ag ah ai aj ak al am an ao ap aq ar as at au av aw ax ay az ba bb bc bd be bf bg bh bi bj bk bl bm bn bo bp bq br bs bt bu bv bw bx by bz ca cb cc cd ce cf cg ch ci cj ck cl cm cn co cp cq cr cs ct cu cv cw cx cy cz da db dc dd de df dg dh di dj dk dl dm dn do dp dq dr ds dt du dv dw dx dy dz ea eb ec ed ee ef eg eh ei ej ek el em en eo ep eq er es et eu ev ew ex ey ez fa fb fc fd fe ff fg fh fi fj fk fl fm fn fo fp fq fr fs ft fu fv fw fx fy fz ga gb gc gd ge gf gg gh gi gj gk gl gm gn go gp gq gr gs gt gu gv gw gx gy gz ha hb hc hd he hf hg hh hi hj hk hl hm hn ho hp hq hr hs ht hu hv hw hx hy hz ia ib ic id ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy iz ja jb jc jd je jf jg jh ji jj jk jl jm jn jo jp jq jr js jt ju jv jw jx jy jz ka kb kc kd ke kf kg kh ki kj kk kl km kn ko kp kq kr ks kt ku kv kw kx ky kz la lb lc ld le lf lg lh li lj lk ll lm ln lo lp lq lr ls lt lu lv lw lx ly lz ma mb mc md me mf mg mh mi mj mk ml mm mn mo mp mq mr ms mt mu mv mw mx my mz na nb nc nd ne nf ng nh ni nj nk nl nm nn no np nq nr ns nt nu nv nw nx ny nz oa ob oc od oe of og oh oi oj ok ol om on oo op oq or os ot ou ov ow ox oy oz pa pb pc pd pe pf pg ph pi pj pk pl pm pn po pp pq pr ps pt pu pv pw px py pz qa qb qc qd qe qf qg qh qi qj qk ql qm qn qo qp qq qr qs qt qu qv qw qx qy qz ra rb rc rd re rf rg rh ri rj rk rl rm rn ro rp rq rr rs rt ru rv rw rx ry rz sa sb sc sd se sf sg sh si sj sk sl sm sn so...

Words: 29642 - Pages: 119

Premium Essay

Philip Kotler Book

...Marketing Management, Millenium Edition Philip Kotler Custom Edition for University of Phoenix Excerpts taken from: A Framework for Marketing Management, by Philip Kotler Copyright © 2001by Prentice-Hall, Inc. A Pearson Education Company Upper Saddle River, New Jersey 07458 Marketing Management Millenium Edition, Tenth Edition, by Philip Kotler Copyright © 2000 by Prentice-Hall, Inc. All rights reserved. No part of this book may be reproduced, in any form or by any means, without permission in writing from the publisher. Compilation Copyright © 2002 by Pearson Custom Publishing. This copyright covers material written expressly for this volume by the editor/s as well as the compilation itself. It does not cover the individual selections herein that first appeared elsewhere. Permission to reprint these has been obtained by Pearson Custom Publishing for this edition only. Further reproduction by any means, electronic or mechanical, including photocopying and recording, or by any information storage or retrieval system, must be arranged with the individual copyright holders noted. This special edition published in cooperation with Pearson Custom Publishing Printed in the United States of America 10 9 8 7 6 5 4 3 2 1 Please visit our web site at www.pearsoncustom.com ISBN 0–536–63099-2 BA 993095 PEARSON CUSTOM PUBLISHING 75 Arlington Street, Suite 300, Boston, MA 02116 A Pearson Education Company SECTION ONE Understanding Marketing Management Marketing......

Words: 231198 - Pages: 925