Top News

Instructions HW1

 Instructions HW1 Essay Instructions HW1 Essay

CS 4320/5320 Homework one particular

Fall 2014

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 differences do not bring about unexpected habit differences.

you

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,

profid INTEGER,

roomid INTEGER,

PRINCIPAL key (cid, semesterid));

This schema details a simple university setting. The first 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 offerings – a course offering has a training course id (cid), semester identity and connected info such as the profid 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...