Sql Project 1 Of 5
July 12th, 2009
Using the SQL CREATE statement, create the following two tables using the following fields:
Note: Supply the SQL Server data types when creating the tables. In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate the field as the Primary Key. In the Job Title table, you will need to either utilize one of the listed fields as the table’s primary key or you will need to create an additional field to use as the primary key. The primary key from the Job Title table will appear as the foreign key in the Employee table.
Categories: SQL 61607 retail assistant, Assistant, create, employee, employee table, enter records into, exempt, field, fine, fine foods, following, foods, for the, information, job, job title, job title 61607, job title table, key, kudler, kudler fine, kudler fine foods, primary, primary key, Project, SQL, sql project, table, Tables, the employee, the employee table, the following, the job, the kudler fine, the primary, the sql, title, title table, using, using the, you will need
