Comprehensive Project Management Database Overview
This document presents a structured database overview for efficient project management. It includes key tables: 1. **ABT** - Department details (abtnr, abtname, ort). 2. **MITARB** - Employee information (persnr, name, vorname, gebdat, ort, taet, geh, abtnr). 3. **PROJ** - Project details (projnr, projleit, pbeg, pende, pkap). 4. **MITARB_PROJ** - Employee assignments to projects (persnr, projnr, akap). The relational database schema facilitates quick access to project, employee, and departmental data needed for effective oversight and planning.
Comprehensive Project Management Database Overview
E N D
Presentation Transcript
pende name akap projnr pkap persnr gebdat n ort pbeg m PROJ MITARB n taet geh projleit vorname 1 ABT abtname ort abtnr Tabelle 1: ABT (abtnr, abtname, ort) Tabelle 2: MITARB (persnr, name, vorname, gebdat, ort, taet, geh, abtnr) Tabelle 3: PROJ (projnr, projleit, pbeg, pende, pkap) Tabelle 4: MITARB_PROJ (persnr, projnr, akap)