Premium Essay

Cis 210 Week 6 Assignment 3 Strayer

In: Business and Management

Submitted By coursehomework
Words 1222
Pages 5
To purchase this visit following link: Contact us at:
Strayer CIS 210 Assignment 4: Databases
Due Week 7 and worth 100 points
You are working as a corporate trainer for a large organization. There are several other trainers and many training topics. The company has grown quickly and scheduling has become difficult. The current method for scheduling involves writing trainer names and courses on a dry-erase board. This has led to issues with trainers changing the assignments in their favor and accidental erasure of some course assignments.
Write a 4-5 page paper in which you:
1. Discuss the requirements needed to build a database for the scheduling process.
2. Describe the advantages and disadvantages of moving the schedule to a database.
3. Create a graphical representation of your proposed database environment.
4. Explain how referential integrity can prevent mistakes in a database, and do the advantages outweigh the difficulty of setting it up?
5. Impress your boss by creating a database in Microsoft Access that will match trainers with courses and meet the following requirements:
a. Two (2) tables, one (1) containing trainer information and the other containing course information. Create data for five (5) instructors and five (5) courses. The trainer data should include: employee ID number, last name, first name, department, and email address. The course data should include: course number, course name, trainer employee ID number, and training location.
b. A relationship should exist between the tables.
c. Use referential integrity to make sure that each course has a valid trainer assigned to it.
Your assignment must follow these formatting requirements:
• Be typed, double-spaced,...

Similar Documents

Premium Essay

Aau Catalog

...ALLIED AMERICAN UNIVERSITY Personalized. Flexible. Dedicated. Online Programs – Individual Support – Open Enrollment – Ease of Transfer Credits UNIVERSITY CATALOG 2013 Seventh Edition 22952 Alcalde Drive, Laguna Hills, CA 92653 Phone: (888) 384-0849 ∼ Fax: (949) 707-2978 7:00 A.M. – 5:00 P.M. (Monday – Friday) Email: Website: KEY STAFF AND FACULTY Charlotte Hislop, Ph.D. Candidate, President/CEO Bonny Nickle, Ed.D., Provost Eric Sharkey, M.Ed., Director of Education Bill Luton, Ph.D., Director of Assessment and Dean of Business Carlo Tannoury, Ph.D. Candidate, Dean of Computer Information Systems Patricia Drown, Ph.D., Dean of Criminal Justice and General Studies C.J. Bishop, M.B.A., Institutional Research Frank Vazquez, Operations Director Parrish Nicholls, J.D., Director of Compliance Lindsay Oglesby, Admissions Director Abby Dolan, B.A., Registrar Sasha Heard, M.B.A., Student Services Manager Barbara Jobin, B.S.B.A., Career Center Manager Hugo Aguilar, B.A., Chief Financial Officer Richard Madrigal, B.A., Financial Aid Officer As a prospective student at Allied American University, you are encouraged to review this catalog prior to signing an enrollment agreement. You are also encouraged to review the student performance fact sheet which must be provided to you prior to signing an enrollment agreement. This catalog is not a contract between the student, AAU, or any party or parties. Reasonable effort was made at the time this......

Words: 52297 - Pages: 210