Systems Engineering assignment #4

A compiler is a specialized computer program that converts source code written in one programming language into another language, usually machine language (also called machine code) so that it can be understood by processors (i.e., logic chips).
Source code is the version of software (usually an application program or an operating system) as it is originally written (i.e., typed into a computer) by a human in plain text (i.e., human readable alphanumeric characters). Source code can be written in any of numerous programming languages, some of the most popular of which are C, C++, Java, Perl, PHP, Python and Tcl/Tk. The output of a compiler is referred to as object code.

The FORTRAN team led by John Backus at IBM is generally credited as having introduced the first complete compiler, in 1957.
The first compiler for pascal was written on paper by Wirth, who then ran it by hand on itself, and then manually entered the resulting machine code. By dint of attention to detail, he then had a working pascal compiler.

The A-0 system, written by Grace Hopper in 1951 and 1952 for the UNIVAC I, was the first compiler ever developed for an electronic computer. The A-0 functioned more as a loader or linker than the modern notion of a compiler. A program was specified as a sequence of subroutines and arguments. The subroutines were identified by a numeric code and the arguments to the subroutines were written directly after each subroutine code. The A-0 system converted the specification into machine code that could be fed into the computer a second time to execute the program.

 

 

Source: Wikipedia , few of the IT enlightened Friends …

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.

Systems Engineering assignment #2

Given Data

Roll No.

Name.

E-mail Address.

Phone No.

Late Fine outstanding

Book Title

Book Author

Book ISBN (Globally Unique)

Book Price

Library Catalogue No.

Quality of the copy (Perfect/Damaged)

 

Library Details Table

Library Catalogue No.

Roll No.

Quality of the book.

 

Book Details Table

Book ISBN.

Library Catalogue No.

Book Title.

Book Author.

Book Price.

 

Student Table

Roll No.

Name.

E-mail address

Phone No.

Late Fine outstanding

 

Red Font denotes Primary key.
Green Font denotes Foreign key