1 / 7

E ddy Consulting

E ddy Consulting. Using Databases to Manage Project, Client, and Employee Information James Walsh. Presentation Outline. Overview of E ddy Consulting Project Overview Entity Relationship Diagram Database Query Demonstration Web Page Demonstration. Overview of E ddy Consulting.

zorion
Download Presentation

E ddy Consulting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Eddy Consulting Using Databases to Manage Project, Client, and Employee Information James Walsh

  2. Presentation Outline • Overview of Eddy Consulting • Project Overview • Entity Relationship Diagram • Database Query Demonstration • Web Page Demonstration

  3. Overview of Eddy Consulting • Provide Design and Construction Services • Water • Wastewater • Reclaimed Water • Design Services • Conceptual Design (Conceptual Design Report) • Final Design (Drawings, Specifications, Cost Estimates) • Construction Services • Coordinate with Contractor During Construction

  4. Eddy Consulting Structure Staff Engineers Accounting Marketing Human Resources

  5. Project Overview • Using Database to Manage Data Related to: • Clients (Primary Contact, Address, Phone) • Projects (Manager, Staff, Budgets) • Employees (Phone, E-Mail, Address) • Primary Purpose • Help Project Managers Manage Projects • Help Senior Management Track Performance and Manage Clients • Secondary Purpose • Accounting • Marketing • Human Resources

  6. Entity Relationship Diagram StartDate EndDate Salary Ename EID Title Address Phone EMail PName Stage PID M M M has Projects has Employees 1 RID 1 WEDate Hours Rate Schedules has BID Amount M Budgets 1 BName Rate has Phone 1 M 1 Contact has Clients Contracts WebSite CID Type DateSigned HowAcheived ClientID ClientName Address

  7. Demonstrations • Query Demonstration • Web Demonstration

More Related