1 / 5

Employee Management and Transaction System

This project entails designing a database system for managing employee details, purchase requests, and check-out transactions. It includes 15 essential business rules such as assigning transactions to employees and linking purchase requests to transactions. The data model is fully attributed, ensuring comprehensive information organization.

ppike
Download Presentation

Employee Management and Transaction System

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. DB Project Yong Choi

  2. Entity description

  3. Business Rules • 15 business rules.. • Each Check Out Transaction must be assigned to one employee. Each employee can have many Check Out Transaction. • Each Purch Request must be requested by at least one employee. Each employee can have many Purch Requests. • Each Check Out Transaction can be caused by one Purch Request. Each Purch Request might cause one Check Out Transaction.

  4. Data Model

  5. Fully Attributed Model

More Related