SQL3 questions.pdf - Databases - Relational Algebra and SQL...

This preview shows page 1 - 4 out of 6 pages.

Databases - Relational Algebra and SQL 3Jianxin LiSchool of Computer Science & Software EngineeringUniversity of Western AustraliaJianxin Li (UWA)Lab 41 / 6
We have textbook solutions for you!
/Database-Systems-Design-Implementation-Management-13th-Edition-9781337627900-625/
The document you are viewing contains questions related to this textbook.
Chapter 13 / Exercise 7
Database Systems: Design, Implementation, & Management
Coronel/Morris
Expert Verified
Relational AlgebraSome of the answers will require you to type relational algebra expressionssuch asπid(σ(a>10)((R./S)×T))(1)To write these in text, do the followingUse the words rho, pi and sigma forρ,πandσUse an underscore for subscriptsUse the word bowtie for./and the letter x for×So you will type: pi_id(sigma_(a>10) ((R bowtie S) x T))Jianxin Li (UWA)Lab 42 / 6
Relational AlgebraThe first few questions will use a student, unit, grade database similar to theone from lectures, but where the tables are called S (for student), U (for unit)and G (for grade) and have the following schema:S(sid, name, gender)U(uid, name)G(sid, uid, grade)Students have a unique id, a name and a gender (either M or F) , Units have anunique id (like CITS1402) and a name (like Databases), while Grades indicatewhat grade the student with id sid achieved when they took the unit with iduid.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 6 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
One
Professor
N/A
Tags
Relational Database, Relational model, Jianxin Li
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Database Systems: Design, Implementation, & Management
The document you are viewing contains questions related to this textbook.
Chapter 13 / Exercise 7
Database Systems: Design, Implementation, & Management
Coronel/Morris
Expert Verified

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture