https://sqliteonline.com/ : Program linkThe first requirement: Using the SQL language, transform the following entity model into tables in the database. Entity Manger contains:M-name The name of the manager.M-ID and manager number.The department entity contains:D-name The name of the department.D-ID and department number.Create constraint master key name of the manager when creating the Manger table.Creating the foreign key constraint The name of the manager when creating the Department table.The second requirement: After creating the tables and specifying the primary and foreign key, do the following:* Add a column D_loc to the Department table, specifying the type of column.* Remove the column named M_name from the Manger table* Change the name of the department table to Dep Please::******* ATTACH A PICTURE OF THE CODES USED AND PICTURE OF THE PROGRAM SCREEN ******* D_nameD_IDM_IDM_name11DepartmentMangerMANGE

Answered: Image /qna-images/answer/4e4b47f7-e115-47f8-bb6e-74128117284e.jpg

Answered: The first requirement: Using the SQL…

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

Concept explainers

Question

https://sqliteonline.com/ : Program link

The first requirement: Using the SQL language, transform the following entity model into tables in the database.

Entity Manger contains:

M-name The name of the manager.
M-ID and manager number.The department entity contains:
D-name The name of the department.
D-ID and department number.

Create constraint master key name of the manager when creating the Manger table.
Creating the foreign key constraint The name of the manager when creating the Department table.

The second requirement: After creating the tables and specifying the primary and foreign key, do the following:

* Add a column D_loc to the Department table, specifying the type of column.
* Remove the column named M_name from the Manger table
* Change the name of the department table to Dep

Please::

******* ATTACH A PICTURE OF THE CODES USED AND PICTURE OF THE PROGRAM SCREEN *******

D_name
D_ID
M_ID
M_name
1
1
Department
Manger
MANGE

Expert Solution

Step by step

Solved in 2 steps with 6 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