Systems Engineering assignment #3

Part- A:

Table: Book

http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=23646000000003023&STANDALONE=true 

Table: Student

http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=23646000000003110&STANDALONE=true

Query: Borrow Details

http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=23646000000003195&STANDALONE=true
Query: Finance Book Details

http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=23646000000003231&STANDALONE=true

Query: Defaulters Details

http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=23646000000004012&STANDALONE=true

Part- B

This is a database of Praxis B-School “Praxlib” which has information relating two entities “Book” and “Student” in two different tables. In the “Book “ table the data regarding Book-ID, Book Name, name of the author, name of the publication ,subject of the book is saved. This table is uniquely identified with primary key field “Book-ID”. Every copy of a particular book has unique identification code “B00X”. When a student comes and borrows a book from the library; this transaction is captured in the “Student” table. Here, the name of the student, his ID, the state he is from, his contact-no., the Book-ID of the borrowed book, Issue-Date, Due- Date, Return Date. The table contains 10 rows of data. This table is uniquely identified with primary key field “Student-ID”. The primary-foreign key relationship of “Book-ID” will be helpful in relating the two tables.

Now, three queries are being generated.

· Borrow Details: In this query, the information regarding which student has taken which book is being generated.

· Finance Details: In this query, information of those books which belong to the “Finance” subject is being retrieved.

· Defaulters Details: In this query, information of those students whose return date is 17-01-2008 and who has not returned his book yet is being retrieved.