CS338 Lecture Notes - Lecture 1: Capital Ship, Relational Algebra, Society Of Naval Architects And Marine Engineers
30 Nov 2017
School
Department
Course
Professor
Document Summary
These exercises are collected and graded but they are essential in learning the material and preparing for exams. Solutions will be posted later and some of questions will be discussed in class: this exercise introduces a database, concerning wwii capital ships. A capital ship could either be a battleship or a battlecruiser. Ships are built in classes (think of it as the data type of the ship) from the same design, and the class is usually named after the first ship of that class. Relation ships records the name of the ship, the name of its class, and the year in which the ship was launched. Relation battles gives the name and date of the battles, and table outcomes gives the result (sunk, damaged, or ok) for ships participated in battles. Tables on the last page give some sample data for these four relations.
