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

Related questions

Q: Given a table students in SQL. Write a SQL query to add a column Address Varchar(30) in the student…

A: Given Table: students We have to add a new column Address Varchar(30) to the given table students.…

Q: in pl /sql the commend is like this create table bb_basketstatus (idstatus number, idbasket…

A: The answer for the given question is as follows.

Q: What happens if you leave the parameter for a key partition empty (in SQL)?

A: key partition is empty in sql answer for is above step

Q: Program language: SQLite Table syntax: CREATE TABLE Author( aid INTEGER PRIMARY KEY, name TEXT NOT…

A: The tables are created as in the question. I am updating the table Author with an attribute email.…

Q: How does the COALESCE function compare with the ISNULL function when handling NULL values in SQL

A: The COALESCE and ISNULL functions are both used to handle NULL values in SQL. However, they have…

Q: How can the OVER clause enhance the flexibility of window functions in SQL?

A: Window functions in SQL enable users to carry out calculations across a set of table rows related to…

Q: A trigger is procedural SQL code that is manually invoked by the RDBMS upon the occurrence of a…

A: Trigger in SQL A trigger is a particular class of stored procedure that starts running…

Q: In SQL, write the appropriate statements to insert default values for these three tables, each table…

A: Prescription table: INSERT INTO prescription (pre_no,pre_date,pre_amount)VALUES (10,12,1200); INSERT…

Q: In SQL Code: Write code snippet to show how value from Bind Variable can be passed to a PL/SQL…

Q: Define Trigger and write a PL/SQL code for creating a trigger that can be triggered when the table…

A: We will talk about PL/SQL triggers in this chapter. Triggers are stored programmes that are launched…

Q: How does the STUFF function help in manipulating string data in SQL?

A: The STUFF function in SQL is used to manipulate string data by inserting, replacing, or deleting…

Q: n sql, an associate array is a table that is associated with a / an

A: Associate array in SQL An associative array, also known as an index-by table, is said to be a set…

Q: Write the T-SQL scripts for the following tasks: Write a query to list the employees whose email is…

A: SELECT * FROM EMPLOYEES WHERE EMP_MAIL LIKE '%gmail.com';

Q: In SQL Server, character data types may be distinguished as follows: NVARCHAR, NVARCHAR, and…

A: Introduction: A SQL developer must choose what information will be kept in each column before…

Q: n sql An index can increase the performance of SQL queries that search large tables Select one: a.…

A: Indexes in Oracle and different knowledge bases area unit objects that store references to data in…

Q: What is aliasing in table joins in SQL and their types?

A: Answer is

Q: What advantages does the ISNULL function offer when dealing with missing data in SQL?

A: In the database management , handling NULL values is a challenge that SQL developers encounter…

Concept explainers

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.

Question

In sql, how do you start adding a column to a table and allow it to update cascadae and 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

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

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

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.
In what scenarios can the UNPIVOT function be beneficial for data transformations in SQL?
INFO 2303 Database Programming Assignment : PL/SQL Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family Practice Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’. You should get no rows.
In SQL code: Create a PL/SQL block to retrieve the name of each employee from the EMPLOYEE table and print the first initial of each name on the screen, incorporating an INDEX BY table.
Write a PL/SQL Programming block to do below actions 2.Before you work on Quesiton 2 , please create a table because you will be inserting numbers in thisMessages tableCREATE TABLE messages( RESULTS NUMBER)Run below query to see if there is any data :SELECT * FROM MESSAGES
What is the maximum number of columns you can define as a primary key when using the column-level approach to creating a table? ( refer to the tables in the JustLee Books database). a. 0 b. 1 c. 30 d. 255
In SQL is this a true or false statement: The DUAL table can be queried and updated.
Create a Pl SQL package named EMP_PKG which will have the above three functions and procedures as follows: CALC_TAX - private CHECK_FNAME - Public AVG_SAL - Public
In SQL With partial dependencies, data redundancies occur because every row entry requires duplication of data. Select one: a. True b. False