SRS document on library database

chutiyappa.accdb

BookID	Book Title	Book Author	Book Publisher	Year Published
2	Lasher	Rice, Anne	knopf	1993
3	Titans, the	Dumas, Alexandre	Harper	1957
4	Dogs tale	Twain, Mark	Harper	1904
5	My very best work	Bronte, Emily	Harper	1810
6	Rob Roy	Scott, Sir Walter	D. Appleton & Co.	1898
7	Kidnapped	Stevenson, Robert Louis	Dodd, Mead	1949
8	Survivor	Butler, Octavia	Doubleday	1978
9	Dragonquest	McCaffrey, Anne	Ballantine Books	1979
10	Tarzan and the Forbidden City	Burrughs, Edger Rice	E.R. burrughs, Inc.	1938

UserID	User Name	User Address	User Contact	Email
3	Tom Smith	4592 Maple Lane, Some City NY 12345	555-555-4321	[email protected]
4	Marry Johnson	98 Elm St., Little town MN 23456	551-555-4567	[email protected]
5	John Smith	867 Apple tree road, Anytown NJ 10111	552-555-9876	[email protected]
6	Emily Jones	7921 Fir Road, Anytown NY 12344	555-555-7654	[email protected]
7	Peter Johnson	709 Hemloc St. Some City NY 12345	555-555-3456	[email protected]
8	Edna Hayes	185 Oak Road, Some City MN 23458	551-555-1234	[email protected]
9	Franklin Hayes	1990 Pine St., Little Town MN 23456	551-555-3939	[email protected]
10	Mary Collins	RR1 Box 297, Rural Area CO 45678	553-555-1234	[email protected]
11	Peter Collins	170 Dogwood Lane, Little Town MN 234	551-555-8484	[email protected]

SELECT DISTINCTROW * FROM Users;

SELECT [Books].[BookID], [Books].[Book Title] FROM Books ORDER BY [Book Title];

SELECT [Users].[UserID], [Users].[User Name] FROM Users ORDER BY [User Name];

SELECT DISTINCTROW * FROM Borrowed;

SELECT DISTINCTROW * FROM Books;