Week 12 Comprehension Quiz

Instructions
This quiz will cover the materials and topics from Week 12. All answers should be correct, free from major spelling/grammar errors, and roughly 50+ words in length for full credit. there must be a reference under each question n APA 7th edition.
textbook:
Stand up, Speak out: The Practice and Ethics of Public Speaking Chapter 5: Audience Analysis
you may use outside sources.

Question 1
What are some of the problems a speaker faces when delivering an unacquainted-audience presentation? How can a speaker work around these problems? (50+ words)

Question 2
Which of the Five Categories of Audience Analysis is the most effective? Why do you think that? Justify your response (50+ words)

Question 3
What are the differences between beliefs, attitudes, and values? Give an example of each. How do these traits impact a public speaker? (50+ words)

Question 4
What challenges does a speaker face when delivering a speech to a multicultural audience? What specifics should a speaker be aware of? Be specific. How can a speaker work around these challenges? (50+ words)

Question 5
Why is it important to conduct an audience analysis prior to developing your speech? How can it help you as a speaker? Be specific and justify your response. (50+ words)

Database

A small university is in the process of creating its first database system, and you are the chief architect of this system. This university does not have majors, faculties, and departments, but it does have programs. A program usually has 5 courses (in real situation, a program usually has much more courses, but to make the test data preparation easier, we set this number as 5), For simplicity, all the courses in a program are required and fixed. Prerequisite is not considered.

This university runs in a two-semester system: every year has Winter semester and Fall semester. In every semester, a course may be offered once or not be offered. A course-offering entity is necessary. A professor may teach any courses, and will teach one or more courses each semester. A student may register in a few programs. A course is passed when the grade is 60 or more.

Every person in the campus, a student or a professor, has an ID. This ID is uniformly managed, that means all the IDs are from the same pool, there is no special digit can be used to distinguish professors or students.

(6 marks) Using MySQL Workbench to create an ER model of this new database.

(4 marks) Convert the model into SQL statements which create tables. All the tables must be normalized or denormalized

(5 marks) Create a view Transcript, which is the transcript of all students. It should contain the following columns: studentID, studentName, course, year, semester, grade, professorName. Insert a few data items into the tables. Prepare a select statement to show a students transcript.

(5 marks) Create a view: TeachingProfile, which shows the teaching history of all professors. It should contain the following columns: ProfessorID, ProfessorName, course, year, semester, enrollment. Insert a few data items into the tables. Prepare a select statement to show a professors teaching profile.

(5 marks) Create a view Audit, which is the audit of all students. It should contain the following columns: studentID, programID, neededCourse, (such a row indicates that this course has not been taken or has not passed.). Insert a few data items into the tables. Prepare a select statement to show a students audit.

The design of the tables/relationships should be intuitive, straightforward, and should support university activities. Item 3, 4, 5 are the university activities.

How The Depiction Of People Functions On The Map Made By A Outcomer In The 19th And The 20th Century?

please look clearly on files I upload; the work is a 3 people group work and I need to do my assigned part which is already cleared in the proposal also in requirement file; the course is about map please see syllabus for course content and 2 parts required as I paid for 6 pages ( 5pages=10 slides as first part presentation and 2 pages words document write up for second part individual write up; total 10 slides + 2 pages writing; two part is linked so do ppt first and then do individual write up ; everything should be based on proposal that already finished as a group ; all researches should be according to the topic already developed as a group and we had 3 map chosen based on the Topic the map I assignment is marked in the requirement filed and also tap the link for the map; all ideas should be about history background linked with map )

Advocating for the decrease in stigma and discrimination against the mentally ill

************Please review all attachments. Its has my draft someone done prior, which gave me a grade of a 70 ??. I have changed the main topic, due to guidance from my instructor, which is written on my previous paper with different color typing (please review all her recommendations). Please review grading rubric and instructions that will be uploaded. I need someone who is great at APA 6th edition and has some medical/advocating/mental health background. I have to make a good grade on this and I am crazy busy working on travel assignments to work this pandemic crisis we are under. ******************* She also put at the end of the references in the paper in black writing underneath bottom of paper her expectations. Please if you dont have the time to write a good paper, please dont take assignment . I attached a document where u might can see whole paper, instead of going through all screen shots, but please read directions, grading rubric and other pertinent information. The subject of paper has changed to make it more simple and more about advocating for mental health stigma and discrimination. Thank you!!!