Describe how each table meets 1NF, 2NF and 3NF, if you need to remove any issues to move to the next higher NF describe what the issue is and how you resolved it.

IP1

Your first step is to select a database you will design and implement in this class. You will make weekly contributions to your overall Key Assignment. The database project idea should first be sent to your instructor for approval before this Phase 1 Individual Project is due. In this first week you will explore a structured design process when creating your database application. You will write a report describing the database design development life cycle and describe in details the steps needed to properly create the database you have selected for your Key Assignment. You will also provide an overall description of your database that you received approval from your instructor to do.

 

You also should take this opportunity to create the template for your entire Key Assignment project; create a Word document that you will add to for each remaining assignment. The document should follow this format:

 

  • Database design project document shell
  • Use Microsoft Word
  • Title page
  • Course number and name
  • Project name
  • Student name
  • Faculty name
  • Date
  • Table of contents
  • Use auto-generated TOC
  • Separate page
  • Maximum of three levels deep (one level deep is okay too)
  • Be sure to update the fields of the TOC so it is up-to-date before submitting your project.
  • Section headings (create each heading on a new page with TBD as content except for sections listed under new content below)

 

    • Project outline
    • Description of the database design life cycle
    • The entity relationship diagram
    • The logical model and normalization
    • The Microsoft Access database
    • The Microsoft Access database application

 

Each week, you will add to this document and submit for grading. As a preview, each section will contain the following:

 

  • Description of the database design life cycle (Week 1 IP)
  • A description of the DBDSL – 7 steps
  • A discussion about the three steps in database design

IP2

 

Once requirements analysis is completed, the first step in database design can be completed. This step is the conceptual model (or entity relationship diagram). Using any modeling tool you choose (MS Access, SmartDraw, Visio, Erwin, or even PowerPoint or Word), create an entity-relationship diagram (ERD) from the entity and attributes list for the database project you selected similar to what you did in the Discussion Board this week. Your submission should ensure the following:

 

  • All entities and attributes are identified
  • All relationships between entities are defined (including proper relation semantics)
  • Add your ERD as a screenshot from the template started in Week 1, and provide supporting discussion about how the relationships were established and determined.
  • Add the ERD and discussion to the section in your template titled: The Entity Relationship Diagram.
  • Update the TOC to reflect the new section.
  • Name the document CS251__IP2.doc.
  • Submit the document for grading.

IP3

Now that the ERD is completed for your selected project, you are anxious to create the database and setup the tables. Before that step you remind everyone that the 2nd phase in the Database development process has not been completed yet. You still need to create the Logical Data Model and check the model against 3rd Normal Form. For this Individual Project convert your ERD into a Logical Data Model that is in 3NF. The deliverables for this task are:

  • 1 Logical Data Model analyzed and converted to 3NF
  • Describe how each table meets 1NF, 2NF and 3NF, if you need to remove any issues to move to the next higher NF describe what the issue is and how you resolved it.
  • Properly Identify all Primary (Use Solid Underlines) and Foreign Keys (Use Dotted Underlines)

Add the normalized Logical Data Model and normalization discussion to the section in your template titled: The Logical Model and Normalization.

  • Update the TOC to reflect the new section.
  • Name the document CS251_<First and Last Name>_IP3.doc.
  • Submit the document for grading.

Demonstrate an ability to motivate individuals and teams toward organizational goals through the application of human resource initiatives and policies.

Mitigating Legal Issues

: Mitigating Legal Issues As you are reviewing the growth of your selected company, you are noticing how diversity and sexual harassment issues are impacting the overall company culture. You want to make sure that your friend is not vulnerable to any legal issues that could jeopardize the survivability of the company. You realize that you may need to start implementing a few policies now instead of waiting until the HR department has been fully materialized. You will also need to communicate the policies to the managers, staff and employees of your selected company. Write a five to six (5-6) APA 6th ed page paper in which you (Question/answer/cite): 1. Create a diversity policy for your selected company to mitigate discrimination on the basis of race, color, religion, sex, national origin, sexual orientation, etc. and to promote a diverse workplace. Note: Use the following samples as guidance. o Hint: Review the sample diversity policy located at http://79.170.40.225/healthworksonline.co.uk/uploads/fck/PDF%20Valuing%20employees-Sample%20Equality%20&%20Diversity%20Statement.pdf o Hint: Review the Sample Human Resources Policies, Checklists, Forms, and Procedures, located at http://humanresources.about.com/od/policysamples/a/policy_samples.htm, or use a sample policy from a company you are familiar with as guidance. 2. Create a sexual harassment policy for your selected company to address a sexual harassment complaint. Cover both quid pro quo and hostile work environment types of harassment in your policy. o Hint: Review Sample Policy 1: Sexual Harassment, located at http://www.thehrspecialist.com/3908/Sample_Policy_Harassment.hr?cat=tools&sub_cat=sample_policy o Hint: Review the Sample Human Resources Policies, Checklists, Forms, and Procedures, located at http://humanresources.about.com/od/policysamples/a/policy_samples.htm, or use a sample policy from a company you are familiar with as guidance. o Hint: Review the article titled How to address an employee sexual harassment complaint, located at http://humanresources.about.com/cs/workrelationships/ht/sexualharass.htm 3. Use the Diversity or Sexual Harassment Training Plan template located in Week 5 of your Blackboard course shell to develop a training plan to communicate one (1) of the policies you created (the diversity policy or the sexual harassment policy) to the companys managers, staff and employees. o Note: The completed Training Plan should be incorporated into the paper and is counted towards the total page length requirement for this assignment. o Hint: Review the article titled How Do I Plan a Human Resource Training Program in an Organization Setting located at http://smallbusiness.chron.com/plan-human-resource-training-program-organization-setting-2553.html 4. Use at least six (6) quality scholarly/peer-reviewed academic resources in this assignment from within the past five (5) years. Utilize sources to lend depth and validity to what is being shared. (Just going to the Internet and selecting urls does not mean they are such and lend validity to your work). Note: Wikipedia and other Websites do not quality as academic resources. 5. Format your assignment according to these formatting requirements: o Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; references must follow APA or school-specific format. Check with your professor for any additional instructions. o Include a cover page containing the title of the assignment, the students name, the professors name, the course title, and the date. The cover page and the reference page are not included in the required page length. o Include a reference page. Citations and references must follow APA format. The reference page is not included in the required page length. The specific course learning outcomes associated with this assignment are:  Develop human resource policies and practices that foster an appreciation for multiple cultures, ethnicities, and other diverse populations.  Describe key laws governing employment and the required compliance for organizations. Use communication skills to effectively convey human resource policies and practices throughout the organization.  Demonstrate an ability to motivate individuals and teams toward organizational goals through the application of human resource initiatives and policies.  Review the human resource management function of training and development and the functions importance to business strategy.  Use technology and information resources to research issues in human resource management.  Write clearly and concisely about human resource management using proper writing mechanics.

Discuss useful theories.

Useful theories
A. lead to practical solutions to problems
B. provide researchers with many testable hypotheses
C. stimulate debate and research
D. all of the above
2. Random assignment is used to control for
A. Experimenter bias
B. The placebo effect
C. Selection bias
D. Participants bias
3. A _______ psychologist specializes in the diagnosis and treatment of mental and behavioral disorders
A. Social B. Development C. Clinical D. Cognitive
4. Which of the following psychologists is associated with the humanistic perspective?
A. Maslow B. Darwin C. Watson D. Freud
5. The branch like extensions of neurons that act as receivers of signals from other neurons are the
A. dendrites B. axons C. neurotransmitters D. cell bodies
6. According to a growing consensus among trait theorists, there are _______ major dimensions of personality
A. 3 B. 5 C. 7 D. 16
7. The electrical charge inside a neuron is about -70mV and is known as the blank potential.
A. Action B. Refractory C. Resting D. Impulse
8. An illusion is
A. an imaginary sensation B. an impossible figure
C. a misperception of a real stimulus D. a figure-ground reversal
9. Perception is the process we used to
A. organize and interpret stimuli B. detect stimuli
C. gather information from the environment D. retrieve information from memory
10. The process by which humans detect visual, auditory, and other stimuli is known as
A. perception B. transduction C. sensation D. threshold
11. Tactile is used in reference to the sense of
A. smell B. balance C. taste D. touch
12. Which of the following best defines consciousness?
A. Awareness B. Wakefulness C. Perceptiveness D. Rationality
13. Which type of sleep seems to a learning and memory?
A. Stage 1 B. Stage 2 C. Stage 3 and 4 D. REM sleep
14. Dreams are difficult to remember because most of them occurred during Stage 4 sleep.(T/F)
15. Which theory proposes that the purpose of sleep is to allow the body to test an recover?
A. Restorative theory of sleep B. Evolutionary theory of sleep
C. Adaptive theory of sleep D. Circadian theory of sleep.
16. A dog’s salivation in response to a musical note is a(n) (conditioned, unconditioned) response.
17. Punishment is roughly the same as negative reinforcement. (T/F)
18. Pavlov is associated with _______ conditioning.
A. Classical B. Operant C. Cognitive D. Watsonian
19. Transforming information into a form that can be stored in memory is called _______; bringing to mind the material that has been stored is called _______.
A. Encoding; decoding B. Consolidation; retrieval
C. Consolidation; decoding D. Encoding; retrieval
20. When you remember where you were an what you were doing when you received a shocking piece of news, you are experiencing
A. flashbulb memory B. sensory memory
C. semantic imagery D. interference
21. The 1st step in the memory process is known as _______, when information is transformed into a form that can be stored in short-term memory.
A. retrieval B. storage C. encoding D. rehearsal
22. Using _______, a person removes an unpleasant memory from consciousness.
A. regression B. traumatic amnesia C. repression D. degeneration
23. John uses a wastebasket to keep the door from closing. In solving his problem, he was not hindered by
A. a heuristic B. an algorithm C. functional fixedness D. mental set
24. An artificial neural network is a computer system that is designed to mimic
A. artificial intelligence B. animal intelligence
C. human heuristics D. human cognition
25. The mental category that represents a class or group of items that that share common characteristics or attributes is called a(n)
A. image B. concept C. positive instance D. prototype
26. The teenager’s personal fable includes all of the following except
A. a sense of personal uniqueness
B. belief that he or she is indestructible and protected from misfortune
C. belief that no one has ever felt so deeply before
D. feeling that he or she is always on stage
27. Assimilation is a process used with _______
A. new schemes B. existing schemes.
C. positive responses D. negative responses
28. Motives and move us toward goals. (T/F)
29. According to the text, emotions have all of the following except a _______ component.
A. physical B. cognitive C. sensory D. behavioral
30. Which of the following not true of the basic emotions?
A. reflected in distinctive facial expressions
B. found in all cultures
C. several hundred known to date
D. unlearned
31. A _______ is a state of tension or arousal brought about by an underlying need, which motivates one to engage in behavior that will satisfy the need and reduce the tension.
A. drive B. balance stimulus C. tension stimulus D. homeostatic condition
32. According to Maslow, the need for love and affiliation is satisfied _______ basic biological needs and the need for safety.
A. instead of B. before C. at the same time as D. after
33. Psychoanalysis is both a theory of personality and a therapy for the treatment of psychological disorders. (T/F)
34. According to Freud, the sex instinct arises at (birth, puberty).
35. Humanistic psychologists would not say that
A. human nature is innately good
B. humans have a natural tendency toward self-actualization
C. humans have free will
D. researchers should focus primarily on observable behavior
36. A person’s unique pattern of behaving, thinking, and feeling is his or her
A. motivation B. emotion C. personality D. cognition
37. Anxiety disorders are the least common of all psychological disorders. (T/F)
38. Somatoform disorders have physiological rather than psychological causes. (T/F)
39. Psychosis is loss of contact with reality. (T/F)
40. Major depression and bipolar disorder are examples of _______ disorders.
A. personality B. psychotics C. mood D. emotional
41. In psychoanalysis, the technique whereby a client reveals every thought, idea, or image that comes to mind is called _______; the clients attempt to avoid revealing certain thoughts if called _______.
A. transference; resistance B. free association; transference
C. revelation; transference D. free association; resistance
42. Behavior therapies based on classical conditioning are used mainly to
A. shape new, more appropriate behaviors
B. rid people of fears and undesirable behaviors or habits
C. promote development of social skills
D. demonstrate appropriate behaviors
43. One must have a medical degree to become a
A. clinical psychologist B. sociologist
C. psychiatrist D. clinical psychologist, psychiatrist, or psychoanalyst
44. This therapy involves the application of principles of classical and operant conditioning.
A. Gestalt therapy B. behavior modification
C. psychoanalysis D. humanistic therapy
45. The B in Albert Ellis’s ABC theory of rational emotive behavior therapy stands for behavior.(T/F)
46. Which of the following statements about 1st impressions is false?
A. People usually pay closer attention to early information they receive about a person than to later
B. Early information forms a framework through which later information is interpreted
C. First impressions often serve as self-fulfilling prophecies
D. The importance of 1st impressions is greatly overrated
47. Which of the following is not one of the 3 components of an attitude?
A. cognitive component B. emotional component
C. physiological component D. behavioral component
48. As the number of bystanders at an emergency increases, the probability that the victim will receive help decreases. (T/F)
49. _______ are the attitudes and standards of behavior expected of members of a particular group.
A. Values B. Social rules C. Social norms D. Social postures
50. The terms stereotype and prejudice are actually different words for the same thing. (T/F)

Select suitable rolling element bearings for the shaft in Figure 1 below.

MEGN 481: Machine Design
HW #7 (4 Problems, due Thursday, November 12th)
You will need access to the 5th edition of the book for this HW
1) Select suitable rolling element bearings for the shaft in Figure 1 below. You will have to select the bearing from the catalogue page supplied in your book. In addition to the load being applied, there is an additional thrust load on the right bearing of 100 lbf from a bevel gear mounted at P. The bearings must support the load with a probability of failure of 5% for at least 70 Million cycles at 1500 rpm. Assume a shaft diameter of d=1.1875 in, b = 18 in and a = 16 in. Assume the inner-raceway is rotating.

Figure 1 for problem #1

Perform Example 11-1 in the book (completely)

2) Find the Petroff no-load torque for the journal bearing in Case Study 10B.

3) Find the minimum film thickness for a bearing with these data: 45mm dia, 30 mm long, 0.001 clearance ratio, 2500 rpm, ON=25, ISO VG 220 oil at 200 degrees F.

4) A paper machine processes rolls of paper having a density of 984 kg/m3. Tge paper roll is 1.5m OD x 22cm ID x 3.23 m long and is on a simply supported, 22cm OD, steel shaft. The roll turns 50 rpm. Design suitable hydrodynamically lubricated full-film bronze short bearings of l/d=0.75 to support the shaft at each end. Specify the viscosity of the lubricant needed at 180 degrees F. State all assumptions.

Explain the features of solid waste landfill design that were new with the passing of the Resource Conservation and Recovery Act (RCRA).

Write an essay consisting of at least 500 words addressing all of the following topics (a through h):

a. Explain the features of solid waste landfill design that were new with the passing of the Resource Conservation and Recovery Act (RCRA).

b. On the Internet, search for “40CFR279.30” which is the portion of the Code of Federal Regulations pertaining to “Do-it-yourselfer used oil collection centers.” Quote two lines from that portion of the CFR.

c. How do the Hazardous and Solid Waste Amendments (HSWA) of 1984 service to supplement the RCRA of 1976?

d. Explain the permitting system instituted by RCRA.

e. Summarize monetary penalties that are used in enforcement under RCRA.

f. Why is CERCLA commonly called “Superfund”?

g. Describe the Hazard Ranking System (HRS) with respect to the process of having a site listed on the National Priorities List (NPL).

h. Explain the Underground Storage Tank (UST) program under RCRA.

You are required to use at least your textbook as source material for your response. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations.

Describe the cradle to grave tracking process instituted by RCRA.

Write an essay consisting of at least 500 words addressing all of the following topics (a through h):

a. How is the Resource Conservation and Recovery Act (RCRA) different from previous legislation addressing solid waste?

b. On the Internet, search for “40CFR261.21” which is the portion of the Code of Federal Regulations pertaining to ignitability under RCRA. Quote two lines from that portion of the CFR.

c. What are the differences between RCRA Subtitle C and Subtitle D?

d. Describe the cradle to grave tracking process instituted by RCRA.

e. List at least three standards for a Treatment, Storage, or Disposal Facility (TSDF) under RCRA?

f. How is CERCLA different than RCRA?

g. Using an Internet search, determine how many sites are currently on the National Priorities List (NPL).

h. What is a brownfield?

You are required to use at least your textbook as source material for your response. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations.

Format the PowerPoint presentation with headings on each slide and at least one (1) relevant graphic (photograph, graph, clip art, etc..

Due 11-11-2015  (no plagiarism)

Imagine that you work for a company with an age diverse workforce. You have baby boomers working with millenials. Their backgrounds are different, and how they view work is different. This is causing some friction within the workforce. Before the tension escalates, you need to have a meeting to discuss the issue. Prepare a five to seven (5-7) slide PowerPoint presentation for your staff meeting that addresses this issue and proposes a solution.

Create a five to seven (5-7) slide PowerPoint presentation in which you:

  1. Propose a solution that will relieve friction in your company’s age diverse workforce.
  2. Format your assignment according to the following formatting requirements:
    1. Format the PowerPoint presentation with headings on each slide and at least one (1) relevant graphic (photograph, graph, clip art, etc.). Ensure that the presentation is visually appealing and readable from up to 18 feet away.

Definition/description, data type, format, allowable values, whether the field is required or optional, whether the field is indexed and the type of field.

Use the attached file to create a data dictionary similar to the metadata tables shown in Table 1-1 to document your choices. (NO VOLUNTEERS). For each Table in the relational schema provide the following information for each field/data element: field name, definition/description, data type, format, allowable values, whether the field is required or optional, whether the field is indexed and the type of field, whether it is a primary key, whether the field is a foreign key, and the table that is referenced by the foreign key field. A template of this will be provided for consistency.  Page 239 Project Assignments P2.  Please complete a minimum of 8 relations including: Person_T, Employee_T, Physician_T, PhysicianDX_T, Diagnosis_T, and at least four others.

Explain “Why Evolution Is True”.

s Evolution True?  A 10 page Critique and personal Essay on Coyne text “Why Evolution Is True”

 

Essay should reflect upon each of the themes in the chapters in Coynes’ book.  Your essay should include reflections on your growing understanding of Evolution.  Your essay should be a record of your personal journey through the discovery of the concepts used to describe the theory of evolution.  Here you can include your reflections on philosophical, theological, and sociological points that reflect your views on evolution.  Additionally, you should critique and evaluate the ideas presented in the book in a way that demonstrates a scientific understanding of the progressions learned in class that occurs during evolution. Also, watch the NOVA video (found on YouTube) Judgment Day: Intelligent Design On Trial (creationism vs evolution) and relate it to your views on evolution or relate it to what the book says about evolution.

Two different team building methods should be researched and discussed.

Instructions

Go to YouTube™.com and search for “team building” or use any other resources to find information. You are required to find at least two “team building” videos or other resources. You will need to be able to contrast and compare the two videos or resources.

After viewing the video or other resource answer the following questions in a Word document and submit it to the course Dropbox:

  • What type of team building concepts does the videos/resources promote? What type of team dysfunctions does the video/resources address?
  • Do the videos/resources employ techniques you believe would benefit or enhance team performance? Why or why not?
  • Have you experienced this type of team building within your organization? If so, how did it work? If not, do you believe this type of team building would work within your organization? Why or why not?
  • Do you believe one technique is better than the other? Why or why not?
  • How would you employ this technique within your organization? What changes would you adopt? Why or why not?

Requirements

  • Two different team building methods should be researched and discussed. The two team building methods should be contrasted within the paper utilizing and addressing each one of the above questions. The paper should be at a minimum 1000 words.