CS 4320/5320 Homework one particular
Due September 17, 2014
This assignment is due about Wednesday, 9/17/2014 at 11: 59pm. It can be out of 65 factors and matters for 10% of your overall grade.
You have to work on this homework in groups of 2 or 3 students. You should make 1 CMS submitter for your whole group, and everybody in the group will receive precisely the same grade. To complete the code portions of this assignment, you will need to mount both MySQL (http://dev.mysql.com/downloads/mysql/) and PostgreSQL
(http://www.postgresql.org/download/). By default we all will class your code on the current release (stable) versions from the respective websites; however , features we are using is very fundamental and stable, so typically minimal version diп¬Ђerences do not bring about unexpected habit diп¬Ђerences.
SQL and Relational Algebra queries (26 points)
Consider the schizzo given by the subsequent two SQL CREATE statements. CREATE DESK Enrolled (sid INTEGER NOT REALLY NULL,
fin INTEGER CERTAINLY NOT NULL,
semesterid INTEGER CERTAINLY NOT NULL,
PRINCIPAL KEY (sid, cid, semesterid));
CREATE TABLE CourseOffering (cid INTEGER CERTAINLY NOT NULL,
semesterid INTEGER NOT REALLY NULL,
PRINCIPAL key (cid, semesterid));
This schema details a simple university setting. The п¬Ѓrst table keeps track of which usually students will be enrolled in which usually courses within a given term, and each (sid, cid, semesterid) triple says that college student sid usually takes course cid in term semesterid. The 2nd table keeps track of course oп¬Ђerings вЂ“ a course oп¬Ђering has a training course id (cid), semester identity and connected info such as the proп¬Ѓd with the professor teaching the program and the roomid of the classroom where the course meets.
Write down thier following inquiries in SQL. Each of the answers has to be a single SQL query. The SQL inquiries will be rated by running these people in MySQL on test out cases; concerns that returning the wrong solution will receive you
0 points, i. elizabeth. there is no partial credit. Particularly, please make sure...