Database System Concepts
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
Bartleby Related Questions Icon
Related questions
Question
Transcribed Image Text:Write the InputLicenses() function in the Database class. Within InputLicenses(), use cin to read pairs of inputs, character
currRenewable and string currState, until 'D' is read from input. Create a License object with currRenewable and currState as
arguments and append the object to vector licenseList.
Ex: If the input is N MS N NY Y NE Y HI D, then the output is:
License renewable: N, State: MS
License renewable: N, State: NY
License renewable: Y, State: NE
License renewable: Y, State: HI
18
19 void License::Print () const {
20
cout << "License renewable: " << renewable <<", State: " << state << endl;
21 }
22
23 class Database {
24
25
26
27
28
29 };
30
public:
void Input Licenses();
void Print Licenses();
vector<License> licenseList;
private:
31* Your code goes here */
32
33 void Database::Print Licenses () {
34
35
36
unsigned int i;
License currLicense;
Ceanned with CamScanner
1
2
3
4
2
Transcribed Image Text:Write the InputLicenses() function in the Database class. Within InputLicenses(), use cin to read pairs of inputs, character
currRenewable and string currState, until 'D' is read from input. Create a License object with currRenewable and currState as
arguments and append the object to vector licenseList.
Ex: If the input is N MS N NY Y NE Y HI D, then the output is:
License renewable: N, State: MS
License renewable: N, State: NY
License renewable: Y, State: NE
License renewable: Y, State: HI
1 #include <iostream>
2 #include <vector>
3 using namespace std;
4
5 class License {
6
7
8
9
public:
void Set Details (char newRenewable, string newstate);
void Print () const;
Check
private:
10
11
12 };
13
14 void License::SetDetails (char newRenewable, string newState) (
15
16
17)
18
char renewable;
string state;
renewable
state newState;
newRenewable;
Next level
2
CS Scanned with CamScanner
3
Feedback?
Expert Solution
Check MarkThis question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
bartleby
This is a popular solution
bartleby
Trending nowThis is a popular solution!
bartleby
Step by stepSolved in 3 steps
Knowledge Booster
Background pattern image
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
- 11.12 LAB: Dates Complete the code to implement the following operations: 1. Complete read_date(): • Read an input string representing a date in the format yyyy-mm-dd. ea date object from the input string. a Create - Retum the date object. 2. Call read_date() to read four (unique) date objects and store the date objects in a list. 3. Call sorted() to sort the list of date objects, earliest first. Store the sorted dates in a new list. 4. Output the sorted dates, in the format mm/dd/vy. a Hint: LUse strftime to format the date outputs. (See resource below.) 5. Output the number of days between the last two dates in the sorted list as a positive number. 6. Output the date that is 3 weeks from the most recent date in the format "July 4, 1776'. • Hint: Use timedelta() to set a duration of time for the arithmetic on date objects. (See resources below.) Ex: timedelta(days=50, seconds=27, hours=B, weeks=2) will define a duration of 50 days + 27 seconds + 8 hours +2 weeks. 7. Output the full...arrow_forwardThe program first reads integer cityCount from input, representing the number of pairs of inputs to be read. Each pair has a string and a character. One City object is created for each pair and added to vector cityList. Write the PrintSelectedCities() function in the SmallTowns class using Print() to output all the City objects with tour status equal to 'N'. Ex: If the input is: 4 Sundance N Adomstown N Hum Y Hanna Y then the output is: City: Sundance, Tour: N City: Adomstown, Tour: N Note: The vector has at least one element. #include <iostream>#include <vector>using namespace std; class City {public:void SetNameAndTour(string newName, char newTour); char GetTour() const; void Print() const;private:string name;char tour;}; void City::SetNameAndTour(string newName, char newTour) {name = newName;tour = newTour;} char City::GetTour() const { return tour;} void City::Print() const { cout << "City: " << name << ", Tour: " << tour <<...arrow_forwardJava programming 1. Write the code that will read the inventory information from a file, populate the object, and populate a linked list with all the inventory objects. Then find a particular item in the linked list based on user input and display the information for that item. Inventory inventory = new Inventory (); Write the line of code to find an inventory object in the linked list using the property for InventoryIDarrow_forward
- The following java function executes an SQL query based on the inputs from the combo boxes and text box from the screen shown and is supposed to return a list of items that match the query. The input string is a string of the field, operator and criteria text from the boxes separated by commas. However, the method is not currently functional and must be modified to enact the query. Modifiy the function so that it works properly. An image of the database schema has also been attached as well as the product class. public List<Product> getProductByCriteria(String criteria) { if (openConnection()) { try { List<Product> items = new ArrayList<>(); Product temp = null; String[] fields = criteria.split(","); String query = "SELECT * FROM products WHERE " + fields[0] + fields[1] + fields[2]; stmt = conn.prepareStatement(query); ResultSet rs = stmt.executeQuery(); while...arrow_forwardjava program For this question, the server contains the id, name and cgpa of some Students in a file. The client will request the server for specific data, which the server will provide to the client. Server: The server contains the data of some Students. For each student, the server contains id, name and cgpa data in a file. Here's an example of the file: data.txt101 Saif 3.52201 Hasan 3.81.... Create a similar file in you server side. The file should have at least 8 students. The client will request the server to provide the details (id, name, cgpa) of the Nth highest cgpa student in the file. If N's value is 1, the server will return the details of the student with the highest cgpa. if N's value is 3, the server will return the details of the student with the third highest cgpa. If N's value is incorrect, the server returns to the client: "Invalid request". Client: The client sends the server the value of N, which is an integer number. The client takes input the value of N...arrow_forwardThis exercise asks you to define some functions for manipulating linked structures. You should use the Node and TwoWayNode classes, as defined in this chapter. Create a tester module in the testnode.py file that contains your function definitions and your code for testing them. In the testnode.py file, complete the following: Complete the implementation of the length() function (not len). This function expects a singly linked structure as an argument. Returns the number of items in the structure. To test your program run the main() method in the testnode.py file. Your program's output should look like the following: 0: 0 5: 5arrow_forward
- In this assignment, you will write a program that readsa list of people from a file, create a HashSet of the people, and print the people in the HashSet.The input filename ispassed in as a command line argument.•The program must implement a main class, and a Person class.•A template for the Person class is provided.A Person has a name and an address, both Strings.•If the input file name is not provided, your program should an error message and exit, e.g., Usage: java FuAssignment10/FuMain inputfile•If the specified input file does not exist or cannot be opened, your program should an error message and exit, e.g.,File abc.txt does not existor cannot be opened!•The input file lists one person per line. Each line contains aname and an address, separated by a comma, ",".For example, the following are in a sample file students.txt:James Bond, 111 Main StTayer Smoke, 2334 Murry LnDavid Jones, 302 Toast AveAbby Wasch, 84 Sunny PlJames Bond, 111 Main St•Yourprogram should read each line,...arrow_forwardwrite in c++Write a program that would allow the user to interact with a part of the IMDB movie database. Each movie has a unique ID, name, release date, and user rating. You're given a file containing this information (see movies.txt in "Additional files" section). The first 4 rows of this file correspond to the first movie, then after an empty line 4 rows contain information about the second movie and so forth. Format of these fields: ID is an integer Name is a string that can contain spaces Release date is a string in yyyy/mm/dd format Rating is a fractional number The number of movies is not provided and does not need to be computed. But the file can't contain more than 100 movies. Then, it should offer the user a menu with the following options: Display movies sorted by id Display movies sorted by release date, then rating Lookup a release date given a name Lookup a movie by id Quit the Program The program should perform the selected operation and then re-display the menu. For...arrow_forwardFor the Assignment 5 (Part 2), Routes v.2 at the end of this module you will create a Route class that has a member a "bag" of Leg objects. The bag is to use a vector of pointers, but since all the objects in the bag are to be Leg s, it's okay to use Leg* instead of void* in the bag's declaration. You wrote its first constructor in a previous exercise. Now write a second one. (You may refer to the Assignment page to refer to the completed class declarations of Leg and Route classes). Assume that class Leg has data member C strings const char* const beginCity; and const char* const endCity; that are available to Route by a friend relationship. Write a constructor function for a Route class that takes exactly two parameters: a constant Route object reference to an already-existing Route , and a constant Leg object reference to be appended to the end of that Route to form the new Route . Here's the algorithm: Copy the first parameter's bag into the host object's bag. If the endCity of...arrow_forward
- Focus on string operations and methods You work for a small company that keeps the following information about its clients: • first name • last name • a 5-digit user code assigned by your company. The information is stored in a file clients.txt with the information for each client on one line (last name first), with commas between the parts. For example Jones, Sally,00345 Lin ,Nenya,00548 Fule,A,00000 Smythe , Mary Ann , 00012 Your job is to create a program assign usernames for a login system. First: write a function named get_parts(string) that will that will receive as its arguments a string with the client data for one client, for example "Lin ,Nenya,00548", and return the separate first name, last name, and client code. You should remove any extra whitespace from the beginning and newlines from the end of the parts. You’ll need to use some of the string methods that we covered in this lesson You can test your function by with a main() that is just the function call with the...arrow_forwardQ1. The last post didnt include the items in the database. Need a different function for the python program display_ticket below: def display_tickets():t = Texttable()tickets=cur.execute('''SELECT * FROM tickets''')for i in tickets:t.add_rows([['tid', 'actual_speed','posted_speed','age','violator_sex'],list(i)])print()print(t.draw())print() Q2. Also need a different function for the python program add_ticket below: def add_tickets():actual_speed=int(input("enter actual speed:"))posted_speed=int(input("enter posted speed:"))age=int(input("enter age:"))sex=input("Male or Female:")cur.execute('''INSERT INTO tickets(actual_speed,posted_speed,age,violator_sex) VALUES(?,?,?,?)''',(actual_speed,posted_speed,age,sex))con.commit() If you'd like to see what thousands of traffic tickets look like, check out this link: https://www.twincities.com/2017/08/11/we-analyzed-224915-minnesota-speeding-tickets-see-what-we-learned/arrow_forwardIs there a difference between the void and the NULL pointers? Your response should provide relevant instances to support it. Distinguish between the two in TABULAR format.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Text book imageDatabase System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationText book imageStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONText book imageDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- Text book imageC How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONText book imageDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningText book imageProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education