Formatting requirements:
● 1,250 – 1,750 words
● 12 point font, double spaced, 1” margins
● Select a format of your choice (MLA, APA, Chicago); citations should be done in this
format, including a “works cited” page or bibliography. pick a topic from the attached file
Best Writer
The American Prison System
APA format, a dozen of in text citations from a variety of sources ( books, articles, interviews, etc.). Follow this thesis “ The american Prison system targets its victims through hostile, discriminatory, and unethical practices.” Expand and elaborate on the evidence given. Build on the thesis throughout the paper and bring attention to it at the end.
Talk about the history of the American Prison System from its invention to modern day.
Expand on the statement that the American prison System acts as a legalized form of slavery.
Online Food Ordering Database
The Final Project for this course is an accumulation of previous weeks’ assignments in which you will utilize all of the skills you have acquired in this course to implement an Online Food Ordering Database using the latest PHPMyAdmin version. In each week of the course, you performed various tasks toward creating the Online Food Ordering Database. Now you will create SQL scripts that regenerate the tables, relationships, and data of the Online Food Ordering Database.
In Week 1 (Task 1), you defined the system stakeholder, and you recognized the importance of understanding organizational stakeholders for database design success. In Week 2 (Task 2), you provided a complete Chen ER diagram design and corresponding list of tables. In Week 3 (Task 3), you normalized your database to the third normalization form. In Week 4 (Task 4), you used the latest version of MySQL to implement the tables and relationships of the database you normalized in Week 3. Finally, in Week 5 (Task 5), you added “for insert” and “delete” triggers to the “tbl_employee” table to track which employee updated the Online Food Ordering Database.
Now you will incorporate all the feedback you received for the work you created in previous weeks and
Provide a MySQL script to recreate the final database you implemented in the previous tasks.
The script should recreate all the tables, constraints, views, and triggers you have implemented. Name the SQL script “CreateDB.sql”
Provide a MySQL script to add several rows to each of the tables you created.
Do your best to use data and formatting that mimics what is used in a real online ordering system (i.e., emails, first name, last name, credit card information, etc.). Name the SQL script “PopulateData.sql”
Create a step-by-step user guide on how to run the above scripts to create the database from scratch using the “CreateDB.sql” and to populate some data into the generated tables using the “PopulateData.sql.”
Title this document “User Guide.” Your user guide should be detailed enough to include your comments describing the SQL functionalities and overall tasks, along with screenshots of all steps and their outputs.
Create a screencast video presentation using Screencast-O-Matic in which you walk the instructor through your Online Food Ordering Database.
(Quick-start guides for Screencast-O-Matic (Links to an external site.) are provided for your convenience.) Be sure to describe the concepts related to the design and management of your database.
Your screencast should be eight to 10 minutes in length. (It is highly recommended that you create a script and/or speaker’s notes to ensure that your screencast will meet the time requirements. This will also allow you to practice your presentation prior to recording it.)
Once your screencast has been created, make sure to include the URL for your screencast at the end of your User Guide.
Once you have completed the final database with all associated scripts, save them into a zip folder, and submit it to the Week 5 Zip File Submission page. Your zip folder should include two SQL scripts (CreateDB.sql and PopulateData.sql). If you need more guidance, review the Zip File Quick Start Guide Download Zip File Quick Start Guide. Next, submit your User Guide through the Waypoint grading system. Your instructor will run your SQL scripts following your instruction to ensure that the SQL scripts you provided generate the Online Food Ordering Database and populate data in its tables.
The Online Food Ordering Database Final Project:
Must include CreateDB.sql and PopulateData.sql scripts.
Must include a User Guide with the URL for the screencast video presentation.
Must include a Screencast that is eight to 10 minutes in length.
Must include a separate title page with the following:
Title of paper
Student’s name
Course name and number
Instructor’s name
Date submitted
Must document all sources in APA
Below are the weekly assignments that i had to do
week 1
You are hired by a software company to design and implement a database for a new online food ordering website. As an expert in MySQL, you suggest building the new database using MySQL. Your project manager has agreed and requested an initial list of at least three to four types of stakeholders (entities) and their related initial list of at least four to five attributes to be included in your design of the database. To assist you, the project manager shared with you the following list of similar information (that was previously generated for a clinic management system) to help you compile and organize your list of defined stakeholders and their attributes:
Doctor (d_id, d_username, d_password, d_firstName, d_lastName, d_email, d_phone)
Nurse (n_id, n_username, n_password, n_firstName, n_lastName, n_email, n_phone)
Patient (PID, PFirstName, p_lastName, p_email, a_phone, p_adddress)
Diagnostic (DiagID, NID, NurseComment, DID, Diagnostic, Medicine, DiagDate)
In your paper,
Create a completed list of stakeholders and attributes for your Online Food Ordering database in a Word document.
Justify why MySQL is the best choice over other database management systems (DBMS) for your Online Food Ordering database on a separate page. (Your justification should be a minimum of 300 words.)
The Online Food Ordering Database – Task 1 paper
week 2
Create a complete Chen ER diagram design for the entities and attributes you have identified in Week 1. Include a screen shot of your diagram in your paper.
Create tables in Word that corresponds with the entities and attributes in your ER diagram. Your tables should include fields and data types for attributes, as well as the relationships between entities.
Describe the advantages and concepts of your Chen ER diagram and how the diagram will help shape the overall relationship between tables. Your description should be a minimum of 300 words.
week 3
If you designed separate tables for employee and department in your Week 2 assignment, you will want to combine the employee and department tables before you begin this assignment. Your combined table should be called tbl_employee. The tbl_employee contains information about the employee and its department, and it contains the following fields (you may also include other missing fields from your Week 2 design): employee_id, employee_gender ,employee_salary, employee_annual_sallary, department_name, department_location, department head.
For this assignment, you will make use of the database normalization skills you have learned to normalize your database to the third normalization form. You will need to organize your columns and tables to reduce data redundancy and arrange attributes based on the relationships.
In your paper,
Provide a screen shot of the database design before the normalization. Create a heading titled “Database Before Normalization.”
Provide a screen shot of the database design after the normalization. Create a heading titled “Database After Normalization.”
Describe the three normalization forms and the guidelines for transforming from lower normal forms to higher normal forms. Your description should be a minimum of 300 words.
week 4
For this assignment, you will use PHPMyAdmin to implement the normalized database you did in the Week 3 assignment including the following:
Implement all tables, fields, and relationships, and add appropriate constrains on some of the fields (e.g., numbers cannot be negative; dates cannot be in the future unless the requirement specify otherwise).
Assign primary and foreign keys to ensure data integrity and perform faster queries.
Generate an ER diagram from the implemented database.
Write SQL queries to add some data into the implemented tables.
Once you have completed Task 4, you must provide the following in a Word document and submit through the Waypoint grading system:
A screen shot of all developed tables in your database
A screen shot of the ER diagram
A screen of the SQL queries you used to populate data. Be sure also to provide a screen shot for the tables after the data is populated. Note: You should use “Select * from table_name” to view the content of the table
In addition to the screen shots,
Describe Data Definition Language (DDL) insert, update, delete. Your description should be a minimum of 600 words.
Provide at least one example.
Describe inner join, sum, and ordered by. Your description should be a minimum of 600 words.
Provide at least one example.
The Online Food Ordering Database – Task 4 paper
Introduction to the Practice Acts
If you reside in a state other than Louisiana, you may answer these questions using your state’s law governing social work practice. Just be sure to provide a copy of what you are referencing so I can review.
Written exercises – Answer these questions about the Practice Act (the actual law). 1. What is the Legislative purpose for the act? 2. By the act’s definition, what is an “agency?” By the act’s definition, what is “social work practice?” 3. What are the qualifications of a Registered Social Worker? 4. What is the RSW qualified to do? 5. What are the differences in qualifications between a RSW and a LMSW (Licensed Master’s Social Worker)? 6. Is someone allowed to practice social work without a license? (Give the paragraph number and quote the paragraph) 7. Is a criminal background check required in order to get the license? (give the paragraph number) 8. How much continuing education must social workers get in order to renew their licenses? How often? 9. what happens if a person fails to renew her/his license? 10. Name 3 causes for which The Board of Social Work Examiners may deny, revoke, or suspend a credential.
R Stan BRMS
Sample and Data description
The current investigation will analyze the outcomes of 61 study participants across five timepoints (baseline, 6 months, 12 months, 18 months, and 24 months). Participants were interviewed five times over 24 months, with interviews occurring every six months (baseline, 6-months, 12months, 18months, and 24 months. 51 participants received the treatment and belong to the treatment group while 10 participants did not receive the treatment and belong to the intervention group. The purpose of this study is to examine if there are any differences in the outcomes of participants in the treatment group versus those in the control group over time.
Data and Measures
Participant outcomes on 8 specific measures will be considered. Specific measures include a depression scale, scale of housing instability, scale of economic abuse, and a composite scale of abuse which includes 4 subscales: stalking, physical abuse, emotional abuse, and sexual abuse. The data also includes additional participant-level information to be added into estimated models as covariates.
Data has been cleaned, scales scores calculated, univariate analysis completed (i.e., skewness, kurtosis, and missingness have been examined), and transformed from wide to long format in preparation for longitudinal analyses.
Analysis Description
Longitudinal analyses. All longitudinal analyses should be conducted using the brms package in R 4.1. (R Core Team, 2021).
To address the research question, multilevel analysis hierarchical linear modeling (HLM) will be used to model outcome trajectories and compare changes across all five timepoints (baseline, 6-months, 12-months, 18-months, and 24-months) on all dependent variables.
In testing the long-term effects of treatment on safety, housing stability, and depression, an HLM analysis with three levels will be conducted for each dependent variable. Level-1 time variant predictors included will be at the assessment level (e.g., timepoint of interview). Linear, quadratic, cubic, and higher polynomial terms will be included to delineate changes more clearly over time, if needed. Level-2 variables will include the person-level time invariant predictors and IPW estimates that may impact outcome trajectories. Finally, Level-3 will include variables at the organizational level and the type of service received to test the significance of trajectory differences between those who received treatment and those who did not receive treatment. Model building will apply a step-up strategy which will begin with an empty model (i.e., a model without predictors) and gradually add potential predictors pertaining to each of the levels. The final model selection will be based on the best-fit model generated from calculating and comparing the Loo Information Criterion (LOOIC) and the Watanabe-Akaike information criterion (WAIC) scores of several possible models using the loo package in R (Spiegelhalter et al., 2014).
Professional Ethics: Importance and Consequences
Assignment:
Ethics is the foundation of being able to professionally work with clients and colleagues. In a 2-page paper, written using proper spelling/grammar, address the following:
Instructions:
In a 1-2 page Microsoft Word document, address the following:
Explain the importance of ethics as a Human Services Professional when working with clients and interacting with colleagues/co-workers.
Discuss the potential short and long-term consequences of unethical actions/behaviors, when working within the diverse areas of Human Services.
Implement a least one (1) credible resource and include one (1) in-text citation.
Include any resources you used on the reference page.
Chronic vs. One time Disaster
In this exercise, you will conduct research on two sets of disaster experiences:
A chronic disaster of extended (of failed) recovery. You may use the TMI case for this matter, since some argue that it qualifies as a chronic disasters, see TMI@36 conference documentation website – presentations (Link: https://sites.psu.edu/tmi35/sample-page/), or you may choose your own chronic disaster.
A one-time disaster, using one of the cases addressed in this lesson’s required course book reading (Response to Disaster: Psychological, Community and Ecological Approaches, Chapters 1 and 2).
In your analysis, focus on two or three aspects of the trauma experience discussed in Chapter 2 of the course book reading.
Write up a 300-word summary report of your research, analyzing the different and similar themes across descriptions of psychological trauma associated with the two sets of experiences. Add you assessment of the consequences for effective coping as a step towards achieving societal resilience!
Explain why the initial response from a police officer to a missing child call considered a crucial component of an investigation?
Explain why the initial response from a police officer to a missing child call considered a crucial component of an investigation? what does an officer do to verify that a child is missing?
Discuss what these two terms are, why and how this phenomenon occurs, and be able to provide examples of each from your own life and experiences.
Directions: This exam will be
available in Canvas from Thursday, February 3rd from the beginning
of our class period at 9:30 AM and will close in 24 hours at 9:30 AM on Friday,
February 4th. Please download the
exam as a word document and submit it in Exam #1 in the Assignments section in
Canvas. Exams must be uploaded in Canvas
by 9:30 AM on Friday, February 4th.
Failure to do so will result in a zero for this assignment. You should write at least about a half
page for each answer, but feel free to write more than that if needed. Since this is a take-home exam, your answers
will be expected to be very thorough and complete. Please read each item very carefully and
thoroughly. You should address
each question for each number.
Remember to
save your answers early and often!
If you are using a MAC
computer, please make sure that you save your exam as a .doc or a .docx or a
.pdf file. Make sure that it is NOT
saved as a .pages file.
Please only select any 5 of the 7 items below to answer. The exam is worth 75 points total (15 points
for each question that you answer).
#2-Chapter
2 discusses the importance of first and last impressions. Discuss what these two terms are, why and how
this phenomenon occurs, and be able to provide examples of each from your own
life and experiences.
First
impressions are important because we analyze everyone, we meet and what people
see about us first is what determines whether or not we want to keep seeing
this person or not.
#3-Chapter
3 discusses the functions of language.
Discuss any four of these functions and be able to provide examples of
each from your own life and experiences.
#4-Chapter
4 discusses the principles of nonverbal communication. Discuss four of these principles and be able
to provide examples from your own life and experiences.
#5-Chapter
4 discusses the functions of nonverbal communication. Discuss four of these functions and be able
to provide examples from your own life and experiences.
#6-Chapter
5 discusses four listening types.
Discuss these four listening types and provide examples of each and/or
when it would be appropriate and/or effective to engage in each listening type.
What do the readings and the film reveal about the qualities that made someone an “ideal American” at the turn of the century?
Before our next class, read the brief document called “Dawes Act Materials.” As you’ll see, these documents deal with government attempts to “solve” the “Indian problem” in the late nineteenth century.
Then, you will be watching about 35 minutes of a PBS documentary film about the Carlisle Indian School. In it, you’ll encounter the historical circumstances, racial ideologies, and assimilationist
beliefs that motivated the school. You’ll also get a sense of how Indian students responded to
this exercise in forced assimilation—the obstacles they faced, the internal struggles they
suffered through, and the painful changes they were forced to make. The film showcases the
numerous ways in which beliefs about racial identity, citizenship, gender, religion, and civilization were intertwined, and suggests important ways in which these beliefs were embedded in
American society. Start watching the film at about the 20:25 minute mark:
Discussion Prompt:
1) What do the readings and the film reveal about the qualities that made someone an
“ideal American” at the turn of the century? Identify 5 specific attributes that constituted an
“appropriate” identity according to hegemonic norms.
2) How should we view Richard Pratt? In 4-5 sentences, identify your perspective on how Pratt
and his efforts should be remembered in American history.