Identify and create database tables with appropriate field-naming conventions.

One of the main functions of any business is to transform data into information. The use of relational databases and data warehousing has gained recognition as a standard for organizations. A quality database design makes the flow of data seamless. The database schema is the foundation of the relational database. The schema defines the tables, fields, relationships, views, indexes, and other elements. The schema should be created by envisioning the business, processes, and workflow of the company. Since your company is an innovative Internet-based company, movement toward data warehousing seems to be one of the most viable options to give your company a competitive advantage; however, these concepts must be explained to the executive board in a manner to garner support.

  1. Support the need for the use of relational databases and data warehousing. From a management standpoint, it may be important to show the efficiencies that can be gained for executive oversight.
  2. Create a database schema that supports the company’s business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes.
  3. Identify and create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be achieved. Normalize the database tables to third normal form (3NF).
  4. Identify and create an Entity-Relationship (E-R) Diagram relating the tables of the database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix. Explain your rationale behind the design of the E-R Diagram.
  5. Identify and create a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix. Explain the rationale behind the design of your DFD.
  6. Illustrate the flow of data including both inputs and outputs for the use of a data warehouse. The diagram should map data between source systems, operational systems, data warehouses and specified data marts. Note: The graphically depicted solution is not included in the required page length.

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
  • Include charts or diagrams created in MS Visio or Dia as an appendix of the design document. All references to these diagrams must be included in the body of the design document.

Section 2: Revised Project PlanUse Microsoft Project to:

  1. Update the project plan (summary and detail) template, from Project Deliverable 2: Business Requirements, with three to five (3-5) new project tasks each consisting of five to ten (5-10) subtasks.

Analyze and explain whether the women who were not hired can make a claim under Section 1983.

Report Issue

  250 words with one scholarly reference including intext citation in APA format.

1. Explain why reliability is important in human resource selection.

2. Describe the steps in an empirical cross-validation. Explain the desired outcome.

3. You are a Human Resource Management Specialist. City of Rockville hired you as a consultant to review their employee selection process. The City of Rockville administers a test twice a year for all persons interested in becoming firefighters. For the past four years, only males were passing the physical portion of the examination. A year ago both the written exam and the physical portion of the examination were revised. This written portion of the revised examination was administered on June 6th, and the physical portion of the exam was performed on June 8th. There were 2,000 persons taking both sections of the exam. Out of the 2,000 applicants, 285 were females. Of the 285 female applicants, 122 passed the written portion of the exam, and of the 1,715 males who took the written portion of the exam, 1,680 passed. After taking the physical portion of the exam, 29 females scored high enough to be placed on the eligibility list, while 1,500 males were placed on the list. Even though 29 women were eligible, their score was too low to be hired as compared to the males. From this group of applicants, 50 person were hired none of which were women.

1. Discuss how you would advise the City of Rockville.

2. Analyze and explain whether the women who were not hired can make a claim under Section 1983.

4. You are a Human Resource Management Specialist. City of Rockville hired you as a consultant to review their employee selection process. The City of Rockville administers a test twice a year for all persons interested in becoming firefighters. For the past four years, only males were passing the physical portion of the examination. A year ago both the written exam and the physical portion of the examination were revised. This written portion of the revised examination was administered on June 6th, and the physical portion of the exam was performed on June 8th. There were 2,000 persons taking both sections of the exam. Out of the 2,000 applicants, 285 were females. Of the 285 female applicants, 122 passed the written portion of the exam, and of the 1,715 males who took the written portion of the exam, 1,680 passed. After taking the physical portion of the exam, 29 females scored high enough to be placed on the eligibility list, while 1,500 males were placed on the list. Even though 29 women were eligible, their score was too low to be hired as compared to the males. From this group of applicants, 50 person were hired none of which were women.

1. Discussed whether the City of Rockville was involved in overt discrimination in their employee selection process based on Title VII.

2. Research and discuss whether the City of Rockville followed the EEOC Guidelines for determining the proper use of tests and other selection procedures.

For the final exam, you will be analyzing three different hypothetical cases.

 need in 2 hours 100% plagiarism free) MUST BE ORIGINAL !!!

For the final exam, you will be analyzing three different hypothetical cases. Please answer the questions for each case in complete sentences, with proper spelling, grammar and punctuation. Each answer should be at least 3-4 paragraphs in length, and contain reasons for your answers. Please provide citations to cases if you feel it is necessary to fully answer the question.

Case One

A police officer who works near a local airport observes a car speeding on the road leading into the airport. He stops the car and approaches the vehicle, where he sees a man alone in the driver’s seat and his suitcase in the back seat. The traveler is sweating profusely, and keeps telling the officer he is in a hurry to catch a flight. The officer asks the traveler if he can search his luggage, and the man says yes. When the officer unzips the bag and starts the search, the man changes his mind and says no. At that point, the officer leaves the bag unzipped but still laying on the back seat where the contents are not visible. He calls for another officer to bring a drug detection dog to the site. The other officer and the dog get called to a more urgent search and don’t appear. The traveler asks to leave, which the officer says is ok, but he won’t let him take his bag. The traveler refuses to catch his plane, and asks for an attorney.

Analyze this case from both the traveler’s and the police officer’s perspective. What constitutional rights are at issue? Have any of them been violated?

Case Two

A police officer observes a motor home driving erratically down a main street at 10:00 a.m. She is concerned that the driver may be impaired by alcohol or drugs. When the officer approaches the driver’s side of the vehicle, the window is down and she can smell a strong marijuana odor. She also observes two other people in the vehicle, a woman in the front seat and a man in the middle of the mobile home sitting at a table. She also observes a clear plastic bag on the table with a white powdery substance inside. What can the officer do next based on these facts? Be specific in your answer.

Case Three

The Patriot Act, as originally passed and amended, significantly increased the ability of law enforcement to use search and surveillance procedures in the investigation of activities in the United States in the interest of national security and preventing terrorism. One provision of the Act, Section 213, is known as the “sneak and peek” provision. The provision provides law enforcement with warrants to enter a suspect’s house, and look for records on their personal computers, without notifying the suspect a search has occurred. This provision has also been used to investigate crimes other than terrorism, such as drug and fraud cases. Evaluate the pros and cons of this law, and include in your analysis the constitutional provisions that are affected.

INTEGRATION OF FAITH AND LEARNING PAPER INSTRUCTIONS

INTEGRATION OF FAITH AND LEARNING PAPER INSTRUCTIONS

1) Review the Thompson text and apply your knowledge of strategy/policy and your Christian worldview.

2) Search the Bible (either the Old or New Testament) for a Bible verse(s) that would guide you in answering the Ethical/Social Issues question (questions are located in another attached document).

3) In a minimum of 1,000 words, discuss this Bible verse and your Christian worldview as they relate to the Ethical/Social Issues questions.

A suggested format for this assignment is as follows in APA Format:

a. First section: Discuss the answers to the Ethical/Social Issues question (from a strategy/policy perspective). Questions are located in another attached document, same as question 2.

**NOTE: There are a total of 5 questions and each question has an attached document that corresponds to assist you in answering the question**

b. Second section: State your Bible verse and then discuss the verse(s). To properly address this section, it will require biblical research to put your verse(s) into context for the next section.

c. Third paragraph: Discuss/analyze the importance of the Bible verse in addressing the question from a Christian worldview perspective.