P5KemN1P

1.mode column
2.headers on
3
4DROP TABLE IF EXISTS Members ;
5DROP TABLE IF EXISTS Books ;
6DROP TABLE IF EXISTS Transactions ;
7
8
9create table Members (MemID int PRIMARY KEY NOT NULL, MemName text, BirthDate date, occupation text);
10create table Books (BookID int PRIMARY KEY NOT NULL, BookTitle text, writer text);
11create table Transactions (MemID int NOT NULL, BookID int NOT NULL,TransactionType text, TransactionDate date);
12
13insert into Books values (1, "The C Programming Language", "Brian W. Kernighan");
14insert into Books values (2, "Pro Git", "Scott Chacon");
15insert into Books values (3, "Planning Extreme Programming", " Kent Beck");
16insert into Books values (4, "The Past Present and Future of JavaScript", "Axel Rauschmayer ");
17insert into Books values (5, "Scratch 2.0 Programming", "Denis Golikov");
18
19
20insert into Members values (1, "Matt Smith",'2000-02-20' , "scientist");
21insert into Members values (2, "James Bruce", '1992-10-17', "scientist");
22insert into Members values (3, " Roger Peng", '1991-09-04', "scientist");
23insert into Members values (4, "Angela Randall", '2000-02-20', "scientist");
24insert into Members values (5, "Shai Almog", '1970-05-07' , "artist");
25insert into Members values (6, "Jamil Soucar", '1999-06-10', "artist");
26insert into Members values (7, "Drew Neil", '1991-02-17', "artist");
27
28insert into Transactions values ( 2, "1" , "borrow" , '2019-08-08' );
29insert into Transactions values ( 2, "1" , "return" , '2019-09-09' );
30insert into Transactions values ( 2, "1" , "borrow" , '2019-10-10' );
31insert into Transactions values ( 2, "1" , "return" , '2019-11-11' );
32insert into Transactions values ( 2, "3" , "return" , '2019-02-02' );
33insert into Transactions values ( 2, "4" , "borrow" , '2019-12-12' );
34insert into Transactions values ( 2, "6" , "return" , '2017-01-01' );
35insert into Transactions values ( 2, 2, "return" , '2015-05-06');
36insert into Transactions values ( 4, 5, "borrow" , '2016-01-01' );
37insert into Transactions values ( 4, 3, "borrow" , '2016-01-01' );
38insert into Transactions values ( 4, 3, "borrow" , '2016-01-01' );
39insert into Transactions values ( 5, 3, "borrow" , '2017-01-01' );
40insert into Transactions values ( 5, 6, "borrow" , '2017-01-01' );
41insert into Transactions values ( 5, 6, "return" , '2017-01-01' );
42insert into Transactions values ( 5, 5, "return" , '2019-01-01' );