Answered: Find out the customers with balance of…

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

Find out the customers with balance of $3500 or more. Your result should include the most recent invoice number, customer code and customer name.

Transcribed Image Text:This image displays an Entity-Relationship Diagram (ERD) for a business database system comprising nine main entities: department, employee, salary_history, line, product, brand, invoice, customer, vendor, and supplies. Each entity contains specific attributes, and the relationships between them are depicted with connecting lines. Here's a detailed explanation of the components: ### Entities and Attributes: 1. **Department** - DEPT_NUM: Numeric identifier for the department (DECIMAL(5,0)) - DEPT_NAME: Name of the department (VARCHAR(50)) - DEPT_MAIL_BOX: Mailbox identifier (VARCHAR(3)) - DEPT_PHONE: Phone number, allows nulls (VARCHAR(9)) - EMP_NUM: Employee number, allows nulls (DECIMAL(6,0)) 2. **Employee** - EMP_NUM: Employee number (DECIMAL(6,0)) - EMP_FNAME: First name (VARCHAR(20)) - EMP_LNAME: Last name (VARCHAR(25)) - EMP_EMAIL: Email address (VARCHAR(25)) - EMP_PHONE: Phone number (VARCHAR(20)) - EMP_HIREDATE: Hiring date (DATE) - EMP_TITLE: Job title (VARCHAR(4)) - EMP_COMM: Commission rate (DECIMAL(2,2)) - DEPT_NUM: Department number (DECIMAL(5,0)) 3. **Salary History** - EMP_NUM: Employee number (DECIMAL(6,0)) - SAL_FROM_DATE: Start date (DATE) - SAL_END_DATE: End date (DATE) - SAL_AMOUNT: Salary amount (DECIMAL(10,2)) 4. **Line** - INV_NUM: Invoice number (DECIMAL(38,0)) - LINE_NUM: Line number (DECIMAL(10,0)) - PROD_SKU: Product SKU (VARCHAR(15)) - LINE_QTY: Quantity (DECIMAL(3,0)) - LINE_PRICE: Price (DECIMAL(6,2)) 5. **Product** - PROD_SKU: Product SKU (VARCHAR(15)) - PROD_DESCRIPT: Product description (VARCHAR(255)) - PROD_TYPE: Product type (VARCHAR(12)) - PROD_BASE: Base price (DECIMAL(6,2)) - PROD_CATEGORY: Category (VARCHAR(15)) - PROD_PRICE: Price

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

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