Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 7, Problem 7.44PAE
Program Plan Intro
SQL query and its Venn diagram listingthe names of each employee, his birth date, name of his manager, and manager’s birth date for those employees who were born before their manager was born.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The Entity Relationship Data Model (Identify the primary key and the foreign key) Represent the different join(inner join, outer joins). Upload the diagram and result of your design query of joins. by using SQL applications
1. Design an Entity Relationship Diagram for the system above. 2. Write query that would return the names and contacts of all Local students. 3. Write a query that would return names, contact and locations of all departments that has a location text with Ave 3 as part of it. [hint: use the LIKE clause with “_” or “%”] 4. What would be the result returned for the following query: SELECT first_name, last_name, student_type.name, student_category.name FROM student, student_type, student_category WHERE stud_type_id = student_type.id AND stud_cat_id = student_category.id AND student_type.name = “Sandwich”; 5. Write a query that would present the first and last names, student type and category of all distance students. 6. What would be the result of the following query: SELECT student.id, first_name, last_name, contact, registration_type.name, course.code FROM student, registration, registration_type, course WHERE student.id = stud_id AND reg_type_id = registration_type.id AND…
write the sql queries for the following er diagram:
Create all the tables and relationships (including all primary keys, foreign keys, attributes and appropriate data types) shown in the ER diagram above.and Insert 3 records into each table. In the Item table, consider the first record as your favorite dress, second record as a gift that you have recently bought to someone, and the third record as your most favorite accessory that you are currently using; then insert the appropriate data. Similarly, insert some valid data into the other three tables. and Write an SQL statement to update the third row of Item table: Item_Name as ‘Hat’, Brand as ‘Puma’, and Type as ‘Ferrari’. and Write an SQL statement to display the Branch_ID, Location_ID, Item_ID, Units_Sold and Dollars_Sold of each customer. Results should be in a descending order of Item_ID.and also Write an SQL statement that displays the number of items, the sum of units_Sold and the sum of dollars_sold in each location. (Hint: Use…
Chapter 7 Solutions
Modern Database Management (12th Edition)
Ch. 7 - Prob. 7.1RQCh. 7 - Prob. 7.2RQCh. 7 - Prob. 7.3RQCh. 7 - Prob. 7.4RQCh. 7 - Prob. 7.5RQCh. 7 - Explain the relationship between EXISTS and...Ch. 7 - Prob. 7.7RQCh. 7 - Prob. 7.8RQCh. 7 - Prob. 7.9RQCh. 7 - Prob. 7.10RQ
Ch. 7 - Under what conditions can a UNION clause be used?Ch. 7 - Prob. 7.12RQCh. 7 - Prob. 7.13RQCh. 7 - List for advantages of SQL-invoked routines.Ch. 7 - Prob. 7.15RQCh. 7 - Prob. 7.16RQCh. 7 - Prob. 7.17RQCh. 7 - Prob. 7.18RQCh. 7 - Prob. 7.19RQCh. 7 - Prob. 7.20RQCh. 7 - Prob. 7.21RQCh. 7 - Prob. 7.22RQCh. 7 - Prob. 7.23RQCh. 7 - This chapter discusses the data dictionary views...Ch. 7 - Prob. 7.25PAECh. 7 - Prob. 7.26PAECh. 7 - Prob. 7.27PAECh. 7 - Are based on the class schedule 3NF relations...Ch. 7 - Prob. 7.29PAECh. 7 - Prob. 7.30PAECh. 7 - Prob. 7.31PAECh. 7 - Are based on Figure 7-17. This problem set...Ch. 7 - Prob. 7.33PAECh. 7 - Prob. 7.34PAECh. 7 - Prob. 7.35PAECh. 7 - Prob. 7.36PAECh. 7 - Prob. 7.37PAECh. 7 - Prob. 7.38PAECh. 7 - Prob. 7.39PAECh. 7 - Prob. 7.40PAECh. 7 - Prob. 7.41PAECh. 7 - Prob. 7.42PAECh. 7 - Prob. 7.43PAECh. 7 - Prob. 7.44PAECh. 7 - Write an SQL query to display the order number,...Ch. 7 - Prob. 7.46PAECh. 7 - Prob. 7.47PAECh. 7 - Prob. 7.48PAECh. 7 - Prob. 7.49PAECh. 7 - Prob. 7.50PAECh. 7 - Write an SQL query to list each customer who...Ch. 7 - Prob. 7.52PAECh. 7 - Modify Problem and Exercise 6-60 so that the list...Ch. 7 - Prob. 7.54PAECh. 7 - Prob. 7.55PAECh. 7 - Prob. 7.56PAECh. 7 - Prob. 7.57PAECh. 7 - Prob. 7.58PAECh. 7 - Prob. 7.59PAECh. 7 - Prob. 7.60PAECh. 7 - Prob. 7.61PAECh. 7 - Prob. 7.62PAECh. 7 - Prob. 7.63PAECh. 7 - Rewrite your answer to Problem and Exercise 6-71...Ch. 7 - Display the customer ID, name, and order ID for...Ch. 7 - Prob. 7.66PAECh. 7 - Prob. 7.67PAECh. 7 - Prob. 7.68PAECh. 7 - Prob. 7.69PAECh. 7 - Prob. 7.70PAECh. 7 - Prob. 7.71PAECh. 7 - Write an SQL query to list the order number,...Ch. 7 - Prob. 7.73PAECh. 7 - Prob. 7.74PAECh. 7 - Prob. 7.75PAECh. 7 - Prob. 7.76PAE
Knowledge Booster
Similar questions
- When part of the data in a table depends on a field in the table that isn’t the table’s primary key, it’s known as: transitive dependency partial dependency psychological dependency a foreign keyarrow_forwardDefine second normal form. What types of problems might you encounter using tables that are not in second normal form?arrow_forwardGiven the employee information in Question 11, list the query output for the INTERSECT query.arrow_forward
- Please Create an SQL query for the following scenario, not an ERD Diagram! Please and Thank You!arrow_forwardQ1) Draw the Relational Schema for the relationship(s) between EMPLOYEE and STORE.arrow_forwardWhen considering creating a join between two tables, how are we demonstrating the concept of "relational" databases? Why is it essential to create the join by finding a unique, unique attribute in at least one table and looking at situations where that attribute has the same value ( is equal ) in both tables?arrow_forward
- Please follow this ER diagram, give a description, and make a schema diagram from it. Also, make database (constraint tables) & intent some sample data. Lastly, run some SQL functions code. Please don't copy from anywhere. I need it for my project.arrow_forwardWhen an attribute is part of a composite primary key, it is also considered a candidate key for the table.arrow_forwardWrite the SQL statements to create all of the necessary tables to represent the above diagram, representing as many constraints as possible. Note: you do not need to worry about specifying types for the fields, but you do need to provide suitable foreign key option(s). When playing a game, the home team name should be stored in attribute htname and the away team name should be stored in atname.arrow_forward
- Using SQL data definition language, write the SQL statements to change each of the following relations according to the suggestions given below.i. customer (customer id, customer name, street, city)Suggestion: Remove customer name and add lname, fname and initial.ii. account (account number, customer id, branch id, balance)Suggestion: Add a foreign key constraints for customer id and branch id, referencing customer and branch tables.iii. branch(branch id, branch name, branch city, assets)Suggestion: Add the not null constraint to branch name and branch city.arrow_forwardWhen considering creating a join between two tables, how are we demonstrating the concept of "relational" databases? Why is it essential that we create the join by finding a common attribute that is unique in at least one table and look at situations where that attribute has the same value ( is equal ) in both tables?arrow_forwardUsing your knowledge of the college environment, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form. Do not create a diagram of the tables. Instead use the symbolism like that found in the textbook when showing functional dependencies. (StudentNum, StudentName, NumCredits, AdvisorNum, AdvisorName, DeptNum, DeptName, CourseNum, Description, Term, Grade)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
- 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
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
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