7830TextProjectAnswersCh1

7830TextProjectAnswersCh1 - Chapter One ANSWERS TO PROJECT...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Page 1-1 Chapter One ANSWERS TO PROJECT QUESTIONS 1.57 Create a new database named Project One and create the following two tables in that database: DEPARTMENT (DepartmentName, OfficeNumber, Phone) and EMPLOYEE (EmployeeName, Email, DepartmentName) Assume that all columns have text data and set the length of the text field to an appropriate value. The two tables to be created are: DEPARTMENT (DepartmentName , OfficeNumber, Phone) EMPLOYEE (EmployeeName, Email , DepartmentName ) Where An underlined column name indicates the table key (primary key) of the table, and an italicized column indicates a foreign key linking two tables. The table below shows one possible database design – your students may create other variations, particularly in the length of the text fields. Note the use of EMPLOYEE.Email as the primary key for EMPLOYEE. This is done because there could be more than one employee with the same name in the company – for example, two people named John Smith. We could add another field – for example EmployeeID - that is guaranteed to be unique, but that is not part of the question as stated. However, if all the employees are required to have company e-mail addresses, these will be unique even for people with
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

7830TextProjectAnswersCh1 - Chapter One ANSWERS TO PROJECT...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online