Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This exercise is from my Discrete Mathematic Class under Chapter 5 Relations and Database EXERCISES 5.3 Exercises 1-4 refer to the Person, Pet, and Petowner
This exercise is from my Discrete Mathematic Class under Chapter 5 "Relations and Database"
EXERCISES 5.3 Exercises 1-4 refer to the Person, Pet, and Petowner relations of Examples 20 and 22 1. Consider the following operation: Restrict Pet where PetType "Cat" giving Kitties a. Write a query in English that would result in the information contained in Kitties. b. What is the cardinality of the relation obtained by performing this operation? c. Write an SQL query to obtain this information. 2. Consider the following operation: Project Person over (Name, City, State) giving Census a. Write a query in English that would result in the information contained in Census. b. What is the degree of the relation obtained by performing this operation? c. Write an SQL query to obtain this informationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started