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

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

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 Programming Questions!