Given relation R with attributes: SSN, FName, LName, Salary, State. Use relation

Question

Given relation R with attributes: SSN, FName, LName, Salary, State. Use relational algebra operators to: write a project statement that gives all of the first and last names write a select statement that shows all the name attributes of all people under 21 write a statement that shows the SSN of all the people with a salary greater than or equal to 100,000 OR live in New York Extra credit: Can a primary key be determined by the data alone? Why or why not? What steps are necessary to determine the primary key?

Explanation / Answer

1. FName,LName (R)

2. Age <21(R)

3. SSN (Salary >= 100000 or State = "New York" (R))

primary key is determined by the data and other factors also.

The data factors are:

Other factors

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.