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
Get step-by-step solutions from verified subject matter experts
