I need help installing / understanding myphpadmin for mac and if i need to install wamp aswell. Also how to create a database from the code below ***************************** ************ This script creates the database named my_guitar_shop*******DROP DATABASE IF EXISTS my_guitar_shop;CREATE DATABASE my_guitar_shop;USE my_guitar_shop;--create the tables for the databaseCREATE TABLE categories (INTVARCHAR(255)category_idcategory_name);CREATE TABLE products (INTINTproduct_idcategory_idproduct_code);*************);CREATE TABLE customers (customer_idemail_addresspasswordfirst_namelast_nameshipping_address_idbilling_address_idPRIMARY KEYNOT NULL,NOT NULLNOT NULL,NOT NULL,TEXTDECIMAL (10, 2)NOT NULL,DECIMAL (10,2) NOT NULLDATETIMEVARCHAR(10)VARCHAR(255)product_namedescriptionlist_pricediscount_percentdate_addedCONSTRAINT products_fk_categoriesFOREIGN KEY (category_id)REFERENCES categories (category_id)INTVARCHAR(255)VARCHAR(60)VARCHAR(60)VARCHAR(60)*********INTINTPRIMARY KEY AUTO_INCREMENT,NOT NULL**********/UNIQUEAUTO_INCREMENT,UNIQUE,DEFAULT 0.00,DEFAULT NULL,PRIMARY KEYNOT NULLNOT NULL,NOT NULL,NOT NULL,AUTO_INCREMENT,UNIQUE,DEFAULT NULL,DEFAULT NULL 1. Write a SELECT statement that returns four columns from the Products table: product_code,product_name, list_price, and discount_percent. Then, run this statement to make sure it works correctly.Add an ORDER BY clause to this statement that sorts the result set by list price in descending sequence.Then, run this statement again to make sure it works correctly. This is a good way to build and test astatement, one clause at a time.

Following steps should be taken to install myphpadmin on mac OS: Step 1: Download a compressed file…

Answered: I need help installing / understanding…

I need help installing / understanding myphpadmin for mac and if i need to install wamp aswell. Also how to create a database from the code below

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: What is the purpose of the Finder in macOS, and how does it work?

A: The finder in macOS is the built-in file management and graphical user interface tool. It serves as…

Q: What is NOT true about tilemap? Increases disk space Increases in performance Incorporate…

A: Tilemap : In Unity Software, the tilemap is the component that is used to create the Game Object.…

Q: Describe the significance of the "Darwin" foundation in MacOS.

A: Darwin serves as the Unix-based core operating system, forming the fundamental framework for…

Q: Below is parts from a cloudformation template. What you need to do is look at the #TODO parts and…

A: AWS CloudFormation which refers to the service that gives the developers and businesses an easy way…

Q: In Linux Op Sys, what is the difference between locate and find commands?

A: Actually, OS is a system software which manages computer hardware and software.

Q: Explain the concept of Spotlight Search and its features in macOS.

A: Spotlight Search is a powerful and versatile search feature in macOS, the operating system used by…

Q: Why is this code not thread safe? 2) What issues could arise if it is not fixed? 3) How you would…

A: Java is a multi-threaded programming language which means we can develop multi-threaded program…

Q: You plan to add to a job to a GitHub workflow that will deploy a container-based web app to Azure…

A: Answer:

Q: As the manager, you have authority over StormWind Studios. The IPAM setup and configuration process…

A: Definition: DNS and DHCP, which offer services to assign and resolve IP addresses of computers in a…

Q: On your Ubuntu Server Linux virtual machine, perform the same steps that you performed in Project…

A: Hey there, I am writing the required solution of the questin mentioned above. Please do find the…

Q: How does the Finder application in MacOS differ from Windows File Explorer?

A: The Finder application in macOS and Windows File Explorer are file management tools designed to help…

Q: How do application bundles work in macOS, and how do they differ from typical executables?

A: Application bundles in macOS are a unique packaging format used to distribute and run applications.…

Q: There is a fundamental difference between page replacement on Android, Linux and Windows. Please…

A: When are requested page is not present in the main memory and the available space is insufficient to…

Q: Using Ubuntu/Linux, create an interface type Menu using AWK combined with Zenity for these specific…

A: while [ 'Exit' !=opt ] ; do clear; op=$(zenity --list --text="\t\t\t\t\tElectronic…

Q: What are the differences between? Thread in Windows and Thread in Linux.?

A: Here's a detailed comparison between threads in Windows and threads in Linux: 1. Thread Creation and…

Q: Reflect on your experience building the Hello World! Django webapp and list at least two…

A: My experience while building the hello world web app in Django is pretty good. Learn a lot of new…

Q: Q21C- What is RBAC ? how does it work on Windows ?

A: Given: What exactly is RBAC? On Windows, how does it work?

Q: Explore the command, use it, and give a detailed description of all its features.

A: Note: "Since you have asked multiple questions, we will solve the first question for you. If you…

Q: Using the example of making a phone call, explain the functionality of Network APIs in a concise…

A: An API acts as a virtual intermediary, transferring information from one interface, such as a mobile…

Q: With IBM Cloud Private, you can choose the prescriptive development approach of Cloud Foundry, or…

A: Please find the answer below :

Q: As the manager, you have authority over StormWind Studios. The IPAM setup and configuration process…

A: IPAM is IP address Management, which acts as administration for DNS(Domain Name System) and…

Question

I need help installing / understanding myphpadmin for mac and if i need to install wamp aswell. Also how to create a database from the code below

********
********
************* ***********
* This script creates the database named my_guitar_shop
*******
DROP DATABASE IF EXISTS my_guitar_shop;
CREATE DATABASE my_guitar_shop;
USE my_guitar_shop;
--
create the tables for the database
CREATE TABLE categories (
INT
VARCHAR(255)
category_id
category_name
);
CREATE TABLE products (
INT
INT
product_id
category_id
product_code
);
*************
);
CREATE TABLE customers (
customer_id
email_address
password
first_name
last_name
shipping_address_id
billing_address_id
PRIMARY KEY
NOT NULL,
NOT NULL
NOT NULL,
NOT NULL,
TEXT
DECIMAL (10, 2)
NOT NULL,
DECIMAL (10,2) NOT NULL
DATETIME
VARCHAR(10)
VARCHAR(255)
product_name
description
list_price
discount_percent
date_added
CONSTRAINT products_fk_categories
FOREIGN KEY (category_id)
REFERENCES categories (category_id)
INT
VARCHAR(255)
VARCHAR(60)
VARCHAR(60)
VARCHAR(60)
*********
INT
INT
PRIMARY KEY AUTO_INCREMENT,
NOT NULL
**********/
UNIQUE
AUTO_INCREMENT,
UNIQUE,
DEFAULT 0.00,
DEFAULT NULL,
PRIMARY KEY
NOT NULL
NOT NULL,
NOT NULL,
NOT NULL,
AUTO_INCREMENT,
UNIQUE,
DEFAULT NULL,
DEFAULT NULL

1. Write a SELECT statement that returns four columns from the Products table: product_code,
product_name, list_price, and discount_percent. Then, run this statement to make sure it works correctly.
Add an ORDER BY clause to this statement that sorts the result set by list price in descending sequence.
Then, run this statement again to make sure it works correctly. This is a good way to build and test a
statement, one clause at a time.

Organized collection of structured information, or data, typically stored in a computer system.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Installing myphpadmin on mac OS

VIEW

Creating database on phpMyAdmin

VIEW

Creating table on phpMyAdmin

VIEW

Question 1

VIEW

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

What is the first process ID for RedHat Enterprise Linux? This treatment is known as...
Upgrade an existing 2008 server to a 2016 server. What are the areas that will be considered for implementation? Make a list of any four actions you can think of.
Write some information about the Chicago/Turabian AND Post Two Additional Resources. 2 2 unread replies. 2 2 replies.
I am designing a web application that allows users to record video files through a web/mobile application. I am looking for a way to import, export, and generate videos with the app. For the app, I am using MERN stack, but instead of MongoDB I am using firebase for the database, and React Native will be used for the mobile. Do you have any ideas on how to implement video generation, import and export? Thank you.
Website Compatibility: Gigantic Life Insurance is planning the implementation of Windows 10 for its internal staff. As part of the migration process, you want to standardize using the Microsoft Edge browser for the enhanced security over Internet Explorer. Several important web-based applications, however, run properly only in Internet Explorer. How can you implement IE Mode to make this process easy for users?
How to create bank management system in Concurrent Programming client and server using c code that include host name, port number, csapp.h and csapp.c. And it have a menu of Check Balance, Deposit, Withdraw and Transfer, and quit for the bank and read the bank.txt. Here's the text file to read in server. //bank.txt 100 John Smith 500.00 200 Jane Doe 1000.00
3-1 Working with the BASH Shell – Linux+ and LPIC-1 Is an alias considered a variable?
Your classmate is seeking for a mechanism to store application files that is both safe and adaptable. Which kind of storage would you recommend? Justify.
The class I'm taking is assembly programming. I am completely stuck. I have attached the problem. Please view attachment before answering. Thank you so much for your help! Any help is greatly appreciated.
Explore the integration of Windows Subsystem for Linux (WSL) 2.0 with Docker for running Linux-based containers on Windows.
i am trying to uplode a nodejs file to heroku this file is working well on py pc it self . but it cant run on heroku the log is like this -----> Building on the Heroku-20 stack-----> Using buildpack: heroku/nodejs-----> Node.js app detected -----> Creating runtime environment NPM_CONFIG_LOGLEVEL=error NODE_VERBOSE=false NODE_ENV=production NODE_MODULES_CACHE=true how could i fix this problem ?what is NPM_CONFIG_LOGLEVEL=error NODE_VERBOSE=false ?
Discuss the differences between two interfaces presented below. Find out the best one, and why you consider it is a good interface. please I want the solution to be clear.