ruhendrawan

DROP TABLE IF EXISTS branch;

CREATE TABLE branch
(branchNo char(5) PRIMARY KEY,
 street varchar(35),
 city varchar(10),
 postcode varchar(10)
);

INSERT INTO branch VALUES('B005','22 Deer Rd','London','SW1 4EH');

ruhendrawan

group: DreamHome
description: Database Systems: A Practical Approach to Design, Implementation, and Management, 6th Edition. Thomas Connolly, Carolyn Begg. 2015

Branch = {
	branchNo:string, street:string, city:string, postcode:string
	'B005'    , '22 Deer Rd'     , 'London'  	, 'SW1 4EH'        
	'B007'    , '16 Argyll St'   , 'Aberdeen'  	, 'AB2 3SU'            
	'B003'    , '163 Main St'    , 'Glasgow'  	, 'G11 9QX'
	'B004'	  , '32 Manse Rd'    , 'Bristol'  	, 'BS99 1NZ'
	'B002'	  , '56 Clover Dr'   , 'London'  	, 'NW10 6EU'

ruhendrawan

group: Oracle Sample
description: OT (Oracle Tutorial) Sample Database. [Show E/R Diagram.](https://www.oracletutorial.com/wp-content/uploads/2017/07/Oracle-Sample-Database.png) Source http://www.oracletutorial.com/oracle

regions = {
	region_id:number, region_name:string

1,'Europe'
2,'Americas'
3,'Asia'
4,'Middle East and Africa'

ruhendrawan

group: akademik

Mahasiswa =
{
	nrp:string, nama:string, gender:string, usia:number, asal_sekolah:string, nip_dosenwali:string
	
	'101', 'bejo', 'laki', 19, 'smu', 'd01'              
	'102', 'amat', 'laki', 20, 'smk', 'd01'              
}

ruhendrawan

group:DreamHome

Branch = {
	bno:string, street:string, area:string, city:string, pcode:string, tel_no:string, fax_no:string

'B5','22 Deer Rd','Sidcup','London','SW1 4EH','0171-886-1212','0171-886-1214'
'B7','16 Argyll St','Dyce','Aberdeen','AB2 3SU','01224-67125','01224-67111'
'B3','163 Main St ','Patrick','Glasgow','G11 9QX','0141-339-2178','0141-339-4439'
'B4','32 Manse Rd','Leigh','Bristol','BS99 1NZ','0117-916-1170','0117-776-1114'
'B2','56 Clover Dr','','London','NW10 6EU','0181-963-1030','0181-453-7992'