Question: 6.- Given the following relational database below; create database shop; use shop: create table users( id int null auto increment, firstname varchar(255), lastname varchar
6.- Given the following relational database below; create database shop; use shop: create table users( id int null auto increment, firstname varchar(255), lastname varchar (255) not null, primary key (id) ); create table products( id int null auto increment. name varchar(255), price float, primary key (id) create table orders( id users int not null, id items int not null, primary key (id users.id_items), foreign key (id users) references users(id), foreign key (id items) references items(id) ); write a SQL query to answer the following questions 1.- Products in the shop catalog, product name, code and price. 2.- Products sold in the shop; product name, code, price and full name of buyer.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
