Relational algebra help?!

Posted by Tom on Stack Overflow See other posts from Stack Overflow or by Tom
Published on 2011-01-12T23:49:06Z Indexed on 2011/01/12 23:53 UTC
Read the original article Hit count: 296

Filed under:

homework

|

relational-algebra

im new to relational algebra and finding it difficult. Ive answered a few questions, however they where relatively simple. Could do with help with these though.

Database
Patient (PatientCode, PatientSurname, PatientFirstname, PatientSex, PatientAge, PatientOccupation, PatientHeight, PatientWeight, PatientAddress) 

Doctor (DoctorCode, DoctorSurName,  DoctorFirstName, DoctorPrivateAddress, MobileNo, Doctor Specilisim) 

Operation (Operation Code, PatientCode, DoctorCode, Date, Time, Result, OperationType) 

Is_Seen_By (PatientCode, DoctorCode, Date, Time).

Q1. Find the surname and gender of the patients that have been operated on by doctor "DR333" and results have not been successful.

Q2. Find the code of the operations that have been done on the 18th of November 2010 and have been successful, please also list the name of the doctors which were involved with the operation.

© Stack Overflow or respective owner

Related posts about homework

parsing a list and producing a structure of that

as seen on Stack Overflow - Search for 'Stack Overflow'
;; structure representing homework points ;; nr: number - the number of the homework ;; points: number - the number of points reached (define-struct homework (nr points)) ;; parse-homework: (list of number pairs) -> (list of homework) ;; The procedure takes a list of number pairs and produces… >>> More
Scheme homework help

as seen on Stack Overflow - Search for 'Stack Overflow'
Okay so I have started a new language in class. We are learning Scheme and i'm not sure on how to do it. When I say learning a new language, I mean thrown a homework and told to figure it out. A couple of them have got me stumped. My first problem is: Write a Scheme function that returns true (the… >>> More
Unix [Homework]: Get a list of /home/user/ directories in /etc/passwd

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm very new to Unix, and currently taking a class learning the basics of the system and its commands. I'm looking for a single command line to list off all of the user home directories in alphabetical order from the /etc/passwd directory. This applies only to the home directories, and not the contents… >>> More
sequential search homework question

as seen on Stack Overflow - Search for 'Stack Overflow'
Consider a disk file containing 100 records a. How many comparisons would be required on the average to find a record using sequential search, if the record is known to be in the file? I figured out that this is 100/2 = 50. b. If the record has a 68% probability of being in the file, how many comparisons… >>> More
[Homework] Online programming editor

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, For a school project i need to write or use a online programming editor. It is a part of a bigger project. I thought of a java application, php/html/javascript or flash. I have a couple of things i could do: Find a good working application and edit it so it works with the rest of the project Find… >>> More

Related posts about relational-algebra

Converting a certain SQL query into relational algebra

as seen on Stack Overflow - Search for 'Stack Overflow'
Just doing an assignment for my database course and I just want to double check that I've correctly wrapped my head around relational algebra. The SQL query: SELECT dato, SUM(pris*antall) AS total FROM produkt, ordre WHERE ordre.varenr = produkt.varenr GROUP BY dato HAVING total >= 10000 The… >>> More
Help to translate SQL query to Relational Algebra

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everyone, I'm having some difficulties with translating some queries to Relational Algebra. I've a great book about Database Design and here is a chapter about Relational Algebra but I still seem to have some trouble creating the right one: Thoes queries I've most difficuelt with is these: SELECT… >>> More
Rails3: how to use relational algebra to replace SQL-constructions like NOT and OUTER JOIN

as seen on Stack Overflow - Search for 'Stack Overflow'
There are two models Post and Comment. I should get all posts, which have no comments with specific tag. How can I do this using new Rails 3 features such relational algebra (arel). SQL-solution should be something like this: SELECT `posts`.* FROM `posts` LEFT OUTER JOIN `comments` ON… >>> More
Relational algebra help?!

as seen on Stack Overflow - Search for 'Stack Overflow'
im new to relational algebra and finding it difficult. Ive answered a few questions, however they where relatively simple. Could do with help with these though. Database Patient (PatientCode, PatientSurname, PatientFirstname, PatientSex, PatientAge, PatientOccupation, PatientHeight, PatientWeight… >>> More
Working with Temporal Data in SQL Server

as seen on SQL Blog - Search for 'SQL Blog'
My third Pluralsight course, Working with Temporal Data in SQL Server, is published. I am really proud on the second part of the course, where I discuss optimization of temporal queries. This was a nearly impossible task for decades. First solutions appeared only lately. I present all together six… >>> More