Tugas Praktikum3 Basis Data

create table customer.

 

 create table employee

create table part

 

create table salesorder

select hasil tabel customer( select * from customer)

select hasil employee( select * from employee)

 

select hasil part ( select * from part)

                                                  select hasil salesorder ( select * from salesorder)

                                                 


                                  finding a customer name using two queries

                                      

                                                                                  

                              Finding a customer name using one query


                           






                                  

                                      













                              
                 Finding an order number for a customer name

                           

                                   
three table joins

four table join

Employees who haves taken orders for customer

Create Tabel statename

sebelum masuk dalam one to many joins, kita harus membuat dulu tabel animal dan vegetable

create table animal

create table vegetable

one to many join


insert dan select dari animal

insert dan select dari vegetable

Unjoined Table