Do not include the questions.

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

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.

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Categories:

No Responses

Leave a Reply

Your email address will not be published. Required fields are marked *