FIGURE Ch08 SimpleCo database tables P8.1 Database name: Ch08_SimpleCo Table name: CUSTOMER Table name: INVOICE CUST NUM CUST LNAME CUST ENAME CUST BALANCE 1000 Smith 1001 Ortega INV_NUM CUST_NUM INV DATE | INV_AMOUNT Jeanne 1050.11 8000 1000 23-Mar-14 235.89 Juan 840.90 8001 1001 23-Mar-14 312.82 8002 1001 30-Mar-14 528.10 Table name: CUSTOMER 2 8003 1000 12-Apr-14 194.78 CUST NUM CUST UNAME CUST FNAME 8004 1000 23-Apr-14 619.44 2000 McPherson Anne 2001 Ortega Juan 2002 Kowalski Jan 2003 Chen George Cengage Learning © 2015

FIGURE Ch08 SimpleCo database tables P8.1 Database name: Ch08_SimpleCo Table name: CUSTOMER Table name: INVOICE CUST NUM CUST LNAME CUST ENAME CUST BALANCE 1000 Smith 1001 Ortega INV_NUM CUST_NUM INV DATE | INV_AMOUNT Jeanne 1050.11 8000 1000 23-Mar-14 235.89 Juan 840.90 8001 1001 23-Mar-14 312.82 8002 1001 30-Mar-14 528.10 Table name: CUSTOMER 2 8003 1000 12-Apr-14 194.78 CUST NUM CUST UNAME CUST FNAME 8004 1000 23-Apr-14 619.44 2000 McPherson Anne 2001 Ortega Juan 2002 Kowalski Jan 2003 Chen George Cengage Learning © 2015

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter6: Additional Database Objects

Section: Chapter Questions

Problem 10MC

See similar textbooks

Similar questions

Db&__Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers...
Hello can you help me to connect my registration PHP which I don't know how to insert those registration data on my database and table which is the admin table and the regular table. Can you help me for the right code for the table admin and regular to connect to my database I would appreciate if you would put the right code and SQL query for the connection. Here is my PHP code <?php session_start(); include 'database_connection.php'; if($_POST['uname'] && $_POST['password']) { $name=$_POST['name']; $lname = $_POST['lname']; $fname = $_POST['fname']; $mname = $_POST['mname']; $gen = $_POST['gender']; $birth = $_POST['birth']; $type = $_POST['utype']; $email = $_POST['email']; $pass=$_POST['password']; if($type=='Admin') admin($name,$lname,$fname,$mname,$gen,$birth,$email,$pass,$con); else regular($name,$lname,$fname,$mname,$gen,$birth,$email,$pass,$con); }…
Write SQL command to create above table “course” and insert the above values. ccode cname C101 Database concepts and design C102 Software Engineering C103 Human Computer Interaction C104 Programming-2 C105 Multimedia Write SQL command to create above table “student” with REFERENCES and insert the above values. Hints:- In table student ccode is a FOREIGN KEY. sid sname ccode 101 Abdullah Ahmad C101 102 Ali C102 103 Hazmi C104 104 Khalid C102 105 Ali Ahmad C103 Write SQL command to display sname(student name) from student table and corresponding cname(course name) from course table using inner join. Your output should be like this sname cname Abdullah Ahmad Database concepts and design Ali Software Engineering Hazmi Programming-2 Khalid Software Engineering Ali Ahmad Human Computer Interaction (in a program mycmpiler)
Part A: MySQL Query/Exec Create StudentsDB database in MySQL server with the following table: Table: Students uid int, Primary Key, Auto Increment studentID varchar(8), Unique name varchar(50) major varchar(50) passedCredits int CGPA float Implement the following PHP scripts as required below: php: the script should display student’s info (StudentID, name, major, credits passed and CGPA) in HTML table with appropriate title for each column. Student cells/rows should be highlighted as follows: Condition Highlight Color Student At Risk: CGPA < 2.0 Red for CGPA Cell Expected to graduate: Passed Credits >=115 Yellow for Passed Credits Cell Outstanding Student: CGPA = 3.5 or above Green for the entire Student Row php: This script should display all students’ names and major. Each student will be identified by a checkbox (define the checkbox name as a numeric array holding the uid). The…
I am new to databases. Using MySQL I am not certain how to make views relevant to the tables in my database. Can I get help explaining how to several views relative to the tables? Here are the tables I set up in MySQL. Employers: CREATE TABLE Employers ( employer_id INT NOT NULL PRIMARY KEY, company_name VARCHAR(50) NOT NULL, company_street VARCHAR(55) NOT NULL, company_city VARCHAR(55) NOT NULL, company_state VRCHAR(2) NOT NULL, company_zip VARCHAR(10) NOT NULL, company_contact VARCHAR(55) ); Customers: CREATE TABLE Customers ( customer_id INT NOT NULL PRIMARY KEY, customer_name VARCHAR(55) NOT NULL, customer_phone VARCHAR(15) NOT NULL, customer_email VARCHAR(40) NOT NULL, customer_education VARCHAR(55) NOT NULL, customer_experience VARCHAR(55) NOT NULL ); Reference: CREATE TABLE Referral ( customer_id INT NOT NULL PRIMARY KEY, referral_first_name VARCHAR(25) NOT NULL, referral_last_name VARCHAR(25) NOT NULL, referral_location VARCHAR(44) NOT NULL, referral_phone VARCHAR(15),…
create Database CTU_YOURICASNOGOUSE CTU_YOURICASNO;GOCREATE TABLE Course( CourseID int PRIMARY KEY, CourseName varchar(255), CourseDesc varchar(255),);CREATE TABLE Students( ICASNo int Primary Key, StudentName varchar (255)NOT NULL, StudentSurname varchar (255)NOT NULL, StudentContact varchar (255)NOT NULL, StudentEmail varchar(255)NOT NULL, HighSchoolAttended varchar(255)NOT NULL, courseID int,);CREATE TABLE Semester( SemesterID int Primary Key, SemesterStartDate varchar(255)NOT NULL, SemesterEndDate varchar(255)NOT NULL, ICASNo varchar(255),);CREATE TABLE Facilitator( FacilitatorID int Primary Key, FacilitatorName varchar(255) Not Null, FacilitatorContact varchar(255)Not Null, FacilitatorEmail varchar(255)Not Null, ICASNo varchar(255)Not Null, ); CREATE TABLE Module( ModuleID int Primary Key, ModuelName varchar(255)Not Null, ModuleDuration varchar(255)Not Null, FacilitatorID varchar(255)Not Null,); Using the…
Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions: Transaction SQL Statement Retrieve the flight number, departure and arrival airports of all British Airways. Retrieve the name of every passenger together with their flight number and the associated company. Retrieve all flights departed from all airports in London. Retrieve the ticket numbers…
Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers.4. Retrieve the flight number, departure and arrival airports of all British Airways.5. Retrieve the name of every passenger together with their…
Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions: Transaction SQL Statement Retrieve all rows in Airport table for all the airports in London city. Retrieve all British and German passengers. Retrieve all names of all the passengers. Retrieve the flight number, departure and arrival airports of all British Airways. Retrieve the name of…
Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions: please if you could give all the sql statements needed i will appreciate that, and i promise to put thump up Transaction SQL Statement Retrieve all rows in Airport table for all the airports in London city. Retrieve all British and German passengers. Retrieve all names of all the passengers.…
Create the following tables using MySQL CLI. Take a screenshot of each CREATE TABLE command that is successfully executed. School Column Name Data Type Length Decimal Places Primary Key? schoolNumber Integer yes name VarChar 200 address VarChar 95 phoneNumber VarChar 10 built Date size Integer
Create a MYSQL Database named 'db'Create a MYSQL User named 'dbuser' with a password 'dbpass' Grant Insert, Delete, Update and Select privileges for 'dbuser' on 'db' Create a MYSQL Table on database 'db' and name it as 'students' with the following field and field propertiesField Name Field Type Field Size Additional İnformationStudent No Varchar 6 Primary keyName Varchar 20 Surname Varchar 25 birthdate date