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
Concept explainers
Question
Hi good day i'm getting this error when trying to access localhost for my
Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1049] Unknown database 'car_sales_db' in C:\xampp\htdocs\Tutorial\config.php:19 Stack trace: #0 C:\xampp\htdocs\Tutorial\index.php(2): require() #1 {main} thrown in C:\xampp\htdocs\Tutorial\config.php on line 19
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 2 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
- EXPLORER 号 = Companion X Piedmont Technical College MindTap - Cengage Learning MindTap - Cengage Learning Companion - student [Codespace X + 时 ΑΠ https://opulent-cod-69vvqr75799xhrqwp.github.dev/?folder=/workspaces/9780357419748_a-guide-to-sql-9b87151b-b6ec-4283-af5b-cbe... ✓ STUDENT [CODESPACES: OPULENT COD] 0* Kim Tay.dump.sql query.sql > OUTLINE > TIMELINE >Codespaces: opulent cod 00 1 1 82°F Sunny ← student [Codespaces: opulent cod] query.sql X query.sql 1 SELECT ITEM_ID, DESCRIPTION, CATEGORY 2 FROM ITEM 3 WHERE PRICE > ANY (SELECT PRICE 4 FROM ITEM 5 WHERE CATEGORY = "CAT"); 6 7 8 9 10 11 12 13 14 15 16 17 18 PROBLEMS OUTPUT DEBUG CONSOLE TERMINAL PORTS 1 UF39 Underground Fence System DOG WB49 Insulated Water Bucket HOR Q Search × Welcome + ☐ Task 17: List the invoice num > Task 18: List the item ID, des A 日 a 08 Task 19: For each item, list th number and quantity ordered Task 20: Repeat Task 18 using Test Feedback: Query Output Ө ^ Query executed successfully. Layout: US 12:43…arrow_forwardPLZ help urgent: change the following so it works on oracle sql live or oracle sql developper CREATE TABLE `book`( `num` INT(20) NOT NULL AUTO_INCREMENT, `title` VARCHAR(20), `year` DATE, `subject` VARCHAR(20), `checkedout` DATETIME, `checkedin` DATETIME, PRIMARY KEY (`num`) ); CREATE TABLE `client`( `CID` INT(20) NOT NULL AUTO_INCREMENT, `fname` VARCHAR(25), `lname` VARCHAR(25), `type` VARCHAR(25), `num` INT(20), PRIMARY KEY (`CID`), FOREIGN KEY (`num`) REFERENCES `emp`.`state`(`state_id`) ); CREATE TABLE `author`( `id` INT(10) NOT NULL AUTO_INCREMENT, `year` DATE, `fName` VARCHAR(20), `lname` VARCHAR(20), `num` INT(20), PRIMARY KEY (`id`) ); ALTER TABLE `author` ADD FOREIGN KEY (`num`) REFERENCES `book`(`num`); ALTER TABLE `client` ADD CONSTRAINT `client_ibfk_1` FOREIGN KEY (`num`) REFERENCES `book`(`num`);arrow_forwardAssume that a database has a table named Stock, with the following columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price moneyWrite a Select statement that returns the Trading_Symbol column only from the rows where Purchase_Price is greater than $25.00.arrow_forward
- ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY'; /* JOB TABLE */ CREATE TABLE JOB ( JOB_CODE varchar2(3) PRIMARY KEY, JOB_DESCRIPTION varchar2(25), JOB_CHG_HOUR float(8), JOB_LAST_UPDATE date ); INSERT INTO JOB VALUES('500','Programmer', '35.75','11/20/2015'); INSERT INTO JOB VALUES('501','Systems Analyst', '96.75','11/20/2015'); INSERT INTO JOB VALUES('502','Database Designer', '125', '3/24/2016'); INSERT INTO JOB VALUES('503','Electrical Engineer', '84.5', '11/20/2015'); INSERT INTO JOB VALUES('504','Mechanical Engineer', '67.9', '11/20/2015'); INSERT INTO JOB VALUES('505','Civil Engineer', '55.78','11/20/2015'); INSERT INTO JOB VALUES('506','Clerical Support', '26.87','11/20/2016'); INSERT INTO JOB VALUES('507','DSS Analyst', '45.95','11/20/2015'); INSERT INTO JOB VALUES('508','Applications Designer','48.1', '3/24/2016'); INSERT INTO JOB VALUES('509','Bio Technician', '34.55','11/20/2015'); INSERT INTO JOB…arrow_forwardDatabase https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_allarrow_forwardThe MongoDB shell is an interactive ______interface to MongoDB. You can use the mongo shell to query and update data as well as perform administrative operations. A. NodeJS B. JavaScript C. C D. SQLarrow_forward
- Hello. I am having trouble with a question for my database devlopment class. I need help with this because I have been struggling with this and haven't found a clear answer. I would appreciate the help. Thanks. Display a list of all books in the BOOKS table. If a book has been ordered by a customer, also list thecorresponding order number and the state in which the customer resides. Use the tablesdb1.casteel.books, db1.casteel.orderitems, db1.casteel.orders, & db1.casteel.customers.[ HINT: You should get 35 rows and three columns ]arrow_forwardclass 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_Stringarrow_forwardDatabase: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_allarrow_forward
- Composite main keys have prospective keys.arrow_forwardJavaFX 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 belowarrow_forwardThe Sqlite.py file contains several very specific queries: select_Query = "select sqlite_version()" delete_query = "DELETE from Database where id = "+str(id) sel = 'SELECT id FROM Database WHERE name == "{0}"'.format(value) insert_query = """INSERT INTO Database (id, name, photo, html) VALUES (?, ?, ?, ?)""" sqlite_select_query = """SELECT * from Database""" table_query = '''CREATE TABLE Database ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, photo text NOT NULL UNIQUE, html text NOT NULL UNIQUE)''' Write a QueryBuilder function. The QueryBuilder builds a generic Query to build ANY Query type (i.e. version, delete, select, insert, select, table). The QueryBuilder parameters require: The type of Query, the input tuple data and then constructs a query string based on the parameters.…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