Week03_HW3_Chapter3_Review_Ques (3)

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

104

Subject

Information Systems

Date

Dec 6, 2023

Type

docx

Pages

Uploaded by ProfPuppy14029

Chapter 3 The Relational Database Model NAME: HOMEWORK REVIEW QUESTIONS: 1-8 1. What does it mean to say that a database displays both entity integrity and referential integrity? Entity integrity : Referential integrity : 2. What are the requirements that two relations must satisfy in order to be considered union- compatible? 3. Which relational algebra operators can be applied to a pair of tables that are not union- compatible? Use the Vending Company database shown to answer Problems 4-8. 42

Chapter 3 The Relational Database Model 4. Write the relational algebra formula to apply a UNION relational operator to the tables shown. 5. Create the table that results from applying a UNION relational operator to the tables shown. 6. Write the relational algebra formula to apply an INTERSECT relational operator to the tables shown. 7. Create the table that results from applying an INTERSECT relational operator to the tables shown. 8. Using the tables, create the table that results from MACHINE DIFFERENCE BOOTH. 43

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Week03_HW3_Chapter3_Review_Ques (3)

Related Documents