Reference no: EM131146835

Directions:

Answer all questions, and please submit only two files into the Final Exam link.

1) One text file for most the answers below (all questions except 2 and 3). Paste your full answers in the text file (no hyperlinks). This greatly simplifies my ability to grade and return many exams in a timely manner.

Please name your file starting with your last name. For example, if your last names is "Jones", submit a file with the name:
Jones_final.txt

2) One HTML file that contains your answers for the HTML form with JavaScript added (for questions 2 and 3). Do start with the midterm template file provided. Use the same file naming convention based on your last name:

Jones_final.html or Jones_final.htm
... I need it to have an html or htmextension so I can try it out myself (don't send me code in a text or word file).

Optional: If you prefer, you can also answer Question 7 by scanning in the Crossword Puzzle hint and attaching it as an image or PDF file (and you can also call this file whatever you want).
NOTE:
DO NOT submit a zip file or word file.
DO NOT email me your final exam, submit it into the Final Exam link.
DO NOT include hyperlinks instead of your actual code
DO compile and test your code (i.e., use IDEOne, Oracle APEX, HTML Editor).
I've added many HINTS below in RED.
My Best HINT: Many of the answers are based directly from your lecture notes or homework assignments

Question 1: C or C++

The year is 1996 and you are working at a small start up company called Amazon.com, which is primarily in the business of selling books. Design a set of structures in C or C++ to capture information about books.
Three primary structures you should have are Books, Authors, and Publishers, as well as various supporting structures (one example would be struct date).
... look at the structures calling structures credit card example in Week 3 notes and/or the suggested answer on midterm that I provided on our exam. I would suggest that you don't worry about character string sizes ... just use the C++ model
string name; // easy, don't have to worry about size
instead of:
char name [50]; /* why worry about size with C, use C++ string instead */
... as for book information, if you look in most books, you'll see a copyright page with just about all the information you will need ... also, why not just got to Amazon.com itself and see what information it displays on a given book. How would that information best be stored within a structures. Think of basic structures you would need to build other structures ... date is a good example. For other fields, what is the best type: float, int, character, string, bool, ...

Question 2: HTML
Develop an HTML form that could be used to enter your book information (Books, Authors, and Publishers) into our fictional book database system. Similar to what you did on the midterm. For questions 1-3, feel free to start with the HTML/JavaScript template provided on the midterm.
... use the template provided on the midterm. Expand upon it!
What field information would you enter into a system? Have your form use more then just character text fields ... radio buttons, pick lists, and other elements make your form easier to use and you don't need to do lots of JavaScript checks.
What fields would be mandatory ... which could be left blank? How would a user know what fields are mandatory? Really look at how I graded you midterm and the comments I provided.

Question 3: JavaScript
Add JavaScript processing similar to what you did on midterm to make sure that the information is correctly verified before being sent to the Amazon.com book database.
... you don't need to be too tricky here ... just provide the basic checks to see if a field that should be added is mandatory if desired. Also, use the isNaN function to verify if field value is a number if applicable. Other than that, no need to add any other checks. The template on the midterm provides you with the basic JavaScript checks to get started ... just expand upon it (don't try to create your own template from scratch unless you had prior knowledge before taking this class). Not all fields need to be mandatory ... especially if you make many of then pick lists, radio buttons, and other fields that don't need to be validated (Hint, Hint).

Question 4: XML
Use the Amazon.com web site to query Books that had made the New York Times Best Seller's list. Go to https://www.amazon.com and then Enter Books in the Search where there is a pick list for "All Departments" ... than click the GO button. Once you get there, you will see a link for "NY Times Bestsellers" near the top of the page. Enter information in XML about any five 5 books based on your design in question 1.
... this one is easy ... pick 5 books from the web site above and add XML to capture that information ... just like you did on the midterm.

Question 5: C#
Write a C# program to create a Queue of books for a customer based on the 5 books you found in Question 4. Remove two items from your queue and add three other books from the NY Times BestSeller's list (Hint: Keep it simple, reuse your C# homework). Now implement a stack (see lecture notes) with your NY Times books as a starting point, add two new items to your stack of books, and then remove three items of your choice. To get full credit, implement as one C# program. Nearly full credit will be granted if you answer it correctly as two C# programs.
... remember our C# homework ... and lecture notes, just about every you need is in them. Just use the queue and stack examples in the notes to get started. I used movies ... but as your homework showed, you can make them handle just about any item. Put the items in the same single class to get full credit.

Question 6: Perl
Use the information about the five books you selected from Question 4 to create a Perl program that will store this information in a Hash of Hashes. Additionally, use at least five or more important attributes (book title, author, ...) about your book to store, and print them out in a nice table like report. If you wish, you could add the XML processing to create the output you will need for Question 4 right in this program.
... use your Perl homework assignment as a guide, you did basically the same thing for your "Teams". Also, review your Perl lecture notes.

Question 7: Language Identification
During the semester, we covered many languages. For each item below, enter the language that is best described by the statement. Do not use the same language twice. Note that some languages we just briefly talked about in the first week. A crossword puzzle hint is provided to help you with this question, use it so you know the exact programming language answer that is expected.

__________ A language that allows you to query a database
__________ A language that is most commonly used to represent web pages
__________ A simplified Scripting Language developed in Japan
__________ An all purpose scripting language with a large following
__________ The flagship language of Microsoft's .NET framework
__________ An object oriented language that is an extension of C
__________ A language that best used for the representation and interchange of data
__________ A language that runs on the client machine within a web page
__________ The language that C was based on
__________ The fastest executing language that we covered
__________ This language is used to develop Apple apps (iPods, iPhones, ...)
__________ This language is most popular with Android and other non-Apple cell phone apps
__________ The Apache Web Server is implemented in this language
__________ Symbolic representation of machine language
__________ An example of a logical programming language
__________ An example of a functional programming language
__________ Popular Index that rates the popularity of programming languages
__________ Older language than C that was popular for business applications
__________ Older language than C that was popular of mathematical applications
__________ Older language than C that was very popular in Europe
__________ Language that is used to present data on many popular web sites (Boston Globe, Dallas Morning News, ...)
__________ A language that is most popular at Google
__________ A language developed around the same time as C that is based on ALGOL
__________ One of more popular languages used by Defense Contractors and the Department of Defense
__________ A scripting language that has been called the "Duct Tape of the Internet"
__________ A scripting language that got its name from a personal home page tools web site

... the answers are all in the lecture notes or in links in the notes ... most from the first week's notes. Google and Wikipedia can be your best friend here ... hint ... hint! Remember, you can only use a language once in the answer above. Also, see the crossword puzzle hint in the Final Exam folder that should provide additional clues on the answers, as well as a little fun!

Question 8: C++ or Java or Ruby Class (your choice)

Write a class for books based on your design of question 1. Consider information on publisher and authors as well. Create one constructor to create a book object and define getter functions as needed. To make this question reasonable, you can limit the total of "getter" functions to five (5).

... Just like you did on the midterm but with Books instead of a license ... remember that you have authors and publishers to worry about as well as books. Here is my best HINT to get you started, read through your C++ lecture notes, espeicially one of those notes :) Keep it simple, don't get too concerned with Structures ... think "string" as a type for many of the class data members. Also, just provide 5 getter functions ... don't go crazy.

Question 9: Design
What methods or actions would you perform on you book data? For example, a useful function would be to Update the Price of a book. List Ten other methods/actions that one would find useful with our Book Class. Think about it in terms of a book, an author, and a publisher.
... no code is needed here, just list out 10 items ... such as "Update the Book Price" ... provide 9 more.

Question 10: SQL
This is a three (3) part question that parallels our Perl homework, where you created information about your favorite team.
Part I: Using SQL, develop one (1) CREATE TABLE statement that would create a database table within Oracle APEX. Define a primary key, you are welcome to add additional columns as needed to your table. Don't worry about a Foreign key or creating any other tables
Part II: Using SQL, develop a set of five (5) INSERT statements to populate your table with information about each team.
Part III: Create one (1) select statement that selects all columns and rows in your table. Sort it by your team name. Don't use an asterisk (like "SELECT * FROM team"), instead, please specify each column.

... All SQL statements are really in your lecture notes ... especially the script I provided that creates and populates the emp, dept, and salgrade tables. Look at how I created, inserted, and selected from the emp table. Just mimic that and try out your work in Oracle APEX to make sure it all works. I just need to see the statements in SQL that do parts I, II, and III. If you can't think of good primary key, just add a column as your primary key called "team_id" that is the same type as empno in our sample emp table.
To verify it works, try out your SQL statements in Oracle APEX to create, populate, and query your table.

Question 11: Ruby Tweets - What Language did you like best?

We covered many languages this semester. What was your favorite language this semester? Use a Hash in Ruby to create and print five (5) Tweets that voice your thoughts on why you like a particular language. Stick to one specific language for all your tweets, not multiple languages.
... its hard to get this wrong :) .... but take the time to answer it and don't give a quick no thought type answer. For the Ruby code, just borrow the homework assignment you created in the Ruby Lecture Notes as starting template. You just need to set up and print 5 Tweets.