Culturally Appropriate OutcomesThinking about your future program design for the target population you will serve, as identified in the media piece in the Studies for this unit, in your initial post, list the culturally appropriate outcomes for your envisioned program. Support your statement by citing two academic sources.

Lab AssignmentsWorth 60 points eachPlease download this document to complete and submit: CIS432 Lab 2, Bike and Barge AppTo review screen shot signature requirements for this lab click hereAny and all written answers must be entered into the online course shell with the submission of the attached lab assignment. Complete the labs based on the following: Write the code for each lab assignment. The lab is to be submitted in a single zip file in the online course shell, which must contain all .java files, along with any additional files that may be necessary for your app to run (for example, code and jar files). Any and all written answers must be entered into the online course shell with the submission of the attached lab assignment. Weekly Lab Breakdown Week Due Graded Lab Exercises 1 None 2 None 3 Lab 1: Sailing Adventures App 4 None 5 Lab 2: Bike and Barge App 6 None 7 Lab 3: Northern Lights Animation App 8 None 9 Lab 4: Electric Car Financing App 10 Lab 5: Publishing Your Android App Each lab assignment will be graded based on the following: The program must compile, execute, produce correct results, and meet all of the specifications in the weekly lab. Additionally you must: Organize the code for user readability. Organize the code for reusability. Provide documentation with embedded comments for reader understanding. Organize the code for efficiency.

SQL Final Project19 pointsDirectionsWelcome to the Final Project for the SQL course! Great job making it this far! This Final Project will be different from the Hands-On projects you have previously seen in a couple of different ways. For the Final Project, you will be putting together the numerous topics you have learned into one large project. It is designed to mimic real problems which you may face in your career, so it may be a challenge for you and will also take several hours. Take this project step-by-step and be aware that the project description below is written to be a bit less specific than previous Hands-Ons. The Final Project is supposed to challenge you to do some problem solving to figure out how to accomplish a task. You can always review past lessons or use a Google search if needed. Please read through the following setup instructions before you start the project. Good luck!SetupThis Final Project is structured into three parts, and each part may ask you to run multiple queries. After each query, please take a screenshot of the MySQL Workbench output and add it to a Word document (or an equivalent) and name this file SQL-FinalProject. This way, you will be able to submit your answers to each part all at once.For this project, you will be working with the same database you have been using throughout this course.Good luck!Part 1Run a query that creates a table named viewer that has the following columns: viewer_id, first_name, last_name, email. Make sure the viewer_id is the primary key and auto increments.Add the following customers:NameEmailKenneth Daviskenneth.davis@gmail.comDavid Shirleydavid.shirley@gmail.comGaby Garciagaby.garcia@gmail.comDonna Bumbletondonna.bumbleton@gmail.comRun a query to see all of the new customers within the database.Additional Info!For an example of creating views, watch this workshop: Views.Part 2Run the following SQL query to add a new table into the database:CREATE TABLE sakila.StreamingServiceQueue( queue_id INTEGER PRIMARY KEY AUTO_INCREMENT, genre NVARCHAR(50) NOT NULL, filmTitle NVARCHAR(50) NOT NULL, streamAvailable BOOLEAN CHECK(streamAvailable IN (true, false)) ) Next, run the following insert statements to add some data to the Products table:-- query 1 INSERT INTO sakila.StreamingServiceQueue (genre, filmTitle, streamAvailable) VALUES ("Movies based on books","The Breadwinner", true) -- query 2 INSERT INTO sakila.StreamingServiceQueue (genre, filmTitle, streamAvailable) VALUES ("Emotional","Roma", false) -- query 3 INSERT INTO sakila.StreamingServiceQueue (genre, filmTitle, streamAvailable) VALUES ("Campy","To Wong Foo, Thanks for Everything Julie Newmar", true) -- query 4 INSERT INTO sakila.StreamingServiceQueue (genre, filmTitle, streamAvailable) VALUES ("Critically Acclaimed","A Single Man", true) Run a query to see all of the films in your Streaming Service queue.Part 3Run the following SQL query to add a new table into the database:CREATE TABLE sakila.WatchedList( watch_id INTEGER PRIMARY KEY AUTO_INCREMENT, queue_id INTEGER NOT NULL, viewer_id INTEGER NOT NULL, FOREIGN KEY(viewer_id) REFERENCES sakila.viewer(viewer_id), FOREIGN KEY(queue_id) REFERENCES sakila.StreamingServiceQueue(queue_id) ) Next, run the following insert statements to add some data to the WatchedList table:-- query 1 INSERT INTO sakila.WatchedList (viewer_id, queue_id) VALUES (1, 2) -- query 2 INSERT INTO sakila.WatchedList (viewer_id, queue_id) VALUES (2, 1) -- query 3 INSERT INTO sakila.WatchedList (viewer_id, queue_id) VALUES (3, 2) -- query 4 INSERT INTO sakila.WatchedList (viewer_id, queue_id) VALUES (4, 1) Lastly, run a query to see the customer's full name, their email address, and their watch_id as well as the genre and title of the film they watched. The list of customers should be ordered in alphabetical order by their last name.Caution!Be sure to zip and submit your SQL-FinalProject Word document when finished! You will not be able to re-submit, so be sure the screenshots to each part are located within this document.