CS348 Lecture Notes - Final Grades, Foreign Key, Relational Algebra

216 views3 pages

lemoncoyote675

16 Oct 2011

School

University of Waterloo

Department

Computer Science

Course

CS348

Professor

Ihab Ilyas

For unlimited access to Class Notes, a Class+ subscription is required.

Document Summary

Assignment 1 (due friday, february 12 at 5:00 pm) For this assignment you must compose and evaluate several queries for a database that records information about courses. The schema for the database is illustrated by the following relational database diagram that includes an indication of primary and foreign key constraints in the manner discussed in class. Note that the schema stores information about both ongoing and past classes for a course. Also note that no marks are recorded for any enrollment of an ongoing class, and that, for a past class, a mark is recorded for each of its enrollments. Finally, you may assume that each class has at least one enrollment. Please read these instructions carefully, as not following them may result in mark deductions. Your submission should include online answers for part 1 and paper-based answers for parts 1 through 3. Queries 1 through 15 are worth 5 marks each.

Related Questions

Which of the following database elements are displayed in each row of an Access relation?

Record
Field
Primary key
All of these

bluecicada723

which of the following statements is true of information systems?

A) Information systems include all business process activities.
B) Every information system has at least one application.
C) Information systems should be bought entirely off-the-shelf.
D) Every business process should include at least one information system.

grayotter535

Learning Objectives

After successfully completing this assignment, students will be able to:

Configure, run, and test a linux server in AWS' EC2
Configure, run, and test a Windows server in AWS' EC2

Requirements

Create an Ubuntu 20 LAMP server in EC2 like we did in class.
Verify your that Apache was installed by opening your browser and enter the public dns of your server in the address bar. If it does not connect either you did not add HTTP to the Security Group, or the install did not work properly. Take a screenshot and save it (for submission below).
The default location of html and php files is /var/www/html. Change to that directory. Now, using your favorite text editor use sudo to run your editor and create a file in that directory named info.php. For example, sudo nano info.php Then enter the following in that file to show information about the PHP installation: <?php phpinfo(); ?> Save the changes to the file and exit the editor.
Now in your browser, enter the public dns of your server in the address bar / info.php. For example, my public dns was ec2-54-89-230-235.compute-1.amazonaws.com, so I enter as the url. Take a screenshot and save it (for submission below).
Create a Windows 2016 Server, like we did in class.
Login to it using Remote Desktop. Take a screenshot of Remote Desktop connected to your Windows Server and save it (for submission below).

Clean Up

Now that you have completed the assignment, stop or terminate your EC2 instances. Stopping them means that it is now longer running, but your data is saved. That means you will not accrue charges on your running server. Terminating will both stop and delete the instances (also not accruing charges).

What to Submit

Screenshot of Apache page on your server shown in your browser
Screenshot of the PHP info page on your server shown in your browser
Screenshot of Remote Desktop session to your Windows Server

jayson

CS348 Lecture Notes - Final Grades, Foreign Key, Relational Algebra

Document Summary

Get access

Related Documents

CS348 Lecture : Assignment #1 Fall 2009

COMPSCI 122A Study Guide - Quiz Guide: Decimal Mark, Foreign Key, Hatchback

ACCT 3122 Chapter : Access Tutorial Assignment Spring 2017

Related Questions