Pre Learning Activities
A table is a collection of related data held in a table format within a database. It consists of columns and rows. In relational databases, and flat file databases, a table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect. A table has a specified number of columns, but can have any number of rows. Each row is identified by one or more values appearing in a particular column subset. A specific choice of columns which uniquely identify rows is called the primary key.
Student required to take and understand the post-activity of the previous Chapter and complete the reading required prior the Main class activity. Read the following lecturer presentation notes before we start with the class session. You may also need to watch the video about managing tables in MS. SQL Server