Exercise 1.1

1) Create a database name BOOK_COLLECTION.

2) Develop a table for saving that field :

a. NAME, SIR NAME, BOOK TITLE, TYPE, YEAR, PRICE.

b. Save your table as BOOK

Name	Sir_Name	Book_Title	Type	Year	Price
Gibbons	Kaye	Brain-Like Computing and IIS	Computing Methodologies	1995	$24.00
ORouke	P.J	Computer Architecture 98	Computer System Organization	1996	$15.00
Sandford	John	Computer Integrated Manufacturing	Computer-Aided Engineering	1997	$35.00
Hiaasen	Carl	Parallel And Real-Time Systems	Computing Methodologies	1997	$25.00
Markoe	Merrill	Scientific Computing	Computing Methodologies	1998	$10.00
Conelly	Michael	The CIM Debacle	Computer-Aided Engineering	1994	$15.00

Exercise 1.2

1) Create a DELIVERY table to organize all this below data :

ID	Product_Name	Unit	Bil_Item	Date	Discount	Area	Price
1	AquaForm Deluxe	4	8	17/02/98	0.07	West	120
2	MicroSet P5-100	1	1	26/3/98	0.03	South	170
3	AlphaTree	10	12	05/02/98	0.11	North	140
4	HighNote Special	2	5	15/06/98	0.05	East	450
5	Matrix LC-700	20	8	29/6/98	0.15	West	100
6	Transcel	5	40	07/07/98	0.03	East	40
7	MegaHit Labels	5	120	20/07/98	0.15	South	20
8	ExtraByte Tapes	3	25	25/07/98	0.05	West	25
9	Pointstar Plus	2	2	01/08/98	0.07	North	30
10	Palo Alto Bizform	5	1	04/08/98	0.05	West	60