October 11, 201213 yr Newbies Hello, Iâm new here, so I suppose that my question and topic of the database were discussed many, many times:), but unfortunately I donât understand everything, thatâs why I want to ask people who have much more experience with databases. Becouse I need to exceptionally some simply database in Access, with is a bit something new for me. Topic of database is locker-room for production crews, so itâs a unit in factory, which assign for every employee a trousers, shoes, helmet, glasses and many other things, when He start work. Every employee also has of course individual locker. So for example. Mrs. John start His work in Juanary 2012, and He get: 4 pair of trousers 1 helmet 1 glasses 2 pair shoes And for example after 6 month of work, He has been fired, so He gives back every item. Now, the whole problem for me is how to create a database diagram to allow control every item given to each employee. I must point that those items donât have any serial number or something, so one helmet is this same like second and so on. So I only need to have actual number of every item given to employee. Continuing my example, after Mrs John gives back everything, his card file should indicate: (0 pair of trousers, 0 helmet etc.) I really donât know how to realize it, If there were only one thing prescribed to user, I think that I would know how to do it, but here I have about 10 items, which I need to control:(. Please, I would be very very very gratefuly for any advice, and helpL. Below I attach 2 difrent ideas of my think, but any of those arenât good ( I suppose ) P.S Sorry for my english, but Iâm from Poland.
Create an account or sign in to comment