CREATE TABLE DONORS ( donor_id INT NOT NULL, donor_name varchar(255) NOT NULL, donor_age int, PRIMARY KEY (donor_id ) ); CREATE TABLE DONATIONS( pledge_id INT NOT NULL, pledge_date varchar(255) NOT NULL, amount_pledged int, Is_paid int, donor_id int, PRIMARY KEY (pledge_id ), FOREIGN KEY (donor_id) REFERENCES DONORS(donor_id) ); 1. Populate every relation with three rows.

CREATE TABLE DONORS ( donor_id INT NOT NULL, donor_name varchar(255) NOT NULL, donor_age int, PRIMARY KEY (donor_id ) ); CREATE TABLE DONATIONS( pledge_id INT NOT NULL, pledge_date varchar(255) NOT NULL, amount_pledged int, Is_paid int, donor_id int, PRIMARY KEY (pledge_id ), FOREIGN KEY (donor_id) REFERENCES DONORS(donor_id) ); 1. Populate every relation with three rows.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter9: Working With Text Functions And Creating Custom Formats

Section: Chapter Questions

Problem 3RA

See similar textbooks

Similar questions

DROP TABLE IF EXISTS Worker; CREATE TABLE Worker ( ); 0 INSERT ); WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FIRST NAME TEXT, LAST NAME TEXT, SALARY INTEGER (15), JOINING DATE DATETIME, DEPARTMENT CHAR (25) INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES 'Arora', 100000, '14-02-20 09.00.00', 'HR'), (001, 'Monika', (002, 'Niharika', 'Verma' 80000, '14-06-11 09.00.00', 'Admin'), 'HR'), 'Admin'), Admin'), 'Account'), 'Kumar', 75000, '14-01-20 09.00.00', 'Account') DROP TABLE IF EXISTS Bonus; CREATE TABLE Bonus ( ); (003, 'Vishal' 'Singhal', 300000, '14-02-20 09.00.00', (004, 'Amitabh 'Singh', 500000, '14-02-20 09.00.00', (005, 'Vivek' 'Bhati', 500000, '14-06-11 09.00.00'. (006, 'Vipul', 'Diwan' 200000, '14-06-11 09.00.00', (007, 'Satish' (008, 'Geetika', 'Chauhan', 90000, '14-04-11 09.00.00', 'Admin'); WORKER_REF_ID INTEGER, BONUS AMOUNT INTEGER(10), BONUS_DATE DATETIME, FOREIGN KEY (WORKER_REF_ID) REFERENCES Worker (WORKER_ID) ON DELETE…
CUSTOMER Customer table is composed of customer number, name and phone number. Give and fill-in the appropriate attribute name for each of the column. custID 123 124 125 126 reservelD 5001 5002 5003 5004 5005 5006 5007 RESERVATION Each reservation is for one taxi. Reservation table is composed of reservation identification number, start reservation date, end reservation date, reservation days requested by customers starting from reservation date until end of reservation date, customer number that make the reservation and taxi number assigned to the reservation. Give and fill-in the appropriate attribute name for each of the column. taxill custName Ahmad Bin Abdullah Fatimah Binti Adam LAI LA2 Ruqayya Binti Idris Sulaiman Bin Daud LA3 LA4 startDate 01/10/2019 05/10/2019 05/10/2019 15/10/2019 20/10/2019 27/10/2019 02/11/2019 taxiType endDate 03/10/2019 12/10/2019 08/10/2019 17/10/2019 25/10/2019 Sedan Sedan Van Van 30/10/2019 04/11/2019 cust Phoneno TAXI Taxi table is composed of taxi…
drop table Parents_Children;drop table Persons; create table Persons (name varchar(64) primary key,gender char(1) not null); create table Parents_Children (parent varchar(64),child varchar(64),primary key (parent, child),foreign key (parent) references Persons(name),foreign key (child) references Persons(name)); insert into Persons (name, gender) values ('Ann', 'F');insert into Persons (name, gender) values ('Bob', 'M');insert into Persons (name, gender) values ('Cory', 'M');insert into Persons (name, gender) values ('Dave', 'M');insert into Persons (name, gender) values ('Emma', 'F');insert into Persons (name, gender) values ('Fred', 'M');insert into Persons (name, gender) values ('Gab', 'Q');insert into Persons (name, gender) values ('Hil', 'F');insert into Persons (name, gender) values ('Ian', 'M'); insert into Parents_Children (parent, child) values ('Ann', 'Bob');insert into Parents_Children (parent, child) values ('Ann', 'Cory');insert into Parents_Children (parent, child) values…
SQL Table: CREATE TABLE employees ( employee_id INT PRIMARY KEY, first_name VARCHAR(255), last_name VARCHAR(255), email VARCHAR(255) UNIQUE, phone_number VARCHAR(255), hire_date DATE, job_id VARCHAR(255), salary DECIMAL(10,2), commission_pct DECIMAL(5,2), manager_id INT, department_id INT, FOREIGN KEY (manager_id) REFERENCES employees(employee_id), FOREIGN KEY (department_id) REFERENCES departments(department_id)); CREATE TABLE departments ( department_id INT PRIMARY KEY, department_name VARCHAR(255), manager_id INT, FOREIGN KEY (manager_id) REFERENCES employees(employee_id)); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id)VALUES (1, 'John', 'Doe', 'john.doe@example.com', '555-555-5555', '2022-01-01', 'IT_PROG', 8000, 0.2, 3, 10), (2, 'Jane', 'Smith', 'jane.smith@example.com', '555-555-5556', '2022-02-01', 'IT_PROG', 9000,…
MySQL CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...6. Find the last name of all employees that were not hired on Tuesday *hint: (UseDATE_FORMAT() function amd the format you need is %W, also use UPPER()7. Find the number of employees in each department who have a manager.8. Find the number of employees for each manager whose employees' minimum salary is greaterthan 5000.9. Find the number of…
CREATE TABLE Users( C_Id varchar(8) NOT NULL, LastName Varchar(255) NOT NULL, FirstName varchar(255) NOT NULL, ema il varchar(255), Phone int, PRIMARY KÉY (C_Id) CREATE TABLE Restaurants( R_Id varchar(255) NOT NULL, Rname varchar(255) NOT NULL, Type varchar(255), Raddress varchar(255), Rphone int, Remail varchar(255), PRIMARY KEY(R_Id) ); CREATE TABLE RDate( T_num int NOT NULL, Bdate DATE, Rdate DATE, T_start varchar(255), E_start varchar(255), PRIMARY KEY(T_num) ); CREATE TABLE Book ingInfo( C_Id varchar(8) NOT NULL, R_Id int NOT NÚLL, PRIMARY KEY(C_Id, R_Id), FOREIGN KEY (C_Ià) REFERENCES Users(C Id), FOREIGN KEY (R_Id) REFERENCES Restaurant(R_Id) ); CREATE TABLE Rating( R_Id varchar(255) NÓT NULL, Rating Id varchar(255) NOT NULL, Rate varchar(255) CHECK (Rate>11), Comment LONG, PRIMARY KEY(Rating Id), FOREIGN KEY (R_Id) REFERENCES Restaurants(R_Id) ); Create 1 procedure Create 1 function Create 1 database trigger |
Write the DDL CREATE statement that can be used to create the following table based on the given schema: Class (class_code, course_code, class_section, class_room ) Note: The example of the data record of the Course table is (10012, "ACCT-211",1, "KLR 225") class_code is the primary key of the Course table course_code is the foreign key from the Course table
Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Answer in MYSQL please
Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. SQL DataBase Test: Create a new table to store maintenance operations Test Query: DESCRIBE MAINTENANCES Expected Results Field Type Null Key Default Extra CAR_ID char(5) NO PRI NULL MAINTENANCE_TYPE_ID char(5) NO PRI NULL MAINTENANCE_DUE date NO PRI NULL
1-Write the syntax to insert into a relational table called students the address column references an object table called addresses that was created using an address_type. Other columns exist in the students table, but you are only inserting into the ones below. Aliases used should be the first letter of the table name, eg students would be s, addresses would be a Relational Table Name students attribute student_id attribute surname attribute address
Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Create a new table to store maintenance operations Test Query DESCRIBE MAINTENANCES Expected Results Field Type Null Key Default Extra CAR_ID char(5) NO PRI NULL MAINTENANCE_TYPE_ID char(5) NO PRI NULL MAINTENANCE_DUE date NO PRI NULL
SQL: THIS IS FIRST TABLE : create table emp ( eid number(7), fname char(20), lname char(20), salary number, primary key (eid) ); insert into emp values (1111111, 'ali', 'ahmed', 3500); insert into emp values(2222222, 'asma', 'dani', 2000); insert into emp values(3333333, 'hassan', 'ali', 4500); insert into emp values(4444444, 'khaled', 'shaalan',6000); insert into emp values(5555555, 'farhad', 'kokol', 7500); insert into emp values(6666666, 'amir', 'sheikh', 10000); insert into emp values(7777777, 'rahul', 'kolap', 11000); insert into emp values(8888888, 'halim', 'ziaey', 21000); insert into emp values(9999999, 'henna', 'bubaker', 30000); THIS IS SECOND TABLE : create table students ( sid number, fname char(20), lname char(20), avg number, age number, primary key (sid) ); insert into students values (1111111, 'ali', 'ahmed', 76, 21); insert into students values(2222222, 'asma', 'dani', 89, 20); insert into students values(3333333, 'hassan', 'ali', 67, 23); insert into…