Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Database for locker-room - problem with schema idea

Featured Replies

  • 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.

post-107556-0-61382900-1349944277_thumb.

post-107556-0-26679400-1349944284_thumb.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.