I did the table creation and data input in Microsoft SQL server management Studio then switched to Microsoft Access to actually write queries for the prompts.<\/strong><\/p>\n\n\n\n A. Write the SQL statements in order to create the tables for the database. Use the Entity Relationship Diagram (ERD) of the database shown in Figure 1. For simplicity, we are assuming in this project that a book cannot be written by more than one author. You need to create the tables as well as the required constraints, including the keys (primary and foreign), and the relationships between tables.<\/p>\n\n\n\n B. Populate your database with the sample set of data given to you in the tables below the assignment prompts.<\/p>\n\n\n\n CREATE DATABASE SDC;<\/p>\n\n\n\n USE SDC;<\/p>\n\n\n\n CREATE TABLE Author ( CREATE TABLE Book ( CREATE TABLE Client ( CREATE TABLE Borrower ( SELECT * SELECT * SELECT * SELECT * INSERT INTO Author (AuthorFirstName,AuthorLastName,AuthorNationality) INSERT INTO Book (BookTitle,BookAuthor,Genre) INSERT INTO Client(ClientFirstName,ClientLastName,ClientDoB,Occupation) INSERT INTO Borrower(ClientId,BookId,BorrowDate) From here I switched to Microsoft Access because it was a more user friendly program to work with. Also it was easier to save my queries and their outputs. The way I populated the data into Access was by importing the tables into Excel via the web search function. I pasted the URL of the assignment page and Excel was able to pull the data directly from the website. I then saved all 4 tables in an .xlsx file and imported that into Access. I set up my primary keys easily in the Access GUI and I set the foreign keys via the relationships tab. After that all the data and relationships were created. It is also why the SQL between the first half and second half is a bit different.<\/strong><\/p>\n\n\n\n SELECT * FROM Client;<\/p>\n\n\n\n SELECT client.ClientFirstName, client.ClientLastName, (YEAR(NOW())-ClientDoB) AS Age, client.Occupation SELECT ClientFirstName, ClientLastName -Index SQL<\/p>\n\n\n\n CREATE INDEX Borrower_idx SELECT TOP 5 Author.AuthorFirstName, Author.AuthorLastName SELECT TOP 5 Author.AuthorNationality, Count(Author.AuthorNationality) AS CountOfAuthorNationality SELECT TOP 1 Book.BookTitle SELECT TOP 5 Genre![\"\"](\"https:\/\/jonthecyberguy.tech\/wp-content\/uploads\/2022\/07\/new_erd_new_db_assignment.png\")
<\/figure>\n\n\n\n{CREATING DATABASE}<\/h3>\n\n\n\n
\n
\n
{CREATING TABLES}<\/h3>\n\n\n\n
\n
AuthorId INT NOT NULL IDENTITY PRIMARY KEY,
AuthorFirstName VARCHAR(30),
AuthorLastName VARCHAR(30),
AuthorNationality VARCHAR(50),
AuthorDoB DATE
);<\/p>\n\n\n\n
\n\n\n\n\n
BookId INT NOT NULL IDENTITY PRIMARY KEY,
BookTitle VARCHAR(50),
BookAuthor INT,
Genre VARCHAR(30),
FOREIGN KEY(BookAuthor) REFERENCES Author(AuthorId)
);<\/p>\n\n\n\n
\n\n\n\n\n
ClientId INT NOT NULL IDENTITY PRIMARY KEY,
ClientFirstName VARCHAR(30),
ClientLastName VARCHAR(30),
ClientDoB Date,
Occupation VARCHAR(50)
);<\/p>\n\n\n\n
\n\n\n\n\n
BorrowId INT NOT NULL IDENTITY PRIMARY KEY,
ClientId INT,
BookId INT,
BorrowDate Date,
FOREIGN KEY(ClientId) REFERENCES Client(ClientId),
FOREIGN KEY(BookId) REFERENCES Book(BookId)
);<\/p>\n\n\n\n
\n\n\n\n\n
FROM Author;<\/p>\n\n\n\n
FROM Client;<\/p>\n\n\n\n
FROM Book;<\/p>\n\n\n\n
FROM Borrower;<\/p>\n\n\n\n{INPUTTING DATA}<\/h3>\n\n\n\n
\n
VALUES (‘Sofia’,’Smith’,’Canada’),
(‘Maria’,’Brown’,’Brazil’),
(‘Elena’,’Martin’,’Mexico’),
(‘Zoe’,’Roy’,’France’),
(‘Sebastian’,’Lavoie’,’Canada’),
(‘Dylan’,’Garcia’,’Spain’),
(‘Ian’,’Cruz’,’Mexico’),
(‘Lucas’,’Smith’,’USA’),
(‘Fabian’,’Wilson’,’USA’),
(‘Liam’,’Taylor’,’Canada’),
(‘William’,’Thomas’,’Great Britain’),
(‘Logan’,’Moore’,’Canada’),
(‘Oliver’,’Martin’,’France’),
(‘Alysha’,’Thompson’,’Canada’),
(‘Isabelle’,’Lee’,’Canada’),
(‘Emily’,’Clark’,’USA’),
(‘John’,’Young’,’China’),
(‘David’,’Wright’,’Canada’),
(‘Thomas’,’Scott’,’Canada’),
(‘Helena’,’Adams’,’Canada’),
(‘Sofia’,’Carter’,’USA’),
(‘Liam’,’Parker’,’Canada’),
(‘Emily’,’Murphy’,’USA’);<\/p>\n\n\n\n
\n\n\n\n\n
VALUES (‘Build your database system’,’1′,’Science’),
(‘The red wall’,’2′,’Fiction’),
(‘The perfect match’,’3′,’Fiction’),
(‘Digital Logic’,’4′,’Science’),
(‘How to be a great lawyer’,’5′,’Law’),
(‘Manage successful negotiations’,’6′,’Society’),
(‘Pollution today’,’7′,’Science’),
(‘A gray park’,’2′,’Fiction’),
(‘How to be rich in one year’,’8′,’Humor’),
(‘Their bright fate’,’9′,’Fiction’),
(‘Black lines’,’10’,’Fiction’),
(‘History of theater’,’11’,’Literature’),
(‘Electrical transformers’,’12’,’Science’),
(‘Build your big data system’,’1′,’Science’),
(‘Right and left’,’13’,’Children’),
(‘Programming using Python’,’1′,’Science’),
(‘Computer networks’,’14’,’Science’),
(‘Performance evaluation’,’15’,’Science’),
(‘Daily exercise’,’16’,’Well being’),
(‘The silver uniform’,’17’,’Fiction’),
(‘Industrial revolution’,’18’,’History’),
(‘Green nature’,’19’,’Well being’),
(‘Perfect football’,’20’,’Well being’),
(‘The chocolate love’,’21’,’Humor’),
(‘Director and leader’,’22’,’Society’),
(‘Play football every week’,’20’,’well being’),
(‘Maya the bee’,’13’,’Children’),
(‘Perfect rugby’,’20’,’Well being’),
(‘The end’,’23’,’Fiction’),
(‘Computer security’,’1′,’Science’),
(‘Participate’,’22’,’Society’),
(‘Positive figures’,’3′,’Fiction’);<\/p>\n\n\n\n
\n\n\n\n\n
VALUES (‘Kaiden’,’Hill’,2006,’Student’),
(‘Alina’,’Morton’,2010,’Student’),
(‘Fania’,’Brooks’,1983,’Food Scientist’),
(‘Courtney’,’Jensen’,2006,’Student’),
(‘Brittany’,’Hill’,1983,’Firefighter’),
(‘Max’,’Rogers’,2005,’Student’),
(‘Margaret’,’McCarthy’,1981,’School Psychologist’),
(‘Julie’,’McCarthy’,1973,’Professor’),
(‘Ken’,’McCarthy’,1974,’Securities Clerk’),
(‘Britany’,’O”Quinn’,1984,’Violinist’),
(‘Conner’,’Gardner’,1998,’Licensed Massage Therapist’),
(‘Mya’,’Austin’,1960,’Parquet Floor Layer’),
(‘Thierry’,’Rogers’,2004,’Student’),
(‘Eloise’,’Rogers’,1984,’Computer Security Manager’),
(‘Gerard’,’Jackson’,1979,’Oil Exploration Engineer’),
(‘Randy’,’Day’,1986,’Aircraft Electrician’),
(‘Jodie’,’Page’,1990,’Manufacturing Director’),
(‘Coral’,’Rice’,1996,’Window Washer’),
(‘Ayman’,’Austin’,2002,’Student’),
(‘Jaxson’,’Austin’,1999,’Repair Worker’),
(‘Joel’,’Austin’,1973,’Police Officer’),
(‘Alina’,’Austin’,2010,’Student’),
(‘Elin’,’Austin’,1962,’Payroll Clerk’),
(‘Ophelia’,’Wolf’,2004,’Student’),
(‘Eliot’,’McGuire’,1967,’Dentist’),
(‘Peter’,’McKinney’,1968,’Professor’),
(‘Annabella’,’Henry’,1974,’Nurse’),
(‘Anastasia’,’Baker’,2001,’Student’),
(‘Tyler’,’Baker’,1984,’Police Officer’),
(‘Lilian’,’Ross’,1983,’Insurance Agent’),
(‘Thierry’,’Arnold’,1975,’Bus Driver’),
(‘Angelina’,’Rowe’,1979,’Firefighter’),
(‘Marcia’,’Rowe’,1974,’Health Educator’),
(‘Martin’,’Rowe’,1976,’Ship Engineer’),
(‘Adeline’,’Rowe’,2005,’Student’),
(‘Colette’,’Rowe’,1963,’Professor’),
(‘Diane’,’Clark’,1975,’Payroll Clerk’),
(‘Caroline’,’Clark’,1960,’Dentist’),
(‘Dalton’,’Clayton’,1982,’Police Officer’),
(‘Steve’,’Clayton’,1990,’Bus Driver’),
(‘Melanie’,’Clayton’,1987,’Computer Engineer’),
(‘Alana’,’Wilson’,2007,’Student’),
(‘Carson’,’Byrne’,1995,’Food Scientist’),
(‘Conrad’,’Byrne’,2007,’Student’),
(‘Ryan’,’Porter’,2008,’Student’),
(‘Elin’,’Porter’,1978,’Computer Programmer’),
(‘Tyler’,’Harvey’,2007,’Student’),
(‘Arya’,’Harvey’,2008,’Student’),
(‘Serena’,’Harvey’,1978,’School Teacher’),
(‘Lilly’,’Franklin’,1976,’Doctor’),
(‘Mai’,’Franklin’,1994,’Dentist’),
(‘John’,’Franklin’,1999,’Firefighter’),
(‘Judy’,’Franklin’,1995,’Firefighter’),
(‘Katy’,’Lloyd’,1992,’School Teacher’),
(‘Tamara’,’Allen’,1963,’Ship Engineer’),
(‘Maxim’,’Lyons’,1985,’Police Officer’),
(‘Allan’,’Lyons’,1983,’Computer Engineer’),
(‘Marc’,’Harris’,1980,’School Teacher’),
(‘Elin’,’Young’,2009,’Student’),
(‘Diana’,’Young’,2008,’Student’),
(‘Diane’,’Young’,2006,’Student’),
(‘Alana’,’Bird’,2003,’Student’),
(‘Anna’,’Becker’,1979,’Security Agent’),
(‘Katie’,’Grant’,1977,’Manager’),
(‘Joan’,’Grant’,2010,’Student’),
(‘Bryan’,’Bell’,2001,’Student’),
(‘Belle’,’Miller’,1970,’Professor’),
(‘Peggy’,’Stevens’,1990,’Bus Driver’),
(‘Steve’,’Williamson’,1975,’HR Clerk’),
(‘Tyler’,’Williamson’,1999,’Doctor’),
(‘Izabelle’,’Williamson’,1990,’Systems Analyst’),
(‘Annabel’,’Williamson’,1960,’Cashier’),
(‘Mohamed’,’Waters’,1966,’Insurance Agent’),
(‘Marion’,’Newman’,1970,’Computer Programmer’),
(‘Ada’,’Williams’,1986,’Computer Programmer’),
(‘Sean’,’Scott’,1983,’Bus Driver’),
(‘Farrah’,’Scott’,1974,’Ship Engineer’),
(‘Christine’,’Lambert’,1973,’School Teacher’),
(‘Alysha’,’Lambert’,2007,’Student’),
(‘Maia’,’Grant’,1984,’School Teacher’);<\/p>\n\n\n\n
\n\n\n\n\n
VALUES (35,17,’2016-07-20′),
(1,3,’2017-04-19′),
(42,8,’2016-10-03′),
(62,16,’2016-04-05′),
(53,13,’2017-01-17′),
(33,15,’2015-11-26′),
(40,14,’2015-01-21′),
(64,2,’2017-09-10′),
(56,30,’2017-08-02′),
(23,2,’2018-06-28′),
(46,19,’2015-11-18′),
(61,20,’2015-11-24′),
(58,7,’2017-06-17′),
(46,16,’2017-02-12′),
(80,21,’2018-03-18′),
(51,23,’2015-09-01′),
(49,18,’2015-07-28′),
(43,18,’2015-11-04′),
(30,2,’2018-08-10′),
(48,24,’2015-05-13′),
(71,5,’2016-09-05′),
(35,3,’2016-07-03′),
(57,1,’2015-03-17′),
(23,25,’2017-08-16′),
(20,12,’2018-07-24′),
(25,7,’2015-01-31′),
(72,29,’2016-04-10′),
(74,20,’2017-07-31′),
(53,14,’2016-02-20′),
(32,10,’2017-07-24′),
(12,15,’2018-04-25′),
(77,13,’2017-06-09′),
(30,4,’2017-10-24′),
(37,24,’2016-01-14′),
(27,26,’2017-06-05′),
(1,16,’2018-05-06′),
(21,9,’2016-03-19′),
(69,28,’2017-03-29′),
(17,19,’2017-03-14′),
(8,9,’2016-04-22′),
(63,18,’2015-01-25′),
(65,20,’2016-10-10′),
(51,19,’2015-07-28′),
(23,12,’2017-01-25′),
(17,4,’2017-04-18′),
(68,5,’2016-09-06′),
(46,13,’2017-09-30′),
(15,13,’2017-07-05′),
(11,19,’2017-12-14′),
(78,15,’2017-01-26′),
(47,9,’2015-03-03′),
(68,7,’2016-05-26′),
(37,26,’2017-02-06′),
(48,27,’2015-12-30′),
(9,21,’2017-10-21′),
(29,8,’2018-04-01′),
(64,18,’2017-08-29′),
(61,26,’2018-02-21′),
(39,28,’2016-07-26′),
(73,18,’2018-08-22′),
(11,13,’2018-01-17′),
(45,6,’2016-07-20′),
(33,13,’2018-03-18′),
(10,17,’2016-06-06′),
(28,18,’2017-02-17′),
(51,3,’2016-12-09′),
(29,2,’2015-09-18′),
(28,30,’2017-09-14′),
(74,20,’2015-12-12′),
(15,22,’2015-01-14′),
(57,8,’2017-08-20′),
(2,5,’2015-01-18′),
(74,12,’2018-04-14′),
(51,10,’2016-02-25′),
(25,17,’2015-02-24′),
(45,21,’2017-02-10′),
(27,25,’2016-08-03′),
(32,28,’2016-06-15′),
(71,21,’2017-05-21′),
(75,26,’2016-05-03′),
(56,32,’2015-12-23′),
(26,32,’2015-05-16′),
(66,32,’2015-05-30′),
(57,18,’2017-09-15′),
(40,15,’2016-09-02′),
(65,4,’2017-08-17′),
(54,7,’2015-12-19′),
(29,4,’2017-07-22′),
(44,9,’2017-12-31′),
(56,31,’2015-06-13′),
(17,4,’2015-04-01′),
(35,16,’2018-07-19′),
(22,18,’2017-06-22′),
(39,24,’2015-05-29′),
(63,14,’2018-01-20′),
(53,21,’2016-07-31′),
(40,9,’2016-07-10′),
(52,4,’2017-04-05′),
(27,20,’2016-09-04′),
(72,29,’2015-12-06′),
(49,16,’2017-12-19′),
(6,12,’2016-12-04′),
(74,31,’2016-07-27′),
(48,32,’2016-06-29′),
(69,2,’2016-12-27′),
(60,32,’2017-10-29′),
(45,22,’2017-06-12′),
(42,15,’2017-05-14′),
(79,8,’2016-10-13′),
(70,18,’2016-12-04′),
(34,8,’2016-03-06′),
(43,8,’2015-12-19′),
(42,32,’2016-04-20′),
(67,5,’2017-03-06′),
(80,25,’2015-06-23′),
(54,11,’2017-05-03′),
(34,28,’2017-08-30′),
(65,20,’2017-08-26′),
(61,19,’2018-01-05′),
(38,12,’2018-01-17′),
(51,4,’2016-05-13′),
(7,16,’2016-03-17′),
(46,16,’2016-11-25′),
(75,30,’2018-08-12′),
(72,32,’2015-03-12′),
(44,17,’2015-06-15′),
(68,15,’2016-02-21′),
(21,1,’2016-06-19′),
(14,25,’2016-10-10′),
(68,21,’2016-05-27′),
(35,20,’2015-03-19′),
(16,27,’2016-08-08′),
(79,31,’2018-03-07′),
(14,17,’2018-04-28′),
(29,28,’2018-03-11′),
(41,4,’2018-08-08′),
(42,3,’2016-02-23′),
(45,3,’2017-07-10′),
(36,16,’2018-07-19′),
(36,30,’2015-08-07′),
(54,32,’2018-03-14′),
(61,15,’2017-03-28′),
(1,13,’2018-05-17′),
(43,1,’2015-05-14′),
(37,14,’2015-07-30′),
(62,17,’2015-09-19′),
(50,22,’2016-12-02′),
(45,1,’2016-07-24′),
(32,17,’2018-03-10′),
(13,28,’2016-02-14′),
(15,9,’2018-08-11′),
(10,19,’2018-08-29′),
(66,3,’2016-11-27′),
(68,29,’2017-07-12′),
(21,14,’2018-06-27′),
(35,9,’2016-01-22′),
(17,24,’2016-08-25′),
(40,21,’2015-07-09′),
(1,24,’2016-03-28′),
(70,27,’2015-07-10′),
(80,26,’2016-04-24′),
(29,5,’2015-10-18′),
(76,12,’2018-04-25′),
(22,4,’2016-12-24′),
(2,2,’2017-10-26′),
(35,13,’2016-02-28′),
(40,8,’2017-10-02′),
(68,9,’2016-01-03′),
(32,5,’2016-11-13′),
(34,17,’2016-09-15′),
(34,16,’2018-04-13′),
(80,30,’2016-10-13′),
(20,32,’2015-11-17′),
(36,10,’2017-09-01′),
(78,12,’2018-06-27′),
(57,8,’2016-03-22′),
(75,11,’2017-06-27′),
(71,10,’2015-08-01′),
(48,22,’2015-09-29′),
(19,16,’2016-02-21′),
(79,30,’2018-08-20′),
(70,13,’2016-09-16′),
(30,6,’2017-02-10′),
(45,12,’2017-10-12′),
(30,27,’2016-11-23′),
(26,3,’2016-08-13′),
(66,6,’2017-01-14′),
(47,15,’2016-02-10′),
(53,30,’2018-08-08′),
(80,16,’2016-03-31′),
(70,13,’2018-02-03′),
(14,25,’2016-03-27′),
(46,22,’2016-01-13′),
(30,32,’2015-08-06′),
(60,14,’2016-11-27′),
(14,13,’2018-05-23′),
(71,15,’2016-06-22′),
(38,21,’2015-12-27′),
(69,30,’2017-04-29′),
(49,31,’2018-06-03′),
(28,28,’2015-05-29′),
(49,3,’2016-08-30′),
(75,1,’2015-10-29′),
(78,3,’2017-05-12′),
(43,18,’2015-03-25′),
(27,21,’2016-02-22′),
(64,22,’2015-04-03′),
(21,11,’2017-12-09′),
(66,29,’2016-12-20′),
(45,13,’2017-04-15′),
(48,30,’2015-01-31′),
(20,25,’2017-12-20′),
(41,20,’2018-01-29′),
(51,12,’2015-07-05′),
(5,1,’2015-04-12′),
(40,3,’2018-02-24′),
(79,4,’2018-06-27′),
(15,10,’2016-11-01′),
(42,22,’2016-12-28′),
(17,9,’2018-01-29′),
(38,13,’2016-05-09′),
(79,2,’2017-12-06′),
(74,3,’2015-12-07′),
(46,8,’2016-06-05′),
(78,22,’2018-08-11′),
(45,2,’2015-04-20′),
(72,31,’2015-11-11′),
(18,17,’2015-03-21′),
(29,3,’2017-08-13′),
(66,11,’2018-06-05′),
(36,16,’2016-04-28′),
(26,2,’2016-10-23′),
(32,1,’2017-10-31′),
(62,14,’2017-07-25′),
(12,4,’2015-07-08′),
(38,32,’2015-02-24′),
(29,16,’2016-07-28′),
(36,25,’2017-05-07′),
(76,7,’2015-06-13′),
(28,16,’2016-08-15′),
(60,13,’2016-08-26′),
(8,3,’2017-07-28′),
(25,1,’2016-07-30′),
(62,29,’2018-08-24′),
(51,8,’2016-09-01′),
(27,23,’2015-02-08′),
(69,12,’2018-06-25′),
(51,12,’2015-07-04′),
(7,4,’2015-05-01′),
(31,15,’2017-10-29′),
(14,23,’2015-01-15′),
(14,1,’2018-05-21′),
(39,25,’2015-12-26′),
(79,24,’2016-05-31′),
(40,15,’2016-03-18′),
(51,13,’2018-04-13′),
(61,1,’2015-02-11′),
(15,24,’2018-03-02′),
(10,22,’2018-01-21′),
(67,10,’2017-07-08′),
(79,11,’2016-12-11′),
(19,32,’2016-05-04′),
(35,11,’2017-08-01′),
(27,13,’2017-12-15′),
(30,22,’2015-12-22′),
(8,7,’2015-06-26′),
(70,9,’2016-03-20′),
(56,18,’2016-01-29′),
(13,19,’2015-03-06′),
(61,2,’2016-06-18′),
(47,13,’2017-09-18′),
(30,22,’2016-02-19′),
(18,22,’2016-12-31′),
(34,29,’2017-10-27′),
(32,21,’2015-06-03′),
(9,28,’2016-03-30′),
(62,24,’2015-03-23′),
(44,22,’2017-04-29′),
(27,5,’2015-03-25′),
(61,28,’2017-07-14′),
(5,13,’2016-12-04′),
(43,19,’2018-03-15′),
(34,19,’2016-06-05′),
(35,5,’2018-02-19′),
(13,12,’2016-09-23′),
(74,18,’2016-12-26′),
(70,31,’2017-08-15′),
(42,17,’2016-06-15′),
(51,24,’2018-07-30′),
(45,30,’2015-01-15′),
(70,17,’2017-10-07′),
(77,7,’2017-01-06′),
(74,25,’2015-09-25′),
(47,14,’2018-02-01′),
(10,2,’2017-04-18′),
(16,21,’2016-10-03′),
(48,5,’2016-09-17′),
(72,3,’2017-02-10′),
(26,23,’2016-03-01′),
(49,23,’2016-10-25′);<\/p>\n\n\n\n{PROMPTS}<\/h3>\n\n\n\n
\n
\n
| ClientId | ClientFirstName | ClientLastName | ClientDoB | Occupation |<\/h4>\n\n\n\n
| 1 | Kaiden | Hill | 2006 | Student |<\/h4>\n\n\n\n
| 2 | Alina | Morton | 2010 | Student |<\/h4>\n\n\n\n
| 3 | Fania | Brooks | 1983 | Food Scientist |<\/h4>\n\n\n\n
| 4 | Courtney | Jensen | 2006 | Student |<\/h4>\n\n\n\n
| 5 | Brittany | Hill | 1983 | Firefighter |<\/h4>\n\n\n\n
| 6 | Max | Rogers | 2005 | Student |<\/h4>\n\n\n\n
| 7 | Margaret | McCarthy | 1981 | School |<\/h4>\n\n\n\n
| 8 | Julie | McCarthy | 1973 | Professor |<\/h4>\n\n\n\n
| 9 | Ken | McCarthy | 1974 | Securities Clerk |<\/h4>\n\n\n\n
| 10 | Britany | O’Quinn | 1984 | Violinist |<\/h4>\n\n\n\n
| 11 | Conner | Gardner | 1998 | Licensed Massage |<\/h4>\n\n\n\n
| 12 | Mya | Austin | 1960 | Parquet Floor |<\/h4>\n\n\n\n
| 13 | Thierry | Rogers | 2004 | Student |<\/h4>\n\n\n\n
| 14 | Eloise | Rogers | 1984 | Computer Security |<\/h4>\n\n\n\n
| 15 | Gerard | Jackson | 1979 | Oil Exploration |<\/h4>\n\n\n\n
| 16 | Randy | Day | 1986 | Aircraft |<\/h4>\n\n\n\n
| 17 | Jodie | Page | 1990 | Manufacturing |<\/h4>\n\n\n\n
| 18 | Coral | Rice | 1996 | Window Washer |<\/h4>\n\n\n\n
| 19 | Ayman | Austin | 2002 | Student |<\/h4>\n\n\n\n
| 20 | Jaxson | Austin | 1999 | Repair Worker |<\/h4>\n\n\n\n
| 21 | Joel | Austin | 1973 | Police Officer |<\/h4>\n\n\n\n
| 22 | Alina | Austin | 2010 | Student |<\/h4>\n\n\n\n
| 23 | Elin | Austin | 1962 | Payroll Clerk |<\/h4>\n\n\n\n
| 24 | Ophelia | Wolf | 2004 | Student |<\/h4>\n\n\n\n
| 25 | Eliot | McGuire | 1967 | Dentist |<\/h4>\n\n\n\n
| 26 | Peter | McKinney | 1968 | Professor |<\/h4>\n\n\n\n
| 27 | Annabella | Henry | 1974 | Nurse |<\/h4>\n\n\n\n
| 28 | Anastasia | Baker | 2001 | Student |<\/h4>\n\n\n\n
| 29 | Tyler | Baker | 1984 | Police Officer |<\/h4>\n\n\n\n
| 30 | Lilian | Ross | 1983 | Insurance Agent |<\/h4>\n\n\n\n
| 31 | Thierry | Arnold | 1975 | Bus Driver |<\/h4>\n\n\n\n
| 32 | Angelina | Rowe | 1979 | Firefighter |<\/h4>\n\n\n\n
| 33 | Marcia | Rowe | 1974 | Health Educator |<\/h4>\n\n\n\n
| 34 | Martin | Rowe | 1976 | Ship Engineer |<\/h4>\n\n\n\n
| 35 | Adeline | Rowe | 2005 | Student |<\/h4>\n\n\n\n
| 36 | Colette | Rowe | 1963 | Professor |<\/h4>\n\n\n\n
| 37 | Diane | Clark | 1975 | Payroll Clerk |<\/h4>\n\n\n\n
| 38 | Caroline | Clark | 1960 | Dentist |<\/h4>\n\n\n\n
| 39 | Dalton | Clayton | 1982 | Police Officer |<\/h4>\n\n\n\n
| 40 | Steve | Clayton | 1990 | Bus Driver |<\/h4>\n\n\n\n
| 41 | Melanie | Clayton | 1987 | Computer Engineer |<\/h4>\n\n\n\n
| 42 | Alana | Wilson | 2007 | Student |<\/h4>\n\n\n\n
| 43 | Carson | Byrne | 1995 | Food Scientist |<\/h4>\n\n\n\n
| 44 | Conrad | Byrne | 2007 | Student |<\/h4>\n\n\n\n
| 45 | Ryan | Porter | 2008 | Student |<\/h4>\n\n\n\n
| 46 | Elin | Porter | 1978 | Computer |<\/h4>\n\n\n\n
| 47 | Tyler | Harvey | 2007 | Student |<\/h4>\n\n\n\n
| 48 | Arya | Harvey | 2008 | Student |<\/h4>\n\n\n\n
| 49 | Serena | Harvey | 1978 | School Teacher |<\/h4>\n\n\n\n
| 50 | Lilly | Franklin | 1976 | Doctor |<\/h4>\n\n\n\n
| 51 | Mai | Franklin | 1994 | Dentist |<\/h4>\n\n\n\n
| 52 | John | Franklin | 1999 | Firefighter |<\/h4>\n\n\n\n
| 53 | Judy | Franklin | 1995 | Firefighter |<\/h4>\n\n\n\n
| 54 | Katy | Lloyd | 1992 | School Teacher |<\/h4>\n\n\n\n
| 55 | Tamara | Allen | 1963 | Ship Engineer |<\/h4>\n\n\n\n
| 56 | Maxim | Lyons | 1985 | Police Officer |<\/h4>\n\n\n\n
| 57 | Allan | Lyons | 1983 | Computer Engineer |<\/h4>\n\n\n\n
| 58 | Marc | Harris | 1980 | School Teacher |<\/h4>\n\n\n\n
| 59 | Elin | Young | 2009 | Student |<\/h4>\n\n\n\n
| 60 | Diana | Young | 2008 | Student |<\/h4>\n\n\n\n
| 61 | Diane | Young | 2006 | Student |<\/h4>\n\n\n\n
| 62 | Alana | Bird | 2003 | Student |<\/h4>\n\n\n\n
| 63 | Anna | Becker | 1979 | Security Agent |<\/h4>\n\n\n\n
| 64 | Katie | Grant | 1977 | Manager |<\/h4>\n\n\n\n
| 65 | Joan | Grant | 2010 | Student |<\/h4>\n\n\n\n
| 66 | Bryan | Bell | 2001 | Student |<\/h4>\n\n\n\n
| 67 | Belle | Miller | 1970 | Professor |<\/h4>\n\n\n\n
| 68 | Peggy | Stevens | 1990 | Bus Driver |<\/h4>\n\n\n\n
| 69 | Steve | Williamson | 1975 | HR Clerk |<\/h4>\n\n\n\n
| 70 | Tyler | Williamson | 1999 | Doctor |<\/h4>\n\n\n\n
| 71 | Izabelle | Williamson | 1990 | Systems Analyst |<\/h4>\n\n\n\n
| 72 | Annabel | Williamson | 1960 | Cashier |<\/h4>\n\n\n\n
| 73 | Mohamed | Waters | 1966 | Insurance Agent |<\/h4>\n\n\n\n
| 74 | Marion | Newman | 1970 | Computer |<\/h4>\n\n\n\n
| 75 | Ada | Williams | 1986 | Computer |<\/h4>\n\n\n\n
| 76 | Sean | Scott | 1983 | Bus Driver |<\/h4>\n\n\n\n
| 77 | Farrah | Scott | 1974 | Ship Engineer |<\/h4>\n\n\n\n
| 78 | Christine | Lambert | 1973 | School Teacher |<\/h4>\n\n\n\n
| 79 | Alysha | Lambert | 2007 | Student |<\/h4>\n\n\n\n
| 80 | Maia | Grant | 1984 | School Teacher |<\/h4>\n\n\n\n
\n\n\n\n\n
\n
FROM client;<\/p>\n\n\n\n| ClientFirstName | ClientLastName | Age | Occupation |<\/h4>\n\n\n\n
| Kaiden | Hill | 16 | Student |<\/h4>\n\n\n\n
| Alina | Morton | 12 | Student |<\/h4>\n\n\n\n
| Fania | Brooks | 39 | Food Scientist |<\/h4>\n\n\n\n
| Courtney | Jensen | 16 | Student |<\/h4>\n\n\n\n
| Brittany | Hill | 39 | Firefighter |<\/h4>\n\n\n\n
| Max | Rogers | 17 | Student |<\/h4>\n\n\n\n
| Margaret | McCarthy | 41 | School |<\/h4>\n\n\n\n
| Julie | McCarthy | 49 | Professor |<\/h4>\n\n\n\n
| Ken | McCarthy | 48 | Securities Clerk |<\/h4>\n\n\n\n
| Britany | O’Quinn | 38 | Violinist |<\/h4>\n\n\n\n
| Conner | Gardner | 24 | Licensed Massage |<\/h4>\n\n\n\n
| Mya | Austin | 62 | Parquet Floor |<\/h4>\n\n\n\n
| Thierry | Rogers | 18 | Student |<\/h4>\n\n\n\n
| Eloise | Rogers | 38 | Computer Security |<\/h4>\n\n\n\n
| Gerard | Jackson | 43 | Oil Exploration |<\/h4>\n\n\n\n
| Randy | Day | 36 | Aircraft |<\/h4>\n\n\n\n
| Jodie | Page | 32 | Manufacturing |<\/h4>\n\n\n\n
| Coral | Rice | 26 | Window Washer |<\/h4>\n\n\n\n
| Ayman | Austin | 20 | Student |<\/h4>\n\n\n\n
| Jaxson | Austin | 23 | Repair Worker |<\/h4>\n\n\n\n
| Joel | Austin | 49 | Police Officer |<\/h4>\n\n\n\n
| Alina | Austin | 12 | Student |<\/h4>\n\n\n\n
| Elin | Austin | 60 | Payroll Clerk |<\/h4>\n\n\n\n
| Ophelia | Wolf | 18 | Student |<\/h4>\n\n\n\n
| Eliot | McGuire | 55 | Dentist |<\/h4>\n\n\n\n
| Peter | McKinney | 54 | Professor |<\/h4>\n\n\n\n
| Annabella | Henry | 48 | Nurse |<\/h4>\n\n\n\n
| Anastasia | Baker | 21 | Student |<\/h4>\n\n\n\n
| Tyler | Baker | 38 | Police Officer |<\/h4>\n\n\n\n
| Lilian | Ross | 39 | Insurance Agent |<\/h4>\n\n\n\n
| Thierry | Arnold | 47 | Bus Driver |<\/h4>\n\n\n\n
| Angelina | Rowe | 43 | Firefighter |<\/h4>\n\n\n\n
| Marcia | Rowe | 48 | Health Educator |<\/h4>\n\n\n\n
| Martin | Rowe | 46 | Ship Engineer |<\/h4>\n\n\n\n
| Adeline | Rowe | 17 | Student |<\/h4>\n\n\n\n
| Colette | Rowe | 59 | Professor |<\/h4>\n\n\n\n
| Diane | Clark | 47 | Payroll Clerk |<\/h4>\n\n\n\n
| Caroline | Clark | 62 | Dentist |<\/h4>\n\n\n\n
| Dalton | Clayton | 40 | Police Officer |<\/h4>\n\n\n\n
| Steve | Clayton | 32 | Bus Driver |<\/h4>\n\n\n\n
| Melanie | Clayton | 35 | Computer Engineer |<\/h4>\n\n\n\n
| Alana | Wilson | 15 | Student |<\/h4>\n\n\n\n
| Carson | Byrne | 27 | Food Scientist |<\/h4>\n\n\n\n
| Conrad | Byrne | 15 | Student |<\/h4>\n\n\n\n
| Ryan | Porter | 14 | Student |<\/h4>\n\n\n\n
| Elin | Porter | 44 | Computer |<\/h4>\n\n\n\n
| Tyler | Harvey | 15 | Student |<\/h4>\n\n\n\n
| Arya | Harvey | 14 | Student |<\/h4>\n\n\n\n
| Serena | Harvey | 44 | School Teacher |<\/h4>\n\n\n\n
| Lilly | Franklin | 46 | Doctor |<\/h4>\n\n\n\n
| Mai | Franklin | 28 | Dentist |<\/h4>\n\n\n\n
| John | Franklin | 23 | Firefighter |<\/h4>\n\n\n\n
| Judy | Franklin | 27 | Firefighter |<\/h4>\n\n\n\n
| Katy | Lloyd | 30 | School Teacher |<\/h4>\n\n\n\n
| Tamara | Allen | 59 | Ship Engineer |<\/h4>\n\n\n\n
| Maxim | Lyons | 37 | Police Officer |<\/h4>\n\n\n\n
| Allan | Lyons | 39 | Computer Engineer |<\/h4>\n\n\n\n
| Marc | Harris | 42 | School Teacher |<\/h4>\n\n\n\n
| Elin | Young | 13 | Student |<\/h4>\n\n\n\n
| Diana | Young | 14 | Student |<\/h4>\n\n\n\n
| Diane | Young | 16 | Student |<\/h4>\n\n\n\n
| Alana | Bird | 19 | Student |<\/h4>\n\n\n\n
| Anna | Becker | 43 | Security Agent |<\/h4>\n\n\n\n
| Katie | Grant | 45 | Manager |<\/h4>\n\n\n\n
| Joan | Grant | 12 | Student |<\/h4>\n\n\n\n
| Bryan | Bell | 21 | Student |<\/h4>\n\n\n\n
| Belle | Miller | 52 | Professor |<\/h4>\n\n\n\n
| Peggy | Stevens | 32 | Bus Driver |<\/h4>\n\n\n\n
| Steve | Williamson | 47 | HR Clerk |<\/h4>\n\n\n\n
| Tyler | Williamson | 23 | Doctor |<\/h4>\n\n\n\n
| Izabelle | Williamson | 32 | Systems Analyst |<\/h4>\n\n\n\n
| Annabel | Williamson | 62 | Cashier |<\/h4>\n\n\n\n
| Mohamed | Waters | 56 | Insurance Agent |<\/h4>\n\n\n\n
| Marion | Newman | 52 | Computer |<\/h4>\n\n\n\n
| Ada | Williams | 36 | Computer |<\/h4>\n\n\n\n
| Sean | Scott | 39 | Bus Driver |<\/h4>\n\n\n\n
| Farrah | Scott | 48 | Ship Engineer |<\/h4>\n\n\n\n
| Christine | Lambert | 49 | School Teacher |<\/h4>\n\n\n\n
| Alysha | Lambert | 15 | Student |<\/h4>\n\n\n\n
| Maia | Grant | 38 | School Teacher |<\/h4>\n\n\n\n
\n\n\n\n\n
\n
FROM Client
INNER JOIN Borrower
ON Client.ClientId = Borrower.ClientId
WHERE MONTH(BorrowDate) = 3 AND YEAR(BorrowDate) = 2018<\/p>\n\n\n\n
ON Borrower (BorrowId ,ClientId,BookId,BorrowDate);<\/p>\n\n\n\n| ClientFirstName | ClientLastName |<\/h4>\n\n\n\n
| Maia | Grant |<\/h4>\n\n\n\n
| Marcia | Rowe |<\/h4>\n\n\n\n
| Katy | Lloyd |<\/h4>\n\n\n\n
| Tyler | Williamson |<\/h4>\n\n\n\n
| Serena | Harvey |<\/h4>\n\n\n\n
| Carson | Byrne |<\/h4>\n\n\n\n
\n\n\n\n\n
\n
FROM Author INNER JOIN (Book INNER JOIN Borrower ON Book.[BookId] = Borrower.[BookId]) ON Author.AuthorId = Book.BookAuthor
WHERE ((Year([BorrowDate]))=2017)
GROUP BY Author.AuthorFirstName, Author.AuthorLastName
ORDER BY Count(Borrower.BookId) DESC;<\/p>\n\n\n\n| AuthorFirstName | AuthorLastName |<\/h4>\n\n\n\n
| Elena | Martin |<\/h4>\n\n\n\n
| Sofia | Smith |<\/h4>\n\n\n\n
| Logan | Moore |<\/h4>\n\n\n\n
| Maria | Brown |<\/h4>\n\n\n\n
| Helena | Adams |<\/h4>\n\n\n\n
| Zoe | Roy |<\/h4>\n\n\n\n
\n\n\n\n\n
\n
FROM Author INNER JOIN (Book INNER JOIN Borrower ON Book.BookId = Borrower.BookId) ON Author.AuthorId = Book.BookAuthor
WHERE (((Year([BorrowDate])) Between 2015 And 2017))
GROUP BY Author.AuthorNationality
ORDER BY Count(Author.AuthorNationality) ASC;<\/p>\n\n\n\n| AuthorNationality | CountOfAuthorNationality |<\/h4>\n\n\n\n
| Spain | 3 |<\/h4>\n\n\n\n
| Great Britain | 6 |<\/h4>\n\n\n\n
| China | 7 |<\/h4>\n\n\n\n
| Brazil | 18 |<\/h4>\n\n\n\n
| France | 24 |<\/h4>\n\n\n\n
\n\n\n\n\n
\n
FROM Book INNER JOIN Borrower ON Book.BookId = Borrower.BookId
WHERE (((Year([BorrowDate])) Between 2015 And 2017))
GROUP BY Book.BookTitle
ORDER BY Count(Borrower.BookId) DESC;<\/p>\n\n\n\n| BookTitle |<\/h4>\n\n\n\n
| The perfect match |<\/h4>\n\n\n\n
\n\n\n\n\n
\n
FROM (Book INNER JOIN Borrower ON Book.BookId = Borrower.BookId)
INNER JOIN Client
ON Borrower.ClientId = Client.ClientId
WHERE ClientDoB BETWEEN 1970 AND 1980
GROUP BY Genre;<\/p>\n\n\n\n| Genre |<\/h4>\n\n\n\n
| Children |<\/h4>\n\n\n\n
| Fiction |<\/h4>\n\n\n\n
| History |<\/h4>\n\n\n\n
| Humor |<\/h4>\n\n\n\n
| Law |<\/h4>\n\n\n\n
\n\n\n\n\n
\n