10 likes | 142 Vues
This document outlines the salary subdivisions for employees based on birth year and start year. It details each employee's name, department, state, and city while providing insights into their role within the company. The document also covers inventory information such as item IDs, quantity on hand, location, and supplier details, along with pricing and shipping dates. Cardinalities of relationships within the data are defined as well, providing a complete overview of both employee management and inventory tracking.
E N D
Store id id salary subdivided in id responsible for birthyear startyear name state located in name head of Employee Dept City account id sdate id manages name name located in qoh Debit floor color Parts amount weight sale on shelf contains id quantity deliver ships Item Supplier Supply name id name id price shipdate quan qoh Do not forget to add cardinalities: 1:N, N:M etc.