Question: Need ASAP, please read question carefully You are given a template database with genres, regions, and bands... The Scehma provided for db: CREATE TABLE Sub_Genre

Need ASAP,

please read question carefully

You are given a template database with genres, regions, and bands...

The Scehma provided for db: CREATE TABLE Sub_Genre ( sgid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, gname CHAR(20) NOT NULL, sgname CHAR(20) NOT NULL );

CREATE TABLE Region ( rid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, rname CHAR(20) NOT NULL ); CREATE TABLE Country ( rid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, rname CHAR(20) NOT NULL, cname CHAR(20) NOT NULL );

CREATE TABLE Bands ( bid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, bname CHAR(20) NOT NULL ); CREATE TABLE Band_Origins ( boid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, bname CHAR(20) NOT NULL, cname CHAR(20) NOT NULL ); CREATE TABLE Band_Styles ( boid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, bname CHAR(20) NOT NULL, sgname CHAR(20) NOT NULL );

Do the following question

Question: Write an application in the back end language of your choice to access the database using the created user in task # 1 with a function to run each query in tasks 4-8 with the user ID passed as a parameter.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!