diff options
| author | mo khan <mo.khan@gmail.com> | 2019-12-30 16:52:17 -0700 |
|---|---|---|
| committer | mo khan <mo.khan@gmail.com> | 2019-12-30 16:52:17 -0700 |
| commit | e4b1b81d1d09e7ce8b09f3a4b772d3fc825791cd (patch) | |
| tree | 3996aac9bafd2b9c458087217be78418f98fd228 /labs | |
| parent | 321a594878b3db5b1ebe9c7a039fd63d1ee0bd2e (diff) | |
fix headers
Diffstat (limited to 'labs')
| -rw-r--r-- | labs/2/README.md | 22 |
1 files changed, 13 insertions, 9 deletions
diff --git a/labs/2/README.md b/labs/2/README.md index 9f90d9e..b0718a5 100644 --- a/labs/2/README.md +++ b/labs/2/README.md @@ -1,9 +1,10 @@ -Lab 2: Tables, Views, SQL Queries, and Triggers +# Lab 2: Tables, Views, SQL Queries, and Triggers Use the Teradata University Network to implement the following tables. -Table 1: Employees -Table 1: 'Employees' includes the first name, middle initial, and last name of every worker in the company, as well as their SIN, date of birth, address, sex, salary, and the number of the department with which they are associated. +## Table 1: Employees + +Includes the first name, middle initial, and last name of every worker in the company, as well as their SIN, date of birth, address, sex, salary, and the number of the department with which they are associated. | FNAME | MINIT | LNAME | SIN | BDATE | ADDRESS | GENDER | SALARY | DNO | | ----- | ----- | ----- | --- | ----- | ------- | ------ | ------ | --- | @@ -17,8 +18,9 @@ Table 1: 'Employees' includes the first name, middle initial, and last name of e | Neil | A | Dion | 654 | 1953-02-27 | Moncton | M | 32000 | 11 | | Karen | C | Ming | 321 | 1963-11-16 | Victoria | F | 26000 | 12 | -Table 2: Departments -Table 2: 'Departments' indicates the name (Consumer Products, Industrial Products, and Research) and number of each department in the company, and the SIN and start date of the manager of each department. +## Table 2: Departments + +Indicates the name (Consumer Products, Industrial Products, and Research) and number of each department in the company, and the SIN and start date of the manager of each department. | DNAME | DNUMBER | MGRSIN | MGRSTARTDATE | | ----- | ------- | ------ | ------------ | @@ -26,8 +28,9 @@ Table 2: 'Departments' indicates the name (Consumer Products, Industrial Product | InduProd | 11 | 654 | 2005-05-01 | | Research | 12 | 111 | 2000-06-15 | -Table 3: Projects -Table 3: 'Projects' includes the project name and number, the number of the department in charge of the project, and the location of the office working on the project. +## Table 3: Projects + +'Projects' includes the project name and number, the number of the department in charge of the project, and the location of the office working on the project. | PNAME | PNUMBER | PLOCATION | DNUM | | ----- | ------- | --------- | ---- | @@ -37,8 +40,9 @@ Table 3: 'Projects' includes the project name and number, the number of the depa | E-Commerce | 4 | Edmonton | 10 | | Mobile | Office | 5 | Athabasca | 11 | -Table 4: Locations -Table 4: 'Locations' lists the locations of all the offices of each department. +## Table 4: Locations + +'Locations' lists the locations of all the offices of each department. | DNBR | DLOCATION | | ---- | --------- | |