Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Write a query to display the eight departments in the LGDEPARTMENT table sorted by department name

Write a query to display the eight departments in the LGDEPARTMENT table sorted by department name

Database System Concepts
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
icon
Related questions
Question

Write a query to display the eight departments in the LGDEPARTMENT table sorted by department name.

## Figure P7.27: The CH07_LargeCo ERD ### Entity-Relationship Diagram (ERD) Breakdown This ERD represents the data model for a company database, capturing key entities and their relationships. The primary key (PK) fields are underlined in each table. 1. **LGCUSTOMER** - **PK**: Cust_Code - **Attributes**: - Cust_Fname - Cust_Lname - Cust_Street - Cust_City - Cust_State - Cust_ZIP - Cust_Balance - **Relationship**: Places orders (links to LGINVOICE) 2. **LGINVOICE** - **PK**: Inv_Num - **FKs**: - Cust_Code (from LGCUSTOMER) - Employee_ID (from LGEMPLOYEE) - **Attributes**: - Inv_Date - Inv_Total - **Relationships**: Contains lines (links to LGLINE) and is completed by employees (links to LGEMPLOYEE) 3. **LGEMPLOYEE** - **PK**: Emp_Num - **FK**: Dept_Num (from LGDEPARTMENT) - **Attributes**: - Emp_Fname - Emp_Lname - Emp_Email - Emp_Phone - Emp_Hiredate - Emp_Title - Emp_Comm - **Relationships**: Manages departments (links to LGDEPARTMENT) and has salary histories (links to LGSALARY_HISTORY) 4. **LGSALARY_HISTORY** - **PK, FK**: Emp_Num - **Attributes**: - Sal_From - Sal_End - Sal_Amount 5. **LGDEPARTMENT** - **PK**: Dept_Num - **FK**: Emp_Num (from LGEMPLOYEE) - **Attributes**: - Dept_Name - Dept_Mail_Box - Dept_Phone - **Relationship**: Employs employees (links to LGEMPLOYEE) 6. **LGLINE** - **PK**: Inv_Num, Line_Num - **FK**: Prod_SKU (from LGPRODUCT) - **Attributes**: - Line_Qty - Line_Price
Transcribed Image Text:## Figure P7.27: The CH07_LargeCo ERD ### Entity-Relationship Diagram (ERD) Breakdown This ERD represents the data model for a company database, capturing key entities and their relationships. The primary key (PK) fields are underlined in each table. 1. **LGCUSTOMER** - **PK**: Cust_Code - **Attributes**: - Cust_Fname - Cust_Lname - Cust_Street - Cust_City - Cust_State - Cust_ZIP - Cust_Balance - **Relationship**: Places orders (links to LGINVOICE) 2. **LGINVOICE** - **PK**: Inv_Num - **FKs**: - Cust_Code (from LGCUSTOMER) - Employee_ID (from LGEMPLOYEE) - **Attributes**: - Inv_Date - Inv_Total - **Relationships**: Contains lines (links to LGLINE) and is completed by employees (links to LGEMPLOYEE) 3. **LGEMPLOYEE** - **PK**: Emp_Num - **FK**: Dept_Num (from LGDEPARTMENT) - **Attributes**: - Emp_Fname - Emp_Lname - Emp_Email - Emp_Phone - Emp_Hiredate - Emp_Title - Emp_Comm - **Relationships**: Manages departments (links to LGDEPARTMENT) and has salary histories (links to LGSALARY_HISTORY) 4. **LGSALARY_HISTORY** - **PK, FK**: Emp_Num - **Attributes**: - Sal_From - Sal_End - Sal_Amount 5. **LGDEPARTMENT** - **PK**: Dept_Num - **FK**: Emp_Num (from LGEMPLOYEE) - **Attributes**: - Dept_Name - Dept_Mail_Box - Dept_Phone - **Relationship**: Employs employees (links to LGEMPLOYEE) 6. **LGLINE** - **PK**: Inv_Num, Line_Num - **FK**: Prod_SKU (from LGPRODUCT) - **Attributes**: - Line_Qty - Line_Price
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Single Table
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
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS