Build an application for a car rental company. It should offer the following features: • Maintain a customer database in a file: Register / add new customers. Customer information should include • Customer ID number • Name Phone number Search customer database by: • Customer ID number Name • Phone number And print out the matching records • Maintain a database in a file: o Add a new vehicle to the fleet. Vehicle information should include • Model year • Make Model name License plate number Customer number who is currently renting vehicle Delete a vehicle from the fleet Rent a vehicle to a registered customer Receive rented vehicle back from customer Search vehicle database by any field: • Model year + Make + Model name • License plate number Customer number who is currently renting vehicle And print out all matching records

Build an application for a car rental company. It should offer the following features: • Maintain a customer database in a file: Register / add new customers. Customer information should include • Customer ID number • Name Phone number Search customer database by: • Customer ID number Name • Phone number And print out the matching records • Maintain a database in a file: o Add a new vehicle to the fleet. Vehicle information should include • Model year • Make Model name License plate number Customer number who is currently renting vehicle Delete a vehicle from the fleet Rent a vehicle to a registered customer Receive rented vehicle back from customer Search vehicle database by any field: • Model year + Make + Model name • License plate number Customer number who is currently renting vehicle And print out all matching records

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

You are required to write a Product Management Android application for a small business as described below. The user of the application is the Purchase Manager. The Purchase Manager requires functionality for decision support on making purchases and updating stock quantities when stocks are received. Viewing of updated stock quantities and stock prices is required. Using Andriod programming Create View 1 as follows: This view is the “Receiving Stocks” view. It must show a list of Product Names, a field for entering the quantity received, and a button, “Update Stocks”. The Purchase Manager will select the relevant Product Name, enter an integer, and click on the button. The button should add the quantity entered above to the StockOnHand field for the specified Product Name, as well as, subtract the quantity entered from the StockInTransit field. The “Output View” must then be updated. See below. Create View 2 as follows: This view is the “Ordering Stocks” view. It shows a list of…
Q1 ): You are about to design a university database to keep information about departments, professors, and course offerings. Here is what you have been told about this application. Departments are identified by a code (e.g. CSE) and have a name (e.g., "Computer Science and Engineering"). Professors are identified by their initials (like "MNK1"), they have a name, and they are affiliated with at least one department. Professors are either tenured ("tenured" means permanent) or junior (they have to be in one of these categories and they cannot be in both). For tenured professors we want to know the year they earned tenure (year when they became permanent) and for junior professors we want to know the date they were hired. Finally, a department has exactly one chairperson who must be a tenured professor in any department (i.e., there is no requirement that the chairperson is affiliated with the department s/he chairs). A department (e.g., CSE) lists courses to be offered to students for…
elifmenu == 'gr': file6 = open('tasks.txt', 'r') tasks = file6.readlines() total_tasks = len(tasks) total_completed_tasks = 0 total_uncompleted_tasks = 0 total_task_overdue = 0 fortaskintasks: assigned_user, task_title, task_description, current_date, task_due, completed_question = task.strip().split(", ") task_due_2 = parser.parse(task_due) iftask[-1] == "Yes": total_completed_tasks += 1 else: total_uncompleted_tasks += 1 iftask_due_2 < datetime.today(): total_task_overdue += 1 incomplete_percentage = round(total_completed_tasks / total_tasks * 100, 2) overdue_percentage = round(total_task_overdue / total_tasks * 100, 2) print("Report Generated in file: task_overview.txt") file7 = open('task_overview.txt', 'a') file7.write(f"Number of tasks: {total_tasks}\n") file7.write(f"Number of completed tasks: {total_completed_tasks}\n") file7.write(f"Number of uncompleted tasks: {total_uncompleted_tasks}\n") file7.write(f"Number of overdue tasks: {total_task_overdue}\n")…
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 state
COVIN is a mobile application used to maintain covid tests and vaccine details of the registered users. Consider the following steps in the use case named 'Display Details' in the COVIN system and do the tasks/requirements: The user requests the system to display his/her details. The user selects the type of the details required. The user enters the registration ID. The user's registration ID is validated using the COVIN database. The user's requested details are displayed. Errors are handled by showing appropriate messages. A.) Draw the use case diagram for 'Display Details' B) Draw the sequence diagram to show the messages exchanged between the objects in 'Display Details' use case.
In Visual Basics, ANTIQUE CAR COMPETITION DATABASE Design a Windows Application and write the code that will execute according to the program requirement below : ____________________________________________________________________________________________________ (i) The user views the Access database, which displays the car year model, and owner information. (ii) The user clicks the Add new button to add a new car and clicks the Save data button to save the item to the database. (iii) The user clicks the Delete button to delete a car, and permanently deletes the record from the database by clicking the Delete data button.
class Database:def __init__(self, db_name):self.db = sqlite3.connect(db_name)self.cursor = self.db.cursor()def create_table(self, table_schema):self.cursor.execute(table_schema)self.db.commit()def insert_data(self, table_name, data):for i in range(len(data)):keys = ", ".join(data.columns)values = ", ".join([f"'{value}'" if pd.isna(value) else str(value) for value in data.iloc[i]])self.cursor.execute(f"INSERT INTO {table_name} ({keys}) VALUES ({values})")self.db.commit()def search_data(self, table_name, year):self.cursor.execute(f"SELECT * FROM {table_name} WHERE year={year}")result = self.cursor.fetchone()if result is not None:return resultelse:return Nonedef delete_data(self, table_name, year):self.cursor.execute(f"DELETE FROM {table_name} WHERE year={year}")self.db.commit()return self.cursor.rowcount > 0 Please rewrite (or convert) the code above with format: def QueryBuilder( Data_Base, Query_Type, Query_Tuple):'''''' Build Query_String'''''' return Query_String
Next year, God willing, Arab Open University will organize an international conference. On the sidelines of the conference, many workshops wilkebeld It is required to help the organizers implement an application to keep track of all workshops and attendees. Requirements: After a quick meeting with the organizers, you got the following information: Each attendee has a unique passport number, a name and other attributes (add at least 2 attributes from your choice). • The whole data should be stored in one collection such that for each workshop, all attendees associated with it çoyld.becetriexed easily and directly. • There is a text file including the names of all available workshops (each workshop is in a separate line) Implementation: After analysiog the given requirements, implement the required application: • with Object Oriented Programming style telleving the rules of good programming style (e.g. adding comments, etc.) O using only the material covered in M251 (and its…
JavaFX program Create a JavaFX GUI that allows the user to retrieve records from the product table in the example database. The GUI should allow the user to specify desired fields, desired order, and a where condition. Display only the desired fields in the desired order for the desired where condition.You may display the records in the GUI in any way you wish. database below
Create an application which can access a database. Create a database with an application user, user specific for your application to use, and 1 table of a couple of fields properly indexed. Grant permissions for the user to access the table. (submit .SQL file) Create a simple application, language of your choice, (BE languages only, no JS or Node) which can do the following operations: (submit source code file): Connect using the application user created above. Insert into the table, and select from the table using a WHERE clause, where all fields are parameterized. Display results of the select. Use a simple web server API interface for data input and output, which can be accessed via local browser or curl.
import sqlite3 from sqlite3 import Error # Creates connection to sqlite in-memory database def create_connection(): """ Create a connection to in-memory database :return: Connection object """ try: conn = sqlite3.connect(":memory:") return conn except Error as e: print(e) # YOUR CODE HERE # Use sqlite3.connect(":memory:") to create connection object return conn # query to create the table table_sql = """ CREATE TABLE Horses ( id integer PRIMARY KEY NOT NULL, name text, breed text, height real, birthday text ); """ # query to insert data into the table ins_sql = """INSERT INTO Horses VALUES(1,'Babe','Quarter Horse',15.3,'2015-02-10'); """ # query to fetch all data from the table fetch_sql = """SELECT * FROM Horses;""" # creating db connection conn = create_connection() # fetching a cursor from the connection c = conn.cursor() # executing statement to create table c.execute(table_sql) # executing statement to…
Exercise 3: Simple login system Create a static dictionary with a number of users and with the following values : first name Last name Email address Password Ask the user for : 5. Email address 6. Password Loop ( for ()) through the dictionary and if ( if ()) the user is found print the following : 7. Hello , first name last name you have successfully logged in 8. Notify the user if the password and email address are wrong 9. Additional challenge : if you want the program to keep asking for a username and password when the combination is wrong, you will need a while () loop.