There is one script that only creates the database and inserts the tables. (Pick a good name for this, e.g., “buildBanasDatabas.sql”.

Learning Goal: I’m working on a databases multi-part question and need an explanation and answer to help me learn.

HELLO,

Please answer the following database tasks in separate word documents

EXERCISE 2

Submit your answers to the exercise questions at the end of chapter 2 in the free text book in a single Word document. Do not include the questions. Use your own words.

( textbook attached below ) ( https://opentextbc.ca/dbdesign01/ )

SQLZOO 2

Submit screenshots of your successful completion of SELECT from World and SELECT from Nobel and quizzes.

( https://sqlzoo.net/wiki/SQL_Tutorial )

BANAS, REVISITED ( CODE ATTACHED BELOW )

Now that you have succeeded in replicating the infamous Banas database example, I need you to refactor your work into three scripts so that:

1.) There is one script that only creates the database and inserts the tables. (Pick a good name for this, e.g., “buildBanasDatabas.sql”.

2.) There is a second script that loads data into the tables. (Pick a good name, e.g.,, “loadDataIntoBanasDatabase.sql”.)

3.) There is a third and final script that reads the data. (Pick a good name e.g., “readDataFromBanasDatase.sql”.)

You will submit three SQL scripts.

Each one must start with a meaningful comment block that indicates who you are, when you did your work, the CRN number of your course, etc.

Be sure that your scripts actually run.

DESIGNING A DATABASE – SONGBOOK

Using what you have learned from the Banas database create a songbook database. Each book has 10 songs. It has a publication date and a name. Each song has a name, a publication date, a genre and an author. Each author may have multiple songs but each song has a single author. Each genre will have multiple songs but each song has only one genre. Create and use foreign keys to connect the books and songs, the songs and their author, and the songs and their genre. Submit two scripts – one to create the database and one to populate the database. Do your own work. type it out yourself so that you contineu to learn the syntax.

WEEK 2 SELF STUDY LAB – JOHN’S T-SHIRTS

Create a retail database for John’s T-Shirts

Tables: product, customer, Sales Person, Transaction

Reverse engineer and ER diagram using Workbench

Submit a Word document with the database code in screenshots. each screenshot should have a timestamp from your computer.