
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
P1). Create ASP.NET Core MVC C# web application with Home controller and implement the following features: 1) In the Home controller, Index method must return “Home” as a content to the browser 2) Add Aboutus action method to the home controller. It must return “About Us” as a content to the browser 3) Add Buyitem action method to the home controller. It must accept ID parameter of string data type. In that method, check if ID parameter is supplied and output the message “ID not supplied”, or “ID supplied:” and ID value. 4) Add Futurevalue action method to the home controller. It must accept three parameters: int years, int rate = 8, decimal investment = 1000 As shown above, default values for rate and investment must be 8 and 1000 respectively. Futurevalue action method must calculate a simple future value of investment. Here is an example code of calculation that you can use: decimal futureValue = investment; for (int i = 0; i < years; i++) { futureValue += (futureValue * rate/100); } Afterwards, the calculated value must be returned to the browser. 5) Add a Route attribute to Futurevalue action method. The route must have four segments: action, years, rate (optional), investment (optional).
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 3 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- I need help with this one please, already tried but still getting a wrong answer Scenario You have been tasked with building a URL file validator for a web crawler. A web crawler is an application that fetches a web page, extracts the URLs present in that page, and then recursively fetches new pages using the extracted URLs. The end goal of a web crawler is to collect text data, images, or other resources present in order to validate resource URLs or hyperlinks on a page. URL validators can be useful to validate if the extracted URL is a valid resource to fetch. In this scenario, you will build a URL validator that checks for supported protocols and file types. Task Create two lists of strings – one list for Protocol called valid_protocols, and one list for storing File extension called valid_fileinfo. For this take the protocol list should be restricted to http, https and ftp. The file extension list should be .html, .csv and .docx. Split an input named url, and then use the first…arrow_forward1) Take the supplied cars_db.sql and create your Cars database (you will have to create the Cars database first, then execute the .sql file from within Netbeans). 2) Implement a program that has the same general user interface as the SimpleSchoolData presented in class. 3) Implement two classes, CarsDisplay which displays the above application, and implement a class named CarQueries that contains the prepared statements to execute the queries. (Java) This is the cars_db.sql DROP TABLE Cars; CREATE TABLE Cars ( CarID INT NOT NULL GENERATED ALWAYS AS IDENTITY, CarMake VARCHAR (10) NOT NULL, CarModel VARCHAR (15) NOT NULL, CarYear VARCHAR (4) NOT NULL, CarMileage DECIMAL (6) NOT NULL ); INSERT INTO Cars (CarMake,CarModel,CarYear,CarMileage) VALUES ('Honda','Civic','1998',135647), ('Honda','Accord','2009',46877), ('Nissan','Pickup','1997',235444);arrow_forwardA WriteOnly attribute may be implemented automatically. True vs. Falsearrow_forward
- Python Required information id fname lname company address city ST zip 103 Art Venere 8 W Cerritos Ave #54 Bridgeport NJ 8014 104 Lenna Paprocki Feltz Printing 639 Main St Anchorage AK 99501arrow_forwardPart 3: JavaScript - Program Outline, Startup Function, and Prompt We are going to use a function that we can consider an entry point into our running JavaScript. Below is an outline of the major elements in our JavaScript file. getRandomInt() function: generate a random integer startup() function: entry point function call to startup() function Below is your startup code: function getRandomInt(min, max) {}function startup() {}startup(); >> Add the above code components to your cis111-07.js JavaScript file below your multiline comment. >> Copy the getRandomInt function code from your previous assignment, or from this Stackoverflow article (Links to an external site.). Remember to add a single line comment above the getRandomInt function that documents the source of the code. Before attempting to use the prompt function in your code, you should try out the function in the console. >> Enter the following into the console to test displaying the prompt dialog. prompt();…arrow_forwardWhat happens if in a catch block heading only the data type is specified, that is, there is no catch block parameter.arrow_forward
- mysql> DESC bookauthor; mysql> DESC author; mysql> DESC book; | Field | Туре | Field | Туре | Field Тур | int(11 | varchai author_order | int(11 royaltyshare | decima: author_id isbn | author_id | int(1: | ssn lastname | firstname | varch: | phone | address | city | state | zip | varch: | varch: isbn var I name | type pub_id I price | advance I ytd_sales I pubdate var var | varch: | varch: | varch: | varch: | varch: | int dec | dec int mysql> DESC bookeditor; | dat | Field | Туре mysql> DESC editor; mysql> DESC publisher; editor_id | int(11) | varchar(1 | Field isbn | Field | Туре editor_id ssn pub_id | int(11) | varchar(40) varchar(40) varchar(20) varchar(2) lastname name firstname address | phone editor_position salary | city statearrow_forwardCreate class Node in a file named Node.java. This class has the following properties: Public fields previous and next, pointing to the previous and next nodes in the list, respectively. Private field data, defined as a reference to an object of any type. Public constructor that takes the node’s data as an argument. Public function GetData() that returns the node’s data.arrow_forward// Declare data fields: a String named customerName, // an int named numItems, and // a double named totalCost.// Your code here... // Implement the default contructor.// Set the value of customerName to "no name"// and use zero for the other data fields.// Your code here... // Implement the overloaded constructor that// passes new values to all data fields.// Your code here... // Implement method getTotalCost to return the totalCost.// Your code here... // Implement method buyItem.//// Adds itemCost to the total cost and increments// (adds 1 to) the number of items in the cart.//// Parameter: a double itemCost indicating the cost of the item.public void buyItem(double itemCost){// Your code here... }// Implement method applyCoupon.//// Apply a coupon to the total cost of the cart.// - Normal coupon: the unit discount is subtracted ONCE// from the total cost.// - Bonus coupon: the unit discount is subtracted TWICE// from the total cost.// - HOWEVER, a bonus coupon only applies if the…arrow_forward
- 115. The types of template dependencies are a. constraint generating templates b. tuple generating templates c. schema generating templates d. both a and barrow_forwardScenario: You have been tasked with building a URL file validator for a web crawler. A web crawler is an application that fetches a web page, extracts the URLs present in that page, and then recursively fetches new pages using the extracted URLs. The end goal of a web crawler is to collect text data, images, or other resources present in order to validate resource URLs or hyperlinks on a page. URL validators can be useful to validate if the extracted URL is a valid resource to fetch. In this scenario, you will build a URL validator that checks for supported protocols and file types.arrow_forwardCreate a JavaScript Arrow function that meets the following requirements: _missingSpace(string)• Authored using arrow expression syntax (constant name _missingSpace)• The function is passed a string argument• The function inserts a white space between every instance of a lowercase character followed immediately by an uppercase character, and returns the modified string, with whitespaces, back to the caller.• Console log output is NOT permitted.• The function should pass each of the illustrated examples below at a minimum._missingSpace(“”) → “”_missingSpace(“a”) → “a”_missingSpace(“A”) → “A”_missingSpace(“Ba”) → “Ba”_missingSpace(“aB”) → “a B”_missingSpace(“BaB”) → “Ba B”_missingSpace(“GeorgeBrownCollege”) → “George Brown College”_missingSpace(“SheWalksToTheBeach”) → “She Walks To The Beach”_missingSpace(“TheGreatUpset”) → “The Great Upset”arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education