Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 10RQ
Program Plan Intro
Subtype:
- Subtype is one type of entity which inherits the attributes from a different entity.
- The subtype relationship is a grouping of entities type in single entity that shares the common attributes or relationships which are different from other grouping.
- It is related to an entity supertype where the supertype entity has common characteristics and the subtype entity has the unique characteristics of each entity subtype.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Explain sIze of the fact taBle?
How do I combine these two SQL statements into one?SELECT * FROM products WHERE title REGEXP '^[A-Za-z]{4,}$';SELECT price, price*0.75 as sale_price FROM products;
Answer number 10,12 and 13
Write the SQL statement to generate the report the following
1. Generate a report for all employees in Ascending order
2. Generate a report for all employees in Descending order
3. Generate a report for all employees in Ascending order with their assigned offices
4. Generate a report for all employees in Descending order with their assigned offices
5. Generate a report on customers
6. Generate a report on all customers and assigned sales reps
7. List all payments within a specified time frame of your choice
8. List all the sum total of all products orders.
9. Fetch the highest paying customer.
10. Fetch the highest paying employee
11. Fetch the highest paying product
12. Fetch all orders with complaints
13. Create a report on the total profits of the following offices
a. NYC
b. London
c. Paris
d. Tokyo
14. Fetch the lowest paying customer.
15. Fetch the lowest paying employee
16. Fetch the lowest paying product
Chapter 5 Solutions
Database Systems: Design, Implementation, & Management
Ch. 5 - Prob. 1RQCh. 5 - What kinds of data would you store in an entity...Ch. 5 - Prob. 3RQCh. 5 - What is a subtype discriminator? Give an example...Ch. 5 - Prob. 5RQCh. 5 - What is a disjoint subtype? Give an example.Ch. 5 - What is the difference between partial...Ch. 5 - Prob. 8RQCh. 5 - According to the data model, is it required that...Ch. 5 - Prob. 10RQ
Ch. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - Prob. 14RQCh. 5 - When implementing a 1:1 relationship, where should...Ch. 5 - What is time-variant data, and how would you deal...Ch. 5 - Prob. 17RQCh. 5 - Prob. 1PCh. 5 - Prob. 2PCh. 5 - Prob. 3PCh. 5 - Prob. 4PCh. 5 - Prob. 5PCh. 5 - Prob. 6PCh. 5 - Prob. 7PCh. 5 - Prob. 8CCh. 5 - Prob. 9CCh. 5 - Prob. 10C
Knowledge Booster
Similar questions
- Define second normal form. What types of problems might you encounter using tables that are not in second normal form?arrow_forwardHow is the processing of SQL DDL statements (such as CREATE TABLE) different from the processing required by DML statements?arrow_forwardWrite an SQL statement that will delete rows where the selling price is greater than 25 in the Stock table.arrow_forward
- Define fourth normal form. What types of problems would you find in tables that are not in fourth normal form?arrow_forwardhow to construct a table in excelarrow_forwardWrite the SQL statement to generate the report the following 7. List all payments within a specified time frame of your choice 8. List all the sum total of all products orders. 9. Fetch the highest paying customer.arrow_forward
- - Create SQL statement (JOIN) to display a list with salesman name, customer name and their cities for the salesmen and customer who belongs to the same city. (Use the JOIN statement))arrow_forwardWrite a SQL statement that returns a list of the team members with all their tasks. Include the team member’s name and the description of the task in the results.arrow_forwardWhen you are getting rid of rows, columns, and tables, what is the one thing you need to keep in mind that is most important?arrow_forward
- Give an example of a SQL statement that uses the DUAL table and explain what it does. Please be as detailed as possible. Thank you in advance!arrow_forwardWhen getting rid of rows, columns, and tables, what is the one thing that you absolutely must keep in mind at all times?arrow_forwardanswer with proper explanation and step by step solution. write a create table statement for this table and insert the statmentsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr