CIND-110 Data Organization for Data Analysts Assignment II Design… CIND-110Data Organization for Data AnalystsAssignment IIDesign and Maintain a Relati

CIND-110 Data Organization for Data Analysts Assignment II Design… CIND-110Data Organization for Data AnalystsAssignment IIDesign and Maintain a RelationalDatabaseAssignment Context:• A data analyst would like to apply an exploratory data analysis on only a subset of attributes ofthe entire relational database.• A department unit would like to update its local database with more information and ensure itsalignment with the information that exists on the main central database.• The aim of this assignment is to help you practice complex and straightforward SQL queriesconstruction for retrieving or modifying data using a sample of the ShakespeareDB dataset1,which can be found as an SQL file on the course shell, under the Assignment 2 tab.• The design of the ShakespeareDB database schema, including the names of entities, the data typesof the attributes, and the types of the relationships, is shown in the following entity-relationshipdiagram. PRIMARY• Download then run the ShakespeareDB.sql file using the MySQL Workbench tool to load thedatabase to your local machine.• For each question:- provide your responseas an SQL query statement.- Take a screenshot of the resulting output.- Paste the solutionand the respective screenshot into your assignment solutionsheet withquestion number.1https://www.opensourceshakespeare.org1 Produce an SQL statement(s) to find the following: [Total Points: 1002]1. [4 Pts.] For every work dated before 1600, list the work title and the genre type.2. [8 Pts.] Identify the unique genre types of each of Shakespeare’s works.3. [8 Pts.] Retrieve each character’s name whose abbreviation starts with the letter ‘B’ and say aparagraph that includes either the word ‘sir’ or the word ‘lady’.4. [8 Pts.] Retrieve the chapter description and the work title of the ‘poem’ or ‘sonnet genre type.5. [8 Pts.] List the names of characters who have at least one scene in the Macbeth play.6. [8 Pts.] Retrieve the title of the works dated 1612, 1610, 1608 or 1606.7. [8 Pts.] Find the number of characters of each work, ordered from the top down.8. [8 Pts.] Retrieve the number of paragraphs for each character in ‘Hamlet’.9. [8 Pts.] Find characters with more than  200 paragraphs of dialogue, and the number of worksin which the character appears.10. [8 Pts.] Retrieve the name of Hamlet characters who appear in Shakespeare’s other works.11. [8 Pts.] Retrieve the names of all characters who appear in the work that have the highestnumber of paragraphs among all of Shakespeare’s works.12. [8 Pts.] Retrieve the chapters’ descriptions of Othello, Passionate Pilgrim, and Twelfth Nightworks without including the chapters with missing descriptions.13. [8 Pts.] List the names of characters who say ‘How now! what’s the matter?’.14. [BONUS] [8 Pts.] List the paragraphs that more than five different characters have said. Computer Science Engineering & Technology MYSQL CIND 110 Share QuestionEmailCopy link Comments (0)

Sure! Here are some good vegan topics for your essay writing tasks:

The benefits and drawbacks of veganism for health and the environment.
The ethics of animal rights and the impact of veganism on animal welfare.
The economic and social implications of the vegan lifestyle.
The role of veganism in reducing greenhouse gas emissions and combating climate change.
The cultural and historical significance of veganism in different regions of the world.
The impact of veganism on food production and supply chain systems.
The rise of veganism in popular culture and its influence on consumer behavior.
The role of veganism in addressing food insecurity and access to healthy food.
The challenges and opportunities of transitioning to a vegan lifestyle.
The future of veganism and its potential to shape global food systems.
References:

Le, L.T., Sabat? J. (2014). Beyond meatless, the health effects of vegan diets: findings from the Adventist Cohorts. Nutrients, 6(6), 2131-2147. doi:10.3390/nu6062131
Gruen, L. (2011). Ethics and Animals: An Introduction. Cambridge University Press.
Harvard T.H. Chan School of Public Health. (n.d.). The Nutrition Source: Vegetarianism and Veganism. Retrieved from https://www.hsph.harvard.edu/nutritionsource/healthy-eating-plate/vegetarian-and-vegan-diet/
Springmann, M., Clark, M., Mason-D’Croz, D., Wiebe, K., Bodirsky, B.L., Lassaletta, L., … & Willett, W. (2018). Options for keeping the food system within environmental limits. Nature, 562(7728), 519-525. doi:10.1038/s41586-018-0594-0
Watson, E. (2015). Brave New World: The New Veganism. Journal of Animal Ethics, 5(1), 69-78. doi:10.5406/janimalethics.5.1.0069

CIND-110 Data Organization for Data Analysts Assignment II Design…          CIND-110Data Organization for Data AnalystsAssignment IIDesign and Maintain a RelationalDatabaseAssignment Context:• A data analyst would like to apply an exploratory data analysis on only a subset of attributes ofthe entire relational database.• A department unit would like to update its local database with more information and ensure itsalignment with the information that exists on the main central database.• The aim of this assignment is to help you practice complex and straightforward SQL queriesconstruction for retrieving or modifying data using a sample of the ShakespeareDB dataset1,which can be found as an SQL file on the course shell, under the Assignment 2 tab.• The design of the ShakespeareDB database schema, including the names of entities, the data typesof the attributes, and the types of the relationships, is shown in the following entity-relationshipdiagram. PRIMARY• Download then run the ShakespeareDB.sql file using the MySQL Workbench tool to load thedatabase to your local machine.• For each question:- provide your responseas an SQL query statement.- Take a screenshot of the resulting output.- Paste the solutionand the respective screenshot into your assignment solutionsheet withquestion number.1https://www.opensourceshakespeare.org1 Produce an SQL statement(s) to find the following: [Total Points: 1002]1. [4 Pts.] For every work dated before 1600, list the work title and the genre type.2. [8 Pts.] Identify the unique genre types of each of Shakespeare’s works.3. [8 Pts.] Retrieve each character’s name whose abbreviation starts with the letter ‘B’ and say aparagraph that includes either the word ‘sir’ or the word ‘lady’.4. [8 Pts.] Retrieve the chapter description and the work title of the ‘poem’ or ‘sonnet genre type.5. [8 Pts.] List the names of characters who have at least one scene in the Macbeth play.6. [8 Pts.] Retrieve the title of the works dated 1612, 1610, 1608 or 1606.7. [8 Pts.] Find the number of characters of each work, ordered from the top down.8. [8 Pts.] Retrieve the number of paragraphs for each character in ‘Hamlet’.9. [8 Pts.] Find characters with more than  200 paragraphs of dialogue, and the number of worksin which the character appears.10. [8 Pts.] Retrieve the name of Hamlet characters who appear in Shakespeare’s other works.11. [8 Pts.] Retrieve the names of all characters who appear in the work that have the highestnumber of paragraphs among all of Shakespeare’s works.12. [8 Pts.] Retrieve the chapters’ descriptions of Othello, Passionate Pilgrim, and Twelfth Nightworks without including the chapters with missing descriptions.13. [8 Pts.] List the names of characters who say ‘How now! what’s the matter?’.14. [BONUS] [8 Pts.] List the paragraphs that more than five different characters have said.                                                            Computer Science                                                Engineering & Technology                                                MYSQL                             CIND 110                                                                      Share QuestionEmailCopy link                              Comments (0)

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.