Can someone tell me why I’m getting the ORA-00942: table or view…
Question Answered step-by-step Can someone tell me why I’m getting the ORA-00942: table or view… Can someone tell me why I’m getting the ORA-00942: table or view does not exist Error? (Line 150 column: 46 | Last line of code) Here is my code below, I’m using SQL Developer 12c, thanks in advance! –Creating the tablesCREATE TABLE Carter_Patients ( patient_full_name TEXT NOT NULL, patient_address TEXT NOT NULL, patient_phone INTEGER NOT NULL, patient_email TEXT NOT NULL, emergency_contact_phone_number INTEGER NOT NULL, emergency_contact_email TEXT NOT NULL, insurance_company TEXT, insurance_policy_number INTEGER, insurance_group_number INTEGER, social_security_number INTEGER NOT NULL, CONSTRAINT Carter_Patients_PK PRIMARY KEY (social_security_number)); CREATE TABLE Carter_Insurance_Companies ( insurance_company_address TEXT, insurance_company_phone INTEGER NOT NULL, insurance_company_email TEXT NOT NULL, insurance_company_plan_type TEXT NOT NULL, CONSTRAINT Carter_Insurance_compnies_PK PRIMARY KEY (insurance_company_address)); CREATE TABLE Carter_Dental_Records ( CONSTRAINT Carter_Dental_Records_FK FOREIGN KEY (social_security_number) REFERENCES Carter_Patients(social_security_number), CONSTRAINT Carter_Dental_Records_FK FOREIGN KEY (patient_full_name) REFERENCES Carter_Patients(patient_full_name), type_of_service TEXT NOT NULL); CREATE TABLE Carter_Invoices ( patient_address TEXT NOT NULL, services_offered TEXT NOT NULL, patient_full_name TEXT NOT NULL, invoice_price INTEGER NOT NULL, invoice_date DATE NOT NULL, CONSTRAINT Carter_Invoices_PK PRIMARY KEY (invoice_number)); CREATE TABLE Carter_Inventory ( CONSTRAINT Carter_Inventory_FK FOREIGN KEY (manufacturer_name) REFERENCES Carter_Manufacturers(manufacturer_name), CONSTRAINT Carter_Inventory_FK FOREIGN KEY (supplier_name) REFERENCES Carter_Suppliers(supplier_name), quantity_in_stock INTEGER, cost_per_unit INTEGER, model_number INTEGER, part_number INTEGER); CREATE TABLE Carter_Manufacturers ( manufacturer_name TEXT NOT NULL, manufacturer_url TEXT NOT NULL, manufacturer_address TEXT NOT NULL, manufacturer_phone INTEGER NOT NULL, manufacturer_fax INTEGER, manufacturer_contact_name TEXT NOT NULL, manufacturer_email, CONSTRAINT Carter_Manufactureres_PK PRIMARY KEY (manufacturer_name)); CREATE TABLE Carter_Suppliers ( supplier_name TEXT NOT NULL, supplier_url TEXT NOT NULL, supplier_address TEXT NOT NULL, supplier_phone INTEGER NOT NULL, supplier_fax INTEGER, supplier_contact_name TEXT NOT NULL, supplier_email TEXT NOT NULL, CONSTRAINT Carter_Suppliers_PK PRIMARY KEY (supplier_name)); CREATE TABLE Carter_Staff ( staff_full_name TEXT NOT NULL, staff_address TEXT NOT NULL, staff_home_phone INTEGER, staff_mobile_phone INTEGER NOT NULL, staff_emergency_contact TEXT NOT NULL, staff_emergency_contact_phone INTEGER NOT NULL, staff_emergency_contact_email TEXT NOT NULL, job_title TEXT, CONSTRAINT Carter_Staff_PK PRIMARY KEY (staff_full_name));–Inserting Records into Patient TableINSERT INTO Carter_Patients (patient_full_name, patient_address, patient_phone, patient_email, emergency_contact_phone_number, emergency_contact_email,social_security_number)VALUES(‘Michael Carter’, ‘..1umbc.edu’, 2222222222, ‘..2umbc.edu’, 000000000);INSERT INTO Carter_Patients (patient_full_name, patient_address, patient_phone, patient_email, emergency_contact_phone_number, emergency_contact_email,social_security_number)VALUES(‘Charlie Kimball’, ‘..eumbc.edu’, 4444444444, ‘..eumbc.edu’, 111111111);INSERT INTO Carter_Patients (patient_full_name, patient_address, patient_phone, patient_email, emergency_contact_phone_number, emergency_contact_email,social_security_number)VALUES(‘Javon Summers’, ‘..sumbc.edu’, 2222222222, ‘..eumbc.edu’, 222222222);–Inserting Insurance Company RecordsINSERT INTO Carter_Insurance_Companies (insurance_company_address, insurance_company_phone, insurance_company_email, insurance_company_plan_type)VALUES (‘Maryland’, 849, ‘..1@invalid.com’, ‘100% dental coverage’);INSERT INTO Carter_Insurance_Companies (insurance_company_address, insurance_company_phone, insurance_company_email, insurance_company_plan_type)VALUES (‘New York’, 456, ‘..2@invalid.com’, ‘60% dental coverage’);INSERT INTO Carter_Insurance_Companies (insurance_company_address, insurance_company_phone, insurance_company_email, insurance_company_plan_type)VALUES (‘Hawaii’, 879, ‘..3@invalid.com’, ‘30% dental coverage’);–Inserting Dental Records RecordsINSERT INTO Carter_Dental_Records (type_of_service, patient_full_name, social_security_number)VALUES (‘Cleaning’, ‘Michael Carter’,000000000);INSERT INTO Carter_Dental_Records (type_of_service, patient_full_name, social_security_number)VALUES (‘Braces’, ‘Charlie Kimball’, 111111111);INSERT INTO Carter_Dental_Records (type_of_service, patient_full_name, social_security_number)VALUES (‘Toothache’, ‘Javon Summers’, 222222222 ); –Inserting Invoice RecordsINSERT INTO Carter_Invoices (patient_address, services_offered, patient_full_name, invoice_price, invoice_date)VALUES (‘Maryland’, ‘Routine Teeth Cleaning’, ‘Michael Carter’, 0, 05-22-2022);INSERT INTO Carter_Invoices (patient_address, services_offered, patient_full_name, invoice_price, invoice_date)VALUES (‘Maryland’, ‘Braces Consultation’, ‘Charlie Kimball’, 75, 07-02-2021);INSERT INTO Carter_Invoices (patient_address, services_offered, patient_full_name, invoice_price, invoice_date)VALUES (‘Pennslyvania’, ‘Toothache Treatment’, ‘Javon Summers’, 150, 09-12-2004);–Inserting Inventory RecordsINSERT INTO Carter_Inventory (manufacturer_name, quantity_in_stock, cost_per_unit)VALUES (‘ACME’, 3, 4000);INSERT INTO Carter_Inventory (supplier_name, quantity_in_stock, cost_per_unit, model_number)VALUES (‘DENTALCO’, 25, 35, 056341);INSERT INTO Carter_Inventory (supplier_name, quantity_in_stock, cost_per_unit, model_number)VALUES (‘ACME’, 15, 780, 123456);–Inserting Manufacturer RecordsINSERT INTO Carter_Manufacturers (manufacturer_name, manufacturer_url, manufacturer_address, manufacturer_phone, manufacturer_contact_name)VALUES (‘ACME’, ‘acme.com’, ‘California’, 55555555555, ‘Brian Griffin’);INSERT INTO Carter_Manufacturers (manufacturer_name, manufacturer_url, manufacturer_address, manufacturer_phone, manufacturer_contact_name)VALUES (‘DENTIST DEPOT’, ‘dentistdepot.com’, ‘New Mexico’, 4565012365, ‘Cowboy Jones’);INSERT INTO Carter_Manufacturers (manufacturer_name, manufacturer_url, manufacturer_address, manufacturer_phone, manufacturer_contact_name)VALUES (‘Cheapstuff for cheap’, ‘cheapstuff.com’, ‘Alaska’, 55555555555, ‘Derek Biles’);–Inserting Supplier RecordsINSERT INTO Carter_Suppliers (supplier_name, supplier_url, supplier_address, supplier_phone, supplier_contact_name, supplier_email)VALUES (‘ACME’, ‘acme.com’, ‘California’, 55555555555, ‘Brian Griffin’);INSERT INTO Carter_Suppliers (supplier_name, supplier_url, supplier_address, supplier_phone, supplier_contact_name, supplier_email)VALUES (‘DENTALCO’, ‘dentalco.com’, ‘Egypt’, 0456158325, ‘King Tut’);INSERT INTO Carter_Suppliers (supplier_name, supplier_url, supplier_address, supplier_phone, supplier_contact_name, supplier_email)VALUES (‘Walmart’, ‘walmart.com’, ‘California’, 55555555555, ‘Walton Family’);–Inserting Staff RecordsINSERT INTO Carter_Staff (staff_full_name, staff_address, staff_mobile_phone, staff_emergency_contact, staff_emergency_contact_phone, staff_emergency_contact_email, job_title)VALUES (‘Jessica Smith’, ‘Maryland’, 911, ‘Jessica Mom’, 912, ‘..m@gmail.com’, ‘Dental Assistant’);INSERT INTO Carter_Staff (staff_full_name, staff_address, staff_mobile_phone, staff_emergency_contact, staff_emergency_contact_phone, staff_emergency_contact_email, job_title)VALUES (‘Kobe Smith’, ‘Maryland’, 411, ‘Sam Smith’, 912, ‘..h@gmail.com’, ‘Dental Assistant’);INSERT INTO Carter_Staff (staff_full_name, staff_address, staff_mobile_phone, staff_emergency_contact, staff_emergency_contact_phone, staff_emergency_contact_email)VALUES (‘Walter White’, ‘Maryland’, 855, ‘Walters Wife’, 122, ‘..y@gmail.com’);–Select all attributes of every staff memberDESCRIBE Carter_Staff;–Select the names for manufacturers who are also suppliersSELECT manufacturer_name FROM Carter_Manufacturers INNER JOIN Carter_Suppliers ON Carter_Manufacturers.manufacturer_name = Carter_Suppliers.supplier_name;–List the first and last names of dental assistantsSELECT staff_full_name FROM Carter_Staff WHERE job_title = ‘Dental Assistant’;–List a single supplier name and address of a single supplySELECT supplier_name, supplier_address FROM Carter_Suppliers WHERE supplier_name = ‘ACME’; Computer Science Engineering & Technology MYSQL IS 607 Share QuestionEmailCopy link Comments (0)
