Conceptual - Conceptual design Business Rules: 1. A company...

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

View Full Document Right Arrow Icon
Conceptual design Business Rules: 1. A company has many employees which each have a phone extension. 2. Some employees also have direct dial lines. 3. When an employee’s phone is on DND their phone is forwarded to another designated employee. 4. Employees quick look up other employees extensions. Entities, attributes, and keys needed: EMPLOYEES ( EMP_ID , EMP_FNAME, EMP_LNAME, DEPT_ID, BRN_ID) EXTENSIONS ( EXT_NUM , EMP_ID, EXT_DEST) DIRECTLINE ( DRT_NUM , EMP_ID) DEPARTMENT ( DEPT_ID , DEPT_NAME) BRANCH ( BRN_ID , BRN_NAME, BRN_ADDR1, BRN_ADDR2, BRN_CITY, BRN_ST, BRN_ZIP, BRN_MANAGER) Reports, forms and queries needed: Reports: a. Employee directory listed by branch and each branch by department. b. Be able to look up employee’s extension by any part of their name. Forms: a. Update employee names and extension.
Background image of page 1

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

View Full DocumentRight Arrow Icon
b. Add new users. c. Delete users. Queries: a. Query by the phone system on the event that a phone is on DND. b.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Conceptual - Conceptual design Business Rules: 1. A company...

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

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