Implement the DBS Share Price Index System in Python as per Figure 2 below which allows users to add, delete, update and lookup Share Prices. The System should store the Company Name and Share Price. Your program should not allow users to add the same company more than once. On adding, deleting, updating or looking up a Share Price, your program should let the user know if the operation was successful or not. On looking up a Share Price return the Company Name and Share Price of the company; if the company is not found give the user the option to add the details they are looking up. The user can perform multiple actions; they can add a new entry and subsequently delete an entry without having to stop and start the program until they decide to quit

Implement the DBS Share Price Index System in Python as per Figure 2 below which allows users to add, delete, update and lookup Share Prices. The System should store the Company Name and Share Price. Your program should not allow users to add the same company more than once. On adding, deleting, updating or looking up a Share Price, your program should let the user know if the operation was successful or not. On looking up a Share Price return the Company Name and Share Price of the company; if the company is not found give the user the option to add the details they are looking up. The user can perform multiple actions; they can add a new entry and subsequently delete an entry without having to stop and start the program until they decide to quit

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter12: Database Queries With Sql

Section: Chapter Questions

Problem 4E

See similar textbooks

Similar questions

What is the difference between disabling a constraint and dropping a constraint?
Which of the following types of constraints cant be created at the table level? a. NOT NULL b. PRIMARY KEY c. CHECK d. FOREIGN KEY e. None of the above constraints can be created at the table level.
Which type of constraint can be used to make certain the category for a book is included when a new book is added to inventory?
Which of the following commands can you use to rename a constraint? RENAME ALTER CONSTRAINT MOVE NEW NAME None of the above commands can be used.
Which type of constraint should you use to ensure that every book has a profit margin between 15% and 25%?
What does the funnel symbol that appears next to a field’s name in the Query Builder dialog box indicate? The field is used in a SELECT statement’s ORDER BY clause. The field is used in a SELECT statement’s WHERE clause. The field is the primary key. The field is the foreign key.
Products_UPDATE should check DiscountPercent. This trigger should error if discount % is 100 or less. This trigger doubles the new discount % from 0–1. A.20% discount. Check this trigger.
Create a trigger named Products_UPDATE that checks the new value for the DiscountPercent column of the Products table. This trigger should raise an appropriate error if the discount percent is greater than 100 or less than 0. If the new discount percent is between 0 and 1, this trigger should modify the new discount percent by multiplying it by 100. That way, a discount percent of .2 becomes 20. Test this trigger with an appropriate UPDATE statement.
SQL: Add a table-level PRIMARY KEY constraint to the EMPLOYEE table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Create a PRIMARY KEY constraint on the DEPARTMENT table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Add a foreign key reference on the EMPLOYEE table that will ensure that the employee is not assigned to a nonexistent department. Confirm that the constraints were added by querying USER_CONSTRAINTS. Note the types and names of the constraints and include them in your statement comments. Display the object names and types from the USER_OBJECTS data dictionary view for EMPLOYEE and DEPARTMENT tables. You will want to format the columns for readability. Provide comments that include the new tables and indexes created. Modify the EMPLOYEE table by adding a SALARY column of NUMBER data type, precision 7. Confirm…
The Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the Driver ID. After the change, you need to insert the following driver: First Name: Nursin Last Name: Yilmaz Driving License ID: 4141447 Start Date: 2019-12-28 Driving License Checked: True Rating: 4.0
1- Create a NONGAME table with the following structure: Column Туpe Length Decimal Places Nulls Allowed? Description ITEM NUM CHAR Primary Key 4 No DESCRIPTION CHAR 30 ON HAND DECIMAL 4 CATEGORY CHAR 3 PRICE DECIMAL 2- Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from the ITEM table for each item that is not in category GME. 3- In the NONGAME table, change the description of item number DL51 to "Classic Train Set". 4- In the NONGAME table, increase the price of each item in category TOY by two percent. (Hint: Multiply each price by 1.02). 5- Add the following item to the NONGAME table: item number: TL92; description: Dump Truck; number of units on hand: 10; category: TOY; and price: 59.95. 6- Delete every item in the NONGAME table for which the category is PZL. 7- In the NONGAME table, change the category for item FD11 to null. 8- Add a column named ON_HAND_VALUE to the NONGAME table. The on-hand value is a seven-digit…
An index is automatically created for a FOREIGN KEY constraint. Select one: a. True b. False