To access the database 1 Launch the MySQL Commnd Line Client executable or MYSQL Workbench 2 Login in using the password set during installation "cgs254518 Tasks Description 1 Alter table employees to zdd columna 2 reportsTo, integar, not null, foreign key to the primary key of table employees and will on update cascade and on delete cascade b. officelD, integar, not null, foreign key to the primary key of table offices and will on update cascade znd on delete c2sczde Alter table customers to add column asalesRepEmployeelD, integer, not null, foreign key to the primary key of table emplovees and will on update cascade and on delete cascade 2 3 Alter table orders to add column 2 customerID, integer, not null, foreign key to the primary key of table customers and will on update cascade and on delete cescade 4 Alter table products to add column a productLineID, integer, znot null, foreign key to the primary key of table productLines and will on update cesczde and on delete cascade

To access the database 1 Launch the MySQL Commnd Line Client executable or MYSQL Workbench 2 Login in using the password set during installation "cgs254518 Tasks Description 1 Alter table employees to zdd columna 2 reportsTo, integar, not null, foreign key to the primary key of table employees and will on update cascade and on delete cascade b. officelD, integar, not null, foreign key to the primary key of table offices and will on update cascade znd on delete c2sczde Alter table customers to add column asalesRepEmployeelD, integer, not null, foreign key to the primary key of table emplovees and will on update cascade and on delete cascade 2 3 Alter table orders to add column 2 customerID, integer, not null, foreign key to the primary key of table customers and will on update cascade and on delete cescade 4 Alter table products to add column a productLineID, integer, znot null, foreign key to the primary key of table productLines and will on update cesczde and on delete cascade

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

How can you create an empty table from an existing table in sql?
In SQL, Pooja established a table called 'bank.' She later discovered that the table should have included another column. To add a column to a table, what command is used?
Write an anonymous PL/SQL block that examines the system date and responds to the console window whether it is a Weekend (i.e. Saturday or Sunday) or a Weekday
Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: ) PROCEDURE: Use the cust_node table to create a procedure called ‘Get_node_id’ that takes the cust_idas an input parameter to show its corresponding node id to the banker. Then execute this procedure withcust_id=5.
What is the use of notation in the illustrative SQL commands?
#below is the SQL Script: You can copy and paste to run create database pharmacy; use pharmacy; create table branch (id int (3) not null auto_increment primary key, name varchar (50) not null); create table transaction_type (id int (1) not null auto_increment primary key, type varchar (15) not null); create table network (id int (2) not null auto_increment primary key, name varchar (30) not null) ; create table worker (id int (3) zerofill not null auto_increment primary key, fname varchar (30) not null, Iname varchar (30) not null, contact varchar (13) not null); create table worker_branch (worker_id int (3) not null references worker (id), branch_id int (3) not null references branch (id), primary key (worker_id,branch_id)); create table transaction (id int not null auto increment primary key, worker id int (3) not null references worker (id), branch_id int (3) not null, customer_no varchar (13) not null, customer_id int (25)); You have been tasked to use the SQL script provided above…
How do you write a single quote as part of a string in SQL?
How do we run a query for SQL table using a staging schema for the fact table planfactsupply
In what scenarios can the UNPIVOT function be beneficial for data transformations in SQL?
In a database, Write SQL query to show table structure of table name Guardians.
What method of Statement is used if you want to execute DELETE SQL statement?
pls help me SQL Instructions: Answers ALL the questions. This test contributes 5% to your coursework. Use the following Table to write the queries. Emp_Infor Table EmpID EmpFname EmpLname Department Salary 1 Mohd Ali HR 2000 Admin Account 2 3 4 5 Azizah Chen Ananthi Manjit Suliman Kang Kulkarni Sidhu HR Admin Address Kuantan Ipoh 1800 8000 DOB 01/12/1977 02/05/1975 3500 5000 Kuala Lumpur 01/01/1984 Georgetown 02/05/1995 Kangar 03/07/1998 1. Write the query to display all the records in the Emp_Infor table. Gender MFMFM 2. Write a query to display the number of employees working in the department 'HR'.