Based on the ER model in USE SQL TO CREATE RELATIONAL TABLES

Based on the ER model in USE SQL TO CREATE RELATIONAL TABLES, INSERT entries into the tables and perform a series of queries on the resulting relational tables.

Insert: Insert the following information into the appropriate tables.

The following are customer addresses (cid, streetAddress, city, state):

43596, 59 southave, Buffulo, NY ,

256 northel, Cleveland, OH

36589, 86 streetY, Atlanta, GA

2583, 128 streetK, Sacremento, CA

The following are company addresses (mid, streetAddress, city, state):

5984, 43 streetX, New York, NY

3647,9 streetA, Houston, TX

58432, 389 StreetY, New Orleans, LA

SQL for CREATING TABLES, INSERTING data AND PERFORMS SOME QUERIES

FOR THE ER MODEL GIVEN BELOW

cid name Buys Customer uantity Lives At streetAddress state Address C1 uantity Delivered date Bread price Product isA. Cake 10111 descriptio Made From Cup Cake filling ocated rid descr naimle Recipe mid quantity Unit Cost Uses uantity name Company Bought From Ingredient aame

Solution

create table customer (cid varchar(10),streetAddress varchar(30),city varchar(15),state varchar(20));

insert into customer values (\'43596\',\'59 southave\',\'Buffulo\',\'NY\');

insert into customer values (\'256\', \'northel\', \'Cleveland\', \'OH\');

insert into customer values (\'36589\', \'86 streetY\', \'Atlanta\', \'GA\');

insert into customer values (\'2583\', \'128 streetK\', \'Sacremento\', \'CA\');

create table company (mid varchar(10),streetAddress varchar(30),city varchar(15),state varchar(20));

insert into customer values (\'5984\', \'43 streetX\', \'New York\', \'NY\');

insert into customer values (\'3647\',\'9 streetA\', \'Houston\', \'TX\');

insert into customer values (\'58432\', \'389 StreetY\', \'New Orleans\', \'LA\');

create table product (pid varchar(20),name varchar(15),price varchar (20),description varchar(50) );

create table recipe (rid varchar(20),name varchar(10),description varchar(30));

select * from customer;

select * from product;

select * from company;

select * from recipe