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…

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 14MC: A unique identifier for a data row that consists of more than one field is commonly called...

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.

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning