If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table design
I have an excel sheet with the following fields, and how
the fields are populated, I use to track my offsite backup tape storage, and I want to move it to a database: Date of Backup (short date, 1/5/2005, manually entered) Tape Drive (Drop down list of two choices) S/N (A number field 7 digits long, manually entered) Media ID (Four alph-numeric characters manually entered) Media Pool (Drop down list of 9 choices) Sequence (Drop down list for tape sequences, ie 1, 1-2, 1- 3, 1-4...) Tape Name (Free text..could be anything) Bin (Drop down list of bin names, WEEK1 MON, WEEK1 TUE, WEEK1 WED.....all the way down to WEEK4 FRI. It's a long list with a lot of repeating in the names, ie week1 five times, week2 five times...mon four times, tue four times...) Date sent (short date, 1/5/2005, manually entered) I've created a database, if you want to call it that, with one table. It's a glorified excel sheet with a real pretty form to enter the data. I designed it around that form actually. I received a little help and got the idea I need at least 3 tables, one for the bins, one for the tapes, and one for the offsite transport. I'm thinking I probably need one for the backups too (to store the dates at least) but i'm stuck, I don't know how these tables should relate. ANyone want to tackle this? Or am I asking for a bit too much help here...? Thanks so much! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
Need help w/ table design | Tom | Database Design | 0 | August 12th, 2004 02:34 PM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Table design question - advice needed | David | Database Design | 3 | June 8th, 2004 02:21 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |