The primary goal of your last assignment is to critically analyze the primary features of the American national government. The results of your analysis will indicate what you have learned over the last five weeks. In order to accomplish this task, it is important to critically evaluate the key facets of our American democracy.

You have been preparing for this final assignment each week by constructing a detailed outline of the Final Paper’s main points through the weekly Learning Activities. In addition, you have read the course text and course readings, reviewed videos, and researched additional material for each week’s assignments and for this paper. This week, you will put all of those outlines, readings, reviews, and research together into a one summative paper.

As we wrap up our course, reflect back on what you have learned about the key structures, systems, roles, and processes that embody our national government. Focus on the strengths and weaknesses, advantages and disadvantages, and positive and negative impacts of these aspects of our democracy. Use what you have learned so far to evaluate our national government and recommend ways to enhance what works and repair what is not working well.

Construct a six-page paper based on the detailed outlines that you created over the last four weeks. Scaffold your paper around the following outline:

1. Title page
2. Introduction (half page):
   1. Describe the paper’s overall thesis.
   2. Provide an overview of main points.
3. The Constitution (1-1.5 pages) (Week 1):
   1. Describe one strength and one weakness of the U.S. Constitution.
   2. Recommend one option to maintain the strength and one to correct the weakness.
4. Federalism (1-1.5 pages) (Week 2):
   1. Describe one advantage and one disadvantage of a national policy that must be implemented by one agency of the federal bureaucracy.
   2. Recommend one option to maintain the advantage and one to improve the disadvantage.
5. Branches of Government (1-1.5 pages) (Week 3):
   1. Describe one strength and one weakness of one branch of our government: Executive, Legislative, or Judiciary.
   2. Recommend one option to maintain the strength and one to correct the weakness.
6. Political Parties, Interest Groups, and Elections (1-1.5 pages) (Week 4):
   1. Describe one positive impact and one negative impact of one of the following: political parties, interest groups, or federal elections.
   2. Recommend one option to accentuate the positive impact and one to lessen the negative impact.
7. Conclusion:
   1. Review your main points.
   2. Review your overall thesis.
8. References page

Writing the Final Paper

The Final Paper:

1. Must be at least six double-spaced pages in length (excluding title and reference pages), and formatted according to APA style as outlined in the Ashford Writing Center.
2. Must include a title page with the following:
   1. Title of paper
   2. Student’s name
   3. Course name and number
   4. Instructor’s name
   5. Date submitted
3. Must begin with an introductory paragraph that has a succinct thesis statement.
4. Must address the topic of the paper with critical thought.
5. Must end with a conclusion that reaffirms your thesis.
6. Must use at least eight scholarly resources, including a minimum of two from the Ashford University Library.
7. Must document all sources in APA style, as outlined in the Ashford Writing Center.
8. Must include a separate reference page, formatted according to APA style as outlined in the Ashford Writing Center.

Your white paper that you have developed on your selected K-12 assessment topic is now ready for you to present to the locally elected board of the school district. Create a presentation using Prezi or similar software in order to present your research to the task force. The information within your presentation will assist the Task Force in developing a district-wide professional development plan geared toward improving the overall test scores of the schools within the district.

Recorded Presentation

Overall presentation style and structure

1. Present your findings in ten (10) slides using Prezi, PowerPoint, or a presentation software of your choice. (Note: Notify the professor on Week 7 concerning the software you choose to use for the presentation).
2. Include a title slide and references section (These two [2] slides are not part of the ten (10) slide requirement).
3. Develop a creative, appealing presentation using your chosen tool for a professional audience, using two to three (2-3) colors, two to three (2-3) fonts, and two to three (2-3) other visuals.
4. Provide coherent, clear, organized, and substantive content that can be easily understood by the audience.
5. Provide audio narration of the presentation slides as if you were delivering the speech (Note: If you do not have access to a microphone, then you should provide detailed speaker notes with your presentation.)
6. Create a section of the presentation (first five [5] slides) in which you:
   1. Provide an overview of the white paper. The overview should include, at a minimum, background on your topic and its relevance to K-12 assessment and the demographics of the district.
   2. Discuss the significant recommendations that you have made within the white paper regarding changes to the district’s current assessment goals.
   3. Provide three (3) methods by which the Task Force might use the white paper in order to develop a district-wide professional development plan geared toward improving the overall test scores of the district.
7. Create a section of the presentation (last five [5] slides) in which you:
   1. Provide your personal reflection in which you highlight what you have learned from developing the white paper as well as what you have learned during this course.
   2. Provide your personal reflection on the new technologies that you researched in Assignment 3 and the manner in which such technologies have changed your views on how to approach assessment in the classroom.
   3. Provide your personal reflection on the manner in which you would implement the recommendations made in Assignment 3 within your own school district or within your classroom practices. Provide specific examples of the changes that you have already made or would like to make.

 

Directions for submitting your presentation:

 

• Submit your presentation to the area designated by your professor.
• Review at least one (1) other classmate’s presentation and post a response indicating what you learned by identifying two (2) specific points that your classmate made in the presentation.

 

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.

 

The specific course learning outcomes associated with this assignment are:

 

• Apply new advances and current thought in the field of educational assessment.
• Analyze traditional theories of assessment.
• Use technology and information resources to research issues in educational assessment.
• Write clearly and concisely about educational assessment using proper grammar and mechanics.

According to Roberts, the industry deems only 25% of technology projects successful. Analyze why this statistic is so low. Suggest strategies that an IT department could use in order to increase the success rate of projects. Give your opinion on whether the structure of the PMO contributes to this statistic. Justify your response.

Imagine that you are a senior business analyst with a multinational corporation. Examine the process of requirements gathering discussed in Chapter 9 of the Roberts text. Suggest your strategy for gathering requirements from across divisional lines. Determine at least two (2) obstacles that you may encounter, and propose one (1) method for overcoming each. Provide a rationale for your response.

Discussion 7
Investigate the importance of effective change leadership in relation to an organization’s adoption of social media initiatives. Next, suggest two (2) ethical issues that a CIO may encounter when implementing social media initiatives. Propose (1) strategy for addressing each identified issue. Provide a rationale for your response.

Select three (3) of the twelve (12) core competencies for IT professionals from Chapter 14 of the Roberts text. Rank each one (1) according to its importance for IT professionals to possess in order to develop their careers and compete in the job market. Justify your ranking.
Discussion 8

Examine the primary reasons why project management causes a cultural change and the impact of that change on integrative information technology. Support your response with at least one (1) example of a cultural change that project management can cause.
The literature affirms that project sponsorship is a major component for the successful completion of projects. Select an organization where you would aspire to serve as a CIO. Explore the role of a project sponsor, and highlight the significant reasons why such a position is pivotal to your organization’s success. Provide a rationale for your response.

Discussion 9

As a newly minted CIO, you have been hired to join a company without a history of project best practices. Suggest strategy and process for your Chief Executive Officer (CEO) to develop standards for your organization that is without any such organizational project history. Justify the main reasons why your suggestion would be effective.

Reflect upon Kerzner’s “Sources of Smaller Migraines” from Chapter 2. Select three (3) issues from the list. Then, specify the reasons why these issues are more critical to control than the others. Justify your response.

Discussion 10

Analyze the relationship between a Feasibility Study and a Cost-Benefit Analysis. Investigate the main reasons why both of these evaluations must tie to the organizational strategic plan. Suggest two (2) issues that an organization may face if these evaluations are not tied to its strategic plan. Provide a rationale for your response.

Review the MSF utilized by Microsoft Corporation in Chapter 15 of Kerzner’s text. Give your opinion as to the degree to which the MSF is versatile. Speculate on whether or not other companies could use MSF, and examine why or why not.

Develop an entire home network with a budget of $5,000.00. Your configuration must assume the purchase of associated hardware for access to both wireless and wired connections and a broadband connection. For the purpose of your configuration you must assume the network will be used by four (4) individuals.

 

Write a two to three (2-3) page paper in which you:

 

1. Describe the hardware you will purchase or build (inclusive of computers, memory, storage, video cards, printers, routers and cabling). Justify your hardware selection.
2. Develop a spreadsheet or table within the two to three (2-3) page paper that itemizes the costs from the online retailer(s) of your choice.
3. Summarize and support the approach you will use to back up your devices.
4. Suppose you were provided an additional $2,000.00 to enhance your network. Explain the changes you would make to grow your infrastructure. Support your response inclusive of memory, storage, networking and redundancy solutions.
5. Use at least two (2) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

 

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.

 

The specific course learning outcomes associated with this assignment are:

 

• Explain how the components of information technology systems interrelate.
• Illustrate the use of information and communication technologies to solve problems as an information technology professional.
• Use technology and information resources to research issues in security management.
• Write clearly and concisely about the theories of security management using proper writing mechanics and technical style conventions.

philosophy 101 paper—6 pages

1. Paper must be typed and submitted in a file format that is commonly readable (Word or .rtf files are best).
2. Paper should be 6 pages in length when double-spaced and using a 12 point font.
3. Include at least four sources;  the textbook may be used as one of your sources. 
4. Please DO NOT cite any online reference encyclopedias such as Wikipedia, Britannica, or Encarta. 
5. Your sources should consist of scholarly journal articles and books available through the Ivy Tech Virtual Library ONLY. 
6. All sources must be cited (must have an end note or a foot note) and the source included in a bibliography. The format of the citations and bibliography must be of a nationally accepted formatting system such as MLA or APA.

 

The paper must be based upon YOUR CHOICE of A or B:

 

4. Compare and contrast the concepts of determinism, compatibilism, and libertarianism, as outlined in Chapter 4. What are the strengths and weaknesses of each of these positions? Which one do you believe is the most likely to be correct? Why?

 

9. Compare and contrast the ethical theories of Aristotle and Immanuel Kant as outlined in Chapter 9.  What are the strengths and weaknesses of each of these positions?  Which one do you believe is the most likely to be correct?  Why?

 

The paper is worth 100 points.

 

Essays will be graded based upon the criteria given below:

 

COMMAND OF TOPIC (up to 50 points)

 

Essay addresses assignment, and demonstrates independent thinking and familiarity with course materials.

 

ARGUMENTATIVE DEVELOPMENT (up to 30 points)

 

Essay shows careful development of related ideas in coherent, sequential paragraphs.

ORGANIZATION (up to 10 points)

 

Student has edited the essay, ensuring that sentences are clear and logical.

 

WRITING MECHANICS & SYNTAX (up to 10 points)

 

Essay is free from errors in word choice and writing mechanics.

Juvenile Rights
Write a 500-750 word paper in APA style which explores the following questions:
Explain the 9 point standard that was devised so that judges could determine whether any juvenile is capable of understanding and waiving one or more of his/his constitutional rights.
Is the 9 point standard fair? Why or why not?
Are these points binding (or should they be binding) in federal district courts?
In your paper, include a title sheet and 2-3 cited references to support your ideas. Only one reference may be found on the internet.
Paper 2 Violent Crime
Domestic Violence
In 2-3 pages, using your own words and APA formatting, examine the connection between stalking and domestic violence. Be sure to discuss the laws surrounding both of these issues and any difficulties that may arise in detection and/or prosecution?

Describe the ethical theory that you have studied in this course that differs the most from what you consider to be feminist ethical thinking.  Utilizing the readings and media from the course, explain specific components of the theories that demonstrate the differences between the theory you choose and feminist theory.

 

Essay

Overview

In the Week One Assignment, you formulated a concrete ethical question, took a position on that topic, and identified a reason supporting and a reason opposing that position. In the Week Three Assignment, you discussed either deontological or utilitarian theory, applied that theory to the question, and raised a relevant objection.

By engaging with the course material, you now have had a chance to refine your thinking and broaden your understanding of the problem by approaching it from the perspective of multiple ethical theories.

In this paper, you will demonstrate what you have learned by writing an essay in which you

• Present a revised formulation of the ethical question and introduction to the topic.
• Explain the kind of reasoning you think is the best way to approach this question, and how that reasoning supports the position you think is strongest.
• Raise an objection, and be able to respond to it.

Instructions

Write an essay that conforms to the requirements below. The paper must be 1500 to 2000 words in length (excluding the title and reference pages) and formatted according to APA style as outlined in the Ashford Writing Center.

The paragraphs of your essay should conform to the following guidelines:

• • Introduction

    Your first paragraph should begin with the topic question, suitably revised. It should be focused, concrete, and on a relevant moral problem. You should then introduce the topic in the way described by the Week One instructions, but reflecting the developed understanding and information you have gained about the topic and any necessary refinement of the scope.

    Follow this with a thesis statement that states your position, and a brief description of the primary reason(s) supporting your position. (See the handout on thesis statements provided). Finally, provide a brief preview of the overall aim and procedure of your paper.

 

• • Explanation and Demonstration of Moral Reasoning

    This section of the Final Paper will explain and demonstrate what you believe to be the best way of reasoning about the question you have chosen, and showing how that reasoning supports the position you have taken on the question. You might explain the principles, rules, values, virtues, conceptions of purposes and ends, and other general ideas that you find persuasive, and show how they support concrete judgments.

    In the course of doing so, you must make reference to at least two of the approaches that we have examined in the course (such as deontological, utilitarian, or virtue-based), and utilize at least one resource off the provided list for each of the two approaches. One of these theories may be the theory you discussed in your Week Three Assignment, but your discussion here should be more refined.

    For example, you might find the reasoning associated with Aristotelian virtue ethics to be the most compelling, and reference Aristotle in the process of showing how that reasoning supports a certain conclusion. In the course of this, you could contrast that with a utilitarian approach, referencing Mill for instance.

 

• • Objection and Response

    After explaining the ethical reasoning that supports your position, you should raise an objection and respond to it. An objection articulates a plausible reason why someone might find the argument weak or problematic. You should explain how it brings out this weakness, and do so in a way that would be acceptable to someone who disagrees with your own argument. Then, provide the best response you can to the objection, showing how it does not undermine your position. Your response should not simply restate your original position or argument, but should say something new in support of it.

 

• Conclusion

  Provide a conclusion that sums up what you presented in the paper and offers some final reflections.

Resource Requirement

You must use at least four scholarly resources. Two of the resources must be drawn from the list of acceptable primary resources on each of the two theories you discuss. For example, if you discuss deontology and virtue ethics, you would need at least one resource under the “Deontology” list and at least one resource under the “Virtue Ethics” list. The other two may be from either the Required or Recommended Resources, or scholarly resources found in the Ashford University Library.

• The textbook may be cited, but it does not count toward the resource requirement. If you cite the textbook, you will still need to cite at least four more sources that fulfill the requirements stated above.
• If you need help with finding additional resources, or are unsure about whether a particular resource will count toward the requirement, please contact your instructor.
• For sources to count toward the resources requirement, they must be cited within the text of your paper and on the reference page. Sources that are listed on the references page, but not cited within the paper, do not count toward fulfilling the resources requirement.
• For information regarding APA, including samples and tutorials

Three-Four (3-4) pages single-spaced, written in proper paper format with citations and bibliography (Use whichever style manual your major discipline requires—but please provide page numbers for citations).
Take one philosophical position on equality/justice from Naomi Wolf and discuss ethical issue of women inequality in workplace. Fully explain the position and the argument justifying this position.
Compare the chosen philosophical position with philosopher John Stuart Mill. Use this philosopher to help develop and show a deeper understanding of the issue. What the philosopher helps you defend or criticize a particular practice?
You are expected to carefully detail the steps of the philosophers’ arguments, develop your own position, and consider objections to your own view.

Please use the following rubric to help you organize and structure your paper:
Rubric/grade criteria:

1. State your topic, why it is a problem, and your position on it in a clear thesis statement. It should be clear to me where you stand/what your view is. You will be developing and defending this view. /10

2. Develop the philosophical position by outlining the main points of the two philosophers’ views (one from unit 3, and one from either unit 1 or 2). Show what the philosophers’ arguments are in a step-by-step manner /10

3. Develop your own position in response to the philosophers. You may agree or disagree. Outline the strongest reasons for your position. /10

4. Anticipate strong objections to your view. What would a reasonable person who disagrees say and why (what reasons)? /10

5. Further support your position. Show why, despite a strong objection, your view is still correct.              /10

6. Demonstrate a thorough understanding of the readings, the authors’ views, class discussion, and the many issues involved in these complex and often contentious topics. Show that you have considered multiple angles—somewhere, someone disagrees with you. How do you respond to them and defend your view? /50
Total: /100

 

·         Week 10 Assignment 5 – Submit Here

Students, please view the “Submit a Clickable Rubric Assignment” in the Student Center.

Instructors, training on how to grade is within the Instructor Center.

Assignment 5: Company Presentation

Due Week 10 and worth 200 points

For this final assignment, imagine that all the research and planning you did for the previous four (4) assignments was part of a global HRM plan your company is devising. You will need to compile all of your findings and present them to your company’s upper management.

Based on the feedback you received for the previous four (4) assignments, address any concerns and update each area based on what you learned throughout this course. Then, create a PowerPoint presentation that includes everything from those assignments. Write out detailed speaker notes, and then narrate the slides as if you were presenting them in a meeting.

Create a ten to fifteen (10-15) slide PowerPoint in which you:

1. Addressed concerns from prior assignment feedback.
2. Converted Assignment 1, 2, 3, and 4 into a cohesive PowerPoint presentation.
3. Suggest a compensation strategy that would support international operations in your company.
4. Indicate two or three (2-3) key strategies your company could use to enhance ethical behavior, labor relations, and work conditions.
5. Format your assignment according to the following formatting requirements:

   a. Format the PowerPoint presentation with headings on each slide and one (1) relevant graphic (photograph, graph, clip art, etc.). Ensuring that the presentation is visually appealing and readable from up to 18 feet away. Check with your professor for any additional instructions.

   b. Include a title slide containing the title of the assignment, your name, your professor’s name, the course title, and the date.

   c. Narrate each slide as if you were presenting them in a meeting, and write out detailed speaker notes. More information about narrating PowerPoint slides can be found here: https://support.office.com/en-au/article/Record-a-slide-show-with-narration-ink-and-slide-timings-3dc85001-efab-4f8a-94bf-afdc5b7c1f0b?ui=en-US&rs=en-AU&ad=AU 

The specific course learning outcomes associated with this assignment are:

• • Determine the nature of globalization, cultures, and labor markets, and assess the impact on human resource management (HRM).
  • Analyze international business strategy to identify human resource requirements and formulate supporting HRM plans that can improve productivity and contribute to the firm’s competitiveness.
  • Propose staffing alternatives for foreign operations and address the considerations for the use of expatriates versus localization or third-country nationals.
  • Assess recruiting and selection strategies that can be used to effectively meet organizational requirements for operating in multiple countries.
  • Select performance management processes to assess and improve performance throughout a multinational corporation.
  • Propose training programs to improve performance throughout a multinational corporation and address the considerations for effective learning in a diverse workforce of expatriates, host country nationals, and third-country nationals.
  • Suggest compensation strategies to support international operations and balance global operational efficiencies with responsiveness to local labor conditions.
  • Analyze effective approaches to the broad spectrum of employee relations issues, including fostering ethical behavior, labor relations, and work conditions.
  • Use technology and information resources to research issues in global HRM.
  • Write clearly and concisely about global HRM using proper writing mechanics.

Click here to view the grading rubric for this assignment.

Included are Assignments 1-4….Please pull from these assignments in order to complete

MIS 403 – Database Management Systems II
Semester 1 – 2015/2016
Group Project
———————-
Deadline for submission: Wednesday 11 November, 2015

Introduction
⦁ The project comprises a group assignment (worth 20% of the total mark for the course).

General information:

The assignment comprises designing and prototyping part of a database systems application. Students should form themselves into groups of up to 4 members, and pass details of the members of their group to the course leader.

In implementing their designs students will use the ORACLE Product SQL*PLUS

The list of products to be handed in on or by the hand-in date is as follows:

⦁ The database design (entity relationship model plus supporting narrative, including any assumptions made)

⦁ A relational schema which comprises listings of table definitions clearly identifying primary and foreign keys.

⦁ SQL code/script showing the implementation of ALL the relations (i.e. creating the tables with the necessary declarative constraints and inserting appropriate sample data).

⦁ The code and results of required queries/reports based on the sample data.

Submission should comprise hard copy (paper) of a, b, c, d above plus soft copy of c and d.

Project group membership

Groups will self-select during the second week of the course. The maximum size is four members per group. All group members should contribute in equal measure to all stages of the group assignment work. It is the responsibility of the group to resolve any internal conflicts.

Groups should appoint a chair and secretary and hold regular meetings (at least one every two weeks). Minutes must be kept and sent to all members. Dates of meetings, persons present, apologies, major points and actions must be listed (comprising a page or less per meeting).
It is not necessary to submit the minutes if the group is satisfied with the contribution of every member, otherwise a copy of the minutes should be attached to the group project report.

The Case Study – Healthy Pets Clinics

Introduction to the case study
A practice called Healthy Pets provides private health care for domestic pets throughout USA. This service is provided through various clinics located in several main cities across the country. The Director of Healthy Pets is concerned that there is a lack of communication within the practice and particularly in sharing of information and resources across the various clinics. To resolve this problem the director has requested the creation of a centralised database system to enable more effective and efficient running of the practice. The director has provided the following description of the current system.

Data Requirements
Veterinary Clinics
Healthy Pets Company has many veterinary clinics located in several cities across USA (New York, Chicago, Dallas, and Boston). The details of each clinic include the clinic number, clinic address (street, city, and zip code), telephone number and e-mail address. Each clinic has a Manager and a number of staff (for example, vets, nurses, secretaries, and cleaners). Clinic number is unique throughout the practice.

Staff
The details stored about each member of staff include staff number, name (first and last), address (street, city, and zip code), telephone number, date of birth, sex, social security number (SSN), position, and current annual salary. The staff number is unique throughout the practice.

Pet Owners
When a pet owner first contacts a clinic of Healthy Pets the details of the pet owner are recorded, which include an owner number, owner name (first name and last name), address (street, city and zip code), and telephone number. The owner number is unique to a particular clinic.

Pets
The details of the pet requiring treatment are noted, which include a pet number, pet name, type of pet, description, age of the pet (if unknown, an approximate age is recorded), date registered at clinic, current status (alive/deceased), and the details of the pet owner. The pet number is unique to a particular clinic.

Examinations
When a sick pet is brought to a clinic, the vet on duty examines the pet. The details of each examination are recorded and include an examination number, the date and time of the examination, the name of the vet, the pet number, pet name, and type of pet, and a full description of the examination results. The examination number is unique to a particular clinic. As a result of the examination, the vet may propose treatment(s) for the pet.
Treatments
Healthy Pets provides various treatments for all types of pets. These treatments are provided at a standard rate across all clinics. The details of each treatment include a treatment number, a full description of the treatment, and the cost to the pet owner. For example, treatments include:

T123 Penicillin antibiotic course $50.00
T155 Feline hysterectomy $200.00
T112 Vaccination course against feline flu $70.00

A standard rate of $20.00 is charged for each examination, which is recorded as a type of treatment. The treatment number uniquely identifies each type of treatment and is used by all Healthy Pets clinics.

Pet Treatments
Based on the results of the examination of a sick pet, the vet may propose one or more types of treatment. For each type of treatment, the information recorded includes the examination number and date, the pet number, name and type, treatment number, description, quantity of each type of treatment, and date the treatment is to begin and end. Any additional comments on the provision of each type of treatment are also recorded.

Invoices
The pet owner is responsible for the cost of the treatment given to a pet. The owner is invoiced for the treatment arising from each examination, and the details recorded on the invoice include the invoice number, invoice date, owner number, owner name and full address, pet number, pet name, and the details of the treatment given. The invoice provides the cost for each type of treatment and the total cost of all treatments given to the pet. Additional data is also recorded on the payment of the invoice, including the date the invoice was paid and the method of payment (for example, check, cash, and visa). The invoice number is unique throughout the practice.

Clinic Pharmaceutical Supplies (Stock)
Each clinic maintains a stock of pharmaceutical supplies (for example, antibiotics, pain killers). The details of pharmaceutical supplies include a drug number and name, description, dosage, method of administration, quantity in stock, reorder level, reorder quantity, and cost. The drug number uniquely identifies each type of pharmaceutical supply. The drug number is unique for each pharmaceutical supply and used throughout the practice.

Appointments
If the pet requires to be seen by the vet at a later date, the owner and pet are given an appointment. The details of an appointment are recorded and include an appointment number, owner number, owner name (first name and last name), home telephone number, the pet number, pet name, type of pet, and the appointment date and time. The appointment number is unique to a particular clinic.
Note: The Director of Healthy Pets has decided that although it is desirable to design appointments into the system, it should not be implemented immediately. You are therefore required to cater for appointments in your design documents (E-R model and relational schema) but NOT to implement this feature at the moment.

Requirements for the case study (deliverables)

a) Develop an Entity Relationship (E-R) model to support the above scenario.
Your model should comprise:

(i) An E-R diagram clearly showing the multiplicities – cardinality and membership constraints – for each pair of related entities (40 marks)

(ii) A relational schema derived from the E-R diagram including appropriate attributes associated with each entity, and the primary and foreign keys of each relation (20 marks)

a) Create tables, including well-designed test data, to implement the application, and identify appropriate integrity constraints to help ensure that data is entered with correct values (10 marks)

a) Set up and test the following queries and reports using Oracle with SQLPLUS and/or PL/SQL: (3 marks each)

(I) List the names and addresses of all pet owners registered at the Boston clinic.

(I) Produce a report listing the manager’s name, clinic address, and telephone number for each clinic, ordered by clinic number.
(I) Produce a report showing all pet owners (Pet_owner_name, city, number of pets) who have registered more than one pet for treatment.

(I) Show the essential details of an unpaid invoice for a given pet owner.

(I) Show which clinic has treated the highest number of Cats so far and how many.

(I) Determine the maximum, minimum and average cost of all treatments administered in the clinics so far.

(I) List the total number of pets in each pet type, ordered by pet type.

(I) Produce a list of the names and staff numbers for all vets and nurses who will retire 5 years from now (if the retirement age is 60) ordered by staff name.

(I) List the pet number, name, and description of pets owned by a particular owner.

(I) For a particular clinic, produce a list showing drug number, unit cost and total cost of all the pharmaceutical items they stock at the moment.

Marking scheme
The Project comprises four main elements:

Analysis: E-R diagram (40 marks)

Design: Normalized Relational Schema/tables (20 marks)

Implementation: Creating relations with necessary constraints and inserting appropriate sample data (10 marks)

Application/Data manipulation: SQL code for the required queries (30 marks, 3 marks for each correct query code and output)

—————————————————————————————————————-