Instructional Leadership

[Type text] [Type text] [Type text]

 

EDLD 5352 Instructional Leadership-Week 1 Assignment

 

 

WORD-DOC-MAST-HEAD

Week 1: Exploring Instructional Leadership through the Instructional Core and Self-Assessment

 

NELP Standard 4 Learning and Instruction

Candidates who successfully complete a building-level educational leadership preparation program understand and demonstrate the capacity to promote the current and future success and well-being of each student and adult by applying the knowledge, skills, and commitments necessary to evaluate, develop, and implement coherent systems of curriculum, instruction, data systems, supports, and assessment.

Component 4.3 Program completers understand and can demonstrate the capacity to evaluate,

develop, and implement formal and informal culturally responsive and accessible assessments that

support data-informed instructional improvement and student learning and well-being.

 

PSEL 4: Curriculum, Instruction, and Assessment

Effective educational leaders develop and support intellectually rigorous and coherent systems of curriculum, instruction, and assessment to promote each student’s academic success and well-being.

 

Texas Principal Standards Pillar: Data-driven Instruction

Principal Domain and Competency

Domain II: Leading Learning

Competency 4

Domain II

 

Course-level Objectives (CLOs):

1. Develop a fundamental understanding of instructional leadership. (Evaluating) (CLO1)

2. Identify and interpret core elements of curriculum alignment used to improve student achievement (Knowledge & Analyzing) (CLO2)

3. Analyze and evaluate data to drive instruction. (Analyzing) (CLO3)

4. Formulate a professional development plan applying data driven decision making. (Creating) (CLO4)

5. Exemplify requisite credentials and program requirements. (Understanding) (CLO5)

 

Week 1 Learning Objectives (W1LO):

1. W1LO1: (CLO1) Examine the role of an instructional leader through the fundamentals of the Instructional Core.

2. W1LO2: (CLO1) Describe leadership skills that address the importance of improving instruction through self-assessment of School Leader Self-Assessment Tool and Educational Leadership Profile Survey.

3. W1LO3: (CLO2) Cultivate components of a professional development plan to improve instruction.

4. W1LO4: (CLO5) Program Requirements: Prepare Progress Check for submission.

 

 

Overview:

In Week 1 of this course you will examine a framework to help instructional leaders understand that the learner, curriculum, and instruction are interrelated. Change one part of this relationship, and you have to consider changes in the other two. Accountability in this relationship is both external and internal. External accountability addresses the question – how well are we doing? Internal accountability addresses the question – what are we doing? This week you will focus on the components of the Instructional Core, complete an Educational Leadership Profile Self-Assessment, and examine the seven levers for Quality Instruction and Culture. Rigor in learning activities, content, and instruction are a priority for instructional leaders of the 21st century.

 

Resources:

 

Week 1 Readings: Be sure you are logged into Blackboard in order to access all of the readings from these links.

 

1. Hallinger, P. (2003). Leading Educational Change: Reflections on the practice of instructional and transformational leadership. Cambridge Journal of Education33(3), 329–338. https://doi-org.libproxy.lamar.edu/10.1080/0305764032000122005

https://libproxy.lamar.edu/login?url=https://search.ebscohost.com/login.aspx?direct=true&db=psyh&AN=2003-09787-001&site=eds-live

 

2. Suh, R. (2017). Instructional Leadership. (p.11) Salem Press Encyclopedia. Retrieved from

https://libproxy.lamar.edu/login?url=https://search.ebscohost.com/login.aspx?direct=true&db=ers&AN=89164275&site=eds-live

 

3. City, E. A., Elmore, R. F., Fiarman, S. E., & Teitel, L. (2009). Instructional rounds in education (p. 30). Cambridge, MA: Harvard Education Press. http://www.macombfsi.net/uploads/1/5/4/4/1544586/instructional_rounds_-_principles.pdf

 

4. Elmore, R. (2010). Leading the instructional core. In Conversation (Vol. 11, No. 3, p. 1-12). http://www.edu.gov.on.ca/eng/policyfunding/leadership/summer2010.pdf

 

5. Desravines, J., Aquino, J., & Fenton, B. (2016). Breakthrough principals: A step-by-step guide to building stronger schools (p.49-55). John Wiley & Sons.

 

6. Bambrick-Santoyo, P. (2018). Leverage Leadership 2.0: A Practical Guide to Building Exceptional Schools (p.365-366). John Wiley & Sons.

 

Week 1 Assignment Rubric:

Use the Rubric to guide your writing.

Tasks Level 1: Does not meet the minimum criteria

0 points

Level 2: Approaches minimum criteria

4 points

Level 3: Meets minimum criteria

6 points

Level 4: Meets target criteria

8 points

Part 1A:

Instructional Core Summary

Candidate examines the elements of an instructional leader through the fundamentals of the Instructional Core by defining the three elements and listing the seven principles for improving student learning

NELP 4

PSEL 4

W1LO1: (CLO1)

 

Candidate lists the three elements of the instructional core. (K) Candidate lists the three elements of the instructional core with little definition. (K) Candidate defines the three elements of the instructional core briefly and may lack clarity. (K) Candidate defines the three elements of the instructional core comprehensively and with clarity. (K)
  Candidate provides no information on the seven principles for improving student learning. (K) Candidate provides information, but no list of the seven principles for improving student learning. (K) Candidate provides an incomplete list of the seven principles for improving student learning. (K) Candidate provides in depth list of the seven principles for improving student learning. ((K)
  Candidate articulates no supporting evidence from the readings and lectures in the summary. (S) Candidate articulates little supporting evidence from the readings and lectures in the summary. (S) Candidate articulates general supporting evidence from the readings and lectures in the summary. (S) Candidate articulates comprehensive evidence from the readings and lectures for specificity and clarity in the summary. (S)
Part 1B:

Self-Assessment Reflection

Candidate examines the elements of an instructional leader through a depth of knowledge of one’s self-reflection regarding their identifiable Areas of Development or Areas of Strength

NELP 4

PSEL 4

W1LO1: (CLO1)

W1LO2: (CLO1)

Candidate demonstrates little or no self-reflection regarding their identifiable Areas of Development or Areas of Strength from the School Leader Self-Assessment Tool. (M) Candidate demonstrates superficial self-reflection regarding their identifiable Areas of Development or Areas of Strength from the School Leader Self-Assessment Tool and is lacking in specificity and clarity. (M) Candidate demonstrates an emerging depth of self-reflection regarding their identifiable Areas of Development or Areas of Strength from the School Leader Self-Assessment Tool and may be lacking in specificity and clarity. (M) Candidate demonstrates and articulates a depth of knowledge of one’s self- regarding their identifiable Areas of Development or Areas of Strength from the School Leader Self-Assessment Tool with specificity and clarity. (M)
 
  Candidate articulates no supporting evidence from the readings, lectures, or self-assessment in the reflection. (S) Candidate articulates little supporting evidence from the readings, lectures, or self-assessment in the reflection. (S) Candidate articulates general supporting evidence from the readings, lectures, or self-assessment in the reflection. (S) Candidate articulates comprehensive evidence from the readings, lectures, or self-assessment with specificity and clarity in the reflection. (S)
Part 2:

Seven Levers: Define & Examples

Candidate defines each of the Seven Leadership Lever and gives an example of each Instructional Levers and Cultural Levers used to improve teacher instruction or student achievement.

NELP 4.3

PSEL 4

W1LO2: (CLO1)

Candidate provides no definition for the Seven Leadership Levers. (K) Candidate defines with little explanation the Seven Leadership Levers. (K) Candidate defines with a general understanding the Seven Leadership Levers. (K) Candidate defines with depth, specificity, and clarity the Seven Leadership Levers. (K)
  Candidate demonstrates little or no ability to give examples of Instructional Levers or Cultural Levers to improve teacher instruction or student achievement. (M) Candidate demonstrates superficial ability to give examples of Instructional Levers or Cultural Levers to improve teacher instruction or student achievement and is lacking in specificity and clarity. (M) Candidate demonstrates an emerging depth of knowledge and ability to give examples of Instructional Levers or Cultural Levers to improve teacher instruction or student achievement and may be lacking in specificity and clarity. (M) Candidate demonstrates and articulates a depth of knowledge and ability regarding examples of Instructional Levers or Cultural Levers to improve teacher instruction or student achievement with specificity and clarity. (M)
Part 3:

Draft: PD Initial Information

Candidate uses data sets to identify trends, patterns, and themes from student work, TAPR, and teachers’ professional development needs survey to plan provide the Initial Information for a 3-Day Professional Development.

NELP 4.4

PSEL 4

W1LO3: (CLO2)

Candidate demonstrates little or no ability to provide initial information for a 3-Day Professional Development. (S) Candidate demonstrates an ambiguous ability to provide initial information for a 3-Day Professional Development. and is lacking in specificity and clarity. (S) Candidate demonstrates an emerging depth of ability to provide initial information for a 3-Day Professional Development and may be lacking in specificity and clarity. (S) Candidate demonstrates and articulates a depth of knowledge and ability regarding initial information for a 3-Day Professional Development with specificity and clarity. (S)
Writing Elements:

W1LO3: (CLO2)

Candidate had spelling, grammar, or technical writing errors.

0-points

    Candidate had no spelling, grammar, or technical writing errors.

11-points

 

 

Part 1A: Instructional Core Summary

Directions:

A. Summary W1LO1:(CLO1): Using the Basic Writing Elements Model found in the Resource section of this course, complete the following summary regarding the Instructional Core.

 

B. Cite any sources and/or readings used as evidence to support your statements in APA format.

Instructional Core:

Directions: Compose 1-2 paragraphs (minimum 200-word) summary of the Instructional Core, by Dr. Richard Elmore from Harvard University, 2008. Define each of the three elements of the core and list the seven principles for improving student learning.
Summary: City, Elmore, Fiarman, and Teitel (2009), explained the Instructional Core as the relationship between the student, teacher and the content. The components of the instructional core impact each other in addition to learning outcomes.

 

According to City, Elmore, Fiarman, and Teitel (2009) the education profession should adopt the medical rounds model. The medical rounds medical is very effective due to the fact it “reproduces practice and the surrounding culture through direct face to face interactions around the work” as a way to build up the way to learn for educators. With applying the instructional rounds, City, Elmore, Fiarman, and Teitel (209) explain that there are seven essential principles for employing instructional rounds in the education field.

First principle: An increase in student learning only occurs as a consequence of improvements in the level of content, teachers’ knowledge and skill, and student engagement.

Second principle: If you change any single element of the instructional core, you have to change the other two to affect student learning.

Third Principle: If you can’t see it in the core, it isn’t there.

Fourth Principle: The task predicts performance.

Fifth Principle: The real accountability system is in the tasks that students are asked to do.

Sixth Principle: We learn to do the work by doing the work, NOT by telling other people to do the work, NOT by having done the work in the past and NOT by hiring experts who can act as proxies for our knowledge about how to do the work.

Seventh Principle: Description before analysis, analysis before prediction, prediction before evaluation.

Reference

City, E. A., Elmore, R. F., Fiarman, S. E., & Teitel, L. (2009). Instructional rounds in education (p. 30). Cambridge, MA: Harvard Education Press.

 

 

Part 1B: Self-Assessments: School Leader Tool and Educational Leadership Profile

Directions:

A. Self-Assessment Reflection W1LO2:(CLO1): Complete the following in-depth self-reflections regarding the results of your completed Self-Assessment by identifying your strengths and weaknesses not only a leader, but as an Instructional Leader. Use the self-reflective model of What? So What? Now What? found in the Resource section of your course.

a. Access online School Leader Self-Assessment Tool (Access PowerPoint in Week 1 for instructions):

https://www.aitsl.edu.au/tools-resources/resource/school-leadership-self-assessment-tool

 

B. Cite any sources and/or readings used as evidence to support your statements in APA format.

 

 

School Leader Self-Assessment Tool: Directions: After completing the School Leader Self-Assessment Tool, compose 1-2 paragraphs (200-word) describing your identified Areas for Development and Areas for Strength.
The School Leader Self-Assessment Tool assists current and aspiring principals to locate their practice within the Leadership Profiles. Identify your strengths and opportunities for development. The School Leader Self-Assessment Tool revealed the area I need to focus on and address is the professional practice of leading teaching and learning. To work in the education field and at a school this skill in vital for this profession. To develop in this area I need to stay up to date with pedagogy and student engagement. The leaders of the school have to be a leading agent of change and the only way to do that is to make sure we are knowledgeable of the latest and current issues in education and honing in on my practice to get better.

 

The School Leader Self-Assessment Tool revealed the area that I am increasing in proficiency is the area of leading the management of the school. For this particular area “principals make best use of technology to record, analyze and share information, monitor progress against goals and support new ways of working.

 

 

Reference

On-Line Survey Page/School Leader Self-Assessment Tool. (n.d.). Retrieved from https://www.aitsl.edu.au/tools-resources/resource/school-leadership-self-assessment-tool

 

On-Line Surveys Page / Educational Leadership Profile (ELP). (n.d.). Retrieved from https://www.ndcel.org/Page/389

 

 

 

 

Part 2: The Seven Levers for Quality Instruction and Culture

Directions:

A. The Seven Levers W1LO1:(CLO1): Review the principle core instructional and cultural areas that are identified as the Seven Levers. These principles allow for “consistent, transformational, and replicable growth” in learning. They are found in your Leverage Leadership 2.0 textbook on pages 8, 365, and 366. In the chart below define each Lever. Then, give an example that can be used on a campus to improve teacher instruction or student achievement. Examples are listed in gray for you to reference, delete examples prior to beginning.

B. Use 12 pt. black font: Times New Roman. The table cells will expand to fit your text.

Instructional Levers Cultural Levers
1. Data-driven Instruction 2. Instructional Planning 3. Observation and Feedback 4. Professional Development

 

5. Student Culture 6. Staff Culture 7. Managing School Leadership Teams
Define: Define: Define: Define: Define: Define: Define:
Define the road map for rigor and adapt teaching to meet students’ needs

(Brambrick-Santoyo, p.8)

Plan backwards to guarantee strong lessons

 

(Brambrick-Santoyo, p.8)

Coach teachers to improve the learning

 

(Brambrick-Santoyo, p.8)

Strengthen culture and instruction with hands on training that sticks

(Brambrick-Santoyo, p.8)

Create a strong culture where learning can thrive

(Brambrick-Santoyo, p.8)

Build and support the right team

(Brambrick-Santoyo, p.8)

Train instructional leaders to expand your impact across the school

(Brambrick-Santoyo, p.8)

Example: Example: Example: Example: Example: Example: Example:
4th grade teachers will meet to create a roadmap to increase rigor and improve student STAAR scores. 4th grade teachers will meet to develop Unit plans that are aligned to STAAR practice tests and materials identify the instructional areas of focus and the strategies. Teachers will take weekly exit ticket data on the area of focus.

 

4th grade teachers will be observed and feedback will be given based on how they implemented the instructional areas of focus, the strategies and best practices. Teachers will collaborate with other teachers to discuss the the instructional areas of focus, the strategies and best practices. Students have been instructed well enough in the area of the instructional focus that they are able to explain it to others. 4th grade teachers will discuss the data from the students exit tickets each week. They will collaborate with one another on ways to improve how the strategy is being implemented 4th grade teachers will assist and support other grade levels to align and implement strategies to improve writing.

Reference

Bambrick-Santoyo, P. (2018). Leverage Leadership 2.0: A Practical Guide to Building Exceptional Schools (p.365-366). John Wiley & Sons.

 

Part 3: Draft: Element for Professional Development:

Comprehensive School-Level Instructional Leadership 3-Day Professional Development Plan

The final signature assessment in this course is to write a comprehensive, school-level instructional leadership 3-Day professional development plan. This plan will be due in Week 4 and include multiple elements. This week you will focus on one of the elements called The Initial Information.

Directions:

A. Data Sets W1LO3:(CLO2): Working collaboratively with a small group on your campus evaluate the data sets given with this week’s assignment, begin to identify trends, patterns, and themes from student work, the TAPR, and the results from a teachers’ professional development needs survey to focus your 3-Day Professional Development Plan. Use suggestions from your collaborative team, data, research, and readings to decide what area(s) of need you will focus on for this 3-Day Professional Development Plan.

Examples are listed in gray for you to reference, delete examples prior to beginning.

 

B. Complete the Professional Development Initial Information. See the student exemplar document in the “Early Info” section in Week 1 for assistance in completing the Focus of Topic, Objective, and other initial information for the 3-Day PD Plan. You will be able to add and delete information to this section in later weeks.

 

C. Use 12 pt. black font: Times New Roman. The table cells will expand to fit your text.

 

School-Level

3-Day

Professional Development Plan

Template

Professional Development Initial Information

Focus of Topic: Engaging students in complex writing

Objective: (Objective)

School Name:

 

Elementary School
Instructional Leader Neonisha Terrell
Professional Development Committee Members: Assistant Principals, Instructional Coach, Curriculum Specialist, Department Heads, Leadership Team
Date plan was created: August 2020
Dates plan will be conducted: October 5, 2020
Dates plan will be in effect: October 5, 2020 through June 1, 2021
Date by which time plan will be updated and revised for upcoming school year: July 1, 2021
Resources to purchase: Journals

Small group tools

Snacks for training

Participation incentives

Lunch for staff

Cost: $800

 

 

 

 

1

Lamar University Revised Spring 2020 v.02.20

Community Needs Analysis Paper

The goal of this assignment is to conduct a community mental health needs and resources assessment that also familiarizes you with the overall mental health needs in your community. Having assessed the most pressing local mental health needs, you will focus on one of the major identified issues involving a specific, marginalized population and evaluate what services are offered and by what organizations.

The paper must be 10-12 pages (not including title page, abstract, or reference page; however, these are required as well). You must use current APA style 7th edition (write in third person) and integrate references to at least 10 recent and relevant sources

 

Note: Your assignment will be checked for originality via the SafeAssign plagiarism tool.

Sample paper:  https://apastyle.apa.org/style-grammar-guidelines/paper-format/professional-annotated.pdf

Video by Dr. Simmons:   https://watch.liberty.edu/media/1_pwjtmc3s

Perdue Owl:  https://owl.purdue.edu/owl/research_and_citation/apa_style/apa_formatting_and_style_guide/apa_changes_7th_edition.html

EDCO 705

Community Needs Analysis Paper Assignment Instructions

The goal of this assignment is to conduct a community mental health needs and resources assessment that also familiarizes you with the overall mental health needs in your community. Having assessed the most pressing local mental health needs, you will focus on one of the major identified issues involving a specific, marginalized population and evaluate what services are offered and by what organizations.

 

Your paper must be 10-12 pages (not including title page, abstract, or reference page; however, these are required as well). You must use current APA style (write in third person) and integrate references to at least 10 recent and relevant sources. Ideally, include both June & Black and Scott & Wolfe in a meaningful way. You may use scholarly journal articles, but your most important sources will be (local and state) government reports, census data, hospital records research, news reports, information from CDC and DHHS, and professional organizations. Sources cited must be specific and relevant to your immediate locality. Include the following content, using appropriate headings:

 

1. Introduction of your community: Describe its location, populations, demographics, and relevant trends, etc.

2. Local needs assessment: Articulate the overall, big picture of your community’s mental health needs and at-risk populations. Be sure to give clear attribution to your sources.

3. Identification of a specific population or issue: Explain why you chose to focus on this particular group.

4. Local resources assessment: Identify the specific organizations that work with this specific population/ issue. Include government, for-profit, and nonprofit organizations in your analysis. How are these organizations addressing this specific need in the community? Your goal is to briefly describe what they do, not to evaluate their effectiveness.

5. Personal reflection: Reflect on how this project has changed your view of your community and/or aided you in better understanding your community. You may use first person in this section.

 

Note: Your assignment will be checked for originality via the SafeAssign plagiarism tool.

 

Hello Class –

I have graded your initial thread to your first discussion board.  I really appreciated the insight that you each shared the case you chose and reflection questions.  You were able to share your wisdom as we begin to learn through our reading and from one another.  The class as a whole did a great job following the rubric and including at least two additional resources to Sue et al. (2014).  Be sure that your citations and resources are in APA format.  I know that we have recently switched from the 6th to the 7th edition and there are some changes.  As a graduate student, you should also be following the professional (not student) format.

Sample paper:  https://apastyle.apa.org/style-grammar-guidelines/paper-format/professional-annotated.pdf

Video by Dr. Simmons:   https://watch.liberty.edu/media/1_pwjtmc3s

Perdue Owl:  https://owl.purdue.edu/owl/research_and_citation/apa_style/apa_formatting_and_style_guide/apa_changes_7th_edition.html

Page 1 of 1

EPA Strategy is: antecedent-based interventions.

EPA Strategy is: antecedent-based interventions.

1. Develop a thesis and 2-3 main ideas based on the peer-reviewed articles related to your strategy. You may use meta-analyses and comprehensive literature reviews to support your thesis. However, research articles must be used to support your main ideas. Specifically, the research articles must be a report of an experimental research design.

a. A thesis is more than just a presentation of the professional literature about the topic. It is a one-sentence statement that is an argument or claim about the research findings on the strategy based on a thorough level of analysis of the professional literature. Before finalizing your thesis, be sure that there is enough research in the professional literature to support it.

b. Your main ideas are two to three ideas, or conclusions, represented across the studies you have reviewed. It is also appropriate to focus one of your main ideas on critical gaps, or points of disagreement, in the research. Each main idea must be supported by four studies.

2. Complete the synthesis matrix using the format presented below. This synthesis matrix includes:

a. Information describing the findings in each research article that support your main ideas (thus supporting your thesis). This is content you will put in the tables. You are to write this information in your own words so that you can avoid plagiarizing the authors’ works.

b. Summary paragraphs written in your own words describing the support for each main idea. In your summary paragraphs, which will be placed beneath the tables, you should avoid summarizing each article separately. Your goal is to identify common themes/conclusions across articles related to your main ideas and, if appropriate, to identify any points of disagreement across articles.

Submission guidelines:

o Your assignment must be formatted in the Synthesis Matrix Template (provided at the end of this document)

o Your strategy description and summary paragraphs must be written in APA 7th edition format (formatting, in-text citations, and a references page).

o Use peer-reviewed articles from the library databases to support your thesis and main ideas.

o NO direct quotes allowed. Summarize in your own words.

o Submit your assignment to the appropriate assignment links in the course.

** You are to focus on only one evidence-based strategy.** Antecedent-based interventions**

For this strategy, you are to write about two main ideas.

You are to identify four references for each main idea. Thus, you will identify a total of 8 references.

The references must be reports of experimental research studies about the evidence-based strategy.

You will construct one table for each main idea. The content that is presented in each reference is to be summarized in one column of the table to which the reference applies. The summary should closely match the relevant information that is presented in the reference’s Abstract section. Specifically, your summary needs to address the following items only: the study’s participants, strategy (meaning the independent variable), and findings.

The evidence-based strategy does not have to be specific to an exceptionality. In other words, the evidence-based strategy can apply across students who have been identified with the various categories of disability that are listed and defined in the IDEA. Conversely, it is okay if the strategy has been investigated with only one student population, such as students with autism.

It is very important that you get the assistance you need to understand how to put this assignment together, properly, since (a) its format is unique and (b) we want to be certain that you learn as much as possible from it.
Once you have read all of the instructions and have agreed to it I will send the articles. This is a graduate class so the writing must be as so.

Article:1 https://journals.sagepub.com/doi/abs/10.1177/10883576050200040401

Article 2: https://journals.sagepub.com/doi/abs/10.1177/019874290903400402

Article 3: https://journals.sagepub.com/doi/abs/10.1177/019874290002500307

Article 4: https://www.jstor.org/stable/24827523?seq=1

Article 5: https://www.tandfonline.com/doi/abs/10.1080/00405841.2011.534935

Article 6: https://journals.sagepub.com/doi/abs/10.1177/10983007050070030301

Article 7: https://link.springer.com/article/10.1007/s10803-009-0693-8

Article 8: https://journals.sagepub.com/doi/abs/10.1177/10983007070090020501

Article 9: https://journals.sagepub.com/doi/abs/10.3102/0034654313498621

RELATIONAL DATABASE DESIGN

ITNPB3 Assignment ONE

 

RELATIONAL DATABASE DESIGN

 

Introduction

“It’s a Dog’s Life” is a kennel which operates just outside the village of Newtown. The kennel’s function is to look after dogs while their owners are out of town. To help with the running of the kennel, they maintain a spreadsheet of the name, breed, and age of each dog who is staying with them, as well as the name, address and phone number of each dog’s owners. The database also stores special instructions for the care of each dog, as well as which kennel room the dog is staying in, and a note of the unique microchip number which each dog has implanted in their neck. Every dog must have a chip number. Vet notes are added to the spreadsheet if a dog is seen by the vet and vet notes must be associated with a single dog.

The current way in which the data are stored is shown in the table below. Note that each person can own more than one dog and each dog can have more than one owner. The vet columns are empty unless the dog has been seen by the vet. A vet visit cannot exist without a dog, of course.

 

Dog Name DogBreed Dog Age Owner Owner Address Owner Phone DogChipNo Note Room Vet ID Vet Date Vet Note
 

Fido

 

Labrador

 

10

Sarah Smith The Meadows Newtown FK40 7LL 01234

567890

 

545682

 

None

 

1

     
 

Fido

 

Labrador

 

10

John Smith The Meadows Newtown FK40 7LL 01234

567890

 

545682

 

None

 

1

     
 

Sheba

 

Labrador

 

9

Sarah Smith The Meadows Newtown FK40 7LL 01234

567890

 

356784

 

None

 

2

76 20.05.18 Worming tablets given
 

Pat

 

Labradoodle

 

3

Sarah Smith The Meadows Newtown FK40 7LL 01234

567890

 

746587

Enjoys petting  

3

     
 

Paddy

Golden retriever  

7

Frank Jones 14 Main Street Newtown FK40 6TT 0376

458015

 

546875

 

Enjoys all

 

6

     
 

Rex

 

Mongrel

 

6

Frank Jones 14 Main Street Newtown FK40 6TT 0376

458015

 

546888

Requires pills  

12

     

 

 

( Page 1 of 3 )

 

 

Your assignment

You have been tasked to turn these data into a relational database. You will need to build the database and write a report about what you did. You only need to submit the report. It should have the following sections:

a. Introduction – Introduce the business requirements and describe one business rule and one use case you can identify from the scenario given above.

10 marks

b. ER Diagram – Identify the entities and relationships in the scenario given above and draw an ER diagram showing the entities, attributes, relationships, and cardinality. Do not decompose any of the relationships at this point.

10 marks

c. Database Schema – Decompose the design to create a schema to store the data in a suitable normal form (2NF or 3NF). Say which normal form the design is in and justify your choice. List the tables and show the fields, primary keys, and any foreign keys in your schema. Describe any assumptions you have made or any additional fields you have added to your design. Make sure all the primary keys are a sensible choice and introduce new fields if needed. Draw a schema diagram to illustrate your design.

20 marks

d. Create Tables – Create a MySQL database to store the schema that you designed in part c. above. Create the tables using SQL statements and reproduce the code in your answer report. Define the keys and choose appropriate data types and any other restrictions you think are required.

20 marks

e. Insert the Data – Insert the data given above into the appropriate tables. Give a single example of an SQL statement that you used to insert one row of data into one of the tables.

10 marks

f. SQL Queries – Carry out the appropriate SQL queries of answering the following questions. For each query, give the SQL code and the result of running the query on the data in your database. Marks are given by each question.

i. Return a list of all dog names (2).

ii. Return a list of all dog breeds, showing each breed only once (3).

iii. Write a query to count how many dogs have the string “Labr” in their breed (2).

iv. Calculate the average age of all dogs in the kennel (2).

v. Calculate the average age of dogs by breed (3).

vi. Find the breed of dog that has an average age of more than 8 (4).

vii. List all the dog names along with their owners’ names (4).

viii. List all the dogs who have had a vet note recorded. Give the name of the dog and the date of the vet note (5).

ix. List all dogs, giving their name, and if a dog has had a vet visit, give the note for the visit, otherwise, if the dog has not visited the vet, return null in the vet note field (5).

 

 

 

Submission

Please write your answers, save them to PDF and upload them in the assignment submission area on iStirling. Include your student number on the front page of the report, but DO NOT PUT YOUR NAME ANYWHERE on the report.

Late penalties of three marks per calendar day you are late in submitting will be applied, up to a maximum of seven calendar days, after which you will receive no grade for the assignment.

 

 

 

Plagiarism

Plagiarism is presenting somebody else’s work as your own. Plagiarism is a form of academic misconduct and is taken very seriously by the University. Students found to have plagiarised work can have marks deducted and, in serious cases, even be expelled from the University. Do not submit any work that is not entirely your own.

The University’s full guidance on academic integrity and misconduct can be found here: https:// www.stir.ac.uk/about/professional-services/student-academic-and-corporate-services/academic- registry/academic-policy-and-practice/quality-handbook/academic-integrity-policy-and-academic- misconduct-procedure/

Please make sure you have read through this guidance.